duckdb_connection-class: DuckDB connection class

Description

Implements '>DBIConnection.

Usage

# S4 method for duckdb_connection
show(object)
# S4 method for duckdb_connection
dbIsValid(dbObj, ...)
# S4 method for duckdb_connection,character
dbSendQuery(conn, statement, params = NULL, ..., arrow = FALSE)
# S4 method for duckdb_connection
dbDataType(dbObj, obj, ...)
# S4 method for duckdb_connection,character,data.frame
dbWriteTable(
  conn,
  name,
  value,
  row.names = FALSE,
  overwrite = FALSE,
  append = FALSE,
  field.types = NULL,
  temporary = FALSE,
  ...
)
# S4 method for duckdb_connection
dbAppendTable(conn, name, value, ..., row.names = NULL)
# S4 method for duckdb_connection
dbListTables(conn, ...)
# S4 method for duckdb_connection,character
dbExistsTable(conn, name, ...)
# S4 method for duckdb_connection,character
dbListFields(conn, name, ...)
# S4 method for duckdb_connection,character
dbRemoveTable(conn, name, ..., fail_if_missing = TRUE)
# S4 method for duckdb_connection
dbGetInfo(dbObj, ...)
# S4 method for duckdb_connection
dbBegin(conn, ...)
# S4 method for duckdb_connection
dbCommit(conn, ...)
# S4 method for duckdb_connection
dbRollback(conn, ...)
# S4 method for duckdb_connection
dbQuoteLiteral(conn, x, ...)

Arguments

object

Any R object

dbObj

An object inheriting from '>DBIObject, i.e. '>DBIDriver, '>DBIConnection, or a '>DBIResult

...

Other arguments to methods.

conn

A '>DBIConnection object, as returned by dbConnect().

statement

a character string containing SQL.

params

A list of bindings, named or unnamed.

arrow

Whether the query should be returned as an Arrow Table

obj

An R object whose SQL type we want to determine.

name

A character string specifying the unquoted DBMS table name, or the result of a call to dbQuoteIdentifier().

value

a data.frame (or coercible to data.frame).

row.names

Whether the row.names of the data.frame should be preserved

overwrite

If a table with the given name already exists, should it be overwritten?

append

If a table with the given name already exists, just try to append the passed data to it

field.types

Override the auto-generated SQL types

temporary

Should the created table be temporary?