git: a9086700db2e - main - databases/R-cran-sqldf: update to version 0.4-11
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Sat, 07 May 2022 18:09:27 UTC
The branch main has been updated by skreuzer: URL: https://cgit.FreeBSD.org/ports/commit/?id=a9086700db2ef0e57713a3719f2c39ec2f4615fb commit a9086700db2ef0e57713a3719f2c39ec2f4615fb Author: Steven Kreuzer <skreuzer@FreeBSD.org> AuthorDate: 2022-05-07 17:47:08 +0000 Commit: Steven Kreuzer <skreuzer@FreeBSD.org> CommitDate: 2022-05-07 17:49:25 +0000 databases/R-cran-sqldf: update to version 0.4-11 Changes: * modifications for RSQLite 2.0.0 * read.csv.sql now accepts https and ftps --- databases/R-cran-sqldf/Makefile | 13 ++++++------- databases/R-cran-sqldf/distinfo | 5 +++-- databases/R-cran-sqldf/pkg-descr | 18 +++++++++--------- 3 files changed, 18 insertions(+), 18 deletions(-) diff --git a/databases/R-cran-sqldf/Makefile b/databases/R-cran-sqldf/Makefile index 5ecdaaf7bfbd..3df9401fd0c7 100644 --- a/databases/R-cran-sqldf/Makefile +++ b/databases/R-cran-sqldf/Makefile @@ -1,8 +1,7 @@ # Created by: Steven Kreuzer <skreuzer@FreeBSD.org> PORTNAME= sqldf -DISTVERSION= 0.4-7.1 -PORTREVISION= 5 +DISTVERSION= 0.4-11 CATEGORIES= databases DISTNAME= ${PORTNAME}_${DISTVERSION} @@ -11,13 +10,13 @@ COMMENT= SQL select on R data frames LICENSE= GPLv2 -BUILD_DEPENDS= R-cran-proto>=0.3.9.2_6:devel/R-cran-proto \ +CRAN_DEPENDS= R-cran-proto>=0.3.9.2_6:devel/R-cran-proto \ R-cran-chron>=2.3.42:devel/R-cran-chron \ R-cran-gsubfn>=0.6.4:devel/R-cran-gsubfn \ - R-cran-DBI>=0.2.5_6:databases/R-cran-DBI \ - R-cran-RSQLite>=0.11.1:databases/R-cran-RSQLite \ - R-cran-RSQLite.extfuns>=0.0.1:databases/R-cran-RSQLite.extfuns -RUN_DEPENDS:= ${BUILD_DEPENDS} + R-cran-DBI>=1.1.0:databases/R-cran-DBI \ + R-cran-RSQLite>=2.2.14:databases/R-cran-RSQLite +BUILD_DEPENDS= ${CRAN_DEPENDS} +RUN_DEPENDS= ${CRAN_DEPENDS} USES= cran:auto-plist diff --git a/databases/R-cran-sqldf/distinfo b/databases/R-cran-sqldf/distinfo index 2e2b13a698d6..57ecd3399158 100644 --- a/databases/R-cran-sqldf/distinfo +++ b/databases/R-cran-sqldf/distinfo @@ -1,2 +1,3 @@ -SHA256 (sqldf_0.4-7.1.tar.gz) = e2b3d1eaf61fb4b7eda72a83f2718f1f683a4d52c565924ef406c235330fef0e -SIZE (sqldf_0.4-7.1.tar.gz) = 28418 +TIMESTAMP = 1651944475 +SHA256 (sqldf_0.4-11.tar.gz) = cee979d4e8c67b4924655365d925a8d67104e62adf71741f645cdc5196de2260 +SIZE (sqldf_0.4-11.tar.gz) = 63097 diff --git a/databases/R-cran-sqldf/pkg-descr b/databases/R-cran-sqldf/pkg-descr index 2378ae63cdc5..e2eef6f9d5b9 100644 --- a/databases/R-cran-sqldf/pkg-descr +++ b/databases/R-cran-sqldf/pkg-descr @@ -1,10 +1,10 @@ -sqldf is an R package for runing SQL statements on R data frames, optimized for -convenience. The user simply specifies an SQL statement in R using data frame -names in place of table names and a database with appropriate table -layouts/schema is automatically created, the data frames are automatically -loaded into the database, the specified SQL statement is performed, the result -is read back into R and the database is deleted all automatically behind the -scenes making the database's existence transparent to the user who only -specifies the SQL statement. +The sqldf() function is typically passed a single argument which is an SQL +select statement where the table names are ordinary R data frame names. sqldf() +transparently sets up a database, imports the data frames into that database, +performs the SQL select or other statement and returns the result using a +heuristic to determine which class to assign to each column of the returned +data frame. The sqldf() or read.csv.sql() functions can also be used to read +filtered files into R even if the original files are larger than R itself can +handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported. -WWW: https://code.google.com/p/sqldf +WWW: https://cran.r-project.org/web/packages/sqldf/