db_xc_local: Manually Create Database Connections

Description Usage Details Value Examples

View source: R/db_functions.R

Description

Use these functions to manually create connections to either a local SQLite database or a remote MySQL database.

Usage

1
2
3

Details

They look for connection information in 'options("sqlite_path")' and 'options("mysql")'.

These connections can then be passed to ss_query when performing arbitrary SQL queries on the data.

Value

A database connection object

Examples

1
2
3
4
5
## Not run: 
conl <- db_xc_local()
ss_query(conl,"select * from main where name = 'RANDALL Kikkan' limit 3")

## End(Not run)

joranE/statskier2 documentation built on May 19, 2019, 8:42 p.m.