query_sql: Get query for all scenarios
In rplexos: Read and Analyze 'PLEXOS' Solutions
Description
Usage
Arguments
See Also
Examples
Description
Send a SQL query to all the files in a PLEXOS database object.
Usage
1
query_sql(db, sql)
Arguments
db
PLEXOS database object
sql
String containing the SQL query to be performed
See Also
plexos_open to create the PLEXOS database object
query_master to perform standard queries of data
Other special.queries: query_class,
query_config, query_log,
query_phase, query_property,
query_time
Examples
1
2
3
4
5
6
7
8
# Process the folder with the solution file provided by rplexos
location <- location_solution_rplexos()
process_folder(location)
# Query data
db <- plexos_open(location)
query_sql(db, "SELECT * from day")
query_sql(db, "SELECT * from time")
rplexos documentation built on Jan. 15, 2017, 11:37 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments See Also Examples
Description
Send a SQL query to all the files in a PLEXOS database object.
Usage
1 | query_sql(db, sql)
|
Arguments
db |
PLEXOS database object |
sql |
String containing the SQL query to be performed |
See Also
plexos_open to create the PLEXOS database object
query_master to perform standard queries of data
Other special.queries: query_class,
query_config, query_log,
query_phase, query_property,
query_time
Examples
1 2 3 4 5 6 7 8 | # Process the folder with the solution file provided by rplexos
location <- location_solution_rplexos()
process_folder(location)
# Query data
db <- plexos_open(location)
query_sql(db, "SELECT * from day")
query_sql(db, "SELECT * from time")
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.