Updates to the r-lib/actions included in the CI pipeline for the repo to address failures occurring during test runs. Removes TravisCI badge and updates the GitHub Actions status badge.
Updates added to allow commented out unit tests to pass in GitHub Actions CI pipeline. The updates enhance error handling and modify the SQL queries used to install packages. This eliminates the Invalid Cursor State errors encountered in test execution when warnings are not handled in withCallingHandlers().
Details
Sets r-version to 3.5.2 to match R version on SQL Server 2019 CU 14.
List of Microsoft SQL Server updates can be found on Microsoft Docs.
Sets extra-repositories to mran snapshot aligning with R version 3.5.2.
Ensures package state matches desired R version.
Update to use r-lib/actions/setup-r-dependencies@v2 to get latest enhancements and bug fixes. Using this action directly gives the capability to cache package dependencies, reducing task completion time by minutes.
Explicitly sets extra-packages to download most recent compatible version of the odbc driver package from CRAN (version 1.3.3) to address errors occurring in the 1.1.6 version of odbc included in the mran snapshot utilized.
Usage of cran::<package> is found in the pakdocumentation.
Summary
Updates to the r-lib/actions included in the CI pipeline for the repo to address failures occurring during test runs. Removes TravisCI badge and updates the GitHub Actions status badge.
Updates added to allow commented out unit tests to pass in GitHub Actions CI pipeline. The updates enhance error handling and modify the SQL queries used to install packages. This eliminates the
Invalid Cursor Stateerrors encountered in test execution when warnings are not handled inwithCallingHandlers().Details
r-versionto3.5.2to match R version on SQL Server 2019 CU 14.extra-repositoriesto mran snapshot aligning with R version 3.5.2.r-lib/actions/setup-r-dependencies@v2to get latest enhancements and bug fixes. Using this action directly gives the capability to cache package dependencies, reducing task completion time by minutes.extra-packagesto download most recent compatible version of theodbcdriver package from CRAN (version 1.3.3) to address errors occurring in the 1.1.6 version of odbc included in the mran snapshot utilized.cran::<package>is found in thepakdocumentation.Resources