init_virtualtables: Initialize SQLite extension virtual tables on a SQLite DB...

In virta: Virtual tables for RSQLite

Description

This function loads extension virtual tables to make them available to an RSQLite database connection. The databse connection needs to have been created by passing loadable.extensions = TRUE to dbConnect (this is the default as of RSQLite 0.9-1).

Usage

init_virtualtables(db)

Arguments

db	An RSQLite database connection as returned by dbConnect.

Value

TRUE if the virtual tables were successfully loaded.

Author(s)

Reijo Sund

References

For details on loadable extensions in SQLite, see http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions.

For details on virtual tables in SQLite, see http://www.sqlite.org/cvstrac/wiki?p=VirtualTables.

Examples

db <- dbConnect(SQLite(), dbname = ":memory:",
                loadable.extensions = TRUE)

init_virtualtables(db)

dbSendQuery(db, "create virtual table t1 using test")
dbGetQuery(db,"select * from t1")

dbDisconnect(db)

virta documentation built on May 2, 2019, 5:18 p.m.