public void WithDefault()
{
strategy = ObjectFactory.GetInstance<IDatabaseStrategy>();
command.SetupSet(x => x.CommandText = It.IsAny<string>()).Verifiable();
var table = new Table("TestTable");
table.AddColumn(new Column("test", DbType.Int32)).Default("100500");
table.AddColumn(new Column("test2", DbType.String.Size(50))).Default("this is the test");
strategy.CreateTable(table);
command.VerifySet(x => x.CommandText = WithDefaultCommand);
}
public void WithStandartDefaultGuid()
{
strategy = ObjectFactory.GetInstance<IDatabaseStrategy>();
command.SetupSet(x => x.CommandText = It.IsAny<string>()).Verifiable();
var table = new Table("TestTable");
table.AddColumn(new Column("test", DbType.Int32)).Default(StandartDefaultType.guid);
strategy.CreateTable(table);
command.VerifySet(x => x.CommandText = WithStandartDefaultGuidCommand);
}
public void RegularCreateTableWithIdentity()
{
strategy = ObjectFactory.GetInstance<IDatabaseStrategy>();
command.SetupSet(x => x.CommandText = It.IsAny<string>()).Verifiable();
var table = new Table("TestTable");
table.AddColumn(new Column("test", DbType.Int32, false, true));
table.AddColumn(new Column("test2", DbType.String.Size(50)));
strategy.CreateTable(table);
command.VerifySet(x => x.CommandText = RegularCreateTableWithIdentityCommand);
}
