public static void generate(string xlsxPath, string datatypePath = null)
{
string filename = Path.GetFileNameWithoutExtension(xlsxPath);
filename = filename.Replace(" ", "_");
string pathWOExtension = Path.GetDirectoryName(xlsxPath)+ "\\" + filename;
DatabaseInfo.DatabaseName = filename;
//convert from xlsx to csv
string csvPath = pathWOExtension + ".csv";
Console.WriteLine("csvPath is: " + csvPath);
XLSXToCSVConverter.toCSV(xlsxPath, csvPath);
//represent csv as an object
CSVWrapper csv = new CSVWrapper();
csv.openCSV(csvPath);
//make the contents of the sql script
string sqlPath = pathWOExtension + ".sql";
Console.WriteLine("sqlPath is: " + sqlPath);
string sqlContent = new SQLBuilder(csv, filename, filename+"Table", datatypePath).
CreateDatabase().DropTable().CreateUse().CreateTable().CreateInsert().Build();
//make the contents of the connection string file
string dbPath = pathWOExtension + ProjectStrings.CONNECTION_STRING_FILE_EXTENSION;
string dbContent = DatabaseInfo.DatabaseName;
//write sql to file
System.IO.File.WriteAllText(sqlPath, sqlContent);
System.IO.File.WriteAllText(dbPath, dbContent);
string[] lines = sqlContent.Split('\n');
createDatabaseFromSql(lines, filename);
populateDatabaseFromSql(lines, filename);
}
