public void ShouldWriteQueryForAddDataTypeUserDefinedType() { var op = new AddDataTypeOperation(SchemaName, Name, AssemblyName, ClassName); var expectedQuery = "create type [schemaName].[name] external name assemblyName.[className]"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldWriteQueryForAddDataTypeAlias() { var op = new AddDataTypeOperation(SchemaName, Name, From); var expectedQuery = "create type [schemaName].[name] from uniqueidentifier"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldMergeIfDataTypeRemoved() { var op = new AddDataTypeOperation("schema", "name", "from"); var removeDataTypeOp = new RemoveDataTypeOperation("SCHEMA", "NAME"); op.Merge(removeDataTypeOp); Assert.That(op.Disabled, Is.True); Assert.That(removeDataTypeOp.Disabled, Is.True); }
public void ShouldSetPropertiesForAddDataTypeUserDefinedTableType() { var op = new AddDataTypeOperation(SchemaName, Name, AsTable, TableConstraint); Assert.AreEqual(SchemaName, op.SchemaName); Assert.AreEqual(Name, op.Name); Assert.AreEqual(AsTable, op.AsTable); Assert.AreEqual(TableConstraint, op.TableConstraint); }
public void ShouldSetPropertiesForAddDataTypeUserDefinedType() { var op = new AddDataTypeOperation(SchemaName, Name, AssemblyName, ClassName); Assert.AreEqual(SchemaName, op.SchemaName); Assert.AreEqual(Name, op.Name); Assert.AreEqual(AssemblyName, op.AssemblyName); Assert.AreEqual(ClassName, op.ClassName); }
public void ShouldSetPropertiesForAddDataTypeAlias() { var op = new AddDataTypeOperation(SchemaName, Name, From); Assert.AreEqual(SchemaName, op.SchemaName); Assert.AreEqual(Name, op.Name); Assert.AreEqual(From, op.From); Assert.That(op.ObjectName, Is.EqualTo(SchemaName + "." + Name)); }
public void ShouldWriteQueryForAddDataTypeUserDefinedTableType() { var op = new AddDataTypeOperation(SchemaName, Name, AsTable, TableConstraint); var expectedQuery = "create type [schemaName].[name] as table (" + $"[name] varchar(50) not null constraint [{DefaultConstraintName}] default '', " + "[int column] int identity not null constraint1, constraint2" + ")"; Assert.AreEqual(expectedQuery, op.ToQuery()); }