protected override ISession CreateAdminSession(IDatabase database) { using (var session = base.CreateAdminSession(database)) { using (var query = session.CreateQuery()) { var tableInfo = new TableInfo(ObjectName.Parse("APP.people")); tableInfo.AddColumn("id", PrimitiveTypes.BigInt()); tableInfo.AddColumn("first_name", PrimitiveTypes.String(), true); tableInfo.AddColumn("last_name", PrimitiveTypes.String()); tableInfo.AddColumn("age", PrimitiveTypes.TinyInt()); query.CreateTable(tableInfo); query.Commit(); } } return(base.CreateAdminSession(database)); }
public Field AsTinyInt() { return(CastTo(PrimitiveTypes.TinyInt())); }
public static SqlType FromValue(object value) { if (value is SqlNumber) { var number = (SqlNumber)value; if (number.Scale == 0) { if (number.Precision <= 3) { return(PrimitiveTypes.TinyInt()); } if (number.Precision <= 5) { return(PrimitiveTypes.SmallInt()); } if (number.Precision <= 10) { return(PrimitiveTypes.Integer()); } if (number.Precision <= 19) { return(PrimitiveTypes.BigInt()); } } else { if (number.Precision <= 8) { return(PrimitiveTypes.Float()); } if (number.Precision <= 12) { return(PrimitiveTypes.Double()); } return(PrimitiveTypes.Numeric(number.Precision, number.Scale)); } } if (value is SqlBoolean) { return(PrimitiveTypes.Boolean()); } if (value is bool) { return(PrimitiveTypes.Boolean()); } if (value is double) { return(PrimitiveTypes.Double()); } if (value is float) { return(PrimitiveTypes.Float()); } if (value is int) { return(PrimitiveTypes.Integer()); } if (value is long) { return(PrimitiveTypes.BigInt()); } if (value is byte) { return(PrimitiveTypes.TinyInt()); } if (value is short) { return(PrimitiveTypes.SmallInt()); } if (value is string) { return(PrimitiveTypes.String()); } throw new NotSupportedException(); }