static void GenerateInsertSql(RawReadingsDto json, int stationid, int location)
{
try
{
for (int i = 0; i < json.Readings.Length; i++)
{
lines.Add(
"INSERT INTO \"STATIONREADING\" (STATIONID, READINGLOCATION, READING_DATE, TEMPERATURE, AIR_PRESSURE, AMBIENT_LIGHT, HUMIDITY, ALTITUDE) VALUES ("
+ stationid + ", "
+ location + ", TO_DATE(\'" +
+json.Readings[i].Date.Year + "-"
+ json.Readings[i].Date.Month + "-"
+ json.Readings[i].Date.Day + " "
+ json.Readings[i].Date.Hour + ":"
+ json.Readings[i].Date.Minute + ":"
+ json.Readings[i].Date.Second + "\', \'YYYY-MM-DD HH24:MI:SS\'), "
+ json.Readings[i].Temperature + ", "
+ json.Readings[i].AirPressure + ", "
+ json.Readings[i].AmbientLight / 10.24 + ", "
+ json.Readings[i].Humidity + ", "
+ 1335 + ");");
}
File.WriteAllLines(@"C:\Users\Public\TestFolder\WriteLines.txt" + DateTime.Now.Date.Year, lines);
}
catch (Exception e)
{
Console.WriteLine("[ ERR ] " + e.Message);
}
}
public static string ToJson(this RawReadingsDto self) => JsonConvert.SerializeObject(self, GetDataFromAPI_GenerateSQL.Converter.Settings);
