Function reference • dittodb

Mock DB methods

with_mock_db() start_mock_db() stop_mock_db(): Run DBI queries against a mocked database

with_mock_path(): Run the DBI queries in an alternate mock directory

Capturing fixtures

start_db_capturing() stop_db_capturing() capture_db_requests(): Capture and record database transactions and save them as mocks

Utilities

expect_sql(): Detect if a specific SQL statement is sent

db_mock_paths() .db_mock_paths(): Set an alternate directory for mock API fixtures

redact_columns(): Redact columns from a dataframe with the default redactors

set_dittodb_debug_level(): Set dittodb's debug level

use_dittodb(): Use dittodb in your tests

DBI methods

dbDisconnect(<DBIMockConnection>) dbMockConnect() dbExistsTable(<DBIMockConnection>,<character>) dbExistsTable(<DBIMockConnection>,<Id>) dbListTables(<DBIMockConnection>) dbListFields(<DBIMockConnection>,<character>) dbListFields(<DBIMockConnection>,<Id>) dbListFields(<DBIMockConnection>,<ANY>) dbSendQuery(<DBIMockConnection>,<character>) dbSendQuery(<DBIMockConnection>,<SQL>) dbSendStatement(<DBIMockConnection>,<character>) dbFetch(<DBIMockResult>) fetch(<DBIMockResult>,<ANY>) fetch(<DBIMockResult>,<missing>) dbClearResult(<DBIMockResult>) dbHasCompleted(<DBIMockResult>) dbGetQuery(<DBIMockRPostgreSQLConnection>,<character>) dbGetRowsAffected(<DBIMockResult>) dbGetInfo(<DBIMockConnection>) dbWriteTable(<DBIMockConnection>,<character>,<data.frame>) dbRemoveTable(<DBIMockConnection>,<character>) dbColumnInfo(<DBIMockResult>) dbGetInfo(<DBIMockResult>) dbQuoteIdentifier(<DBIMockRPostgresConnection>,<character>) dbQuoteIdentifier(<DBIMockRPostgresConnection>,<SQL>) dbQuoteString(<DBIMockRPostgresConnection>,<character>) dbQuoteString(<DBIMockRPostgresConnection>,<SQL>) dbQuoteString(<DBIMockMariaDBConnection>,<character>) dbQuoteString(<DBIMockMariaDBConnection>,<SQL>) dbBegin(<DBIMockConnection>) dbCommit(<DBIMockConnection>) dbRollback(<DBIMockConnection>): Methods for interacting with DB mocks instead of an actual database

Test DB creation

nycflights_sqlite(): An SQLite connection to a subset of nycflights13

nycflights13_create_sql(): Create a standardised database for testing

nycflights13_create_sqlite(): Create an in-memory SQLite database for testing