databases/R-RSQLite: Update to 2.1.1

Notable changes since 1.0.0:

- RSQLite has been rewritten (essentially from scratch) in C++ with
  Rcpp.
- You can now use SQLite’s URL specification for databases.
- Queries, query parameters and table data are always converted to
  UTF-8 before being sent to the database.
- New strategy for prepared queries. Create a prepared query with
  dbSendQuery() or dbSendStatement() and bind values with dbBind().
- dbSendQuery(), dbGetQuery(), dbSendStatement() and dbExecute() also
  support inline parameterised queries.
- Improve column type inference.
- dbFetch() uses the same row name strategy as dbReadTable().
- dbColumnInfo() will now return information even before you’ve
  retrieved any data.
- New sqliteVersion() prints the header and library versions of
  RSQLite.
- Deprecation warnings are given only once, with a clear reference to
  the source.
- datasetsDb() now returns a read-only database, to avoid
  modifications to the installed file.
- Values of class "integer64" are now supported for dbWriteTable() and
  dbBind().
- New connections now automatically load default RSQLite extensions.
- Implement dbUnquoteIdentifier().

3 files changed, 23 insertions, 14 deletions

diff --git a/databases/R-RSQLite/DESCR b/databases/R-RSQLite/DESCR
index 847e67a5b7e..0c393dfe28f 100644
--- a/databases/R-RSQLite/DESCR
+++ b/databases/R-RSQLite/DESCR
@@ -1,2 +1,3 @@
-This package embeds the SQLite database engine in R and provides
-an interface compliant with the DBI package.
+Embeds the 'SQLite' database engine in R and provides an interface
+compliant with the 'DBI' package. The source for the 'SQLite' engine
+is included.
diff --git a/databases/R-RSQLite/Makefile b/databases/R-RSQLite/Makefile
index 62fc1a8e4c7..b081edb8ce5 100644
--- a/databases/R-RSQLite/Makefile
+++ b/databases/R-RSQLite/Makefile
@@ -1,17 +1,25 @@
-# $NetBSD: Makefile,v 1.1 2016/02/25 19:46:54 fhajny Exp $
+# $NetBSD: Makefile,v 1.2 2018/05/10 00:09:29 minskim Exp $
 
+DISTNAME=	RSQLite_2.1.1
 CATEGORIES=	databases
-MASTER_SITES=	${MASTER_SITE_R_CRAN:=contrib/}
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
-HOMEPAGE=	${R_HOMEPAGE_BASE}/RSQLite/
-COMMENT=	Database Interface R driver for SQLite
+HOMEPAGE=	https://github.com/r-dbi/RSQLite
+COMMENT=	'SQLite' Interface for R
 LICENSE=	gnu-lgpl-v2
 
-R_PKGNAME=	RSQLite
-R_PKGVER=	1.0.0
+DEPENDS+=	R-bit64-[0-9]*:../../devel/R-bit64
+DEPENDS+=	R-blob>=1.1.1:../../devel/R-blob
+DEPENDS+=	R-DBI>=1.0.0:../../math/R-DBI
+DEPENDS+=	R-memoise-[0-9]*:../../devel/R-memoise
+DEPENDS+=	R-pkgconfig-[0-9]*:../../devel/R-pkgconfig
 
-DEPENDS+=	R-DBI>=0.3.1:../../math/R-DBI
+USE_LANGUAGES+=	c c++
 
+BUILDLINK_API_DEPENDS.R+=	R>=3.1.0
 .include "../../math/R/Makefile.extension"
+.include "../../devel/R-BH/buildlink3.mk"
+BUILDLINK_API_DEPENDS.R-Rcpp+=	R-Rcpp>=0.12.7
+.include "../../devel/R-Rcpp/buildlink3.mk"
+.include "../../devel/R-plogr/buildlink3.mk"
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/R-RSQLite/distinfo b/databases/R-RSQLite/distinfo
index 00cb61bf6c0..eae07550667 100644
--- a/databases/R-RSQLite/distinfo
+++ b/databases/R-RSQLite/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.1 2016/02/25 19:46:54 fhajny Exp $
+$NetBSD: distinfo,v 1.2 2018/05/10 00:09:29 minskim Exp $
 
-SHA1 (R/RSQLite_1.0.0.tar.gz) = 2304d8c3e8768a4560947656977a8201a9129457
-RMD160 (R/RSQLite_1.0.0.tar.gz) = a2e2aeb636cbb2e3ba4248b845becaf9aa801227
-SHA512 (R/RSQLite_1.0.0.tar.gz) = 3ffde5bed18bde630d6130e2b9a15f17e77a2fe92aa2c7102fe59a20121f6aa704af1e8861269d1616231bc1d74193ebd101ee224112da667362897bc61e96db
-Size (R/RSQLite_1.0.0.tar.gz) = 1745731 bytes
+SHA1 (R/RSQLite_2.1.1.tar.gz) = ed4ffd85a72685205f0bc651c5d25b539f788339
+RMD160 (R/RSQLite_2.1.1.tar.gz) = 49e94c10233030e46f8953965e10ad8fdc015d7a
+SHA512 (R/RSQLite_2.1.1.tar.gz) = c488c61cb587617d40af8e622dd5598c98173fce5569a22ec74032a515199af54361045c40bbf20425e8bbfe601d1c5496fa6056f9425eabc5590737a331810b
+Size (R/RSQLite_2.1.1.tar.gz) = 2192835 bytes