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());
}
