public override void WriteColumnChanges(ColumnModifications col)
{
Builder.AppendFormat("alter table {0} alter column {1} ", SqlServerProvider.EscapeIdentifier(col.TableName),
SqlServerProvider.EscapeIdentifier(col.Current.Name));
_writer.Write(col);
Builder.AppendLine(";");
}
public void WriteColumnsChanges(TableSchema table)
{
var mods = table.ModifiedColumns.ChangedColumns;
if (mods.Count == 0)
{
return;
}
FillRealTableSchema(table);
var writer = new SqlServerCompactColumnWriter(Builder);
foreach (var col in mods.Where(c => c.DefaultDropped))
{
Builder.AppendFormat("alter table {0} alter column {1} drop default;\n", table.Name, col.Name);
}
foreach (var col in mods.Where(d => !d.IsDropped))
{
Builder.AppendFormat("alter table [{0}] alter column {1} ", table.Name,
SqlServerProvider.EscapeIdentifier(col.Current.Name));
writer.Write(col);
Builder.AppendLine(";");
}
foreach (var cl in mods.Where(c => !string.IsNullOrEmpty(c.DefaultValue)))
{
Builder.AppendFormat("alter table {0} alter column {1} set default '{2}';\n", table.Name, cl.Name,
cl.DefaultValue);
}
}
public WhereCriteriaTests()
{
_sb = new StringBuilder();
_pm = new ParametersManager();
_fRm = new Mock <IDbProviderExpressionHelper>();
_fRm.Setup(d => d.EscapeName(It.IsAny <string>())).Returns((string v) => SqlServerProvider.EscapeIdentifier(v));
_fRm.Setup(d => d.FormatBoolean(It.IsAny <bool>())).Returns((bool v) => v == true?"1":"0");
_w = new ExpressionWriter(_sb, _fRm.Object, _pm);
}
public override void WriteDropDefault(ColumnModifications col)
{
if (!col.Current.DefaultConstraintName.IsNullOrEmpty())
{
Builder.AppendFormat("alter table {0} drop constraint {1};\n",
SqlServerProvider.EscapeIdentifier(col.TableName),
col.Current.DefaultConstraintName);
}
}
public override string EscapeName(string s)
{
return(SqlServerProvider.EscapeIdentifier(s));
}
protected override string Escape(string name)
{
return(SqlServerProvider.EscapeIdentifier(name));
}
protected override void WriteTableName()
{
Builder.Append(SqlServerProvider.EscapeIdentifier(Table.Name));
}
protected override string FormatName(string s)
{
return(SqlServerProvider.EscapeIdentifier(s));
}
public override void WriteSetDefault(ColumnModifications col)
{
Builder.AppendFormat("alter table {0} add constraint {1} default ('{2}') for {3};\n",
SqlServerProvider.EscapeIdentifier(col.TableName),
string.Format("DF_{0}_{1}", col.TableName, col.Name), col.DefaultValue, col.Name);
}
public override void provider_escape_name()
{
Assert.Equal("[dbo.table]", SqlServerProvider.EscapeIdentifier("dbo.table"));
}
protected override void WriteOnTable()
{
Builder.AppendFormat(" on {0}", SqlServerProvider.EscapeIdentifier(Item.TableName));
}
protected override void WriteColumn(IndexColumn column)
{
Builder.Append(SqlServerProvider.EscapeIdentifier(column.Name));
}
protected override void WriteIndexName()
{
Builder.Append(SqlServerProvider.EscapeIdentifier(Index.Name));
}
public void anything_with_dot_will_be_escaped_as_schema_table()
{
Assert.Equal("[dbo].[mytable]", SqlServerProvider.EscapeIdentifier("dbo.mytable"));
}
public void common_escaping()
{
Assert.Equal("[mytable]", SqlServerProvider.EscapeIdentifier("mytable"));
Assert.Equal("[my table]", SqlServerProvider.EscapeIdentifier("my table"));
}
public void already_escaped_id_are_not_escaped()
{
Assert.Equal("dbo.[my.table]", SqlServerProvider.EscapeIdentifier("dbo.[my.table]"));
Assert.Equal("dbo.\"my.table\"", SqlServerProvider.EscapeIdentifier("dbo.\"my.table\""));
}
