Package: sqlcaser 0.2.0
Leoson Hoay
sqlcaser: 'SQL' Case Statement Generator
Includes built-in methods for generating long 'SQL' CASE statements, and other 'SQL' statements that may otherwise be arduous to construct by hand. The generated statement can easily be concatenated to string literals to form queries to 'SQL'-like databases, such as when using the 'RODBC' package. The current methods include casewhen() for building CASE statements, inlist() for building IN statements, and updatetable() for building UPDATE statements.
Authors:
sqlcaser_0.2.0.tar.gz
sqlcaser_0.2.0.tar.gz(r-4.5-noble)sqlcaser_0.2.0.tar.gz(r-4.4-noble)
sqlcaser_0.2.0.tgz(r-4.4-emscripten)sqlcaser_0.2.0.tgz(r-4.3-emscripten)
sqlcaser.pdf |sqlcaser.html✨
sqlcaser/json (API)
NEWS
| # Install 'sqlcaser' in R: |
| install.packages('sqlcaser', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.
Last updated 12 months agofrom:471231d997. Checks:OK: 2. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Oct 31 2024 |
| R-4.5-linux | OK | Oct 31 2024 |
Exports:casewheninlistupdatetable
Dependencies:
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Generate a SQL CASE statement from a mapping file | casewhen |
| Generate a SQL IN statement from a mapping file | inlist |
| Generate a SQL UPDATE statement from a mapping file | updatetable |