Man pages for OHDSI/DatabaseConnector
Connecting to Various Database Platforms

assertTempEmulationSchemaSetAssert the temp emulation schema is set
computeDataHashCompute hash of data
connectconnect
createConnectionDetailscreateConnectionDetails
createDbiConnectionDetailsCreate DBI connection details
createZipFileCompress files and/or folders into a single zip file
DatabaseConnectorDbiResult-classDatabaseConnector DBI results class.
DatabaseConnectorDriverCreate a DatabaseConnectorDriver object
DatabaseConnectorDriver-classDatabaseConnectorDriver class.
DatabaseConnectorJdbcResult-classDatabaseConnector JDBC results class.
DatabaseConnector-packageDatabaseConnector: Connecting to Various Database Platforms
dateAddAdd an interval to a date
dateDiffCompute difference between dates
dateFromPartsConstruct a date from parts
dayExtract the day from a date
dbAppendTable-DatabaseConnectorConnection-character-methodInsert rows into a table
dbClearResult-DatabaseConnectorDbiResult-methodClear a result set
dbClearResult-DatabaseConnectorJdbcResult-methodClear a result set
dbColumnInfo-DatabaseConnectorDbiResult-methodInformation about result types
dbColumnInfo-DatabaseConnectorJdbcResult-methodInformation about result types
dbConnect-DatabaseConnectorDriver-methodCreate a connection to a DBMS
dbCreateTable-DatabaseConnectorConnection-methodCreate a table in the database
dbDisconnect-DatabaseConnectorConnection-methodDisconnect (close) a connection
dbExecute-DatabaseConnectorConnection-character-methodExecute an update statement, query number of rows affected,...
dbExistsTable-DatabaseConnectorConnection-character-methodDoes a table exist?
dbFetch-DatabaseConnectorDbiResult-methodFetch records from a previously executed query
dbFetch-DatabaseConnectorJdbcResult-methodFetch records from a previously executed query
dbGetInfo-DatabaseConnectorConnection-methodGet DBMS metadata
dbGetInfo-DatabaseConnectorDriver-methodGet DBMS metadata
dbGetQuery-DatabaseConnectorConnection-character-methodSend query, retrieve results and then clear result set
dbGetRowCount-DatabaseConnectorDbiResult-methodThe number of rows fetched so far
dbGetRowCount-DatabaseConnectorJdbcResult-methodThe number of rows fetched so far
dbGetRowsAffected-DatabaseConnectorDbiResult-methodThe number of rows affected
dbGetRowsAffected-DatabaseConnectorJdbcResult-methodThe number of rows affected
dbGetStatement-DatabaseConnectorDbiResult-methodGet the statement associated with a result set
dbGetStatement-DatabaseConnectorJdbcResult-methodGet the statement associated with a result set
dbHasCompleted-DatabaseConnectorDbiResult-methodCompletion status
dbHasCompleted-DatabaseConnectorJdbcResult-methodCompletion status
dbIsValid-DatabaseConnectorDbiConnection-methodIs this DBMS object still valid?
dbIsValid-DatabaseConnectorJdbcConnection-methodIs this DBMS object still valid?
dbListFields-DatabaseConnectorConnection-character-methodList field names of a remote table
dbListTables-DatabaseConnectorConnection-methodList remote tables
dbmsGet the database platform from a connection
dbReadTable-DatabaseConnectorConnection-character-methodCopy data frames from database tables
dbRemoveTable-DatabaseConnectorConnection-ANY-methodRemove a table from the database
dbSendQuery-DatabaseConnectorDbiConnection-character-methodExecute a query on a given database connection
dbSendQuery-DatabaseConnectorJdbcConnection-character-methodExecute a query on a given database connection
dbSendStatement-DatabaseConnectorConnection-character-methodExecute a data manipulation statement on a given database...
dbUnloadDriver-DatabaseConnectorDriver-methodLoad and unload database drivers
dbWriteTable-DatabaseConnectorConnection-ANY-methodCopy data frames to database tables
disconnectDisconnect from the server
downloadJdbcDriversDownload DatabaseConnector JDBC Jar files
dropEmulatedTempTablesDrop all emulated temp tables.
eoMonthReturn the end of the month
executeSqlExecute SQL code
existsTableDoes the table exist?
extractQueryTimesExtract query times from a 'ParallelLogger' log file
getAvailableJavaHeapSpaceGet available Java heap space
getTableNamesList all tables in a database schema.
inDatabaseSchemaRefer to a table in a database schema
insertTableInsert a table on the server
isSqlReservedWordTest a character vector of SQL names for SQL reserved words
jdbcDriversHow to download and use JDBC drivers for the various data...
lowLevelExecuteSqlExecute SQL code
lowLevelQuerySqlLow level function for retrieving data to a data frame
lowLevelQuerySqlToAndromedaLow level function for retrieving data to a local Andromeda...
monthExtract the month from a date
querySqlRetrieve data to a data.frame
querySqlToAndromedaRetrieves data to a local Andromeda object
renderTranslateExecuteSqlRender, translate, execute SQL code
renderTranslateQueryApplyBatchedRender, translate, and perform process to batches of data.
renderTranslateQuerySqlRender, translate, and query to data.frame
renderTranslateQuerySqlToAndromedaRender, translate, and query to local Andromeda
requiresTempEmulationDoes the DBMS require temp table emulation?
yearExtract the year from a date
OHDSI/DatabaseConnector documentation built on Jan. 31, 2024, 7:28 p.m.