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"); }); }