コード例 #1
0
        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);
        }
コード例 #2
0
ファイル: Tools.cs プロジェクト: fibsmaster/TeslaLogger
        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);
        }
コード例 #3
0
 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;
 }
コード例 #4
0
ファイル: FileManager.cs プロジェクト: ramonsmits/TeslaLogger
        internal static string GetSRTMDataPath()
        {
            var path = System.IO.Path.Combine(FileManager.GetExecutingPath(), "SRTM-Data");

            if (!Directory.Exists(path))
            {
                Directory.CreateDirectory(path);
            }

            return(path);
        }
コード例 #5
0
ファイル: Program.cs プロジェクト: JonasTillges/TeslaLogger
        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)
            { }
        }
コード例 #6
0
 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;
     }
 }
コード例 #7
0
ファイル: Program.cs プロジェクト: dehsgr/TeslaLogger
        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)
            { }
        }
コード例 #8
0
ファイル: Geofence.cs プロジェクト: fibsmaster/TeslaLogger
        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;
            }
        }
コード例 #9
0
ファイル: Program.cs プロジェクト: bassmaster187/TeslaLogger
        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();
            }
        }
コード例 #10
0
ファイル: Program.cs プロジェクト: driemekasten/TeslaLogger
        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)
            { }
        }
コード例 #11
0
ファイル: Program.cs プロジェクト: JonasTillges/TeslaLogger
        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!");
            }
        }
コード例 #12
0
        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());
            }
        }
コード例 #13
0
        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");
        }
コード例 #14
0
        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());
            }
        }