protected override string Escape(string name)
{
return(MySqlProvider.EscapeIdentifier(name));
}
public override void WriteSetDefault(ColumnModifications col)
{
Builder.AppendFormat("alter table {0} alter {1} set default '{2}';",
MySqlProvider.EscapeIdentifier(col.TableName), MySqlProvider.EscapeIdentifier(col.Name),
col.DefaultValue);
}
public override void WriteDropDefault(ColumnModifications col)
{
Builder.AppendFormat("alter table {0} alter {1} drop default;",
MySqlProvider.EscapeIdentifier(col.TableName), MySqlProvider.EscapeIdentifier(col.Name));
}
public void anything_with_dot_will_be_escaped_as_schema_table()
{
Assert.Equal("`dbo`.`mytable`", MySqlProvider.EscapeIdentifier("dbo.mytable"));
}
public void common_escaping()
{
Assert.Equal("`mytable`", MySqlProvider.EscapeIdentifier("mytable"));
Assert.Equal("`my table`", MySqlProvider.EscapeIdentifier("my table"));
}
public void already_escaped_id_are_not_escaped()
{
Assert.Equal("`my table`.id", MySqlProvider.EscapeIdentifier("`my table`.id"));
Assert.Equal("`a``b`", MySqlProvider.EscapeIdentifier("`a``b`"));
}
