Releases: ScotGovAnalysis/RtoSQLServer
Releases · ScotGovAnalysis/RtoSQLServer
v0.1.8 for R 4.2.2
0.18 fix view qry (#65)
0.2.3
What's Changed
- Column functions and pkgdown site by @tomwilsonsco in #63
Full Changelog: 0.2.1...0.2.3
0.2.1
What's Changed
- list all tables (and views); delete rows from existing table by @tomwilsonsco in #62
Full Changelog: 0.2.0...0.2.1
v 0.2.0
What's Changed
- readme fixes by @tomwilsonsco in #58
- readme fixes by @tomwilsonsco in #58
- New metadata query by @tomwilsonsco in #61
Full Changelog: 0.1.9...0.2.0
v0.1.9
What's Changed
- Datetime2 append hotfix by @tomwilsonsco in #53
- Extra actions by @tomwilsonsco in #54
- Drop versioned check by @tomwilsonsco in #56
- Error warning improvements by @tomwilsonsco in #57
Full Changelog: 0.17...0.1.9
v0.17 for R 4.2.2
v0.1.6 for R 4.2.2
What's Changed
- Datatype map by @tomwilsonsco in #49
- difftime to time by @tomwilsonsco in #50
Full Changelog: 0.1.5...0.1.6
v0.1.5 for R 4.2.2
v0.1.4 for R 4.2.2
Changes
- Make unique column names after truncating R column names > 128 characters.
- Convert df NaN values to NA before loading into database to fix datatype issue.
read_table_from_db
row filter argument so subset of database table rows can be read into R.db_table_metadata
exposed as external function for describing existing database table columns.DBI::dbQuoteIdentifier
andglue::glue_sql
used for internal SQL construction for best practice to prevent SQL injection.- Database table primary key column <table_name>Id no longer included by default when using
read_table_from_db
.
Full Changelog: 0.1.3...0.1.4
v0.1.3 for R 4.2.2
extra section to readme (#30)