public static void GetProgressBar(ProgressBarInfo pbInfo)
        {
            StartBox();

            GUILayout.Label("Progressbar :", (GUIStyle)"BoldLabel");

            pbInfo.ProgressbarWindow = (MgsProgressWindow)EditorGUILayout.ObjectField(
                new GUIContent("ProgressbarWindow"),
                pbInfo.ProgressbarWindow,
                typeof(MgsProgressWindow), true);

            if (pbInfo.ProgressbarWindow != null)
            {
                EditorTools.Instance.LanguageField(TargetNode, "Progressbar Message", ref pbInfo.ProgressbarMessage);

                GUILayout.BeginHorizontal();
                {
                    GUILayout.Label("Display method:");
                    pbInfo.ProgressbarShow = GUILayout.Toggle(pbInfo.ProgressbarShow, "Show");
                    pbInfo.ProgressbarHide = GUILayout.Toggle(pbInfo.ProgressbarHide, "Hide");
                }
                GUILayout.EndHorizontal();
            }
            EndBox();
        }
Beispiel #2
0
        public void ShowProgressBar(ProgressBarInfo progressBarInfo)
        {
            Console.Write(progressBarInfo.Message + " ");

            progressBarInfo.ProgressChanged += (sender, d) =>
            {
                if (progressBarInfo.IsClosed)
                {
                    return;
                }

                var progressBlockCount = (int)(d * Bars);
                var percent            = (int)(d * 100);

                var text = string.Format("[{0}{1}] {2,3}%",
                                         progressBlockCount == 0 ? "" : new string('=', progressBlockCount - 1) + ">",
                                         new string(' ', Bars - progressBlockCount),
                                         percent);
                UpdateText(text);
            };
            progressBarInfo.Closed += (sender, args) =>
            {
                UpdateText(string.Empty);
                Console.WriteLine("Done");
            };
        }
Beispiel #3
0
 public void ShowProgressBar(ProgressBarInfo progressBarInfo)
 {
     _mainForm.ShowProgressBar(progressBarInfo.Message);
     progressBarInfo.ProgressChanged += (sender, d) =>
     {
         _mainForm.ChangeProgress(d);
     };
     progressBarInfo.Closed += (sender, args) =>
     {
         _mainForm.HideProgressBar();
     };
 }
