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