public void TestIndexes()
{
using (var connection = new ODBCConnection.ODBCConnection())
{
connection.Initialize();
if (connection.Connect(TestTableData1.testConnection))
{
foreach (var table in TestData.testData)
{
var DBIndexes = connection.GetIndexData("", table.TableName);
Assert.AreNotEqual(DBIndexes.Count, 0);
foreach (var record in table.IndexData)
{
var found = DBIndexes.Find(T => { return(T.IndexName == record.IndexName); });
Assert.IsNotNull(found);
foreach (var column in found.NextColumn())
{
var dest = record.NextColumn().First(T => { return(T.ColumnName == column.ColumnName); });
Assert.AreEqual(column.ColumnName, dest.ColumnName);
}
}
}
}
else
{
Assert.Fail("could not connect to testDB");
}
}
}
public void TestColumns()
{
using (var connection = new ODBCConnection.ODBCConnection())
{
connection.Initialize();
if (connection.Connect(TestTableData1.testConnection))
{
foreach (var table in TestData.testData)
{
var records = connection.GetColumns("", table.TableName);
var columnName = table.ColumnsDescription.Find(T => { return(records.Find(TT => { return T.ColumnName == TT.ColumnName; }) != null); });
Assert.IsNotNull(columnName);
}
}
}
}
public void TestTables()
{
using (var connection = new ODBCConnection.ODBCConnection())
{
connection.Initialize();
if (connection.Connect(TestTableData1.testConnection))
{
var records = connection.GetTableList();
foreach (var table in TestTableData1.tableList)
{
var tableName = records.Find(T => { return(T.TableName == table); });
Assert.IsNotNull(tableName);
}
}
else
{
Assert.Fail("could not connect to testDB");
}
}
}
public void TestPrimaryKeys()
{
using (var connection = new ODBCConnection.ODBCConnection())
{
connection.Initialize();
if (connection.Connect(TestTableData1.testConnection))
{
foreach (var table in TestData.testData)
{
var records = connection.GetPrimaryKey("", table.TableName);
foreach (var column in records.NextColumn())
{
var columnName = table.PrimaryKey.NextColumn().First(T => { return(T.ColumnName == column.ColumnName); });
Assert.IsNotNull(columnName);
}
}
}
else
{
Assert.Fail("could not connect to testDB");
}
}
}
