public void Test_CreateTable_Postgre()
{
CleanUpCreateDropTestTable();
var sql = Db <DBForCreateTest> .Sql(db =>
CreateTable(db.table3,
new Column(db.table3.obj1, DataType.BigInt()),
new Column(db.table3.obj2, DataType.BigSerial()),
new Column(db.table3.obj3, DataType.Bit(1)),
new Column(db.table3.obj4, DataType.BitVarying(1)),
new Column(db.table3.obj5, DataType.Boolean()),
new Column(db.table3.obj6, DataType.Box()),
new Column(db.table3.obj7, DataType.Bytea()),
new Column(db.table3.obj8, DataType.Character(1)),
new Column(db.table3.obj9, DataType.CharacterVarying(1)),
new Column(db.table3.obj10, DataType.Cidr()),
new Column(db.table3.obj11, DataType.Circle()),
new Column(db.table3.obj12, DataType.Date()),
new Column(db.table3.obj13, DataType.DoublePrecision()),
new Column(db.table3.obj14, DataType.Inet()),
new Column(db.table3.obj15, DataType.Integer()),
new Column(db.table3.obj16, DataType.Interval(IntervalType.Day)),
new Column(db.table3.obj17, DataType.Json()),
new Column(db.table3.obj18, DataType.JsonB()),
new Column(db.table3.obj19, DataType.Line()),
new Column(db.table3.obj20, DataType.Lseg()),
new Column(db.table3.obj21, DataType.MacAddr()),
new Column(db.table3.obj22, DataType.Money()),
new Column(db.table3.obj23, DataType.Numeric()),//(1, 2)
new Column(db.table3.obj24, DataType.Path()),
new Column(db.table3.obj25, DataType.Pg_Lsn()),
new Column(db.table3.obj26, DataType.Point()),
new Column(db.table3.obj27, DataType.Polygon()),
new Column(db.table3.obj28, DataType.Real()),
new Column(db.table3.obj29, DataType.SmallInt()),
new Column(db.table3.obj30, DataType.SmallSerial()),
new Column(db.table3.obj31, DataType.Serial()),
new Column(db.table3.obj32, DataType.Text()),
new Column(db.table3.obj33, DataType.Time()),
new Column(db.table3.obj34, DataType.Time(1)),
new Column(db.table3.obj35, DataType.TimeStamp()),
new Column(db.table3.obj36, DataType.TimeStamp(1)),
new Column(db.table3.obj37, DataType.TsQuery()),
new Column(db.table3.obj38, DataType.TsVector()),
new Column(db.table3.obj39, DataType.Txid_Snapshot()),
new Column(db.table3.obj40, DataType.Uuid()),
new Column(db.table3.obj41, DataType.Xml()),
new Column(db.table3.obj42, DataType.TimeWithTimeZone()),
new Column(db.table3.obj43, DataType.TimeWithTimeZone(1)),
new Column(db.table3.obj44, DataType.TimeStampWithTimeZone()),
new Column(db.table3.obj45, DataType.TimeStampWithTimeZone(1))
));
//time zone
_connection.Execute(sql);
}
public void Test_CreateTable_SQLite()
{
CleanUpCreateDropTestTable();
var sql = Db <DBForCreateTest> .Sql(db =>
CreateTable(db.table3,
new Column(db.table3.obj1, DataType.Int()),
new Column(db.table3.obj2, DataType.Integer()),
new Column(db.table3.obj3, DataType.TinyInt()),
new Column(db.table3.obj4, DataType.SmallInt()),
new Column(db.table3.obj5, DataType.MediumInt()),
new Column(db.table3.obj6, DataType.BigInt()),
new Column(db.table3.obj7, DataType.UnsignedBigInt()),
new Column(db.table3.obj8, DataType.Int2()),
new Column(db.table3.obj9, DataType.Int8()),
new Column(db.table3.obj10, DataType.Character(1)),
new Column(db.table3.obj11, DataType.VarChar(1)),
new Column(db.table3.obj12, DataType.VaryingCharacter(1)),
new Column(db.table3.obj13, DataType.NChar(1)),
new Column(db.table3.obj14, DataType.NativeCharacter(1)),
new Column(db.table3.obj15, DataType.NVarChar()),
new Column(db.table3.obj16, DataType.Text()),
new Column(db.table3.obj17, DataType.Clob()),
new Column(db.table3.obj18, DataType.Blob()),
new Column(db.table3.obj19, DataType.Real()),
new Column(db.table3.obj20, DataType.Double()),
new Column(db.table3.obj21, DataType.DoublePrecision()),
new Column(db.table3.obj22, DataType.Float()),
new Column(db.table3.obj23, DataType.Numeric()),
new Column(db.table3.obj24, DataType.Decimal()),//(10, 5)
new Column(db.table3.obj25, DataType.Boolean()),
new Column(db.table3.obj26, DataType.Date()),
new Column(db.table3.obj27, DataType.DateTime())
));
_connection.Execute(sql);
}
