public void ShouldWriteQueryForAddSynonymNoTargetDatabase()
{
var op = new AddSynonymOperation(SchemaName, Name, TargetSchemaName, "", TargetObjectName);
const string expectedQuery = "create synonym [schemaName].[name] for [targetSchemaName].[targetObjectName]";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
public void ShouldDisableWhenMergedWithRemoveOperation()
{
var op = new AddSynonymOperation("schema", "name", "targetschema", "targetdatabase", "targetobject");
var removeOp = new RemoveSynonymOperation("SCHEMA", "NAME");
op.Merge(removeOp);
Assert.That(op.Disabled, Is.True);
Assert.That(removeOp.Disabled, Is.True);
}
public void ShouldSetPropertiesForAddSynonym()
{
var op = new AddSynonymOperation(SchemaName, Name, TargetSchemaName, TargetDatabaseName, TargetObjectName);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(Name, op.Name);
Assert.AreEqual(TargetSchemaName, op.TargetSchemaName);
Assert.AreEqual(TargetDatabaseName, op.TargetDatabaseName);
Assert.AreEqual(TargetObjectName, op.TargetObjectName);
Assert.That(op.ObjectName, Is.EqualTo(string.Format("{0}.{1}", SchemaName, Name)));
}
public void ShouldUpdateTargetObjectNameIfItGetsRenamedByMerge(string targetDatabaseName)
{
var op = new AddSynonymOperation("schema", "name", "targetschema", targetDatabaseName, "targetobject");
var renameOp = new RenameObjectOperation("TARGETSCHEMA", "TARGETOBJECT", "newtargetobject");
op.Merge(renameOp);
Assert.That(op.Disabled, Is.False);
if (null == targetDatabaseName)
{
Assert.That(renameOp.Disabled, Is.True);
Assert.That(op.TargetObjectName, Is.EqualTo("newtargetobject"));
}
else
{
Assert.That(renameOp.Disabled, Is.False);
Assert.That(op.TargetObjectName, Is.EqualTo("targetobject"));
}
}
