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,24 +1,23 @@ # Created by: Steven Kreuzer PORTNAME= sqldf -DISTVERSION= 0.4-7.1 -PORTREVISION= 5 +DISTVERSION= 0.4-11 CATEGORIES= databases DISTNAME= ${PORTNAME}_${DISTVERSION} MAINTAINER= skreuzer@FreeBSD.org 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 .include 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/