virta.sql: SQL queries from Muste (SVO)-files using virtual tables
Description Usage Arguments Details Value Author(s)
Description
Makes it possible to easily utilize Muste (SVO)-files in SQL-queries and also move output results directly to SVO-files.
Usage
1 | virta.sql(query,destfile,database,encod)
|
Arguments
query |
SQL query |
destfile |
path to SVO-output file |
database |
path to RSQLite database file to be used (defaults to memory) |
encod |
force enconding (defaults to UTF-8) |
Details
Initializes database connection, enables virtual tables (references to SVO-files in queries must be given as MUSTE.<path to SVO-file>), runs the query, returns R data frame or outputs SVO-file.
Value
R data frame or SVO-file.
Author(s)
Reijo Sund
