HT-TL
Functionality of HT-TL
This project is also known as HTtl, HTtr, and Transformer. It takes Raw data from the extractor in a SQLite database and smooths the data placing it in a __ database.
Solution and Projects
HT-TL solution is named HTtl.sln. This solution contains 8 projects
- EN2PostgresContext.csproj
- HTLogger.csproj
- HTModels.csproj
- HTtl.csproj
- HTUtility.csproj
- PostgresContext.csproj
- SDPostgresContext.csproj
- SqliteContext.csproj
From a clean pull you will need to do the following:
- Epanet2Wrapper was not in the project to start *
To change the network or modify the run change the appsettings.json file in the HTtl project.
Files used to Test HT-EX
- Extracted.db3 - This will have several tables.
Create statments for EX and TL:
CREATE TABLE "RawData" ( "ScadaTagID" varchar(255) NOT NULL, "UnixTime" DateTime NOT NULL, "Value" DOUBLE, PRIMARY KEY("ScadaTagID","UnixTime") )
CREATE TABLE "ScadaTag" ( "ScadaTagID" TEXT, "DataSourceID" INTEGER)