Package: sqlhelper 0.2.1
sqlhelper: Easier 'SQL' Integration
Execute files of 'SQL' and manage database connections. 'SQL' statements and queries may be interpolated with string literals. Execution of individual statements and queries may be controlled with keywords. Multiple connections may be defined with 'YAML' and accessed by name.
Authors:
sqlhelper_0.2.1.tar.gz
sqlhelper_0.2.1.zip(r-4.5)sqlhelper_0.2.1.zip(r-4.4)sqlhelper_0.2.1.zip(r-4.3)
sqlhelper_0.2.1.tgz(r-4.4-any)sqlhelper_0.2.1.tgz(r-4.3-any)
sqlhelper_0.2.1.tar.gz(r-4.5-noble)sqlhelper_0.2.1.tar.gz(r-4.4-noble)
sqlhelper_0.2.1.tgz(r-4.4-emscripten)sqlhelper_0.2.1.tgz(r-4.3-emscripten)
sqlhelper.pdf |sqlhelper.html✨
sqlhelper/json (API)
NEWS
| # Install 'sqlhelper' in R: |
| install.packages('sqlhelper', repos = c('https://majerr.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/majerr/sqlhelper/issues
Last updated 10 months agofrom:1b49d2f454. Checks:OK: 7. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Oct 25 2024 |
| R-4.5-win | OK | Oct 25 2024 |
| R-4.5-linux | OK | Oct 25 2024 |
| R-4.4-win | OK | Oct 25 2024 |
| R-4.4-mac | OK | Oct 25 2024 |
| R-4.3-win | OK | Oct 25 2024 |
| R-4.3-mac | OK | Oct 25 2024 |
Exports:config_examplesconnectconnection_infodefault_conndisconnectget_default_conn_nameis_connectedlive_connectionnot_connectedprepare_sqlread_sqlrun_filesrun_queriesrunfilesrunqueriesset_default_conn_name
Dependencies:classclassIntclicpp11DBIdplyre1071fansigenericsglueKernSmoothlaterlifecyclemagrittrMASSpillarpkgconfigpoolproxypurrrR6rappdirsRcpprlangs2sfstringistringrtibbletidyrtidyselectunitsutf8vctrswithrwkyaml
Executing SQL
Rendered fromexecution.Rmdusingknitr::rmarkdownon Oct 25 2024.Last update: 2024-01-18
Started: 2024-01-18
Managing Connections
Rendered fromconnections.Rmdusingknitr::rmarkdownon Oct 25 2024.Last update: 2024-01-18
Started: 2023-01-12
sqlhelper
Rendered fromsqlhelper.Rmdusingknitr::rmarkdownon Oct 25 2024.Last update: 2024-01-18
Started: 2023-01-12
Using sqlhelper in packages
Rendered fromuse_case.Rmdusingknitr::rmarkdownon Oct 25 2024.Last update: 2024-01-18
Started: 2024-01-18
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Examples of yaml configurations for database connections | config_examples |
| (Re-)Establish connections to databases | connect |
| Browse available connections | connection_info |
| Return the default connection | default_conn |
| Close all connections and remove them from the connections cache | disconnect |
| Test whether a database is connected | is_connected not_connected |
| Return the named connection or NULL | live_connection |
| prepare queries and assemble meta data prior to execution | prepare_sql |
| Read a sql file and return it's contents as a tibble | read_sql |
| Read, prepare and execute .SQL files | runfiles run_files |
| Execute a sequence of SQL queries | runqueries run_queries |
| Set/get the name of the default connection to use | get_default_conn_name set_default_conn_name |
