public void AddDefaultAutoName()
{
var tbl = new Table("test")
.AddColumn(new Column("testid", System.Data.DbType.Int32));
tbl.Default("100500");
Assert.AreEqual("DF_TEST_TESTID", tbl.Columns[0].Constraint.Name);
}
public void AddDefaultAtPrimaryKeyColumn()
{
var tbl = new Table("test")
.AddColumn(new Column("testid", System.Data.DbType.Int32))
.AddPrimaryKey("testid");
Assert.Throws<ConflictingDataException>(() => tbl.Default("test"));
}
public void AddOneDefaultAtLastColumn()
{
var tbl = new Table("test")
.AddColumn(new Column("testid", System.Data.DbType.Int32))
.AddColumn(new Column("col2", System.Data.DbType.Int32))
.AddColumn(new Column("col3", System.Data.DbType.Int32))
.AddPrimaryKey("testid");
tbl.Default("100500");
var constraint = tbl.Columns.Last().Constraint as ValueDefault;
Assert.IsNotNull(constraint);
Assert.AreEqual("100500", constraint.Value);
}
public void AddDefaultWithoutColumn()
{
var tbl = new Table("test");
Assert.Throws<ColumnExpectedException>(() => tbl.Default("test"));
}