rplexos (version 1.1.11)

query_sql: Get query for all scenarios

Description

Send a SQL query to all the files in a PLEXOS database object.

Usage

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

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