backend_db

0th

Percentile

Database generics.

These generics execute actions on the database. All generics have a method for DBIConnection which typically just call the standard DBI S4 method.

Keywords
internal
Usage
db_list_tables(con)

db_has_table(con, table)

db_data_type(con, fields)

db_save_query(con, sql, name, temporary = TRUE, ...)

db_begin(con, ...)

db_commit(con, ...)

db_rollback(con, ...)

db_create_table(con, table, types, temporary = FALSE, ...)

db_insert_into(con, table, values, ...)

db_create_index(con, table, columns, name = NULL, ...)

db_drop_table(con, table, force = FALSE, ...)

db_analyze(con, table, ...)

db_explain(con, sql, ...)

db_query_fields(con, sql, ...)

db_query_rows(con, sql, ...)

Arguments
con
A database connection.
table
A string, the table name.
fields
A list of fields, as in a data frame.
Value

A logical value indicating success. Most failures should generate an error.

copy_to

Currently, the only user of sql_begin(), sql_commit(), sql_rollback(), sql_create_table(), sql_insert_into(), sql_create_indexes(), sql_drop_table() and sql_analyze(). If you find yourself overriding many of these functions it may suggest that you should just override copy_to instead.

Aliases
  • backend_db
  • db_analyze
  • db_begin
  • db_commit
  • db_create_index
  • db_create_table
  • db_data_type
  • db_drop_table
  • db_explain
  • db_has_table
  • db_insert_into
  • db_list_tables
  • db_query_fields
  • db_query_rows
  • db_rollback
  • db_save_query
Documentation reproduced from package dplyr, version 0.3, License: MIT + file LICENSE

Community examples

Looks like there are no examples yet.