query_sql: Get query for all scenarios

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")


Search within the rplexos package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.