lazysql: Lazy SQL Programming
Version 0.1.3

Helper functions to build SQL statements for dbGetQuery or dbSendQuery under program control. They are intended to increase speed of coding and to reduce coding errors. Arguments are carefully checked, in particular SQL identifiers such as names of tables or columns. More patterns will be added as required.

Browse man pages Browse package API and functions Browse package files

AuthorUwe Block [aut, cre]
Date of publication2016-03-12 06:16:37
MaintainerUwe Block <u.block.mz@gmail.com>
LicenseMIT + file LICENSE
Version0.1.3
URL https://github.com/UweBlock/lazysql
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("lazysql")

Man pages

date_between: Create SQL string to select date between two given dates
in_condition: Create SQL string to select values included in a set of given...
lazysql: Lazy SQL programming
natural_key: Create SQL string for joining on matching natural keys
valid_identifier_regex: Regex pattern to validate SQL identifier names

Functions

date_between Man page Source code
in_condition Man page Source code
lazysql Man page
lazysql-package Man page
natural_key Man page Source code
valid_identifier_regex Man page Source code

Files

tests
tests/testthat.R
tests/testthat
tests/testthat/test_natural_key.R
tests/testthat/test_date_between.R
tests/testthat/test_in_condition.R
NAMESPACE
NEWS.md
R
R/utils.R
R/date_between.R
R/lazysql-package.R
R/in_condition.R
R/natural_key.R
README.md
MD5
DESCRIPTION
man
man/valid_identifier_regex.Rd
man/date_between.Rd
man/lazysql.Rd
man/in_condition.Rd
man/natural_key.Rd
LICENSE
lazysql documentation built on May 19, 2017, 10:25 a.m.