protected CommandBuilderTestBase()
{
CurrentSource = new Source("My Data");
CurrentSource.Schemas.Add("SchemaA");
CurrentSource.AddFunction("Function A", "dbo", "My Definition");
CurrentSource.AddStoredProcedure("Stored Procedure A", "dbo", "My Definition");
var Table = CurrentSource.AddTable("Table A", "dbo");
Table.AddCheckConstraint("Constraint A", "My Definition");
Table.AddColumn <int>("Column A", DbType.Int32);
Table.AddTrigger("Trigger A", "My Definition", TriggerType.Insert);
//Table.AddForeignKey("Column A", "Foreign Table", "Foreign Column");
CurrentSource.AddView("View A", "dbo", "My Definition");
var ForeignTable = CurrentSource.AddTable("Foreign Table", "dbo");
ForeignTable.AddColumn <int>("Foreign Column", DbType.Int32);
Table.SetupForeignKeys();
DesiredSource = new Source("My Data");
DesiredSource.Schemas.Add("SchemaA");
DesiredSource.AddFunction("Function A", "dbo", "My Definition 2");
DesiredSource.AddStoredProcedure("Stored Procedure A", "dbo", "My Definition 2");
Table = DesiredSource.AddTable("Table A", "dbo");
Table.AddCheckConstraint("Constraint A", "My Definition2");
Table.AddColumn <int>("Column A", DbType.Int32);
Table.AddColumn <string>("Column B", DbType.String);
Table.AddTrigger("Trigger A", "My Definition 2", TriggerType.Update);
Table.AddForeignKey("Column A", "Foreign Table", "Foreign Column");
DesiredSource.AddView("View A", "dbo", "My Definition 2");
ForeignTable = DesiredSource.AddTable("Foreign Table", "dbo");
ForeignTable.AddColumn <int>("Foreign Column", DbType.Int32);
Table.SetupForeignKeys();
}
public void FillSource()
{
var TempStoredProcedureColumns = new StoredProcedureColumns();
var TempSource = new Source("My Source");
TempSource.AddStoredProcedure("Procedure A", "dbo", "");
var ConstraintsToAdd = new List <dynamic>
{
new Dynamo(new
{
Procedure = "Procedure A",
TYPE = "Int",
NAME = "Column A",
LENGTH = 4,
DEFAULT_VALUE = ""
})
};
TempStoredProcedureColumns.FillSource(ConstraintsToAdd, TempSource);
var Constraint = (StoredProcedure)TempSource.StoredProcedures[0];
var Column = Constraint.Columns[0];
Assert.Equal(DbType.Int32, Column.DataType);
Assert.Equal("Column A", Column.Name);
Assert.Equal(4, Column.Length);
}
public void AddStoredProcedure()
{
var TempSource = new Source("MySource");
var TempStoredProcedure = TempSource.AddStoredProcedure("ProcedureName", "dbo", "ProcedureDefinition");
Assert.Equal("ProcedureName", TempStoredProcedure.Name);
Assert.Equal("ProcedureDefinition", TempStoredProcedure.Definition);
Assert.Equal(TempSource, TempStoredProcedure.Source);
}
public void Copy()
{
var TempSource = new Source("MySource");
_ = TempSource.AddTable("TableName", "dbo");
_ = TempSource.AddView("ViewName", "dbo", "ViewDefinition");
_ = TempSource.AddStoredProcedure("ProcedureName", "dbo", "ProcedureDefinition");
_ = TempSource.AddFunction("FunctionName", "dbo", "FunctionDefinition");
var TempCopy = TempSource.Copy();
Assert.Equal(TempSource, TempCopy);
}
