rws_query: Query SQLite Database

View source: R/query.R

rws_queryR Documentation

Query SQLite Database

Description

Gets a query from a SQLite database.

Usage

rws_query(query, meta = TRUE, conn)

Arguments

query

A string of a SQLite query.

meta

A flag specifying whether to preserve meta data.

conn

A SQLiteConnection to a database.

Value

A data frame of the query.

Examples

conn <- rws_connect()
rws_write(rws_data, exists = FALSE, conn = conn)
rws_query("SELECT date, posixct, factor FROM rws_data", conn = conn)
rws_disconnect(conn)

poissonconsulting/dbWriteSQLite documentation built on Oct. 20, 2022, 11:06 p.m.