@@ 184-200 (lines=17) @@ | ||
181 | e_min = Column(ARRAY(Float)) |
|
182 | ||
183 | ||
184 | class EgonDemandregioSitesIndElectricityDsmTimeseries(Base): |
|
185 | target = config.datasets()["DSM_CTS_industry"]["targets"][ |
|
186 | "demandregio_ind_sites_dsm" |
|
187 | ] |
|
188 | ||
189 | __tablename__ = target["table"] |
|
190 | __table_args__ = {"schema": target["schema"]} |
|
191 | ||
192 | industrial_sites_id = Column(Integer, primary_key=True, index=True) |
|
193 | scn_name = Column(String, primary_key=True, index=True) |
|
194 | bus = Column(Integer) |
|
195 | application = Column(String) |
|
196 | p_set = Column(ARRAY(Float)) |
|
197 | p_max = Column(ARRAY(Float)) |
|
198 | p_min = Column(ARRAY(Float)) |
|
199 | e_max = Column(ARRAY(Float)) |
|
200 | e_min = Column(ARRAY(Float)) |
|
201 | ||
202 | ||
203 | class EgonSitesIndLoadCurvesIndividualDsmTimeseries(Base): |
|
@@ 203-218 (lines=16) @@ | ||
200 | e_min = Column(ARRAY(Float)) |
|
201 | ||
202 | ||
203 | class EgonSitesIndLoadCurvesIndividualDsmTimeseries(Base): |
|
204 | target = config.datasets()["DSM_CTS_industry"]["targets"][ |
|
205 | "ind_sites_loadcurves_individual" |
|
206 | ] |
|
207 | ||
208 | __tablename__ = target["table"] |
|
209 | __table_args__ = {"schema": target["schema"]} |
|
210 | ||
211 | site_id = Column(Integer, primary_key=True, index=True) |
|
212 | scn_name = Column(String, primary_key=True, index=True) |
|
213 | bus = Column(Integer) |
|
214 | p_set = Column(ARRAY(Float)) |
|
215 | p_max = Column(ARRAY(Float)) |
|
216 | p_min = Column(ARRAY(Float)) |
|
217 | e_max = Column(ARRAY(Float)) |
|
218 | e_min = Column(ARRAY(Float)) |
|
219 | ||
220 | ||
221 | def add_metadata_individual(): |
|
@@ 166-181 (lines=16) @@ | ||
163 | e_min = Column(ARRAY(Float)) |
|
164 | ||
165 | ||
166 | class EgonOsmIndLoadCurvesIndividualDsmTimeseries(Base): |
|
167 | target = config.datasets()["DSM_CTS_industry"]["targets"][ |
|
168 | "ind_osm_loadcurves_individual_dsm" |
|
169 | ] |
|
170 | ||
171 | __tablename__ = target["table"] |
|
172 | __table_args__ = {"schema": target["schema"]} |
|
173 | ||
174 | osm_id = Column(Integer, primary_key=True, index=True) |
|
175 | scn_name = Column(String, primary_key=True, index=True) |
|
176 | bus = Column(Integer) |
|
177 | p_set = Column(ARRAY(Float)) |
|
178 | p_max = Column(ARRAY(Float)) |
|
179 | p_min = Column(ARRAY(Float)) |
|
180 | e_max = Column(ARRAY(Float)) |
|
181 | e_min = Column(ARRAY(Float)) |
|
182 | ||
183 | ||
184 | class EgonDemandregioSitesIndElectricityDsmTimeseries(Base): |
|
@@ 149-163 (lines=15) @@ | ||
146 | ||
147 | ||
148 | # Datasets |
|
149 | class EgonEtragoElectricityCtsDsmTimeseries(Base): |
|
150 | target = config.datasets()["DSM_CTS_industry"]["targets"][ |
|
151 | "cts_loadcurves_dsm" |
|
152 | ] |
|
153 | ||
154 | __tablename__ = target["table"] |
|
155 | __table_args__ = {"schema": target["schema"]} |
|
156 | ||
157 | bus = Column(Integer, primary_key=True, index=True) |
|
158 | scn_name = Column(String, primary_key=True, index=True) |
|
159 | p_set = Column(ARRAY(Float)) |
|
160 | p_max = Column(ARRAY(Float)) |
|
161 | p_min = Column(ARRAY(Float)) |
|
162 | e_max = Column(ARRAY(Float)) |
|
163 | e_min = Column(ARRAY(Float)) |
|
164 | ||
165 | ||
166 | class EgonOsmIndLoadCurvesIndividualDsmTimeseries(Base): |