dbSaveData: Save data to SQLite database.

In MinZhang95/flightscanner: Flight Information

Description

Save data to the corresponding tables in the SQLite database. Tables includes: price, itinerary, leg, segment, carrier, agent, and place.

Usage

dbSaveData(x, conn, ...)

## S3 method for class 'list'
dbSaveData(x, conn, ...)

## S3 method for class 'response'
dbSaveData(x, conn, ...)

Arguments

x	An object of data to be saved.
conn	A SQLiteConnection object, as returned by dbConnect().
...	Further arguments passed to methods.

Methods (by class)

• list: Save a list of data.frames in databse.

• response: Save data from the request response in databse.

Examples

## Not run: 
# Get data from API
apiSetKey("YOUR_API_KEY")
resp <- apiCreateSession(origin = "SFO", destination = "LHR", startDate = "2019-07-01")
resp <- apiPollSession(resp)
data <- flightGet(resp)

# Connect to SQLite database
con <- dbCreateDB(dbname = ":memory:")
dbSaveData(resp, con)  # from response
dbSaveData(data, con)  # from list
dbDisconnect(con)

## End(Not run)

MinZhang95/flightscanner documentation built on July 1, 2019, 9:36 p.m.