Beispiel #4
0
        public void DownloadDatabase(DirectoryInfo directory, string emailAddress, string password)
        {
            Logger.Info("Geo-IP database not found, preparing download...");
            if (directory.Exists)
            {
                directory.Delete(true);
            }

            Logger.Debug("Create directory");
            directory.Create();

            FileInfo csvFile = null;

            if (File.Exists("IP2LOCATION-LITE-DB11.CSV"))
            {
                csvFile = new FileInfo("IP2LOCATION-LITE-DB11.CSV");
                Logger.Info("Local CSV file found");
            }
            else
            {
                var zipFile      = new FileInfo(Path.Combine(directory.FullName, "temp.zip"));
                var progressInfo =
                    new ProgressBarInfo(
                        $"{DateTime.Now:dd-MM-yyyy HH:mm:ss.ffff}\t[PROGRESS] Download IP2Location database");
                UiManager.UiImplementation.ShowProgressBar(progressInfo);
                try
                {
                    using (var webClient = new WebClient {
                        Proxy = null
                    })
                    {
                        var url =
                            $"http://www.ip2location.com/download?login={Uri.EscapeDataString(emailAddress)}&password={Uri.EscapeDataString(password)}&productcode={DatabaseProduct}";
                        webClient.DownloadProgressChanged +=
                            (sender, args) =>
                            progressInfo.ReportProgress(args.ProgressPercentage / 100d);
                        using (var autoResetEvent = new AutoResetEvent(false))
                        {
                            webClient.DownloadFileCompleted += (sender, args) => autoResetEvent.Set();
                            webClient.DownloadFileAsync(new Uri(url), zipFile.FullName);
                            autoResetEvent.WaitOne();
                        }
                    }
                }
                finally
                {
                    progressInfo.Close();
                }

                if (zipFile.Length < 10 * 1024)               //noob tactic, checking the file size
                {
                    var errorText = File.ReadAllText(zipFile.FullName);
                    directory.Delete(true);
                    throw new InvalidOperationException(errorText);
                }

                Logger.Info("Download finished successfully");

                using (var fileStream = new FileStream(zipFile.FullName, FileMode.Open, FileAccess.Read))
                {
                    var zf = new ZipFile(fileStream);
                    foreach (ZipEntry zipEntry in zf)
                    {
                        if (zipEntry.IsFile && zipEntry.Name.EndsWith(".csv", StringComparison.OrdinalIgnoreCase))
                        {
                            var zipProgressInfo =
                                new ProgressBarInfo($"{DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss.ffff")}\t[PROGRESS] Extracting archive");
                            UiManager.UiImplementation.ShowProgressBar(zipProgressInfo);
                            try
                            {
                                using (var csvFileStream = new FileStream("IP2LOCATION-LITE-DB11.CSV", FileMode.CreateNew, FileAccess.Write))
                                    using (var inputStream = zf.GetInputStream(zipEntry))
                                    {
                                        byte[] buffer = new byte[16 * 1024];
                                        int    read;
                                        while ((read = inputStream.Read(buffer, 0, buffer.Length)) > 0)
                                        {
                                            csvFileStream.Write(buffer, 0, read);
                                            zipProgressInfo.ReportProgress(csvFileStream.Position /
                                                                           (double)zipEntry.Size);
                                        }
                                    }
                            }
                            finally
                            {
                                zipProgressInfo.Close();
                            }
                            csvFile = new FileInfo("IP2LOCATION-LITE-DB11.CSV");
                            break;
                        }
                    }
                }

                if (csvFile == null)
                {
                    throw new FileNotFoundException("Could not find CSV file in zip archive");
                }

                zipFile.Delete();
            }

            Logger.Info("Building database");
            var databaseFile = new FileInfo(Path.Combine(directory.FullName, "geoipDatabase.sqlite"));

            SqliteConnection.CreateFile(databaseFile.FullName);
            using (var sqliteConnection = new SqliteConnection($"Data Source={databaseFile.FullName};Version=3;"))
            {
                sqliteConnection.Open();
                using (
                    var command =
                        new SqliteCommand(
                            "CREATE TABLE `IpLocation` (IpFrom INTEGER UNIQUE, IpTo INTEGER PRIMARY KEY, Country TEXT, CountryName TEXT, Region TEXT, City TEXT, Latitude REAL, Longitude REAL, ZipCode TEXT, Timezone TEXT)",
                            sqliteConnection))
                    command.ExecuteNonQuery();

                using (
                    var command =
                        new SqliteCommand(
                            "CREATE TABLE `Properties` (Name TEXT, Value TEXT)",
                            sqliteConnection))
                    command.ExecuteNonQuery();

                using (
                    var command =
                        new SqliteCommand(
                            $"INSERT INTO `Properties` (Name, Value) VALUES ('CreationDate', '{DateTime.Now.ToString(CultureInfo.InvariantCulture)}')",
                            sqliteConnection))
                    command.ExecuteNonQuery();

                using (var csvReader = new CsvReader(csvFile.FullName))
                    using (var transaction = sqliteConnection.BeginTransaction())
                    {
                        using (var command = sqliteConnection.CreateCommand())
                        {
                            command.Transaction = transaction;
                            while (csvReader.ReadNextRecord())
                            {
                                command.CommandText =
                                    $"INSERT INTO `IpLocation` (IpFrom, IpTo, Country, CountryName, Region, City, Latitude, Longitude, ZipCode, Timezone) VALUES ({csvReader.Fields[0]}, {csvReader.Fields[1]}, '{csvReader.Fields[2]}', @countryName, @region, @city, {csvReader.Fields[6]}, {csvReader.Fields[7]}, '{csvReader.Fields[8]}', '{csvReader.Fields[9]}')";
                                command.Parameters.AddWithValue("@countryName", csvReader.Fields[3]);
                                command.Parameters.AddWithValue("@region", csvReader.Fields[4]);
                                command.Parameters.AddWithValue("@city", csvReader.Fields[5]);
                                command.ExecuteNonQuery();
                            }
                            transaction.Commit();
                        }
                    }

                Logger.Info("Database created");
            }
        }