All functions

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.