public void TestCreateTableSourceInfoFromQualifiedName(DatabaseProviderTestCase tc)
{
var databaseServices = tc.Services;
IDatabaseInfo db = databaseServices.ObjectFactory.CreateDatabaseInfo(GetDatabaseIdentifier(databaseServices));
IEnumerable <ITableSourceInfo> tableSources = databaseServices.IntrospectionService.ListTableSourcesWithoutFilter(db);
foreach (var tableSource in tableSources)
{
if (tableSource.QualifiedName.ToLowerInvariant().EndsWith(MachineName.ToLowerInvariant()))
{
ITableSourceInfo inferredTableSource = databaseServices.ObjectFactory.CreateTableSourceInfo(tableSource.QualifiedName);
bool equals = tableSource.Equals(inferredTableSource);
Assert.IsTrue(equals, "The inferred ITableSourceInfo is not equal to the original ITableSourceInfo for table source with qualified name: " + tableSource.QualifiedName);
}
}
}
public void TestListTableSourcesValidateAllQualifiedNames(DatabaseProviderTestCase tc)
{
var databaseServices = tc.Services;
IDatabaseInfo db = databaseServices.ObjectFactory.CreateDatabaseInfo(GetDatabaseIdentifier(databaseServices));
IEnumerable <ITableSourceInfo> tableSources = databaseServices.IntrospectionService.ListTableSourcesWithoutFilter(db);
foreach (var tableSource in tableSources)
{
if (tableSource.QualifiedName.ToLowerInvariant().EndsWith(MachineName.ToLowerInvariant()))
{
SQLExecutor sqlExecutor = new SQLExecutor(databaseServices);
string sql = "SELECT COUNT(*) FROM " + tableSource.QualifiedName;
Scalar result = sqlExecutor.ExecuteScalar(sql);
Assert.IsTrue(result.Value <int>() >= 0, "Error counting the rows of table source '" + tableSource.Name + "' using the SQL: " + sql);
}
}
}
