Store time series metadata in SQLite

[daniel-thom]

New features:

• Allows addition of user-defined features to time series arrays.
• Adds support for different time series resolutions.

Refactor/re-design:

• Store time series metadata in a SQLite database instead of per-component dictionaries. This allows system-wide SQL queries instead of looping across component dictionaries.
• Consolidate management of time series in TimeSeriesManager instead of individual time series storage implementations.

Features removed:

• get_time_series and get_time_series_multiple no longer support abstract types. This could be restored, but I think it’s better this way. list_time_series* methods support abstract types.

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 85.76642% with 117 lines in your changes are missing coverage. Please review.

Project coverage is 79.03%. Comparing base (7254a29) to head (09048b2).

:exclamation: Current head 09048b2 differs from pull request most recent head 608887e. Consider uploading reports for the commit 608887e to get more accurate results

Additional details and impacted files

[](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna) ```diff @@ Coverage Diff @@ ## main #348 +/- ## ========================================== - Coverage 80.34% 79.03% -1.31% ========================================== Files 54 56 +2 Lines 4416 4360 -56 ========================================== - Hits 3548 3446 -102 - Misses 868 914 +46 ``` | [Flag](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna) | Coverage Δ | | |---|---|---| | [unittests](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna) | `79.03% <85.76%> (-1.31%)` | :arrow_down: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#carryforward-flags-in-the-pull-request-comment) to find out more. | [Files](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?dropdown=coverage&src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna) | Coverage Δ | | |---|---|---| | [src/InfrastructureSystems.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2FInfrastructureSystems.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL0luZnJhc3RydWN0dXJlU3lzdGVtcy5qbA==) | `80.00% <ø> (ø)` | | | [src/abstract\_time\_series.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fabstract_time_series.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL2Fic3RyYWN0X3RpbWVfc2VyaWVzLmps) | `85.71% <100.00%> (+10.71%)` | :arrow_up: | | [src/component.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fcomponent.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL2NvbXBvbmVudC5qbA==) | `92.72% <100.00%> (-2.54%)` | :arrow_down: | | [src/components.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fcomponents.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL2NvbXBvbmVudHMuamw=) | `89.92% <100.00%> (-0.16%)` | :arrow_down: | | [src/containers.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fcontainers.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL2NvbnRhaW5lcnMuamw=) | `100.00% <100.00%> (ø)` | | | [src/deterministic\_metadata.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fdeterministic_metadata.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL2RldGVybWluaXN0aWNfbWV0YWRhdGEuamw=) | `95.45% <100.00%> (+86.36%)` | :arrow_up: | | [src/probabilistic.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fprobabilistic.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL3Byb2JhYmlsaXN0aWMuamw=) | `81.66% <100.00%> (ø)` | | | [src/scenarios.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fscenarios.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL3NjZW5hcmlvcy5qbA==) | `85.18% <100.00%> (ø)` | | | [src/serialization.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fserialization.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL3NlcmlhbGl6YXRpb24uamw=) | `70.33% <ø> (+9.70%)` | :arrow_up: | | [src/single\_time\_series.jl](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree&filepath=src%2Fsingle_time_series.jl&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna#diff-c3JjL3NpbmdsZV90aW1lX3Nlcmllcy5qbA==) | `68.00% <100.00%> (ø)` | | | ... and [20 more](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna) | | ... and [5 files with indirect coverage changes](https://app.codecov.io/gh/NREL-Sienna/InfrastructureSystems.jl/pull/348/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=NREL-Sienna)

[daniel-thom]

Closing because CodeCov is not currently working on forks.