コード例 #1
0
ファイル: Import.cs プロジェクト: 65001/DBM-CSharp
        static void ArrayToSql(int Standard_Size, string TableName, string Headers, ref StreamWriter SW)
        {
            int StackPointer = Stack.Add("Import.ArrayToSql");

            for (int i = 2; i <= LDFastArray.Size1(Data); i++)
            {
                //This prevent out of bound errors.
                //The Minus one is for the difference in data sets. C# counts from Zero and the LD from one
                if (CSV_Length[(i - 1)] != Standard_Size)
                {
                    continue;
                }

                SW.Write($"INSERT INTO \"{TableName}\" {Headers} VALUES(");
                for (int ii = 1; ii <= LDFastArray.Size2(Data, i); ii++)
                {
                    string Temp = "'" + LDFastArray.Get2D(Data, i, ii).ToString().Replace("'", "''").Replace("\n", " ");
                    if (string.IsNullOrWhiteSpace(Temp))
                    {
                        Temp = "NULL";
                    }

                    if (ii < Standard_Size)
                    {
                        Temp += "',";
                    }

                    if (Temp == "'NULL','")
                    {
                        SW.Write("NULL");
                    }
                    else
                    {
                        SW.Write(Temp);
                    }
                }

                SW.WriteLine("');");
                if (i % CSVInterval == 0)
                {
                    SW.Flush();
                }
            }
            SW.Flush();
            Stack.Exit(StackPointer);
        }
コード例 #2
0
ファイル: Import.cs プロジェクト: 65001/DBM-CSharp
        public static void CSV(string FilePath, ref StreamWriter SW)
        {
            int StackPointer = Stack.Add($"Utilities.CSV({FilePath})");

            //TODO Make sure comment's are universal across SQL.Then use them to insert data such as how long it took to generate the SQL and how many rows were skipped if any?
            if (File.Exists(FilePath) == false)
            {
                throw new FileNotFoundException();
            }

            Stopwatch Elappsed = Stopwatch.StartNew();

            Elappsed.Start();

            CSV_Length.Clear();
            CSV_IsString.Clear();

            string Name = Path.GetFileNameWithoutExtension(FilePath).Trim();

            Data = LDFastArray.ReadCSV(FilePath);

            //Calculate Lengths of Data
            for (int i = 1; i <= LDFastArray.Size1(Data); i++)
            {
                CSV_Length.Add(LDFastArray.Size2(Data, i));
            }
            int Standard_Size = CSV_Length.First();

            //Sets IsInteger to true by default
            for (int i = 1; i <= Standard_Size; i++)
            {
                CSV_IsString.Add(true);
            }

            //Tests all Data to see if it is a integer type
            for (int i = 2; i <= Standard_Size; i++)
            {
                //This prevent out of bound errors.
                //The Minus one is for the difference in data sets. C# counts from Zero and the LD from one
                if (CSV_Length[(i - 1)] != Standard_Size)
                {
                    continue;
                }

                for (int ii = 1; ii <= LDFastArray.Size2(Data, i); ii++)
                {
                    if (CSV_IsString[(ii - 1)] == false)
                    {
                        continue;
                    }

                    string Temp = LDFastArray.Get2D(Data, i, ii).ToString().Replace("'", "''").Replace("\n", " ");
                    if (double.TryParse(Temp, out double double2) == true) //Tests a String to see if its a number
                    {
                        CSV_IsString[ii] = false;
                    }
                }
            }

            try
            {
                CSVHeaders(Standard_Size, Name, ref SW);
                ArrayToSql(Standard_Size, Name, HeaderWOType, ref SW);
                LDFastArray.Remove(Data);
                Stack.Exit(StackPointer);
                SW.Close();
                return;
            }
            catch (Exception ex)
            {
                Events.LogMessagePopUp(ex.Message + "\n" + ex.StackTrace, "System", "CSV Conversion Error");
            }

            //Drops The FastArray
            LDFastArray.Remove(Data);
            Stack.Exit(StackPointer);
            SW.Close();
            return;
        }