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'"); }