|
convert.db.to.r()
|
Convert data from a database table to R format |
|
convert.r.to.db()
|
Convert data from a database table to R format |
|
dbConnectSQLiteWithSchema()
|
Creates a connection to an SQLite database and sets
the specified schema |
|
dbCreateSchemaTable()
|
Create database table and possible indices from a simple yaml schema |
|
dbCreateSchemaTables()
|
Create or update database tables and possible indices from a simple yaml schema |
|
dbCreateSQLiteFromSchema()
|
Create or update a SQLite database from a schema file |
|
dbDelete()
|
Delete row(s) from table |
|
dbGet()
|
Get rows from a table |
|
dbGetMemoise()
|
Get results from a database like dbGet put buffer the results in memory |
|
dbInsert()
|
Insert row(s) into table |
|
dbTableCols()
|
Get a data frame with column information for a database table |
|
dbUpdate()
|
Update a row in a database table |
|
empty.df.from.schema()
|
Creates an example data frame from a database schema table
using provided column values and default values specified in schema |
|
empty.row.from.schema()
|
Creates an example row from a database schema table
using provided column values and default values specified in schema |
|
get.db.schema()
|
Extract schemas from a data base connection |
|
init.schema()
|
Init a schema by parsing table definition and store info
in easy accessibale R format |
|
load.and.init.schemas()
|
Load and init database table schemas from yaml file |
|
logDBcommand()
|
log a command that changes a database |
|
schema.r.classes()
|
Get a vector of R classes of the database columns described in a schema |
|
schema.template()
|
Create an example schema from a list of R objects |
|
set.db.schema()
|
Set schemas as hidden attribute to a data base connection db |
|
sql.where.code()
|
Create a parametrized or escaped SQL WHERE clause from
the provided parameters. |
|
to.db.date()
|
Convert an R object to a date object that can be used
in a WHERE clause. |
|
to.db.datetime()
|
Convert an R object to a datetime object that can be used
in a WHERE clause. |