Introduction | Demonstration | Advanced Examples | Using Named Columns and ELSE Clause | Working with Numeric Data and Auto-Quoting | Creating IN Lists with Duplicate Removal | Bulk UPDATE Statements | Sample Data | Function Reference | casewhen() - CASE Statement Generator | inlist() - IN Statement Generator | updatetable() - UPDATE Statement Generator | Common Parameters Explained | Installation | Acknowledgments | Citation and License
Package: sqlcaser 0.2.1
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.1.tar.gz
sqlcaser_0.2.1.tar.gz(r-4.7-any)sqlcaser_0.2.1.tar.gz(r-4.6-any)
sqlcaser_0.2.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
sqlcaser/json (API)
| # 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 from:d64e34d9c9. Checks:4 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 114 | ||
| source / vignettes | OK | 149 | ||
| linux-release-x86_64 | OK | 119 | ||
| wasm-release | OK | 96 |
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 |