public void Test_Generic_BuildQuery()
{
RunTestOnAllDBTypes(delegate(DataBaseType type)
{
var objectToSql = new Services.ObjectToSql(type);
var sql = objectToSql.BuildQuery(ActionType, new EmployeeWithIdentityKeySqlColumn());
Assert.AreEqual(sql, EmployeeWithIdentityKeySqlColumn.ToSql(ActionType, type));
});
}
public void Test_Generic_BuildUpdateQuery_Includes_Where_Clause_With_Identity_Column()
{
RunTestOnAllDBTypes(delegate(DataBaseType type)
{
var objectToSql = new Services.ObjectToSql(type);
var sql = objectToSql.BuildQuery <EmployeeWithIdentityKeySqlColumn>(ActionType, nameof(EmployeeWithIdentityKeySqlColumn));
Assert.AreEqual(sql, EmployeeWithIdentityKeySqlColumn.ToSql(ActionType, type));
});
}
public void Test_Generic_BuildQuery_Ensure_Override_Keys_Is_Used()
{
RunTestOnAllDBTypes(delegate(DataBaseType type)
{
var objectToSql = new Services.ObjectToSql(type);
var sql = objectToSql.BuildQuery <EmployeeWithIdentityKeySqlColumn>(ActionType, nameof(EmployeeWithIdentityKeySqlColumn), column => column.IdentityKey);
Assert.AreEqual(sql, EmployeeWithIdentityKeySqlColumn.ToSql(ActionType, type));
});
}
public void Test_Anonymous_T_BuildQuery_With_Specified_Table_Name()
{
RunTestOnAllDBTypes(delegate(DataBaseType type)
{
var dt2Sql = new Services.DataTableToSql(type);
var insertSql = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Insert);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Insert, type), insertSql, "DataTable 2 Sql insertSql Failed");
var updateSQL = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Update);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Update, type), updateSQL, "DataTable 2 Sql updateSQL Failed");
var deleteSQL = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Delete);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Delete, type), deleteSQL, "DataTable 2 Sql deleteSQL Failed");
if (type == DataBaseType.Sqlite || type == DataBaseType.MySql)
{
return; // TODO :: fIX for sqlite
}
// TODO :: FIX
var upsertSQL = dt2Sql.BuildQuery(MockDataIdentityKey, ActionType.Upsert);
Assert.AreEqual(EmployeeWithIdentityKeySqlColumn.ToSql(ActionType.Upsert, type), upsertSQL, "DataTable 2 Sql upsertSQL Failed");
});
}
