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