databases/R-cran-RSQLite: Update to 2.3.6

While I'm here,

- remove conditionals regarding llvm16 build fix as port build fine
  without it.
- add test target

ChangeLog: https://cran.r-project.org/web/packages/RSQLite/news/news.html

Differential Revision:	https://reviews.freebsd.org/D44592

1 files changed, 27 insertions, 0 deletions

diff --git a/databases/R-cran-RSQLite/files/patch-tests_testthat_test-encoding.R b/databases/R-cran-RSQLite/files/patch-tests_testthat_test-encoding.R
new file mode 100644
index 000000000000..443e56a34ca7
--- /dev/null
+++ b/databases/R-cran-RSQLite/files/patch-tests_testthat_test-encoding.R
@@ -0,0 +1,27 @@
+Fix to skip a windows only test that does not exclude FreeBSD.
+https://github.com/r-dbi/RSQLite/pull/504
+
+--- tests/testthat/test-encoding.R.orig	2024-01-20 09:56:34 UTC
++++ tests/testthat/test-encoding.R
+@@ -34,9 +34,7 @@ test_that("list the field of tables whose colnames are
+ })
+ 
+ test_that("list the field of tables whose colnames are BIG5 encoded (#277)", {
+-  skip_on_os("linux")
+-  skip_on_os("mac")
+-  skip_on_os("solaris")
++  skip_if_not(.Platform$OS.type == "windows")
+   if (.Platform$OS.type == "windows") {
+     withr::local_collate("cht")
+   } else {
+@@ -133,9 +131,7 @@ test_that("write tables whose colnames or contents are
+ })
+ 
+ test_that("write tables whose colnames or contents are BIG5 encoded (#277)", {
+-  skip_on_os("linux")
+-  skip_on_os("mac")
+-  skip_on_os("solaris")
++  skip_if_not(.Platform$OS.type == "windows")
+ 
+   .loc <- Sys.getlocale("LC_COLLATE")
+   suppressWarnings(Sys.setlocale(locale = "cht"))