search

poissonconsulting / tsdbr

R package to create, populate, maintain and query SQLite databases of environmental time series data
https://poissonconsulting.github.io/tsdbr/
Other
1 stars 0 forks source link

Upkeep #38

Open dunkenwg opened 1 week ago

dunkenwg commented 1 week ago

We're getting three instances of the following warning:

Warning (test-zzz-package.R:62:3): package
SQL statements must be issued with dbExecute() or dbSendStatement()
instead of dbGetQuery() or dbSendQuery().

The backtrace points to data.R line 129 x <- DBI::dbFetch(res); however the code before uses dbSendStatement():

res <- DBI::dbSendStatement(conn, paste0(
    "INSERT OR ", toupper(resolution),
    " INTO Data SELECT * FROM Upload;"
  ))