internal override void RenameTable(string tableName, string newTableName)
{
var escapedTableName = EscapeIdentifier(tableName);
var escapedNewTableName = EscapeIdentifier(newTableName);
Dapper.Execute($"RENAME TABLE {escapedTableName} TO {escapedNewTableName}");
}
internal override void RemoveIndex(string tableName, string indexName)
{
var escapedTableName = EscapeIdentifier(tableName);
var escapedIndexName = EscapeIdentifier(indexName);
Dapper.Execute($"ALTER TABLE {escapedTableName} DROP INDEX {escapedIndexName}");
}
internal override void RemoveForeignKey(string tableName, string foreignKeyName)
{
var escapedTableName = EscapeIdentifier(tableName);
var escapedForeignKeyName = EscapeIdentifier(foreignKeyName);
Dapper.Execute($"ALTER TABLE {escapedTableName} DROP FOREIGN KEY {escapedForeignKeyName}");
}
internal override void RenameColumn(string tableName, string columnName, string newColumnName)
{
var escapedTableName = EscapeIdentifier(tableName);
var escapedColumnName = EscapeIdentifier(columnName);
var escapedNewColumnName = EscapeIdentifier(newColumnName);
Dapper.Execute($"ALTER TABLE {escapedTableName} RENAME COLUMN {escapedColumnName} TO {escapedNewColumnName}");
}
internal override void ChangeColumn(string tableName, string columnName, string dataType, bool nullable)
{
var escapedTableName = EscapeIdentifier(tableName);
var escapedColumnName = EscapeIdentifier(columnName);
var nullableStatement = nullable ? "NULL" : "NOT NULL";
Dapper.Execute($"ALTER TABLE {escapedTableName} CHANGE COLUMN {escapedColumnName} {escapedColumnName} {dataType} {nullableStatement}");
}
internal override void RemoveIndex(string tableName, string indexName)
{
var escapedIndexName = EscapeIdentifier(indexName);
var schemaName = GetSchema(tableName);
var escapedSchemaName = EscapeIdentifier(schemaName);
Dapper.Execute($"DROP INDEX {escapedSchemaName}.{escapedIndexName}");
}
internal override void RenameColumn(string tableName, string columnName, string newColumnName)
{
var isColumnAutoIncrement = GetColumnAutoIncrement(tableName, columnName);
if (isColumnAutoIncrement)
{
throw new NotSupportedException("Renaming a serial column is not supported by PostgreSql.");
}
var escapedTableName = EscapeIdentifier(tableName);
var escapedColumnName = EscapeIdentifier(columnName);
var escapedNewColumnName = EscapeIdentifier(newColumnName);
Dapper.Execute($"ALTER TABLE {escapedTableName} RENAME {escapedColumnName} TO {escapedNewColumnName}");
}
internal override void RemovePrimaryKey(string tableName, string primaryKeyName)
{
var escapedTableName = EscapeIdentifier(tableName);
Dapper.Execute($"ALTER TABLE {escapedTableName} DROP PRIMARY KEY");
}
internal override void RenameTable(string tableName, string newTableName)
{
Dapper.Execute($"sp_RENAME '{tableName}', '{newTableName}'");
}
internal override void RenameColumn(string tableName, string columnName, string newColumnName)
{
Dapper.Execute($"sp_RENAME '{tableName}.{columnName}', '{newColumnName}', 'COLUMN'");
}
