public static FluentColumn AutoIncrement(string name) { var fc = SColumn.Int32(name); fc.Object.IsAutoIncrement = true; return(fc); }
protected void TestDefaults(Column c) { Assert.IsNull(c.DefaultValue); Assert.AreEqual("COL1", c.ColumnName); Assert.IsFalse(c.IsAutoIncrement); Assert.IsTrue(c.IsNullable); }
public FluentColumn(string name, DbType type, int size) { Object = new Column(name, type); if (size > 0) { Object.Size = size; } }
private static void SetAutoIncrementColumn(Column autoIncrementColumn, string tableName, ICollection<string> sqls) { if (autoIncrementColumn == null) { return; } var sequenceName = SequencePrefix + tableName; sqls.Add(String.Format("CREATE SEQUENCE {0} INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1", sequenceName)); sqls.Add(String.Format("ALTER TABLE {0} ALTER COLUMN {1} SET DEFAULT NEXTVAL(\'{2}\'::REGCLASS)", tableName, autoIncrementColumn.ColumnName, sequenceName)); }
public override string GetColumnToSqlWhenCreate(Column col) { string nullOption = col.IsNullable ? WordNull : WordNotNull; string autoIncrement = col.IsAutoIncrement ? " AUTO_INCREMENT" : ""; string defaultValue = col.DefaultValue != null ? " default "+GetColumnValueToSql(col.DefaultValue): ""; return String.Format("{0} {1} {2}{3}{4}", col.ColumnName, GetDbTypeString(col.Type, col.Size), nullOption, defaultValue, autoIncrement); }
public override string GetColumnToSqlWhenCreate(Column col) { string colType = GetDbTypeString(col.Type, col.Size); string colNullable = col.IsNullable ? WordNull : WordNotNull; string colAutoIncrement = col.IsAutoIncrement ? "identity(1,1)" : ""; string colDefault = (col.DefaultValue != null) ? String.Format("default ({0})", GetColumnValueToSql(col.DefaultValue)) : ""; //name type default nullable autoIncrement return String.Format("{0} {1} {2} {3} {4}", col.ColumnName, colType, colNullable, colDefault, colAutoIncrement); }
public override string GetColumnToSqlWhenCreate(Column col) { string colType = GetDbTypeString(col.Type, col.Size); string colNullable = col.IsNullable ? WordNull : WordNotNull; string colDefault = (col.DefaultValue != null) ? String.Format(" default {0}", GetColumnValueToSql(col.DefaultValue)) : ""; //name type default nullable return String.Format("{0} {1}{2} {3}", col.ColumnName, colType, colDefault, colNullable); }
public override string GetColumnToSqlWhenCreate(Column col) { string colAutoIncrement = ""; if(col.IsAutoIncrement) { colAutoIncrement = "autoincrement"; col.IsPrimaryKey = true; } string colType = GetDbTypeString(col.Type, col.Size); string colNullable = col.IsNullable ? WordNull : WordNotNull; string colPrimaryKey = col.IsPrimaryKey ? "primary key" : ""; string colDefault = (col.DefaultValue != null) ? String.Format("default ({0})", GetColumnValueToSql(col.DefaultValue)) : ""; return String.Format("{0} {1} {2} {3} {4} {5}", col.ColumnName, colType, colNullable, colDefault, colPrimaryKey, colAutoIncrement); }
public string GetModifyColumnSql(string tableName, string columnName, Column columnDefinition) { var colStructure = GetSqlColumnStructure(columnDefinition, _getDbTypeString); var builder = new StringBuilder(); const string alterColumn = "ALTER COLUMN"; builder.AppendFormat("ALTER TABLE {0} ", tableName); GetTypeSqlToRenameColumnCommand(columnName, colStructure, builder, alterColumn); GetNullableSqlToRenameColumnCommand(columnName, colStructure, builder, alterColumn); GetDefaultValueSqlToRenameColumnCommand(columnName, colStructure, builder, alterColumn); builder.Remove(builder.Length - 1, 1); return builder.ToString(); }
public override string GetModifyColumnSql(string tableName, string columnName, Column columnDefinition) { return String.Format("alter table {0} modify {1}", tableName, GetColumnToSqlWhenCreate(columnDefinition)); }
public override string GetModifyColumnSql(string tableName, string columnName, Column columnDefinition) { throw new NotSupportedByDialect("Try recreating table", "GetModifyColumnSql", GetDialectName()); }
public override string GetModifyColumnSql(string tableName, string columnName, Column columnDefinition) { return _postgreSqlColumnDialect.GetModifyColumnSql(tableName, columnName, columnDefinition); }
private SqlColumnStructure GetSqlColumnStructure(Column col, Func<DbType, int, string> getDbTypeString) { return new SqlColumnStructure { Type = getDbTypeString(col.Type, col.Size), Nullable = col.IsNullable ? _wordNull : _wordNotNull, Default = (col.DefaultValue != null) ? String.Format("DEFAULT {0}", GetColumnValueToSql(col.DefaultValue)) : "" }; }
public void When_column_is_autoIncrement_it_is_also_not_null() { var c = new Column("COL1", DbType.UInt32); c.IsAutoIncrement = true; Assert.IsFalse(c.IsNullable); }
public static FluentColumn Decimal(string name) { return(SColumn.Decimal(name)); }
public static FluentColumn Binary(string name) { return(SColumn.Binary(name)); }
public static FluentColumn Boolean(string name) { return(SColumn.Boolean(name)); }
public static FluentColumn Int64(string name) { return(SColumn.Int64(name)); }
public static FluentColumn Clob(string name) { return(SColumn.Clob(name)); }
public static FluentColumn String(string name, int size) { return(SColumn.String(name, size)); }
public void Constructor_with_no_type_test() { var c = new Column("COL1"); Assert.AreEqual(DbType.String, c.Type); TestDefaults(c); }
public void Constructor_with_type_test() { var c = new Column("COL1", DbType.UInt32); Assert.AreEqual(DbType.UInt32, c.Type); TestDefaults(c); }
public static FluentColumn Single(string name) { return(SColumn.Single(name)); }
public void When_column_is_primary_key_it_is_also_not_null() { var c = new Column("COL1", DbType.UInt32); c.IsPrimaryKey = true; Assert.IsFalse(c.IsNullable); }
public AddColumn(IDataClient dataClient, Column column) : base(dataClient) { _column = column; }
public override string GetColumnToSqlWhenCreate(Column col) { return _postgreSqlColumnDialect.GetColumnToSqlWhenCreate(col); }
public void AddColumn(string tableName, Column column) { }
public void ModifyColumn(string firstTableName, string columnName, Column columnDefinition) { }
public static FluentColumn Guid(string name) { return(SColumn.Guid(name)); }
public static FluentColumn Double(string name) { return(SColumn.Double(name)); }
public virtual string GetAddColumnSql(string table, Column column) { return String.Format("alter table {0} add {1}", table, GetColumnToSqlWhenCreate(column)); }
public override string GetModifyColumnSql(string tableName, string columnName, Column columnDefinition) { throw new NotImplementedException(); }
public void ModifyColumn(string tableName, string columnName, Column columnDefinition) { Database.ExecuteSql(Dialect.GetModifyColumnSql(tableName, columnName, columnDefinition)); }
public abstract string GetModifyColumnSql(string tableName, string columnName, Column columnDefinition);
public virtual void AddColumn(string tableName, Column column) { string sql = Dialect.GetAddColumnSql(tableName, column); Database.ExecuteSql(sql); }
public abstract string GetColumnToSqlWhenCreate(Column col);
public string GetColumnToSqlWhenCreate(Column col) { var colStructure = GetSqlColumnStructure(col, _getDbTypeString); return String.Format("{0} {1} {2} {3}", col.ColumnName, colStructure.Type, colStructure.Default, colStructure.Nullable); }