public void DeleteTableTest()
{
var factory = new MySQLCommandFactory();
var table = Utils.RandomName();
var builder = factory.CreateDeleteBuilder()
.From(factory.GetDbObjectFactory().CreateTable(table));
Assert.Equal($"DELETE `{ table }`", builder.Build());
}
public void CreateTest()
{
var factory = new MySQLCommandFactory();
Assert.IsAssignableFrom <ISelectBuilder>(factory.CreateSelectBuilder());
Assert.IsAssignableFrom <IInsertBuilder>(factory.CreateInsertBuilder());
Assert.IsAssignableFrom <IUpdateBuilder>(factory.CreateUpdateBuilder());
Assert.IsAssignableFrom <IDeleteBuilder>(factory.CreateDeleteBuilder());
}
public void DeleteTableWhereTest()
{
var factory = new MySQLCommandFactory();
var table = Utils.RandomName();
var column_1 = Utils.RandomName();
var condition_1 = factory.GetConditionFactory().EqualTo(factory.GetDbObjectFactory().CreateColumn(column_1), factory.GetDbObjectFactory().CreateParameter(column_1));
var builder = factory.CreateDeleteBuilder()
.From(factory.GetDbObjectFactory().CreateTable(table))
.Where(condition_1);
Assert.Equal($"DELETE `{ table }` WHERE `{ column_1 }` = @{ column_1 }", builder.Build());
}