public void TestVarChar()
{
// Simple varchar
IColumn column = new VarCharColumn("users", 100);
Assert.Equal("`users` VARCHAR(100)", generator.ToSQL(column));
// Advanced var char
column = new VarCharColumn("nickname", 50);
column.NotNull();
column.Unique();
Assert.Equal("`nickname` VARCHAR(50) NOT NULL UNIQUE", generator.ToSQL(column));
}
public void TestDate()
{
IColumn column = new Year("created_year");
column.NotNull();
Assert.Equal("`created_year` YEAR NOT NULL", generator.ToSQL(column));
}
public void TestDouble()
{
IColumn column = new DoubleColumn("my_double_field", 7, 4);
column.NotNull();
Assert.Equal("`my_double_field` DOUBLE(7, 4) NOT NULL", generator.ToSQL(column));
}
public void TestFloat()
{
IColumn column = new FloatColumn("my_float_field", 7, 4);
column.NotNull();
Assert.Equal("`my_float_field` FLOAT(7, 4) NOT NULL", generator.ToSQL(column));
}
public void TestDecimal()
{
IColumn column = new DecimalColumn("my_decimal_field", 5, 2);
column.NotNull();
Assert.Equal("`my_decimal_field` DECIMAL(5, 2) NOT NULL", generator.ToSQL(column));
}
public void TestDate()
{
IColumn column = new Timestamp("created_atStamp", 6);
column.Unique();
column.NotNull();
Assert.Equal("`created_atStamp` TIMESTAMP(6) NOT NULL UNIQUE", generator.ToSQL(column));
}
public void TestDate()
{
IColumn column = new Date("created_at", 4);
column.Unique();
column.NotNull();
Assert.Equal("`created_at` DATE(4) NOT NULL UNIQUE", generator.ToSQL(column));
}
public void TestTinyInt()
{
IColumn column = new TinyIntColumn("line_no");
column.NotNull();
column.AutoIncrement();
Assert.Equal("`line_no` TINYINT NOT NULL AUTO_INCREMENT", generator.ToSQL(column));
}
public void TestSmallInt()
{
IColumn column = new SmallIntColumn("shoe_size", 2);
column.NotNull();
column.AutoIncrement();
Assert.Equal("`shoe_size` SMALLINT(2) NOT NULL AUTO_INCREMENT", generator.ToSQL(column));
}
public void TestInt()
{
IColumn column = new IntColumn("user_id");
column.NotNull();
column.AutoIncrement();
Assert.Equal("`user_id` INT NOT NULL AUTO_INCREMENT", generator.ToSQL(column));
}
public void TestInt()
{
IColumn column = new BigIntColumn("foo", 20);
column.NotNull();
column.AutoIncrement();
Assert.Equal("`foo` BIGINT(20) NOT NULL AUTO_INCREMENT", generator.ToSQL(column));
}
public void TestDate()
{
IColumn column = new Time("times", 2);
column.Unique();
column.NotNull();
Assert.Equal("`times` TIME(2) NOT NULL UNIQUE", generator.ToSQL(column));
}
public void TestText()
{
IColumn column = new TextColumn("description");
Assert.Equal("`description` TEXT", generator.ToSQL(column));
}
public void TestBit()
{
IColumn column = new BitColumn("is_online");
Assert.Equal("`is_online` BIT(1)", generator.ToSQL(column));
}
