Tags: jarauh/DBI
Tags
DBI 1.0.0.9002 - Add tests for `dbUnquoteIdentifier()` (r-dbi#279, @baileych). - `sqlInterpolate()` uses `dbQuoteLiteral()` instead of checking the type of the input. - Improved documentation for `sqlInterpolate()` (r-dbi#100). - `dbUnquoteIdentifier()` also handles unquoted identifiers of the form `table`, `schema.table` or `catalog.schema.table`, for compatibility with dbplyr. - `dbUnquoteIdentifier()` now supports `Id()` objects with `catalog` members (r-dbi#266, @raffscallion).
DBI 1.0.0.9001 - Add usage of `SQL()` to `sqlInterpolate()` examples (r-dbi#259, @renkun-ken).
DBI 1.0.0 ## New generics - New `dbAppendTable()` that by default calls `sqlAppendTableTemplate()` and then `dbExecute()` with a `param` argument, without support for `row.names` argument (r-dbi#74). - New `dbCreateTable()` that by default calls `sqlCreateTable()` and then `dbExecute()`, without support for `row.names` argument (r-dbi#74). - New `dbCanConnect()` generic with default implementation (r-dbi#87). - New `dbIsReadOnly()` generic with default implementation (r-dbi#190, @anhqle). ## Changes - `sqlAppendTable()` now accepts lists for the `values` argument, to support lists of `SQL` objects in R 3.1. - Add default implementation for `dbListFields(DBIConnection, Id)`, this relies on `dbQuoteIdentifier(DBIConnection, Id)` (r-dbi#75). ## Documentation updates - The DBI specification vignette is rendered correctly from the installed package (r-dbi#234). - Update docs on how to cope with stored procedures (r-dbi#242, @aryoda). - Add "Additional arguments" sections and more examples for `dbGetQuery()`, `dbSendQuery()`, `dbExecute()` and `dbSendStatement()`. - The `dbColumnInfo()` method is now fully specified (r-dbi#75). - The `dbListFields()` method is now fully specified (r-dbi#75). - The dynamic list of methods in help pages doesn't contain methods in DBI anymore. ## Bug fixes - Pass missing `value` argument to secondary `dbWriteTable()` call (#737, @jimhester). - The `Id` class now uses `<Id>` and not `<Table>` when printing. - The default `dbUnquoteIdentifier()` implementation now complies to the spec.
DBI 0.8.0.9003 - Rename `values` to `value` in `dbAppendTable()` for consistency with `dbWriteTable()`.
DBI 0.8.0.9002 - `sqlAppendTable()` now accepts lists for the `values` argument, to support lists of `SQL` objects in R 3.1.
DBI 0.8.0.9001 - New `dbAppendTable()` that by default calls `sqlAppendTableTemplate()` and then `dbExecute()` with a `param` argument, without support for `row.names` argument (r-dbi#74). - New `dbCreateTable()` that by default calls `sqlCreateTable()` and then `dbExecute()`, without support for `row.names` argument (r-dbi#74). - Add "Additional arguments" sections and more examples for `dbGetQuery()`, `dbSendQuery()`, `dbExecute()` and `dbSendStatement()`. - New `dbCanConnect()` generic with default implementation (r-dbi#87). - The `dbColumnInfo()` method is now fully specified (r-dbi#75). - The `dbListFields()` method is now fully specified (r-dbi#75). - Add default implementation for `dbListFields(DBIConnection, Id)`, this relies on `dbQuoteIdentifier(DBIConnection, Id)` (r-dbi#75). - Add new generic `dbIsReadOnly()` (r-dbi#190, @anhqle). - Pass missing `value` argument to secondary `dbWriteTable()` call (#737, @jimhester). - Fix `dbWriteTable()` forwarder for signature `c("DBIConnection", "Id", "data.frame")`. - The `Id` class now uses `<Id>` and not `<Table>` when printing. - The default `dbUnquoteIdentifier()` implementation now complies to the spec.
Breaking changes ---------------- - `SQL()` now strips the names from the output if the `names` argument is unset. - The `dbReadTable()`, `dbWriteTable()`, `dbExistsTable()`, `dbRemoveTable()`, and `dbListFields()` generics now specialize over the first two arguments to support implementations with the `Id` S4 class as type for the second argument. Some packages may need to update their documentation to satisfy R CMD check again. New generics ------------ - Schema support: Export `Id()`, new generics `dbListObjects()` and `dbUnquoteIdentifier()`, methods for `Id` that call `dbQuoteIdentifier()` and then forward (r-dbi#220). - New `dbQuoteLiteral()` generic. The default implementation uses switchpatch to avoid dispatch ambiguities, and forwards to `dbQuoteString()` for character vectors. Backends may override methods that also dispatch on the second argument, but in this case also an override for the `"SQL"` class is necessary (r-dbi#172). Default implementations ----------------------- - Default implementations of `dbQuoteIdentifier()` and `dbQuoteLiteral()` preserve names, default implementation of `dbQuoteString()` strips names (r-dbi#173). - Specialized methods for `dbQuoteString()` and `dbQuoteIdentifier()` are available again, for compatibility with clients that use `getMethod()` to access them (r-dbi#218). - Add default implementation of `dbListFields()`. - The default implementation of `dbReadTable()` now has `row.names = FALSE` as default and also supports `row.names = NULL` (r-dbi#186). API changes ----------- - The `SQL()` function gains an optional `names` argument which can be used to assign names to SQL strings. Deprecated generics ------------------- - `dbListConnections()` is soft-deprecated by documentation. - `dbListResults()` is deprecated by documentation (r-dbi#58). - `dbGetException()` is soft-deprecated by documentation (r-dbi#51). - The deprecated `print.list.pairs()` has been removed. Bug fixes --------- - Fix `dbDataType()` for `AsIs` object (r-dbi#198, @yutannihilation). - Fix `dbQuoteString()` and `dbQuoteIdentifier()` to ignore invalid UTF-8 strings (r-dbi/DBItest#156). Documentation ------------- - Help pages for generics now contain a dynamic list of methods implemented by DBI backends (#162). - `sqlInterpolate()` now supports both named and positional variables (r-dbi#216, @hannesmuehleisen). - Point to db.rstudio.com (@wibeasley, r-dbi#209). - Reflect new 'r-dbi' organization in `DESCRIPTION` (@wibeasley, r-dbi#207). Internal -------- - Using switchpatch on the second argument for default implementations of `dbQuoteString()` and `dbQuoteIdentifier()`.
- Schema support: Export `Id()`, new generics `dbListObjects()` and `… …dbUnquoteIdentifier()`, methods for `Id` that call `dbQuoteIdentifier()` and then forward (r-dbi#220). - `dbListConnections()` is soft-deprecated by documentation. - Default implementations of `dbQuoteIdentifier()` and `dbQuoteLiteral()` preserve names, default implementation of `dbQuoteString()` strips names (r-dbi#173). - Breaking change: If the `names` argument is unset, `SQL()` strips the names from the output.
PreviousNext