protected override string MakeAlterColumnScript(ColumnInfo c, MappedPropertyAttribute prop) { var temp = prop.DefaultValue; prop.DefaultValue = null; var col = string.Format("alter table {0} alter column {1};", MakeIdentifier(c.table_schema ?? DefaultSchemaName, c.table_name), MakeColumnString(prop)); prop.DefaultValue = temp; return(col); }
private string MaybeMakeColumnTypeString(MappedPropertyAttribute attr, bool skipDefault = false) { if (reverseTypeMapping.ContainsKey(attr.SystemType)) { var typeStr = MakeSqlTypeString(attr); return(string.Format("{0} {1} {2}NULL {3}", attr.Name, typeStr, attr.IsOptional ? "" : "NOT ", !skipDefault ? attr.DefaultValue ?? "" : "").Trim()); } return(null); }
protected override string MakeColumnString(MappedPropertyAttribute p) { var typeStr = MakeSqlTypeString(p); if (p.IsIdentity) { typeStr = "autoincrement"; } return(string.Join(" ", p.Name, typeStr, p.IsOptional || p.IncludeInPrimaryKey ? "" : "NOT NULL") .Trim()); }
protected override string MakeDefaultConstraintScript(ColumnInfo c, MappedPropertyAttribute prop) { if (prop.DefaultValue == null) { return(string.Format("alter table {0} drop constraint DEF_{1}_{2}", MakeIdentifier(c.table_schema ?? DefaultSchemaName, c.table_name), c.table_name, c.column_name)); } else { return(string.Format("alter table {0} add constraint DEF_{1}_{2} default {3} for {2}", MakeIdentifier(c.table_schema ?? DefaultSchemaName, c.table_name), c.table_name, c.column_name, prop.DefaultValue)); } }
protected override string MakeColumnString(MappedPropertyAttribute p) { var typeStr = MakeSqlTypeString(p); var defaultString = ""; if (p.DefaultValue != null) { defaultString = string.Format("DEFAULT ({0})", p.DefaultValue); } else if (p.IsIdentity) { defaultString = "IDENTITY(1, 1)"; } return(string.Format("{0} {1} {2} {3}", p.Name, typeStr, p.IsOptional ? "" : "NOT NULL", defaultString)); }
protected override string MakeColumnString(MappedPropertyAttribute p) { var typeStr = MakeSqlTypeString(p); var defaultString = ""; if (p.DefaultValue != null) { defaultString = "DEFAULT " + p.DefaultValue.ToString(); } else if (p.IsIdentity) { defaultString = "DEFAULT nextval('serial')"; } return(string.Format("{0} {1} {2} {3}", p.Name, typeStr, p.IsOptional ? "NULL": "NOT NULL", defaultString)); }
public void IsIncludedByDefault1() { var p = new MappedPropertyAttribute(); Assert.IsTrue(p.Include); }
protected override string MakeDefaultConstraintScript(ColumnInfo columnInfo, MappedPropertyAttribute prop) { throw new System.NotImplementedException(); }
protected override string MakeAddColumnScript(string tableID, MappedPropertyAttribute prop) { throw new System.NotImplementedException(); }
protected override string MakeAddColumnScript(string tableID, MappedPropertyAttribute prop) { return(string.Format("alter table {0} add {1} {2};", tableID, prop.Name, prop.SqlType)); }
protected override string MakeAlterColumnScript(ColumnInfo columnInfo, MappedPropertyAttribute prop) { throw new NotImplementedException(); }
protected override string MakeColumnString(MappedPropertyAttribute p) { throw new NotImplementedException(); }