public static SqlStatement Build(PlSqlParser.CreateTableStatementContext context)
{
var tableName = Name.Object(context.objectName());
var columnOrConstraints = context.columnOrConstraintList().columnOrConstraint();
bool ifNotExists = context.IF() != null && context.NOT() != null && context.EXISTS() != null;
bool temporary = context.TEMPORARY() != null;
var tableColumns = new List <SqlTableColumn>();
var tableConstraints = new List <SqlTableConstraint>();
var columnConstraints = new List <ColumnConstraint>();
foreach (var columnOrConstraint in columnOrConstraints)
{
if (columnOrConstraint.tableColumn() != null)
{
tableColumns.Add(TableColumn.Form(columnOrConstraint.tableColumn(), columnConstraints));
}
else if (columnOrConstraint.tableConstraint() != null)
{
tableConstraints.Add(TableConstraint.Form(columnOrConstraint.tableConstraint()));
}
}
if (columnConstraints.Count > 0)
{
var constraintGroups = columnConstraints.GroupBy(x => x.Type);
foreach (var constraintGroup in constraintGroups)
{
var columnNames = constraintGroup.Select(x => x.ColumnName).ToArray();
var index = tableConstraints.FindIndex(x => String.IsNullOrEmpty(x.ConstraintName) &&
x.ConstraintType == constraintGroup.Key);
if (index != -1)
{
var unnamedConstraint = tableConstraints[index];
var columns = new List <string>(unnamedConstraint.Columns);
foreach (var columnName in columnNames)
{
if (!columns.Contains(columnName))
{
columns.Add(columnName);
}
}
// TODO: set the new columns
}
else
{
tableConstraints.Add(new SqlTableConstraint(constraintGroup.Key, columnNames));
}
}
}
var block = new SequenceOfStatements();
block.Statements.Add(new CreateTableStatement(tableName, tableColumns)
{
IfNotExists = ifNotExists,
Temporary = temporary
});
foreach (var constraint in tableConstraints)
{
block.Statements.Add(new AlterTableStatement(tableName, new AddConstraintAction(constraint)));
}
return(block);
}
