search

energyPATHWAYS / EnergyPATHWAYS

EnergyPATHWAYS model is a professional, open-source energy and carbon planning tool for use in evaluating long-term, economy-wide greenhouse gas mitigation scenarios.
MIT License
45 stars 15 forks source link

Load system tables via SQLAlchemy #42

Closed mactyr closed 8 years ago

mactyr commented 8 years ago

[technical ticket, no story]

AC

  1. All system tables are available as SQLAlchemy model classes. The definition of "system table" is fuzzy, but as of my latest reckoning it includes:
    • [x] AgeGrowthOrDecayType
    • [x] CleaningMethods
    • [x] Currencies
    • [x] CurrenciesConversion
    • [x] CurrencyYears (note that this is slated for removal per #23, so I will actually be removing it and making the related code changes noted there rather than bringing it over into the new schema)
    • [x] Definitions
    • [x] DemandSectors
    • [x] DemandStockUnitTypes
    • [x] DemandTechUnitTypes
    • [x] EfficiencyTypes
    • [x] GreenhouseGasEmissionsType
    • [x] GreenhouseGases
    • [x] InflationConversion
    • [x] InputTypes
    • [x] OptPeriods
    • [x] ShapesTypes
    • [x] ShapesUnits
    • [x] StockDecayFunctions
    • [x] SupplyCostTypes
    • [x] SupplyTypes
    • [x] TimeZones (possibly we can get rid of this and use the timezone library's list instead?)

Note: IDMap and IndexLevels are system tables that currently exist but will be obviated by improvements we're making as we switch to SQLAlchemy and therefore don't need to be brought over to the new database.

mactyr commented 8 years ago

This is basically done on the data_access branch except for some lingering tidying up for #23. It probably won't be merged into master until the SQLAlchemy transition is complete, though.

mactyr commented 8 years ago

This is done on data_access except for some lingering data issues that are specific to #23, so I am closing.