private void AddColumnTo(CreateTableSQLCommand table, string columnName, DbType type, int size, byte precision, byte scale, bool isNotNull, object defaultValue)
{
SqlObjectModel.LDD.ColumnConstraint constraint = null;
if (defaultValue != null)
constraint = new SqlObjectModel.LDD.DefaultConstraint(new Constant(defaultValue, type), !isNotNull);
else
constraint = new SqlObjectModel.LDD.ColumnConstraint(!isNotNull);
if (!table.ColumnDefinitions.Contains(columnName))
{
ColumnDefinition column = new ColumnDefinition(columnName, type, size, precision, scale, constraint);
table.ColumnDefinitions.Add(columnName, column);
}
else
{
ColumnDefinition column = table.ColumnDefinitions[columnName] as ColumnDefinition;
column.ColumnConstraint = constraint;
}
}
public abstract void Visit(DefaultConstraint constraint);
private void AddForeignKeysTo(CreateTableSQLCommand table, string columnName, string ref_column_name, string ref_table_name, GeneratorMapping map_generator, object defaultValue)
{
if (!table.ColumnDefinitions.Contains(columnName))
{
DbType type = _Dialect.GetDbTypeToPrimaryKey(map_generator);
SqlObjectModel.LDD.ColumnConstraint constraint = null;
if (defaultValue != null)
constraint = new SqlObjectModel.LDD.DefaultConstraint(new Constant(defaultValue, type), false);
else
constraint = new SqlObjectModel.LDD.ColumnConstraint(true);
int size = _Dialect.GetSizeToPrimaryKey(map_generator);
ColumnDefinition column = new ColumnDefinition(columnName, type, size, constraint);
table.ColumnDefinitions.Add(columnName, column);
// Add foreign keys here
}
}
public virtual void Visit(DefaultConstraint constraint)
{
this.Visit((ColumnConstraint)constraint);
if (constraint.DefaultValue != null)
{
_Query.Append(DEFAULT).Append(OPENBRACE);
constraint.DefaultValue.Accept(this);
_Query.Append(CLOSEBRACE);
}
}
