backend-implementations.md

In prestodb/RPresto: DBI Connector to Presto

RPresto's implmentation of DBI and dplyr backends

There are two main layers of RPresto's code: a DBI backend and a dplyr remote database backend mainly using dbplyr.

DBI backend

Important classes:

| Class | Implementation type | File | | ----- | ------------------- | ---- | | PrestoDriver| S4 | PrestoDriver.R | | PrestoConnection | S4 | PrestoConnection.R | | PrestoResult | S4 | PrestoResult.R | | PrestoQuery | RefClass | PrestoQuery.R | | PrestoSession | RefClass | PrestoSession.R |

Important methods:

| Method | Class | Status | File | | ------ | ----- | ------ | ---- | | dbGetInfo | PrestoDriver | Implemented | dbGetInfo.R | | dbDataType | PrestoDriver | Implemented | dbDataType.R | | dbUnloadDriver | PrestoDriver | Implemented | dbUnloadDriver.R | | dbConnect | PrestoDriver | Implemented | dbConnect.R | | dbGetInfo | PrestoConnection | Implemented | dbGetInfo.R | | dbDisconnect | PrestoConnection | Implemented | dbDisconnect.R | | dbQuoteIdentifier | PrestoConnection | Partially implemented | dbQuoteIdentifier.R | | dbUnquoteIdentifier | PrestoConnection | Default | | | dbQuoteString | PrestoConnection | Default | | | dbQuoteLiteral | PrestoConnection | Implemented | dbQuoteLiteral.R | | dbListTables | PrestoConnection | Implemented | dbListTables.R | | dbExistsTable | PrestoConnection | Implemented | dbExistsTable.R | | dbSendQuery | PrestoConnection | Implemented | dbSendQuery.R | | dbSendStatement | PrestoConnection | Default | | | dbGetQuery | PrestoConnection | Implemented | dbGetQuery.R | | dbExecute | PrestoConnection | Default | | | dbCreateTable | PrestoConnection | Implemented | dbCreateTable.R | | sqlCreateTable | PrestoConnection | Implemented | sqlCreateTable.R | | dbCreateTableAs | PrestoConnection | Created | dbCreateTableAs.R | | sqlCreateTableAs | PrestoConnection | Created | sqlCreateTableAs.R | | dbWriteTable | PrestoConnection | Implemented | dbWriteTable.R | | dbRemoveTable | PrestoConnection | Implemented | dbRemoveTable.R | | dbReadTable | PrestoConnection | Implemented | dbReadTable.R | | dbRenameTable | PrestoConnection | Created | dbRenameTable.R | | dbAppendtable | PrestoConnection | Implemented | dbAppendTable.R | | dbListFields | PrestoConnection | Implemented | dbListFields.R | | dbBegin | PrestoConnection | Not implemented | | | dbCommit | PrestoConnection | Not implemented | | | dbRollback | PrestoConnection | Not implemented | | | dbBreak | PrestoConnection | Not implemented | | | dbWithTransaction | PrestoConnection | Not implemented | | | dbGetInfo | PrestoResult | Implemented | dbGetInfo.R | | dbClearResult | PrestoResult | Implemented | dbClearResult.R | | dbFetch | PrestoResult | Implemented | dbFetch.R | | fetch | PrestoResult | Implemented | fetch.R | | dbHasCompleted | PrestoResult | Implemented | dbHasCompleted.R | | dbIsValid | PrestoResult | Implemented | dbIsValid.R | | dbGetStatement | PrestoResult | Implemented | dbGetStatement.R | | dbGetRowCount | PrestoResult | Implemented | dbGetRowCount.R | | dbGetRowsAffected | PrestoResult | Implemented | dbGetRowsAffected.R | | dbListFields | PrestoResult | Implemented | dbListFields.R | | dbBind | PrestoResult | Not implemented | | | dbColumnInfo | PrestoResult | Not implemented | |

dplyr remote database backend

dplyr generics:

| Method | Primary class | Status | File | | ------ | ------------- | ------ | ---- | | db_desc | PrestoConnection | Implemented | dbplyr-db.R | | db_data_type | PrestoConnection | Implemented | dbplyr-db.R | | db_explain | PrestoConnection | Implemented | dbplyr-db.R | | db_query_rows | PrestoConnection | Not implemented | | | db_query_fields | PrestoConnection | Default | | | db_save_query | PrestoConnection | Default | | | db_list_tables | PrestoConnection | Implemented | dbplyr-db.R | | db_has_table | PrestoConnection | Implemented | dbplyr-db.R | | db_write_table | PrestoConnection | Implemented | dbplyr-db.R | | db_create_table | PrestoConnection | Not implemented | | | db_insert_into | PrestoConnection | Not implemented | | | db_drop_table | PrestoConnection | Not implemented | | | db_begin | PrestoConnection | Not implemented | | | db_rollback | PrestoConnection | Not implemented | | | db_commit | PrestoConnection | Not implemented | | | db_analyze | PrestoConnection | Not implemented | |

dplyr remote database source functions:

| Function | Default | Primary class | Status | File | | -------- | ----------- | ------------- | ------ | ---- | | src_presto | src_dbi | | Implemented | dbplyr-src.R | | tbl | | PrestoConnection | Implemented | dbplyr-src.R | | copy_to | | PrestoConnection | Implemented | dbplyr-src.R | | tbl.src_presto | tbl.src_dbi | src_presto | Implemented | dbplyr-src.R | | copy_to.src_presto | copy_to.src_sql | src_presto | Implemented | dbplyr-src.R | | collect.tbl_presto | collect.tbl_sql | tbl_presto | Implemented | dbplyr-src.R | | compute.tbl_presto | compute.tbl_sql | tbl_presto | Implemented | dbplyr-src.R | | collapse.tbl_presto | collapse.tbl_sql | tbl_presto | Default | |

dbplyr generics:

| Method | Primary class | Status | File | | ------ | ------------- | ------ | ---- | | dbplyr_edition | PrestoConnection | Implemented | dbplyr-db.R | | db_collect | PrestoConnection | Implemented | dbplyr-db.R | | db_copy_to | PrestoConnection | Implemented | dbplyr-db.R | | db_compute | PrestoConnection | Implemented | dbplyr-db.R | | db_sql_render | PrestoConnection | Implemented | dbplyr-db.R | | sql_query_fields | PrestoConnection | Implemented | dbplyr-sql.R | | sql_escape_date | PrestoConnection | Implemented | dbplyr-sql.R | | sql_escape_datetime | PrestoConnection | Implemented | dbplyr-sql.R | | sql_translation | PrestoConnection | Implemented | dbplyr-sql.R | | sql_query_save | PrestoConnection | Implemented | dbplyr-sql.R |

prestodb/RPresto documentation built on April 30, 2024, 1:34 a.m.