public void RelatedCatalogueTest_OneCatalogue(bool createExtractionInformation)
{
TableInfo t = new TableInfo(Repository, "MyTable");
ColumnInfo c = new ColumnInfo(Repository, "MyCol", "varchar(10)", t);
Catalogue cata = new Catalogue(Repository, "MyCata");
CatalogueItem ci = new CatalogueItem(Repository, cata, "MyCataItem");
try
{
if (createExtractionInformation)
{
new ExtractionInformation(Repository, ci, c, "dbo.SomeFunc('Bob') as MySelectLine");
}
else
{
ci.SetColumnInfo(c);
}
var catas = t.GetAllRelatedCatalogues();
Assert.AreEqual(1, catas.Length);
Assert.AreEqual(cata, catas[0]);
}
finally
{
ci.DeleteInDatabase();
cata.DeleteInDatabase();
t.DeleteInDatabase();
}
}
public void update_changeAllPropertiesOfCatalogueItem_passes()
{
Catalogue parent = new Catalogue(CatalogueRepository, "KONGOR");
CatalogueItem child = new CatalogueItem(CatalogueRepository, parent, "KONGOR_SUPERKING")
{
Agg_method = "Adding SetUp",
Comments = "do not change amagad super secret!",
Limitations = "Extreme limitaitons",
Description =
"Exciting things are going down in the streets of new your this time of year it would be a great idea if you were to go there",
Name = "KONGOR_MINIMAN",
Periodicity = Catalogue.CataloguePeriodicity.Monthly,
Research_relevance = "Highly relevant to all fields of subatomic particle study",
Statistical_cons = "Dangerous cons frequent the areas that this stats is happening, be afraid",
Topic = "nothing much, lots of stuff"
};
child.SaveToDatabase();
CatalogueItem childAfter = CatalogueRepository.GetObjectByID <CatalogueItem>(child.ID);
Assert.IsTrue(child.Name == childAfter.Name);
Assert.IsTrue(child.Agg_method == childAfter.Agg_method);
Assert.IsTrue(child.Comments == childAfter.Comments);
Assert.IsTrue(child.Limitations == childAfter.Limitations);
Assert.IsTrue(child.Description == childAfter.Description);
Assert.IsTrue(child.Periodicity == childAfter.Periodicity);
Assert.IsTrue(child.Research_relevance == childAfter.Research_relevance);
Assert.IsTrue(child.Statistical_cons == childAfter.Statistical_cons);
Assert.IsTrue(child.Topic == childAfter.Topic);
child.DeleteInDatabase();
parent.DeleteInDatabase();
}
public void AddSameLinkTwice()
{
Catalogue predator = null;
CatalogueItem lazor = null;
TableInfo highEnergyTable = null;
ColumnInfo velocityColumn = null;
try
{
///////////////Create the things that we are going to create relationships between /////////////////
predator = new Catalogue(CatalogueRepository, "Predator");
lazor = new CatalogueItem(CatalogueRepository, predator, "QuadlzorVelocity");
highEnergyTable = new TableInfo(CatalogueRepository, "HighEnergyShizzle");
velocityColumn = new ColumnInfo(CatalogueRepository, "Velocity Of Matter", "int", highEnergyTable);
//now you can add as many links as you want, it just skips them
lazor.SetColumnInfo(velocityColumn);
Assert.AreEqual(lazor.ColumnInfo, velocityColumn);
}
finally
{
lazor.DeleteInDatabase(); //delete child
predator.DeleteInDatabase(); //delete parent
velocityColumn.DeleteInDatabase(); //delete child
highEnergyTable.DeleteInDatabase(); //delete parent
}
}
public void TestSettingColumnInfoToNull()
{
var parent = new Catalogue(CatalogueRepository, "GROG");
CatalogueItem child1 = new CatalogueItem(CatalogueRepository, parent, "GROG_ITEM1");
child1.SetColumnInfo(null);
Assert.IsNull(child1.ColumnInfo_ID);
child1.DeleteInDatabase();
parent.DeleteInDatabase();
}
public void clone_CloneCatalogueItemWithIDIntoCatalogue_passes()
{
Catalogue parent = new Catalogue(CatalogueRepository, "KONGOR");
Catalogue parent2 = new Catalogue(CatalogueRepository, "KONGOR2");
CatalogueItem child = new CatalogueItem(CatalogueRepository, parent, "KONGOR_SUPERKING")
{
Agg_method = "Adding SetUp",
Comments = "do not change amagad super secret!",
Limitations = "Extreme limitaitons",
Description =
"Exciting things are going down in the streets of new your this time of year it would be a great idea if you were to go there",
Name = "KONGOR_MINIMAN",
Periodicity = Catalogue.CataloguePeriodicity.Monthly,
Research_relevance = "Highly relevant to all fields of subatomic particle study",
Statistical_cons = "Dangerous cons frequent the areas that this stats is happening, be afraid",
Topic = "nothing much, lots of stuff"
};
CatalogueItem cloneChild = null;
try
{
child.SaveToDatabase();
cloneChild = child.CloneCatalogueItemWithIDIntoCatalogue(parent2);
//get the clone that was returned
Assert.AreEqual(cloneChild.Catalogue_ID, parent2.ID); //it is in the second one
Assert.AreNotEqual(cloneChild.Catalogue_ID, parent.ID); //it is not in the first one
Assert.AreNotEqual(cloneChild.ID, child.ID); //it has a new ID
Assert.AreEqual(cloneChild.Limitations, child.Limitations);
Assert.AreEqual(cloneChild.Description, child.Description);
Assert.AreEqual(cloneChild.Name, child.Name);
Assert.AreEqual(cloneChild.Periodicity, child.Periodicity);
Assert.AreEqual(cloneChild.Research_relevance, child.Research_relevance);
Assert.AreEqual(cloneChild.Statistical_cons, child.Statistical_cons);
Assert.AreEqual(cloneChild.Topic, child.Topic);
}
finally
{
if (cloneChild != null)
{
cloneChild.DeleteInDatabase();
}
child.DeleteInDatabase();
parent.DeleteInDatabase();
parent2.DeleteInDatabase();
}
}
public void constructor_newTestCatalogueItem_pass()
{
var parent = new Catalogue(CatalogueRepository, "GROG");
CatalogueItem child1 = new CatalogueItem(CatalogueRepository, parent, "GROG_ITEM1");
CatalogueItem child2 = new CatalogueItem(CatalogueRepository, parent, "GROG_ITEM2");
Assert.IsTrue(child1.Catalogue_ID == parent.ID);
Assert.IsTrue(child2.Catalogue_ID == parent.ID);
Assert.IsTrue(child1.ID != child2.ID);
child1.DeleteInDatabase();
child2.DeleteInDatabase();
parent.DeleteInDatabase();
}
public void DeleteSetupObjects()
{
if (cataItem != null)
{
cataItem.DeleteInDatabase();
}
cata.DeleteInDatabase();
if (columnInfo != null)
{
columnInfo.DeleteInDatabase();
}
if (ti != null)
{
ti.DeleteInDatabase();
}
}
public void ExtractableColumnTest()
{
ExtractableDataSet dataSet = null;
ExtractionConfiguration configuration = null;
Project project = null;
Catalogue cata = null;
CatalogueItem cataItem = null;
ColumnInfo column = null;
TableInfo table = null;
ExtractionInformation extractionInformation = null;
ExtractableColumn extractableColumn = null;
try
{
//setup catalogue side of things
cata = new Catalogue(CatalogueRepository, "unit_test_ExtractableColumnTest_Cata");
cataItem = new CatalogueItem(CatalogueRepository, cata, "unit_test_ExtractableColumnTest_CataItem");
table = new TableInfo(CatalogueRepository, "DaveTable");
column = new ColumnInfo(CatalogueRepository, "Name", "string", table);
cataItem.SetColumnInfo(column);
extractionInformation = new ExtractionInformation(CatalogueRepository, cataItem, column, "Hashme(Name)");
//setup extractor side of things
dataSet = new ExtractableDataSet(DataExportRepository, cata);
project = new Project(DataExportRepository, "unit_test_ExtractableColumnTest_Proj");
configuration = new ExtractionConfiguration(DataExportRepository, project);
extractableColumn = new ExtractableColumn(DataExportRepository, dataSet, configuration, extractionInformation, 0, "Hashme2(Name)");
Assert.AreEqual(configuration.GetAllExtractableColumnsFor(dataSet).Length, 1);
}
finally
{
if (extractionInformation != null)
{
extractionInformation.DeleteInDatabase();
}
if (column != null)
{
column.DeleteInDatabase();
}
if (table != null)
{
table.DeleteInDatabase();
}
if (cataItem != null)
{
cataItem.DeleteInDatabase();
}
if (configuration != null)
{
configuration.DeleteInDatabase();
}
if (project != null)
{
project.DeleteInDatabase();
}
if (dataSet != null)
{
dataSet.DeleteInDatabase();
}
if (cata != null)
{
cata.DeleteInDatabase();
}
}
}