Is there a plan to implement the unimplemented methods in the PlexosDB class ?

[NLaws]

There are 32 raise NotImplementedError in db.py. When if at all will these methods be implemented?

[pesap]

We implement it on a request basis (project dependent). Is there any particular one you are interested? If so we can make that work

[NLaws]

My first use case is updating "data flie" references (an example of how to do this would be great!). But in general I will be updating many object attributes.

[davidAlexander08]

Similar situation here. I’d like to create a DataFile object, attach one or more CSV files to it, and then link that DataFile to a Generator property so that PLEXOS will automatically use the CSV during a run.

I’m not entirely sure if this is the same use case as @NLaws , but it sounds very similar.

[pesap]

Can you both try this PR and let me know if it meets your needs? I added the implementation on this commit for showing how to do the DataFile manipulation.

[davidAlexander08]

Hey @pesap, thanks for the update! Looks solid to me. I tried adding a DataFile entry and then a generator and Plexos read it just fine. I didn’t run it, though, but it correctly identified the fields. However, I had to add a query to change everything to Dynamic for it to work. Without it, the fields were just static.

Dynamic:

db._db.execute("UPDATE t_config SET value = ? WHERE element = ?", ("1", "Dynamic"))

Here's the example I tried.

import sys
sys.path.insert(0, r"C:\Users\testa\Documents\git\plexosdb\src")
from plexosdb import PlexosDB
from plexosdb.enums import ClassEnum, CollectionEnum
from datetime import datetime
db = PlexosDB.from_xml("PLEXOS_BASE.xml")
db._db.execute("UPDATE t_config SET value = ? WHERE element = ?", ("1", "Dynamic"))


data_file = "Entrada/capacity_profile.csv"

datafile_name = "CapacityProfile"
objeto = db.add_object(ClassEnum.DataFile, datafile_name)
db.add_property(
    ClassEnum.DataFile, datafile_name, "Filename", 0.0, datafile_text=str(data_file), band=1
)
db.add_object(ClassEnum.Generator, "USINA1")
property_data_id = db.add_property(
    ClassEnum.Generator, "USINA1", "Max Capacity", 100.0, band=1
)

result: int = db.add_datafile_tag(property_data_id, str(data_file))


db.to_xml("output_model.xml")

[pesap]

Good catch, will add that to the PR!

[NLaws]

Thank you for this!