Skip to content

Releases: ScotGovAnalysis/RtoSQLServer

v0.1.8 for R 4.2.2

04 Oct 10:31
86b6ac0
Compare
Choose a tag to compare
0.18

fix view qry (#65)

0.2.3

23 Sep 15:47
6812f50
Compare
Choose a tag to compare

What's Changed

Full Changelog: 0.2.1...0.2.3

0.2.1

13 Sep 11:01
b029153
Compare
Choose a tag to compare

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

09 Sep 14:39
01dc755
Compare
Choose a tag to compare

What's Changed

Full Changelog: 0.1.9...0.2.0

v0.1.9

13 Aug 08:29
c8ff939
Compare
Choose a tag to compare

What's Changed

Full Changelog: 0.17...0.1.9

v0.17 for R 4.2.2

13 Nov 13:18
4766db0
Compare
Choose a tag to compare

What's Changed

Full Changelog: 0.1.6...0.17

v0.1.6 for R 4.2.2

11 Oct 08:31
9823ed0
Compare
Choose a tag to compare

What's Changed

Full Changelog: 0.1.5...0.1.6

v0.1.5 for R 4.2.2

09 Oct 08:12
ce54af9
Compare
Choose a tag to compare

What's Changed

Full Changelog: 0.1.4...0.1.5

v0.1.4 for R 4.2.2

06 Sep 07:28
d84a6d1
Compare
Choose a tag to compare

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 and glue::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

27 Jun 08:28
702cf73
Compare
Choose a tag to compare
v0.1.3 for R 4.2.2 Pre-release
Pre-release
extra section to readme (#30)