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);
}
