public SqlProberTests()
{
this.FakeSqlItem = sql_item.CreateSqlItem(FAKE_DB_ENGINE, FAKE_DB_VERSION, FAKE_CONNECTION_STRING, FAKE_SQL_QUERY);
this.FakeCollectedSqlItem = sql_item.CreateSqlItem(FAKE_DB_ENGINE, FAKE_DB_VERSION, FAKE_CONNECTION_STRING, FAKE_SQL_QUERY);
this.FakeCollectedSqlItem.result = new EntityItemAnySimpleType[] { new EntityItemAnySimpleType() { Value = "10" }, new EntityItemAnySimpleType() { Value = "11" } };
this.FakeSql57Item = sql57_item.CreateSqlItem(FAKE_DB_ENGINE, FAKE_DB_VERSION, FAKE_CONNECTION_STRING, FAKE_SQL_QUERY);
this.FakeCollectedSql57Item = sql57_item.CreateSqlItem(FAKE_DB_ENGINE, FAKE_DB_VERSION, FAKE_CONNECTION_STRING, FAKE_SQL_QUERY);
this.FakeCollectedSql57Item.result =
new EntityItemRecordType[]
{
new EntityItemRecordType()
{
field = new EntityItemFieldType[]
{
new EntityItemFieldType() { name = "id", Value = "10" },
new EntityItemFieldType() { name = "name", Value = "John" }
}
}
};
}
private void AssertSqlItem(
sql_item sqlItemToAssert,
string expectedEngineValue = "oracle",
string expectedVersionValue = "9",
string expectedConnectionStringValue = FAKE_CONNECTION_STRING,
string expectedSqlValue = FAKE_SQL_QUERY)
{
ItemTypeEntityChecker.AssertItemTypeEntity(sqlItemToAssert.engine, expectedEngineValue);
ItemTypeEntityChecker.AssertItemTypeEntity(sqlItemToAssert.version, expectedVersionValue);
ItemTypeEntityChecker.AssertItemTypeEntity(sqlItemToAssert.connection_string, expectedConnectionStringValue);
ItemTypeEntityChecker.AssertItemTypeEntity(sqlItemToAssert.sql, expectedSqlValue);
}