public override void RenameTable(string oldName, string newName)
{
oldName.MustNotBeEmpty();
newName.MustNotBeEmpty();
Db.ExecuteCommand(string.Format("alter table {0} rename to {1}", PostgresProvider.EscapeIdentifier(oldName),
PostgresProvider.EscapeIdentifier(newName)));
}
protected override string Escape(string name)
{
return(PostgresProvider.EscapeIdentifier(name));
}
public override void provider_escape_name()
{
var txt = @"""public.test""";
Assert.Equal(txt, PostgresProvider.EscapeIdentifier("public.test"));
}
public void anything_with_dot_will_be_escaped_as_schema_table()
{
Assert.Equal("\"public\".\"mytable\"", PostgresProvider.EscapeIdentifier("public.mytable"));
}
public void common_escaping()
{
Assert.Equal("\"mytable\"", PostgresProvider.EscapeIdentifier("mytable"));
Assert.Equal("\"my table\"", PostgresProvider.EscapeIdentifier("my table"));
}
public void already_escaped_id_are_not_escaped()
{
Assert.Equal("\"public.table\"", PostgresProvider.EscapeIdentifier("\"public.table\""));
Assert.Equal("\"my table\"", PostgresProvider.EscapeIdentifier("\"my table\""));
}
protected override string FormatName(string s)
{
return(PostgresProvider.EscapeIdentifier(s));
}
protected override void WriteColumn(IndexColumn column)
{
Builder.Append(PostgresProvider.EscapeIdentifier(column.Name));
}
protected override void WriteTableName()
{
Builder.Append(PostgresProvider.EscapeIdentifier(Index.TableName));
}