Get query for all scenarios

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