public void UpdateTableSetWhereTwoConditionsTest() { var factory = new MySQLCommandFactory(); var table = Utils.RandomName(); var column_1 = Utils.RandomName(); var column_2 = Utils.RandomName(); var condition_1 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_1), factory.GetDbObjectFactory().CreateParameter(column_1)); var condition_2 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_2), factory.GetDbObjectFactory().CreateParameter(column_2)); var builder = factory.CreateDeleteBuilder() .From(factory.GetDbObjectFactory().CreateTable(table)) .Where(condition_1.And(condition_2)); Assert.Equal($"DELETE `{ table }` WHERE (`{ column_1 }` = @{ column_1 }) AND (`{ column_2 }` = @{ column_2 })", builder.Build()); }
public void SelectStarFromWhereAndTest() { var factory = new MySQLCommandFactory(); var table = Utils.RandomName(); var column_1 = Utils.RandomName(); var column_2 = Utils.RandomName(); var condition_1 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_1), factory.GetDbObjectFactory().CreateParameter(column_1)); var condition_2 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_2), factory.GetDbObjectFactory().CreateParameter(column_2)); var builder = factory.CreateSelectBuilder() .From(factory.GetDbObjectFactory().CreateTable(table)) .Where(condition_1) .And(condition_2); Assert.Equal($"SELECT * FROM `{ table }` WHERE `{ column_1 }` = @{ column_1 } AND `{ column_2 }` = @{ column_2 }", builder.Build()); }
public void UpdateTableSetWhereTwoConditionsTest() { var factory = new MySQLCommandFactory(); var table = Utils.RandomName(); var column_1 = Utils.RandomName(); var column_2 = Utils.RandomName(); var column_3 = Utils.RandomName(); var column_4 = Utils.RandomName(); var condition_3 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_3), factory.GetDbObjectFactory().CreateParameter(column_3)); var condition_4 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_4), factory.GetDbObjectFactory().CreateParameter(column_4)); var builder = factory.CreateUpdateBuilder() .Table(factory.GetDbObjectFactory().CreateTable(table)) .Set(factory.GetDbObjectFactory().CreateColumn(column_1), factory.GetDbObjectFactory().CreateParameter(column_1)) .Set(factory.GetDbObjectFactory().CreateColumn(column_2), factory.GetDbObjectFactory().CreateParameter(column_2)) .Where(condition_3.Or(condition_4)); Assert.Equal($"UPDATE `{ table }` SET `{ column_1 }` = @{ column_1 }, `{ column_2 }` = @{ column_2 } WHERE (`{ column_3 }` = @{ column_3 }) OR (`{ column_4 }` = @{ column_4 })", builder.Build()); }
public void SelectColumnFromLimitTest() { var factory = new MySQLCommandFactory(); var table = Utils.RandomName(); var column_1 = Utils.RandomName(); var column_2 = Utils.RandomName(); var column_3 = Utils.RandomName(); var offset = new Random().Next(1000, 2000); var rows = new Random().Next(10, 20); var condition_1 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_1), factory.GetDbObjectFactory().CreateParameter(column_1)); var condition_2 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_2), factory.GetDbObjectFactory().CreateParameter(column_2)); var condition_3 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_3), factory.GetDbObjectFactory().CreateParameter(column_3)); var builder = factory.CreateSelectBuilder() .From(factory.GetDbObjectFactory().CreateTable(table)) .Where(condition_1) .And(condition_2.And(condition_3)) .Limit(offset, rows); Assert.Equal($"SELECT * FROM `{ table }` WHERE `{ column_1 }` = @{ column_1 } AND (`{ column_2 }` = @{ column_2 }) AND (`{ column_3 }` = @{ column_3 }) LIMIT { offset }, { rows }", builder.Build()); }
public void SelectStarFromWhereNotNullTest() { var factory = new MySQLCommandFactory(); var table = Utils.RandomName(); var column = Utils.RandomName(); var builder = factory.CreateSelectBuilder() .From(factory.GetDbObjectFactory().CreateTable(table)) .Where(factory.GetConditionFactory().NotIsNull( factory.GetDbObjectFactory().CreateColumn(column))); Assert.Equal($"SELECT * FROM `{ table }` WHERE `{ column }` IS NOT NULL", builder.Build()); }
public void SelectStarFromWhereGTETest() { var factory = new MySQLCommandFactory(); var table = Utils.RandomName(); var column = Utils.RandomName(); var builder = factory.CreateSelectBuilder() .From(factory.GetDbObjectFactory().CreateTable(table)) .Where(factory.GetConditionFactory().GreaterThanOrEqualTo( factory.GetDbObjectFactory().CreateColumn(column), factory.GetDbObjectFactory().CreateParameter(column))); Assert.Equal($"SELECT * FROM `{ table }` WHERE `{ column }` >= @{ column }", builder.Build()); }