static Dictionary <string, string> GetLanguageDictionary(string language) { System.Collections.Generic.Dictionary <string, string> ht = new Dictionary <string, string>(); string filename = Path.Combine(FileManager.GetExecutingPath(), "language-" + language + ".txt"); string content = null; if (System.IO.File.Exists(filename)) { try { String[] lines = File.ReadAllLines(filename); foreach (string line in lines) { content = line; if (line.Length == 0) { continue; } if (line.StartsWith("#")) { continue; } if (!line.Contains("=")) { continue; } int pos = line.IndexOf("="); string key = line.Substring(0, pos).Trim(); string value = line.Substring(pos + 1); // Logfile.Log("Key insert: " + key); if (ht.ContainsKey(key)) { Logfile.Log($"Error Key '{key}' already in Dictionary!!!"); continue; } if (value.Trim().Length > 0) { ht.Add(key, value); } else { ht.Add(key, key + " xxx"); } } } catch (Exception ex) { Logfile.Log(ex.Message); Logfile.ExceptionWriter(ex, content); } } return(ht); }
public static bool IsShareData() { try { if (IsDocker()) { return(File.Exists("/tmp/sharedata.txt")); } string filepath = Path.Combine(FileManager.GetExecutingPath(), "sharedata.txt"); if (File.Exists(filepath)) { return(true); } filepath = Path.Combine(FileManager.GetExecutingPath(), "sharedata.txt.txt"); if (File.Exists(filepath)) { return(true); } } catch (Exception ex) { Logfile.ExceptionWriter(ex, "IsShareData"); } return(false); }
public Geofence() { Init(); fsw = new System.IO.FileSystemWatcher(FileManager.GetExecutingPath(), "*.csv"); fsw.Changed += Fsw_Changed; // fsw.Created += Fsw_Changed; // fsw.Renamed += Fsw_Changed; fsw.EnableRaisingEvents = true; }
internal static string GetSRTMDataPath() { var path = System.IO.Path.Combine(FileManager.GetExecutingPath(), "SRTM-Data"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } return(path); }
private static void WriteMissingFile(double missingOdometer) { try { string filepath = System.IO.Path.Combine(FileManager.GetExecutingPath(), "MISSINGKM"); System.IO.File.AppendAllText(filepath, DateTime.Now.ToString(Tools.ciDeDE) + " : " + $"Missing: {missingOdometer}km!\r\n"); UpdateTeslalogger.chmod(filepath, 666, false); } catch (Exception) { } }
public Geofence() { Init(); if (fsw == null) { fsw = new System.IO.FileSystemWatcher(FileManager.GetExecutingPath(), "*.csv"); fsw.NotifyFilter = System.IO.NotifyFilters.LastWrite; fsw.Changed += Fsw_Changed; // fsw.Created += Fsw_Changed; // fsw.Renamed += Fsw_Changed; fsw.EnableRaisingEvents = true; } }
private static void InitStage1() { Tools.SetThread_enUS(); UpdateTeslalogger.Chmod("nohup.out", 666, false); ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; Logfile.Log("TeslaLogger Version: " + Assembly.GetExecutingAssembly().GetName().Version); Logfile.Log("Teslalogger Online Version: " + WebHelper.GetOnlineTeslaloggerVersion()); Logfile.Log("Logfile Version: " + Assembly.GetAssembly(typeof(Logfile)).GetName().Version); Logfile.Log("SRTM Version: " + Assembly.GetAssembly(typeof(SRTM.SRTMData)).GetName().Version); try { string versionpath = Path.Combine(FileManager.GetExecutingPath(), "VERSION"); File.WriteAllText(versionpath, Assembly.GetExecutingAssembly().GetName().Version.ToString()); } catch (Exception) { } }
public Geofence(bool RacingMode) { _RacingMode = RacingMode; Init(); if (fsw == null) { fsw = new FileSystemWatcher(FileManager.GetExecutingPath(), "*.csv"); FSWCounter++; if (FSWCounter > 1) { Logfile.Log("ERROR: more than one FileSystemWatcher created!"); } fsw.NotifyFilter = NotifyFilters.LastWrite; fsw.Changed += Fsw_Changed; // fsw.Created += Fsw_Changed; // fsw.Renamed += Fsw_Changed; fsw.EnableRaisingEvents = true; } }
private static void InitStage1() { Tools.SetThreadEnUS(); UpdateTeslalogger.Chmod("nohup.out", 666, false); UpdateTeslalogger.Chmod("backup.sh", 777, false); UpdateTeslalogger.Chmod("TeslaLogger.exe", 755, false); #pragma warning disable CA5364 // Verwenden Sie keine veralteten Sicherheitsprotokolle. ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; #pragma warning restore CA5364 // Verwenden Sie keine veralteten Sicherheitsprotokolle. Logfile.Log("TeslaLogger Version: " + Assembly.GetExecutingAssembly().GetName().Version); Logfile.Log("Teslalogger Online Version: " + WebHelper.GetOnlineTeslaloggerVersion()); Logfile.Log("Logfile Version: " + Assembly.GetAssembly(typeof(Logfile)).GetName().Version); Logfile.Log("SRTM Version: " + Assembly.GetAssembly(typeof(SRTM.SRTMData)).GetName().Version); try { string versionpath = Path.Combine(FileManager.GetExecutingPath(), "VERSION"); File.WriteAllText(versionpath, Assembly.GetExecutingAssembly().GetName().Version.ToString()); } catch (Exception) { } try { if (File.Exists("BRANCH")) { var branch = File.ReadAllText("BRANCH").Trim(); Logfile.Log($"YOU ARE USING BRANCH: " + branch); ExceptionlessClient.Default.Configuration.DefaultData.Add("Branch", branch); ExceptionlessClient.Default.CreateLog("Program", "BRANCH: " + branch, Exceptionless.Logging.LogLevel.Warn).FirstCarUserID().Submit();; } } catch (Exception ex) { Logfile.Log(ex.ToString()); ex.ToExceptionless().FirstCarUserID().Submit(); } }
private static void InitStage1() { Tools.SetThreadEnUS(); UpdateTeslalogger.Chmod("nohup.out", 666, false); UpdateTeslalogger.Chmod("backup.sh", 777, false); UpdateTeslalogger.Chmod("TeslaLogger.exe", 755, false); #pragma warning disable CA5364 // Verwenden Sie keine veralteten Sicherheitsprotokolle. ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; #pragma warning restore CA5364 // Verwenden Sie keine veralteten Sicherheitsprotokolle. Logfile.Log("TeslaLogger Version: " + Assembly.GetExecutingAssembly().GetName().Version); Logfile.Log("Teslalogger Online Version: " + WebHelper.GetOnlineTeslaloggerVersion()); Logfile.Log("Logfile Version: " + Assembly.GetAssembly(typeof(Logfile)).GetName().Version); Logfile.Log("SRTM Version: " + Assembly.GetAssembly(typeof(SRTM.SRTMData)).GetName().Version); try { string versionpath = Path.Combine(FileManager.GetExecutingPath(), "VERSION"); File.WriteAllText(versionpath, Assembly.GetExecutingAssembly().GetName().Version.ToString()); } catch (Exception) { } }
static void Main(string[] args) { CheckNewCredentials(); try { Tools.SetThread_enUS(); UpdateTeslalogger.chmod("nohup.out", 666, false); ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; Logfile.Log("TeslaLogger Version: " + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version); Logfile.Log("Logfile Version: " + System.Reflection.Assembly.GetAssembly(typeof(Logfile)).GetName().Version); Logfile.Log("SRTM Version: " + System.Reflection.Assembly.GetAssembly(typeof(SRTM.SRTMData)).GetName().Version); try { string versionpath = System.IO.Path.Combine(FileManager.GetExecutingPath(), "VERSION"); System.IO.File.WriteAllText(versionpath, System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString()); } catch (Exception) { } try { if (Tools.IsDocker()) { Logfile.Log("Docker: YES!"); if (!System.IO.File.Exists("/etc/teslalogger/settings.json")) { Logfile.Log("Creating empty settings.json"); System.IO.File.AppendAllText("/etc/teslalogger/settings.json", "{\"SleepTimeSpanStart\":\"\",\"SleepTimeSpanEnd\":\"\",\"SleepTimeSpanEnable\":\"false\",\"Power\":\"hp\",\"Temperature\":\"celsius\",\"Length\":\"km\",\"Language\":\"en\",\"URL_Admin\":\"\",\"ScanMyTesla\":\"false\"}"); UpdateTeslalogger.chmod("/etc/teslalogger/settings.json", 666); } if (!System.IO.Directory.Exists("/etc/teslalogger/backup")) { System.IO.Directory.CreateDirectory("/etc/teslalogger/backup"); UpdateTeslalogger.chmod("/etc/teslalogger/backup", 777); } if (!System.IO.Directory.Exists("/etc/teslalogger/Exception")) { System.IO.Directory.CreateDirectory("/etc/teslalogger/Exception"); UpdateTeslalogger.chmod("/etc/teslalogger/Exception", 777); } } else { Logfile.Log("Docker: NO!"); } } catch (Exception ex) { Logfile.Log(ex.ToString()); } Logfile.Log("Current Culture: " + System.Threading.Thread.CurrentThread.CurrentCulture.ToString()); Logfile.Log("Mono Runtime: " + Tools.GetMonoRuntimeVersion()); Logfile.Log("Grafana Version: " + Tools.GetGrafanaVersion()); Logfile.Log("OS Version: " + Tools.GetOsVersion()); Logfile.Log("DBConnectionstring: " + DBHelper.DBConnectionstring); Logfile.Log("Car#:" + ApplicationSettings.Default.Car); Logfile.Log("KeepOnlineMinAfterUsage: " + ApplicationSettings.Default.KeepOnlineMinAfterUsage); Logfile.Log("SuspendAPIMinutes: " + ApplicationSettings.Default.SuspendAPIMinutes); Logfile.Log("SleepPositions: " + ApplicationSettings.Default.SleepPosition); Logfile.Log("UseScanMyTesla: " + Tools.UseScanMyTesla()); for (int x = 1; x <= 30; x++) // try 30 times until DB is up and running { try { Logfile.Log("DB Version: " + DBHelper.GetVersion()); Logfile.Log("Count Pos: " + DBHelper.CountPos()); // test the DBConnection break; } catch (Exception ex) { if (ex.Message.Contains("Connection refused")) { Logfile.Log($"Wait for DB ({x}/30): Connection refused."); } else { Logfile.Log("DBCONNECTION " + ex.Message); } System.Threading.Thread.Sleep(15000); } } WebHelper wh = new WebHelper(); if (!wh.RestoreToken()) { wh.Tesla_token = wh.GetTokenAsync().Result; } if (wh.Tesla_token == "NULL") { return; } // don't show full Token in Logfile string tempToken = wh.Tesla_token; if (tempToken.Length > 5) { tempToken = tempToken.Substring(0, tempToken.Length - 5); tempToken += "XXXXX"; } Logfile.Log("TOKEN: " + tempToken); if (DBHelper.DBConnectionstring.Length == 0) { return; } if (wh.GetVehicles() == "NULL") { return; } String online = wh.IsOnline().Result; Logfile.Log("Streamingtoken: " + wh.Tesla_Streamingtoken); if (DBHelper.GetMaxPosid(false) == 0) { Logfile.Log("Insert first Pos"); wh.IsDriving(true); } DBHelper.GetEconomy_Wh_km(wh); wh.DeleteWakeupFile(); String carName = wh.carSettings.Name; if (wh.carSettings.Raven) { carName += " Raven"; } Logfile.Log("Car: " + carName + " - " + wh.carSettings.Wh_TR + " Wh/km"); double.TryParse(wh.carSettings.Wh_TR, out DBHelper.currentJSON.Wh_TR); DBHelper.GetLastTrip(); UpdateTeslalogger.Start(wh); UpdateTeslalogger.UpdateGrafana(wh); DBHelper.currentJSON.current_car_version = DBHelper.GetLastCarVersion(); MQTTClient.StartMQTTClient(); new System.Threading.Thread(() => { System.Threading.Thread.Sleep(30000); DBHelper.UpdateElevationForAllPoints(); WebHelper.UpdateAllPOIAddresses(); DBHelper.CheckForInterruptedCharging(true); wh.UpdateAllEmptyAddresses(); DBHelper.UpdateIncompleteTrips(); DBHelper.UpdateAllChargingMaxPower(); var sd = new ShareData(wh.TaskerHash); sd.SendAllChargingData(); sd.SendDegradationData(); }).Start(); DBHelper.currentJSON.current_odometer = DBHelper.getLatestOdometer(); DBHelper.currentJSON.CreateCurrentJSON(); // wh.IsDriving(); // wh.GetCachedRollupData(); // wh.GetEnergyChartData(); // wh.StartStreamThread(); // xxx // string w = wh.Wakeup().Result; Address lastRacingPoint = null; while (true) { try { switch (currentState) { case TeslaState.Start: { RefreshToken(wh); if (wh.scanMyTesla != null) { wh.scanMyTesla.FastMode(false); } // Alle States werden geschlossen DBHelper.CloseChargingState(); DBHelper.CloseDriveState(wh.lastIsDriveTimestamp); string res = wh.IsOnline().Result; lastCarUsed = DateTime.Now; if (res == "online") { Logfile.Log(res); currentState = TeslaState.Online; wh.IsDriving(true); wh.ResetLastChargingState(); DBHelper.StartState(res); continue; } else if (res == "asleep") { Logfile.Log(res); currentState = TeslaState.Sleep; DBHelper.StartState(res); wh.ResetLastChargingState(); DBHelper.currentJSON.CreateCurrentJSON(); } else if (res == "offline") { Logfile.Log(res); DBHelper.StartState(res); DBHelper.currentJSON.CreateCurrentJSON(); while (true) { System.Threading.Thread.Sleep(30000); string res2 = wh.IsOnline().Result; if (res2 != "offline") { Logfile.Log("Back Online: " + res2); break; } if (wh.TaskerWakeupfile()) { if (wh.DeleteWakeupFile()) { string wakeup = wh.Wakeup().Result; lastCarUsed = DateTime.Now; } currentState = TeslaState.Start; break; } } } else { DBHelper.currentJSON.current_sleeping = false; DBHelper.currentJSON.current_online = false; DBHelper.currentJSON.CreateCurrentJSON(); Logfile.Log("Unhandled State: " + res); } } break; case TeslaState.Online: { if (wh.IsDriving() && DBHelper.currentJSON.current_speed > 0) { wh.ResetLastChargingState(); lastCarUsed = DateTime.Now; lastOdometerChanged = DateTime.Now; Logfile.Log("Driving"); if (wh.scanMyTesla != null) { wh.scanMyTesla.FastMode(true); } double missingOdometer = DBHelper.currentJSON.current_odometer - odometerLastTrip; if (odometerLastTrip != 0) { if (missingOdometer > 5) { Logfile.Log($"Missing: {missingOdometer} km! - Check: https://teslalogger.de/faq-1.php"); WriteMissingFile(missingOdometer); } else { Logfile.Log($"Missing: {missingOdometer} km"); } } // TODO: StartDriving currentState = TeslaState.Drive; wh.StartStreamThread(); // für altitude DBHelper.StartDriveState(); Task.Run(() => wh.DeleteWakeupFile()); continue; } else if (wh.isCharging(true)) { lastCarUsed = DateTime.Now; Logfile.Log("Charging"); if (wh.scanMyTesla != null) { wh.scanMyTesla.FastMode(true); } wh.IsDriving(true); DBHelper.StartChargingState(wh); currentState = TeslaState.Charge; wh.DeleteWakeupFile(); } else { RefreshToken(wh); int startSleepHour, startSleepMinute; Tools.StartSleeping(out startSleepHour, out startSleepMinute); bool sleep = true; if (FileManager.CheckCmdGoSleepFile()) { Logfile.Log("STOP communication with Tesla Server to enter sleep Mode! (Sleep Button) https://teslalogger.de/faq-1.php"); currentState = TeslaState.GoSleep; goSleepWithWakeup = false; } else if (DateTime.Now.Hour == startSleepHour && DateTime.Now.Minute == startSleepMinute) { Logfile.Log("STOP communication with Tesla Server to enter sleep Mode! (Timespan Sleep Mode) https://teslalogger.de/faq-1.php"); currentState = TeslaState.GoSleep; goSleepWithWakeup = true; } else { // wenn er 15 min online war und nicht geladen oder gefahren ist, dann muss man ihn die möglichkeit geben offline zu gehen TimeSpan ts = DateTime.Now - lastCarUsed; if (ts.TotalMinutes > ApplicationSettings.Default.KeepOnlineMinAfterUsage) { currentState = TeslaState.Start; wh.IsDriving(true); // kurz bevor er schlafen geht, eine Positionsmeldung speichern und schauen ob standheizung / standklima / sentry läuft. if (DBHelper.currentJSON.current_is_preconditioning) { Logfile.Log("preconditioning prevents car to get sleep"); lastCarUsed = DateTime.Now; } else if (wh.is_sentry_mode) { Logfile.Log("sentry_mode prevents car to get sleep"); lastCarUsed = DateTime.Now; } else { try { Logfile.Log("STOP communication with Tesla Server to enter sleep Mode! https://teslalogger.de/faq-1.php"); for (int x = 0; x < ApplicationSettings.Default.SuspendAPIMinutes * 10; x++) { TimeSpan tsSMT = DateTime.Now - DBHelper.currentJSON.lastScanMyTeslaReceived; if (DBHelper.currentJSON.SMTSpeed > 5 && DBHelper.currentJSON.SMTSpeed < 260 && DBHelper.currentJSON.SMTBatteryPower > 2 && tsSMT.TotalMinutes < 5) { Logfile.Log("ScanMyTesla prevents car to get sleep. Speed: " + DBHelper.currentJSON.SMTSpeed); lastCarUsed = DateTime.Now; string wakeup = wh.Wakeup().Result; sleep = false; break; } if (wh.existsWakeupFile) { Logfile.Log("Wakeupfile prevents car to get sleep"); lastCarUsed = DateTime.Now; wh.DeleteWakeupFile(); string wakeup = wh.Wakeup().Result; sleep = false; break; } if (x % 10 == 0) { Logfile.Log("Waiting for car to go to sleep " + (x / 10).ToString()); Tools.StartSleeping(out startSleepHour, out startSleepMinute); if (DateTime.Now.Hour == startSleepHour && DateTime.Now.Minute == startSleepMinute) { Logfile.Log("STOP communication with Tesla Server to enter sleep Mode! (Timespan Sleep Mode) https://teslalogger.de/faq-1.php"); currentState = TeslaState.GoSleep; goSleepWithWakeup = true; break; } } System.Threading.Thread.Sleep(1000 * 6); } } finally { if (!goSleepWithWakeup) { Logfile.Log("Restart communication with Tesla Server!"); } } } } } if (sleep) { System.Threading.Thread.Sleep(5000); } else { continue; } } } break; case TeslaState.Charge: { if (!wh.isCharging()) { // TODO: ende des ladens in die datenbank schreiben currentState = TeslaState.Start; wh.IsDriving(true); } else { lastCarUsed = DateTime.Now; System.Threading.Thread.Sleep(10000); //wh.GetCachedRollupData(); } } break; case TeslaState.Sleep: { string res = wh.IsOnline().Result; if (res == "online") { Logfile.Log(res); currentState = TeslaState.Start; wh.IsDriving(true); // Positionsmeldung in DB für Wechsel } else { // Logfile.Log(res); System.Threading.Thread.Sleep(10000); } } break; case TeslaState.Drive: { int t = Environment.TickCount; if (wh.IsDriving()) { lastCarUsed = DateTime.Now; t = ApplicationSettings.Default.SleepPosition - 1000 - (Environment.TickCount - t); if (t > 0) { System.Threading.Thread.Sleep(t); // alle 5 sek eine positionsmeldung } if (odometerLastTrip != DBHelper.currentJSON.current_odometer) { odometerLastTrip = DBHelper.currentJSON.current_odometer; lastOdometerChanged = DateTime.Now; } else { if (wh.isCharging(true)) { Logfile.Log("Charging during Drive -> Finish Trip!!!"); DriveFinished(wh); } else { // Odometer didn't change for 600 seconds TimeSpan ts = DateTime.Now - lastOdometerChanged; if (ts.TotalSeconds > 600) { Logfile.Log("Odometer didn't change for 600 seconds -> Finish Trip!!!"); DriveFinished(wh); } } } if (WebHelper.geofence.RacingMode) { Address a = WebHelper.geofence.GetPOI(DBHelper.currentJSON.latitude, DBHelper.currentJSON.longitude); if (a != null) { if (lastRacingPoint == null) { lastRacingPoint = a; Logfile.Log("RACING MODE: Finish Trip!"); DriveFinished(wh); } } else { lastRacingPoint = null; } } } else { DriveFinished(wh); ShareData sd = new ShareData(wh.TaskerHash); sd.SendAllChargingData(); } } break; case TeslaState.GoSleep: { wh.ResetLastChargingState(); bool KeepSleeping = true; int round = 0; try { while (KeepSleeping) { round++; System.Threading.Thread.Sleep(1000); if (System.IO.File.Exists(FileManager.GetFilePath(TLFilename.WakeupFilename))) { if (wh.DeleteWakeupFile()) { string wakeup = wh.Wakeup().Result; } KeepSleeping = false; currentState = TeslaState.Start; break; } else if (round > 10) { round = 0; if (wh.TaskerWakeupfile()) { if (wh.DeleteWakeupFile()) { string wakeup = wh.Wakeup().Result; } KeepSleeping = false; currentState = TeslaState.Start; break; } } if (goSleepWithWakeup) { int stopSleepingHour, stopSleepingMinute; Tools.EndSleeping(out stopSleepingHour, out stopSleepingMinute); if (DateTime.Now.Hour == stopSleepingHour && DateTime.Now.Minute == stopSleepingMinute) { Logfile.Log("Stop Sleeping Timespan reached!"); KeepSleeping = false; currentState = TeslaState.Start; break; } } } } finally { Logfile.Log("Restart communication with Tesla Server!"); } } break; } } catch (Exception ex) { Logfile.ExceptionWriter(ex, "While Schleife"); } if (WebHelper.geofence.RacingMode) { System.Threading.Thread.Sleep(10); } else { System.Threading.Thread.Sleep(1000); } } } catch (Exception ex) { Logfile.Log(ex.Message); Logfile.ExceptionWriter(ex, "While Schleife"); } finally { Logfile.Log("Teslalogger Stopped!"); } }
public static void Start(WebHelper wh) { try { if (!DBHelper.ColumnExists("pos", "battery_level")) { Logfile.Log("ALTER TABLE pos ADD COLUMN battery_level DOUBLE NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN battery_level DOUBLE NULL"); } if (!DBHelper.ColumnExists("drivestate", "outside_temp_avg")) { Logfile.Log("ALTER TABLE drivestate ADD COLUMN outside_temp_avg DOUBLE NULL, ADD COLUMN speed_max INT NULL, ADD COLUMN power_max INT NULL, ADD COLUMN power_min INT NULL, ADD COLUMN power_avg DOUBLE NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE drivestate ADD COLUMN outside_temp_avg DOUBLE NULL, ADD COLUMN speed_max INT NULL, ADD COLUMN power_max INT NULL, ADD COLUMN power_min INT NULL, ADD COLUMN power_avg DOUBLE NULL"); DBHelper.UpdateAllDrivestateData(); } if (!DBHelper.ColumnExists("charging", "charger_pilot_current")) { Logfile.Log("ALTER TABLE charging ADD COLUMN charger_pilot_current INT NULL, ADD COLUMN charge_current_request INT NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE charging ADD COLUMN charger_pilot_current INT NULL, ADD COLUMN charge_current_request INT NULL"); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.TableExists("car_version")) { Logfile.Log("CREATE TABLE car_version (id int NOT NULL AUTO_INCREMENT, StartDate datetime NOT NULL, version varchar(50), PRIMARY KEY(id))"); DBHelper.ExecuteSQLQuery("CREATE TABLE car_version (id int NOT NULL AUTO_INCREMENT, StartDate datetime NOT NULL, version varchar(50), PRIMARY KEY(id))"); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.TableExists("can")) { Logfile.Log("CREATE TABLE `can` (`datum` datetime NOT NULL, `id` mediumint NOT NULL, `val` double DEFAULT NULL, PRIMARY KEY(`datum`,`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1;"); DBHelper.ExecuteSQLQuery("CREATE TABLE `can` (`datum` datetime NOT NULL, `id` mediumint NOT NULL, `val` double DEFAULT NULL, PRIMARY KEY(`datum`,`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1;"); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "inside_temp")) { Logfile.Log("ALTER TABLE pos ADD COLUMN inside_temp DOUBLE NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN inside_temp DOUBLE NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "battery_heater")) { Logfile.Log("ALTER TABLE pos ADD COLUMN battery_heater TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN battery_heater TINYINT(1) NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "is_preconditioning")) { Logfile.Log("ALTER TABLE pos ADD COLUMN is_preconditioning TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN is_preconditioning TINYINT(1) NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "sentry_mode")) { Logfile.Log("ALTER TABLE pos ADD COLUMN sentry_mode TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN sentry_mode TINYINT(1) NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "conn_charge_cable")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN conn_charge_cable varchar(50)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN conn_charge_cable varchar(50)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "fast_charger_brand")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN fast_charger_brand varchar(50)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN fast_charger_brand varchar(50)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "fast_charger_type")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN fast_charger_type varchar(50)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN fast_charger_type varchar(50)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "fast_charger_present")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN fast_charger_present TINYINT(1)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN fast_charger_present TINYINT(1)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("charging", "battery_heater")) { Logfile.Log("ALTER TABLE charging ADD COLUMN battery_heater TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE charging ADD COLUMN battery_heater TINYINT(1) NULL", 600); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "max_charger_power")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN max_charger_power int NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN max_charger_power int NULL", 600); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("trip", "outside_temp_avg")) { UpdateDBView(wh); } System.Threading.Timer t = new System.Threading.Timer(FileChecker, null, 10000, 5000); chmod("/var/www/html/admin/wallpapers", 777); UpdatePHPini(); try { // create empty weather.ini file string filepath = System.IO.Path.Combine(FileManager.GetExecutingPath(), "weather.ini"); if (!File.Exists(filepath)) { System.IO.File.WriteAllText(filepath, "city = \"Berlin, de\"\r\nappid = \"12345678901234567890123456789012\""); } UpdateTeslalogger.chmod(filepath, 666, false); } catch (Exception) { } if (System.IO.File.Exists("cmd_updated.txt")) { Logfile.Log("Update skipped!"); return; } System.IO.File.AppendAllText("cmd_updated.txt", DateTime.Now.ToLongTimeString()); Logfile.Log("Start update"); if (Tools.IsMono()) { chmod("VERSION", 666); chmod("settings.json", 666); chmod("cmd_updated.txt", 666); chmod("MQTTClient.exe.config", 666); if (!exec_mono("git", "--version", false).Contains("git version")) { exec_mono("apt-get", "-y install git"); exec_mono("git", "--version"); } exec_mono("rm", "-rf /etc/teslalogger/git/*"); exec_mono("rm", "-rf /etc/teslalogger/git"); exec_mono("mkdir", "/etc/teslalogger/git"); exec_mono("git", "clone https://github.com/bassmaster187/TeslaLogger /etc/teslalogger/git/"); Tools.CopyFilesRecursively(new System.IO.DirectoryInfo("/etc/teslalogger/git/TeslaLogger/GrafanaPlugins"), new System.IO.DirectoryInfo("/var/lib/grafana/plugins")); Tools.CopyFilesRecursively(new System.IO.DirectoryInfo("/etc/teslalogger/git/TeslaLogger/www"), new System.IO.DirectoryInfo("/var/www/html")); Tools.CopyFile("/etc/teslalogger/git/TeslaLogger/bin/geofence.csv", "/etc/teslalogger/geofence.csv"); Tools.CopyFile("/etc/teslalogger/git/TeslaLogger/GrafanaConfig/sample.yaml", "/etc/grafana/provisioning/dashboards/sample.yaml"); if (!System.IO.Directory.Exists("/var/lib/grafana/dashboards")) { System.IO.Directory.CreateDirectory("/var/lib/grafana/dashboards"); } Tools.CopyFilesRecursively(new System.IO.DirectoryInfo("/etc/teslalogger/git/TeslaLogger/bin"), new System.IO.DirectoryInfo("/etc/teslalogger")); try { if (!File.Exists("/etc/teslalogger/MQTTClient.exe.config")) { Logfile.Log("Copy empty MQTTClient.exe.config file"); Tools.CopyFile("/etc/teslalogger/git/MQTTClient/App.config", "/etc/teslalogger/MQTTClient.exe.config"); } } catch (Exception ex) { Logfile.Log(ex.ToString()); } } Logfile.Log("End update"); Logfile.Log("Rebooting"); exec_mono("reboot", ""); } catch (Exception ex) { Logfile.Log("Error in update: " + ex.ToString()); } }
public async Task <string> GetDataFromWebservice() { string resultContent = ""; try { HttpClient client = new HttpClient(); FormUrlEncodedContent content = new FormUrlEncodedContent(new[] { new KeyValuePair <string, string>("t", token) }); DateTime start = DateTime.UtcNow; HttpResponseMessage result = await client.PostAsync("http://teslalogger.de/get_scanmytesla.php", content); resultContent = await result.Content.ReadAsStringAsync(); DBHelper.AddMothershipDataToDB("teslalogger.de/get_scanmytesla.php", start, (int)result.StatusCode); if (resultContent == "not found") { return("not found"); } if (resultContent.Contains("Resource Limit Is Reached")) { Logfile.Log("SMT: Resource Limit Is Reached"); Thread.Sleep(25000); return("Resource Limit Is Reached"); } string temp = resultContent; int i = 0; i = temp.IndexOf("\r\n"); string id = temp.Substring(0, i); temp = temp.Substring(i + 2); i = temp.IndexOf("\r\n"); string date = temp.Substring(0, i); temp = temp.Substring(i + 2); dynamic j = new JavaScriptSerializer().DeserializeObject(temp); DateTime d = DateTime.Parse(j["d"]); DBHelper.currentJSON.lastScanMyTeslaReceived = d; DBHelper.currentJSON.CreateCurrentJSON(); Dictionary <string, object> kv = (Dictionary <string, object>)j["dict"]; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO `can` (`datum`, `id`, `val`) VALUES "); bool first = true; string sqlDate = d.ToString("yyyy-MM-dd HH:mm:ss"); foreach (KeyValuePair <string, object> line in kv) { if (line.Value.ToString().Contains("Infinity") || line.Value.ToString().Contains("NaN")) { continue; } switch (line.Key) { case "2": DBHelper.currentJSON.SMTCellTempAvg = Convert.ToDouble(line.Value); break; case "5": DBHelper.currentJSON.SMTCellMinV = Convert.ToDouble(line.Value); break; case "6": DBHelper.currentJSON.SMTCellAvgV = Convert.ToDouble(line.Value); break; case "7": DBHelper.currentJSON.SMTCellMaxV = Convert.ToDouble(line.Value); break; case "28": DBHelper.currentJSON.SMTBMSmaxCharge = Convert.ToDouble(line.Value); break; case "29": DBHelper.currentJSON.SMTBMSmaxDischarge = Convert.ToDouble(line.Value); break; case "442": if (Convert.ToDouble(line.Value) == 287.6) // SNA - Signal not Available { DBHelper.currentJSON.SMTSpeed = 0; Logfile.Log("SMT Speed: Signal not Available"); } else { DBHelper.currentJSON.SMTSpeed = Convert.ToDouble(line.Value); } break; case "43": DBHelper.currentJSON.SMTBatteryPower = Convert.ToDouble(line.Value); break; default: break; } if (first) { first = false; } else { sb.Append(","); } sb.Append("('"); sb.Append(sqlDate); sb.Append("',"); sb.Append(line.Key); sb.Append(","); sb.Append(Convert.ToDouble(line.Value).ToString(Tools.ciEnUS)); sb.Append(")"); } using (MySqlConnection con = new MySqlConnection(DBHelper.DBConnectionstring)) { con.Open(); MySqlCommand cmd = new MySqlCommand(sb.ToString(), con); cmd.ExecuteNonQuery(); try { string lastscanmyteslafilepaht = System.IO.Path.Combine(FileManager.GetExecutingPath(), "LASTSCANMYTESLA"); System.IO.File.WriteAllText(lastscanmyteslafilepaht, sqlDate); } catch (Exception) { } return("insert ok [" + kv.Keys.Count + "] " + d.ToString()); } } catch (Exception ex) { Logfile.ExceptionWriter(ex, resultContent); Thread.Sleep(10000); } return("NULL"); }
public static void Start(WebHelper wh) { try { shareDataOnStartup = Tools.IsShareData(); if (!DBHelper.ColumnExists("pos", "battery_level")) { Logfile.Log("ALTER TABLE pos ADD COLUMN battery_level DOUBLE NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN battery_level DOUBLE NULL"); } if (!DBHelper.ColumnExists("drivestate", "outside_temp_avg")) { Logfile.Log("ALTER TABLE drivestate ADD COLUMN outside_temp_avg DOUBLE NULL, ADD COLUMN speed_max INT NULL, ADD COLUMN power_max INT NULL, ADD COLUMN power_min INT NULL, ADD COLUMN power_avg DOUBLE NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE drivestate ADD COLUMN outside_temp_avg DOUBLE NULL, ADD COLUMN speed_max INT NULL, ADD COLUMN power_max INT NULL, ADD COLUMN power_min INT NULL, ADD COLUMN power_avg DOUBLE NULL"); DBHelper.UpdateAllDrivestateData(); } if (!DBHelper.ColumnExists("charging", "charger_pilot_current")) { Logfile.Log("ALTER TABLE charging ADD COLUMN charger_pilot_current INT NULL, ADD COLUMN charge_current_request INT NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE charging ADD COLUMN charger_pilot_current INT NULL, ADD COLUMN charge_current_request INT NULL"); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.TableExists("car_version")) { Logfile.Log("CREATE TABLE car_version (id int NOT NULL AUTO_INCREMENT, StartDate datetime NOT NULL, version varchar(50), PRIMARY KEY(id))"); DBHelper.ExecuteSQLQuery("CREATE TABLE car_version (id int NOT NULL AUTO_INCREMENT, StartDate datetime NOT NULL, version varchar(50), PRIMARY KEY(id))"); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.TableExists("can")) { Logfile.Log("CREATE TABLE `can` (`datum` datetime NOT NULL, `id` mediumint NOT NULL, `val` double DEFAULT NULL, PRIMARY KEY(`datum`,`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1;"); DBHelper.ExecuteSQLQuery("CREATE TABLE `can` (`datum` datetime NOT NULL, `id` mediumint NOT NULL, `val` double DEFAULT NULL, PRIMARY KEY(`datum`,`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1;"); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "inside_temp")) { Logfile.Log("ALTER TABLE pos ADD COLUMN inside_temp DOUBLE NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN inside_temp DOUBLE NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "battery_heater")) { Logfile.Log("ALTER TABLE pos ADD COLUMN battery_heater TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN battery_heater TINYINT(1) NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "is_preconditioning")) { Logfile.Log("ALTER TABLE pos ADD COLUMN is_preconditioning TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN is_preconditioning TINYINT(1) NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("pos", "sentry_mode")) { Logfile.Log("ALTER TABLE pos ADD COLUMN sentry_mode TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE pos ADD COLUMN sentry_mode TINYINT(1) NULL", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "conn_charge_cable")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN conn_charge_cable varchar(50)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN conn_charge_cable varchar(50)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "fast_charger_brand")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN fast_charger_brand varchar(50)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN fast_charger_brand varchar(50)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "fast_charger_type")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN fast_charger_type varchar(50)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN fast_charger_type varchar(50)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "fast_charger_present")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN fast_charger_present TINYINT(1)"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN fast_charger_present TINYINT(1)", 300); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("charging", "battery_heater")) { Logfile.Log("ALTER TABLE charging ADD COLUMN battery_heater TINYINT(1) NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE charging ADD COLUMN battery_heater TINYINT(1) NULL", 600); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("chargingstate", "max_charger_power")) { Logfile.Log("ALTER TABLE chargingstate ADD COLUMN max_charger_power int NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE chargingstate ADD COLUMN max_charger_power int NULL", 600); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.ColumnExists("trip", "outside_temp_avg")) { UpdateDBView(wh); } if (!DBHelper.TableExists("mothership")) { Logfile.Log("CREATE TABLE mothership (id int NOT NULL AUTO_INCREMENT, ts datetime NOT NULL, commandid int NOT NULL, duration DOUBLE NULL, PRIMARY KEY(id))"); DBHelper.ExecuteSQLQuery("CREATE TABLE mothership (id int NOT NULL AUTO_INCREMENT, ts datetime NOT NULL, commandid int NOT NULL, duration DOUBLE NULL, PRIMARY KEY(id))"); Logfile.Log("CREATE TABLE OK"); } if (!DBHelper.TableExists("mothershipcommands")) { Logfile.Log("CREATE TABLE mothershipcommands (id int NOT NULL AUTO_INCREMENT, command varchar(50) NOT NULL, PRIMARY KEY(id))"); DBHelper.ExecuteSQLQuery("CREATE TABLE mothershipcommands (id int NOT NULL AUTO_INCREMENT, command varchar(50) NOT NULL, PRIMARY KEY(id))"); Logfile.Log("CREATE TABLE OK"); } if (!DBHelper.ColumnExists("mothership", "httpcode")) { Logfile.Log("ALTER TABLE mothership ADD COLUMN httpcode int NULL"); DBHelper.ExecuteSQLQuery("ALTER TABLE mothership ADD COLUMN httpcode int NULL", 600); Logfile.Log("ALTER TABLE OK"); } if (!DBHelper.TableExists("httpcodes")) { Logfile.Log("CREATE TABLE httpcodes (id int NOT NULL, text varchar(50) NOT NULL, PRIMARY KEY(id))"); DBHelper.ExecuteSQLQuery("CREATE TABLE httpcodes (id int NOT NULL, text varchar(50) NOT NULL, PRIMARY KEY(id))"); Logfile.Log("CREATE TABLE OK"); } if (!DBHelper.IndexExists("can_ix", "can")) { Logfile.Log("alter table can add index can_ix (id,datum)"); DBHelper.ExecuteSQLQuery("alter table can add index can_ix (id,datum)", 600); Logfile.Log("ALTER TABLE OK"); } DBHelper.EnableMothership(); CheckDBCharset(); DBHelper.UpdateHTTPStatusCodes(); timer = new System.Threading.Timer(FileChecker, wh, 10000, 5000); Chmod("/var/www/html/admin/wallpapers", 777); UpdatePHPini(); try { // create empty weather.ini file string filepath = Path.Combine(FileManager.GetExecutingPath(), "weather.ini"); if (!File.Exists(filepath)) { File.WriteAllText(filepath, "city = \"Berlin, de\"\r\nappid = \"12345678901234567890123456789012\""); } Chmod(filepath, 666, false); } catch (Exception) { } if (File.Exists("cmd_updated.txt")) { Logfile.Log("Update skipped!"); return; } File.AppendAllText("cmd_updated.txt", DateTime.Now.ToLongTimeString()); Logfile.Log("Start update"); if (Tools.IsMono()) { Chmod("VERSION", 666); Chmod("settings.json", 666); Chmod("cmd_updated.txt", 666); Chmod("MQTTClient.exe.config", 666); if (!Exec_mono("git", "--version", false).Contains("git version")) { Exec_mono("apt-get", "-y install git"); Exec_mono("git", "--version"); } Exec_mono("rm", "-rf /etc/teslalogger/git/*"); Exec_mono("rm", "-rf /etc/teslalogger/git"); Exec_mono("mkdir", "/etc/teslalogger/git"); Exec_mono("mozroots", "--import --sync --machine"); for (int x = 1; x < 10; x++) { Logfile.Log("git clone: try " + x); Exec_mono("git", "clone --progress https://github.com/bassmaster187/TeslaLogger /etc/teslalogger/git/", true, true); if (Directory.Exists("/etc/teslalogger/git/TeslaLogger/GrafanaPlugins")) { Logfile.Log("git clone success!"); break; } Logfile.Log("Git failed. Retry in 30 sec!"); System.Threading.Thread.Sleep(30000); } Tools.CopyFilesRecursively(new DirectoryInfo("/etc/teslalogger/git/TeslaLogger/GrafanaPlugins"), new DirectoryInfo("/var/lib/grafana/plugins")); Tools.CopyFilesRecursively(new DirectoryInfo("/etc/teslalogger/git/TeslaLogger/www"), new DirectoryInfo("/var/www/html")); Tools.CopyFile("/etc/teslalogger/git/TeslaLogger/bin/geofence.csv", "/etc/teslalogger/geofence.csv"); Tools.CopyFile("/etc/teslalogger/git/TeslaLogger/GrafanaConfig/sample.yaml", "/etc/grafana/provisioning/dashboards/sample.yaml"); if (!Directory.Exists("/var/lib/grafana/dashboards")) { Directory.CreateDirectory("/var/lib/grafana/dashboards"); } Tools.CopyFilesRecursively(new DirectoryInfo("/etc/teslalogger/git/TeslaLogger/bin"), new DirectoryInfo("/etc/teslalogger")); try { if (!File.Exists("/etc/teslalogger/MQTTClient.exe.config")) { Logfile.Log("Copy empty MQTTClient.exe.config file"); Tools.CopyFile("/etc/teslalogger/git/MQTTClient/App.config", "/etc/teslalogger/MQTTClient.exe.config"); } } catch (Exception ex) { Logfile.Log(ex.ToString()); } } Logfile.Log("End update"); Logfile.Log("Rebooting"); Exec_mono("reboot", ""); } catch (Exception ex) { Logfile.Log("Error in update: " + ex.ToString()); } }