} // createQueryBuilder(...)
#endregion
private static void Dump(ActiveQueryBuilder.View.WinForms.QueryBuilder qb, AQBTest.DataStore ds)
{
string fnAqbQbFilename = TS_STR + "." + ds.AqbQbFilename;
string fnMiFqnFilename = TS_STR + "." + ds.MiFqnFilename;
{
// Export AQB's Query Builder XML Structures...
//string xmlStr = qb.MetadataContainer.XML;
qb.MetadataContainer.ExportToXML(fnAqbQbFilename);
// qb.MetadataContainer.ImportFromXML( filename );
}
{
// Export MetadataItem FQN Collection...
AQBTest.MetadataItemFQNCollection o = new AQBTest.MetadataItemFQNCollection( );
o.List = BuildBindingList(qb);
o.Save(fnMiFqnFilename);
}
}
private static DevExpress.XtraBars.ToastNotifications.ToastNotification CreateToastNotification(AQBTest.DataStore ds)
{
DevExpress.XtraBars.ToastNotifications.ToastNotification tn = new DevExpress.XtraBars.ToastNotifications.ToastNotification( );
tn.ID = "cf47cb4e-394e-4ac9-a978-111715c1fc56";
tn.Image = null;
tn.Header = "Starting: " + ds.Name;
tn.Body = TS_STR;
tn.Body2 = TS_STR;
tn.Template = DevExpress.XtraBars.ToastNotifications.ToastNotificationTemplate.Text04;
tn.Duration = DevExpress.XtraBars.ToastNotifications.ToastNotificationDuration.Long;
return(tn);
}
public static void PullRemotely(AQBTest.DataStoreCollection dsColl)
{
dsColl = dsColl ?? throw new System.ArgumentNullException(nameof(dsColl));
for (int i = 0; i < dsColl.List.Count; i++)
{
AQBTest.DataStore ds = dsColl.List[i];
if (!ds.IsActive)
{
continue;
}
if (ds.IsToPullRemotely)
{
#region --- ??? ---
TS_STR = @"D:\TEMP\SQLite\" + AQBTest.DataStore.TS_STR.Replace(":", "");
if (ds.NotificationWhenStarted)
{
DevExpress.XtraBars.ToastNotifications.ToastNotification tn = CreateToastNotification(ds);
tn.Header = "Starting: " + ds.Name;
tn.Body = ds.AqbQbFilename;
tn.Body2 = ds.MiFqnFilename;
tnm.ShowNotification(tn);
}
switch ((AQBTest.DataStore.SyntaxProviderEnum)ds.SyntaxProvider)
{
case AQBTest.DataStore.SyntaxProviderEnum.SQLITE:
DumpSQLite(ds);
break;
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_2014:
DumpMSSQL(ds);
break;
case AQBTest.DataStore.SyntaxProviderEnum.AUTO:
case AQBTest.DataStore.SyntaxProviderEnum.GENERIC:
case AQBTest.DataStore.SyntaxProviderEnum.ANSI_SQL_2003:
case AQBTest.DataStore.SyntaxProviderEnum.ANSI_SQL_89:
case AQBTest.DataStore.SyntaxProviderEnum.ANSI_SQL_92:
case AQBTest.DataStore.SyntaxProviderEnum.FIREBIRD_1_0:
case AQBTest.DataStore.SyntaxProviderEnum.FIREBIRD_1_5:
case AQBTest.DataStore.SyntaxProviderEnum.FIREBIRD_2_0:
case AQBTest.DataStore.SyntaxProviderEnum.FIREBIRD_2_5:
case AQBTest.DataStore.SyntaxProviderEnum.IBM_DB2:
case AQBTest.DataStore.SyntaxProviderEnum.IBM_INFORMIX_10:
case AQBTest.DataStore.SyntaxProviderEnum.IBM_INFORMIX_8:
case AQBTest.DataStore.SyntaxProviderEnum.IBM_INFORMIX_9:
case AQBTest.DataStore.SyntaxProviderEnum.MS_ACCESS_2000_:
case AQBTest.DataStore.SyntaxProviderEnum.MS_ACCESS_2003_:
case AQBTest.DataStore.SyntaxProviderEnum.MS_ACCESS_97_:
case AQBTest.DataStore.SyntaxProviderEnum.MS_ACCESS_XP_:
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_2000:
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_2005:
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_2008:
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_2012:
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_7:
case AQBTest.DataStore.SyntaxProviderEnum.MS_SQL_SERVER_COMPACT_EDITION:
case AQBTest.DataStore.SyntaxProviderEnum.MYSQL_3_XX:
case AQBTest.DataStore.SyntaxProviderEnum.MYSQL_4_0:
case AQBTest.DataStore.SyntaxProviderEnum.MYSQL_4_1:
case AQBTest.DataStore.SyntaxProviderEnum.MYSQL_5_0:
case AQBTest.DataStore.SyntaxProviderEnum.ORACLE_10:
case AQBTest.DataStore.SyntaxProviderEnum.ORACLE_11:
case AQBTest.DataStore.SyntaxProviderEnum.ORACLE_7:
case AQBTest.DataStore.SyntaxProviderEnum.ORACLE_8:
case AQBTest.DataStore.SyntaxProviderEnum.ORACLE_9:
case AQBTest.DataStore.SyntaxProviderEnum.POSTGRESQL:
case AQBTest.DataStore.SyntaxProviderEnum.SYBASE_ASE:
case AQBTest.DataStore.SyntaxProviderEnum.SYBASE_SQL_ANYWHERE:
case AQBTest.DataStore.SyntaxProviderEnum.TERADATA:
case AQBTest.DataStore.SyntaxProviderEnum.VISTADB:
default:
break;
} // switch(...) ...
if (ds.NotificationWhenFinished)
{
DevExpress.XtraBars.ToastNotifications.ToastNotification tn = CreateToastNotification(ds);
tn.Header = "Finished: " + ds.Name;
tn.Body = ds.AqbQbFilename;
tn.Body2 = ds.MiFqnFilename;
tnm.ShowNotification(tn);
}
#endregion
} // if( ... ) ...
} // for( ;; ) ...
}
private static ActiveQueryBuilder.View.WinForms.QueryBuilder CreateQueryBuilderSQLite(AQBTest.DataStore ds)
{
return(CreateQueryBuilderSQLite(ds.ConnectionString, ds.LoadDefaultDatabaseOnly, ds.LoadSystemObjects, ds.WithFields));
}
} // createQueryBuilder(...)
#endregion
#region --- SQLite... ---
private static ActiveQueryBuilder.View.WinForms.QueryBuilder DumpSQLite(AQBTest.DataStore ds)
{
ActiveQueryBuilder.View.WinForms.QueryBuilder qb = CreateQueryBuilderSQLite(ds);
Dump(qb, ds);
return(qb);
}