public void DeleteAllItemsInADatabase()
{
DatabaseModifier.DeleteAll(typeof(Person));
int count = CountItemsInDatabase();
Assert.AreEqual(0, count);
}
public void AddToDepartment()
{
List <Person> persons = new List <Person>()
{
new Person
{
Id = 3,
Name = "name3",
departmentId = 52
},
new Person
{
Id = 4,
Name = "name4",
departmentId = 52
}
};
Department department = new Department()
{
Id = 52,
persons = persons
};
DatabaseModifier.AddData(department);
}
public void TestDeleteMethodWhereItemDoesntExist()
{
Person person = new Person(203, "Delete203");
int count = CountItemsInDatabase();
DatabaseModifier.DeleteItemFromDatabase(person);
int countAfter = CountItemsInDatabase();
Assert.AreEqual(count, countAfter);
}
private static bool MergeDatabase(DatabaseModifierModel mergedDatabase,
List <DatabaseModifier> userConfigDatabases,
DatabaseMetadata defaultDatabaseSchema,
AppMetadata appMetadata)
{
var hasChange = false;
var userConfigDatabase = userConfigDatabases.FirstOrDefault(d => d.Name == mergedDatabase.Name);
if (defaultDatabaseSchema == null)
{
hasChange = true;
}
//Add new
if (userConfigDatabase == null)
{
userConfigDatabase = new DatabaseModifier {
Name = mergedDatabase.Name
};
userConfigDatabases.Add(userConfigDatabase);
}
//Apply changes
userConfigDatabase.TemplateId = mergedDatabase.TemplateId;
userConfigDatabase.BasedOn = mergedDatabase.UseTemplateId;
userConfigDatabase.Description = mergedDatabase.Description;
if (mergedDatabase.TemplateId != 0 ||
mergedDatabase.UseTemplateId != 0 ||
!String.IsNullOrEmpty(mergedDatabase.Description))
{
hasChange = true;
}
if (mergedDatabase.Schemas != null)
{
foreach (var mergedSchema in mergedDatabase.Schemas)
{
var defaultSchema = GetSchemaMetadata(defaultDatabaseSchema, appMetadata, mergedSchema.Name);
if (MergeSchema(mergedSchema, userConfigDatabase.Schemas, defaultSchema))
{
hasChange = true;
}
}
}
//If no change has been detected with the default config
if (!hasChange)
{
userConfigDatabases.Remove(userConfigDatabase);
}
return(hasChange);
}
public void TestDeleteMethod()
{
Person person = new Person(104, "Delete104");
DatabaseModifier.AddData(person);
int count = CountItemsInDatabase();
DatabaseModifier.DeleteItemFromDatabase(person);
int countAfter = CountItemsInDatabase();
Assert.AreEqual(count - 1, countAfter);
}
public void TestCreateMethod()
{
DatabaseModifier.CreateTable(typeof(Department));
DatabaseModifier.CreateTable(typeof(Person));
List <string> tablesInDatabase = CheckTablesInDatabase();
for (int i = 0; i < tablesInDatabase.Count; i++)
{
TestContext.WriteLine(tablesInDatabase[i]);
}
CollectionAssert.Contains(tablesInDatabase, "PERSONS");
}
public void TestAdderAndSelectMethod()
{
Person person = new Person(39, "Test39");
person.departmentId = 39;
int count = CountItemsInDatabase();
DatabaseModifier.AddData(person);
int countAfter = CountItemsInDatabase();
Assert.AreEqual(count + 1, countAfter);
List <Person> lists = DatabaseModifier.SelectData <Person>().ToList();
foreach (Person p in lists)
{
TestContext.WriteLine(p.departmentId.ToString());
}
}
public void UpdateItemInADatabase()
{
Person oldPerson = new Person()
{
Id = 410,
Name = "Update410"
};
//DatabaseModifier.AddData(oldPerson);
Person newPerson = new Person()
{
Id = 460,
Name = "Update460",
departmentId = 460
};
//List<Person> lists = DatabaseModifier.SelectData<Person>().ToList();
DatabaseModifier.UpdateItem(oldPerson, newPerson);
//List<Person> lists2 = DatabaseModifier.SelectData<Person>().ToList();
//Assert.AreNotEqual(lists, lists2);
}
public void initializeForTests()
{
DatabaseModifier.CreateTable(typeof(Department));
DatabaseModifier.CreateTable(typeof(Person));
}
