public static void GenerateCreateScript() { SQLServerAccessor accessor = new SQLServerAccessor(); string tsvfilepath = "d:\\data\\ta\\IntelligenceRoute.tsv"; //"d:\\data\\ta\\Examination.tsv";//"C:\\WS\\OfficialAccountBotExtension\\Hackthon\\TABot\\DBSourceData\\Calculator3.tsv"; string csvfilepath = "C:\\WS\\OfficialAccountBotExtension\\Hackthon\\TABot\\DBSourceData\\PSAScheduleData2.csv"; // "C:\\WS\\OfficialAccountBotExtension\\Hackthon\\TABot\\DBSourceData\\PSANotificationData.csv"; // "C:\\WS\\OfficialAccountBotExtension\\Hackthon\\TABot\\DBSourceData\\PSAESCachedObject.csv"; //CSVParser parser = new CSVParser(csvfilepath); TSVParser parser = new TSVParser(tsvfilepath); DBTableSchema schema = parser.ParserSchema(); string createtablestr = parser.GenerateSQLQueryForCreateTable(schema); Console.WriteLine(createtablestr); accessor.ExecSQL(createtablestr); List <string> insertList = parser.GenerateSQLQueryForInsertRow(schema); StringBuilder builder = new StringBuilder(); foreach (string line in insertList) { builder.AppendLine(line); Console.WriteLine(line); } accessor.ExecSQL(builder.ToString()); }
public static void GenerateCreateScript() { SQLServerAccessor accessor = new SQLServerAccessor(); string tsvfilepath = @"D:\repository\Mitutor\DBSourceData\ScoreScripts.tsv"; string csvfilepath = "D:\\hackson\\TABot\\TABot\\DBSourceData\\PSAScheduleData2.csv"; //CSVParser parser = new CSVParser(csvfilepath); TSVParser parser = new TSVParser(tsvfilepath); DBTableSchema schema = parser.ParserSchema(); string createtablestr = parser.GenerateSQLQueryForCreateTable(schema); Console.WriteLine(createtablestr); //accessor.ExecSQL(createtablestr); List <string> insertList = parser.GenerateSQLQueryForInsertRow(schema); StringBuilder builder = new StringBuilder(); foreach (string line in insertList) { builder.AppendLine(line); Console.WriteLine(line); } accessor.ExecSQL(builder.ToString()); }