static void Main(string[] args)
{
const string PROJECT = @"\Sausa\Test_Write_Project.xml";
const string SETTINGS = "Hangerbay.xml";
const string ProjectSQLiteDBFile = "Hangerbay.sqlite";
//ExternalDBModel test = ReadXML.GetExternalProjectDBSettings(FilePathDefaults.ScratchFolder, SETTINGS);
//string[] blahParam = new string[4];
//blahParam[0] = test.Server;
//blahParam[1] = test.Database;
//blahParam[2] = test.UserID;
//blahParam[3] = test.PassWord;
//mysql testing credentials
string[] testParm = new string[] {
"MYSQL5022.site4now.net", "db_a4733c_sausa", "a4733c_sausa", "Sausa#1test"
};
ObservableCollection <FullStackModel> ListForTesting = ReadSQLite.GetEntireStack(FilePathDefaults.ScratchFolder, ProjectSQLiteDBFile);
//bool testExport = WriteExternalDB.Export_ToMSSQL(testParm, ListForTesting, FilePathDefaults.ScratchFolder, SETTINGS);
//bool testSetup = WriteExternalDB.SetUp_MySQLDatabase(testParm, FilePathDefaults.ScratchFolder, SETTINGS);
bool testExport = WriteExternalDB.Export_ToMySQL(testParm, ListForTesting, FilePathDefaults.ScratchFolder, SETTINGS);
//Console.WriteLine(testSQL + "\n" + testing);
Console.WriteLine(testExport);
}// end of main
/// <summary>
/// Write the database to a CSV using the GetEntireStack method and a ConvertToCSV helper method
/// </summary>
/// <param name="fullDBFilePath"></param>
/// <param name="dbFileName"></param>
/// <param name="specifiedCustomDBFieldsList"></param>
/// <returns></returns>
///
public static void WriteDatabasetoCSV(string fullDBFilePath, string dbFileName)
{
ObservableCollection <FullStackModel> modelList = new ObservableCollection <FullStackModel>();
string[] file = dbFileName.Split('.');
modelList = ReadSQLite.GetEntireStack(fullDBFilePath, dbFileName);
using (var textWriter = File.CreateText(AppDomain.CurrentDomain.BaseDirectory.ToString() + UNITY_DBCSV))
{
foreach (var line in ConvertToCSV(modelList))
{
textWriter.WriteLine(line);
}
}
}
