public override void Process(Expressions.RenameTableExpression expression)
{
truncator.Truncate(expression);
FirebirdSchemaProvider schema = new FirebirdSchemaProvider(this);
TableDefinition tableDef = schema.GetTableDefinition(expression.OldName);
tableDef.Name = expression.NewName;
CreateTableExpression createNew = new CreateTableExpression()
{
TableName = expression.NewName,
SchemaName = String.Empty
};
//copy column definitions (nb: avoid to copy key names, because in firebird they must be globally unique, so let it rename)
tableDef.Columns.ToList().ForEach(x => createNew.Columns.Add(new ColumnDefinition()
{
Name = x.Name,
DefaultValue = x.DefaultValue,
IsForeignKey = x.IsForeignKey,
IsIdentity = x.IsIdentity,
IsIndexed = x.IsIndexed,
IsNullable = x.IsNullable,
IsPrimaryKey = x.IsPrimaryKey,
IsUnique = x.IsUnique,
ModificationType = x.ModificationType,
Precision = x.Precision,
Size = x.Size,
Type = x.Type,
CustomType = x.CustomType
}));
Process(createNew);
int columnCount = tableDef.Columns.Count;
string[] columns = tableDef.Columns.Select(x => x.Name).ToArray();
InsertDataExpression data = new InsertDataExpression();
using (DataSet ds = ReadTableData(String.Empty, expression.OldName))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
InsertionDataDefinition insert = new InsertionDataDefinition();
for (int i = 0; i < columnCount; i++)
{
insert.Add(new KeyValuePair <string, object>(columns[i], dr.ItemArray[i]));
}
data.Rows.Add(insert);
}
}
Process(data);
DeleteTableExpression delTable = new DeleteTableExpression()
{
TableName = expression.OldName,
SchemaName = String.Empty
};
Process(delTable);
}
public override string Generate(Expressions.RenameTableExpression expression)
{
return(string.Format(
"RENAME TABLE {0} TO {1}",
Quoter.QuoteTableName(expression.OldName, expression.SchemaName),
Quoter.QuoteTableName(expression.NewName)));
}
public void Process(Expressions.RenameTableExpression expression)
{
Process(Generator.Generate(expression));
}
