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