Man pages for skranz/dbmisc
Tools for working with SQLite in R
| 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... |
| dbCreateSchemaTable | Create database table and possible indices from a simple yaml... |
| dbCreateSchemaTables | Create or update database tables and possible indices from a... |
| 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... |
| 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... |
| empty.row.from.schema | Creates an example row from a database schema table using... |
| get.db.schema | Extract schemas from a data base connection |
| init.schema | Init a schema by parsing table definition and store info in... |
| 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... |
| 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... |
| to.db.date | Convert an R object to a date object that can be used in a... |
| to.db.datetime | Convert an R object to a datetime object that can be used in... |
