[incubator-sedona] branch master updated: [DOCS] remove DBI as a R dependency (#690)

[ji...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

jiayu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-sedona.git


The following commit(s) were added to refs/heads/master by this push:
     new 54942047 [DOCS] remove DBI as a R dependency (#690)
54942047 is described below

commit 54942047b91a4f60f6d6e3128b73f4c9a7342982
Author: Yitao Li <yi...@rstudio.com>
AuthorDate: Fri Sep 16 21:07:49 2022 -0300

    [DOCS] remove DBI as a R dependency (#690)
    
    Co-authored-by: Yitao Li <yi...@apache.org>
---
 R/DESCRIPTION         | 1 -
 R/R/spatial_queries.R | 5 +++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/R/DESCRIPTION b/R/DESCRIPTION
index 531055a7..e7b5e21c 100644
--- a/R/DESCRIPTION
+++ b/R/DESCRIPTION
@@ -28,7 +28,6 @@ Depends:
 Imports:
     rlang,
     sparklyr (>= 1.3),
-    DBI (>= 0.6-1),
     dplyr (>= 0.7.2),
     dbplyr (>= 1.1.0)
 Suggests:
diff --git a/R/R/spatial_queries.R b/R/R/spatial_queries.R
index 2b543764..74e23395 100644
--- a/R/R/spatial_queries.R
+++ b/R/R/spatial_queries.R
@@ -59,14 +59,15 @@ NULL
 #' if (!inherits(sc, "test_connection")) {
 #'   knn_query_pt_x <- -84.01
 #'   knn_query_pt_y <- 34.01
-#'   knn_query_pt_tbl <- DBI::dbGetQuery(
+#'   knn_query_pt_tbl <- sdf_sql(
 #'     sc,
 #'     sprintf(
 #'       "SELECT ST_GeomFromText(\"POINT(%f %f)\") AS `pt`",
 #'       knn_query_pt_x,
 #'       knn_query_pt_y
 #'     )
-#'   )
+#'   ) %>%
+#'       collect()
 #'   knn_query_pt <- knn_query_pt_tbl$pt[[1]]
 #'   input_location <- "/dev/null" # replace it with the path to your input file
 #'   rdd <- sedona_read_geojson_to_typed_rdd(