bike_datelimits: Extract date-time limits from trip database

In mpadge/sqlite3-test: Test C++ issue with bikedata package

Description

Extract date-time limits from trip database

Usage

bike_datelimits(bikedb, city)

Arguments

bikedb	A string containing the path to the SQLite3 database. If no directory specified, it is presumed to be in tempdir().
city	If given, date limits are calculated only for trips in that city.

Value

A vector of 2 elements giving the date-time of the first and last trips

Examples

data_dir <- tempdir ()
bike_write_test_data (data_dir = data_dir)
# dl_bikedata (city = 'la', data_dir = '.') # or download some real data!
bikedb <- file.path (data_dir, 'testdb')
store_bikedata (data_dir = data_dir, bikedb = bikedb)
bike_datelimits ('testdb') # overall limits for all cities
bike_datelimits ('testdb', city = 'NYC') 
bike_datelimits ('testdb', city = 'los angeles') 

bike_rm_test_data (data_dir = data_dir)
bike_rm_db (bikedb)
# don't forget to remove real data!
# file.remove (list.files ('.', pattern = '.zip'))

mpadge/sqlite3-test documentation built on May 23, 2019, 6:24 a.m.