public void TestFoodInMeals()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new FoodInMealsAccess(context);
var kiwi = access.Add(new Foods {
Name = "Kiwi", Category = "Fruit", Nutrition = "Don't know"
});
var carrot = access.Add(new Foods {
Name = "Carrot", Category = "Vegetable", Nutrition = "Vitamin A"
});
Assert.AreEqual("Kiwi", kiwi.Name);
Assert.AreEqual("Carrot", carrot.Name);
var meal = access.Add(new Meals {
Name = "Test Meal", DietPlanId = 5
});
var mealFood1 = access.Add(new FoodInMeals {
MealId = meal.Id, FoodId = kiwi.Id
});
var mealFood2 = access.Add(new FoodInMeals {
MealId = meal.Id, FoodId = carrot.Id
});
var returned = spec_access.GetFoodsInMeals(meal.Id);
Assert.IsTrue(returned.ToList().Contains(mealFood1));
access.Delete <FoodInMeals>(mealFood1.Id);
access.Delete <FoodInMeals>(mealFood2.Id);
access.Delete <Meals>(meal.Id);
access.Delete <Foods>(kiwi.Id);
access.Delete <Foods>(carrot.Id);
}
public void TestDietPlansGetDietPlansByCreator()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new DietPlansAccess(context);
var person = access.Add(new Persons {
Age = 12, Email = "*****@*****.**", Name = "MyUnitTest", Password = "******", Sex = "M", Profile = "For unit test"
});
Assert.AreEqual("MyUnitTest", person.Name);
var diet_plan_1 = access.Add(new DietPlans {
Name = "Unit Diet 1", Information = "Unit test diet 1", PersonId = person.Id
});
var diet_plan_2 = access.Add(new DietPlans {
Name = "Unit Diet 2", Information = "Unit test diet 2", PersonId = person.Id
});
var returned = spec_access.GetDietPlansByCreatorId(person.Id);
Assert.IsTrue(returned.ToList().Contains(diet_plan_1));
Assert.IsTrue(returned.ToList().Contains(diet_plan_2));
Assert.IsNotNull(returned.ToList()[0].Person);
Assert.AreEqual(person.Name, returned.ToList()[0].Person.Name);
access.Delete <Persons>(person.Id);
access.Delete <DietPlans>(diet_plan_1.Id);
access.Delete <DietPlans>(diet_plan_2.Id);
}
public void TestPinnedWorkouts()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new PinnedWorkoutsAccess(context);
var follower = access.Add(new Persons {
Age = 12, Email = "*****@*****.**", Name = "FollowerTest", Password = "******", Sex = "M", Profile = "For unit test"
});
var workout = access.Add(new Workouts {
Name = "Pull Up", Category = "Body Weight", CreatorId = follower.Id
});
Assert.AreEqual("Pull Up", workout.Name);
var pinned = access.Add(new PinnedWorkouts {
PersonId = follower.Id, WorkoutId = workout.Id
});
var returned = spec_access.GetPinnedWorkoutsByPerson(follower.Id);
Assert.IsTrue(returned.ToList().Contains(pinned));
access.Delete <PinnedWorkouts>(pinned.Id);
access.Delete <Workouts>(workout.Id);
access.Delete <Persons>(follower.Id);
}
public static extern ConsoleHandle CreateConsoleScreenBuffer(
GenericAccess dwDesiredAccess,
uint dwShareMode,
IntPtr secutiryAttributes,
uint flags,
IntPtr screenBufferData
);
internal static extern Handle CreateFileW(
string fileName,
GenericAccess desiredAccess,
FileShare shareMode,
IntPtr securityAttributes,
FileMode creationDisposition,
uint flagsAndAttributes,
IntPtr templateFile);
public void TestDietPlansGetDietPlanById()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new DietPlansAccess(context);
var returned = spec_access.GetDietPlanById(5);
Assert.IsNotNull(returned.Meals);
Assert.IsNotNull(returned.Person);
Assert.AreEqual(5, returned.Meals.ToArray <Meals>()[0].DietPlanId);
Assert.AreEqual(4, returned.Person.Id);
}
public void TestGetById()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var person = access.GetById <Persons>(2);
var diet_plan = access.GetById <DietPlans>(5);
var food = access.GetById <Foods>(1);
var meal = access.GetById <Meals>(2);
Assert.AreEqual(2, person.Id);
Assert.AreEqual("Fruit", food.Category);
Assert.AreEqual("FirstMeal", meal.Name);
Assert.IsTrue(diet_plan.Meals.Contains(meal));
}
public void TestPersonsLogin()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new PersonsAccess(context);
var person = access.Add(new Persons {
Age = 12, Email = "*****@*****.**", Name = "MyUnitTest", Password = "******", Sex = "M", Profile = "For unit test"
});
Assert.AreEqual("MyUnitTest", person.Name);
var returned = spec_access.Login(person.Email, person.Password);
Assert.AreEqual(person, returned);
access.Delete <Persons>(returned.Id);
}
public void TestCRUDForWorkouts()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var workout = access.Add(new Workouts {
Name = "Test Workout", Category = "Unit test", CreatorId = 5
});
Assert.AreEqual("Test Workout", workout.Name);
workout.Name = "Changed Test Workout";
workout.Category = "Changed Workout";
workout = access.Update(workout, workout.Id);
var returned = access.GetById <Workouts>(workout.Id);
Assert.AreEqual(workout.Name, returned.Name);
access.Delete <Workouts>(returned.Id);
}
public void TestCRUDForPersons()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var person = access.Add(new Persons {
Age = 12, Email = "*****@*****.**", Name = "UnitTest", Password = "******", Sex = "M", Profile = "For unit test"
});
Assert.AreEqual("UnitTest", person.Name);
person.Name = "Changed UnitTest";
person.Profile = "Changed profile";
Persons personReturn2 = access.Update(person, person.Id);
var returned2 = access.GetById <Persons>(person.Id);
Assert.AreEqual(person.Name, returned2.Name);
access.Delete <Persons>(returned2.Id);
}
public void TestPersonGetPersonById()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new PersonsAccess(context);
var person = access.Add(new Persons {
Age = 12, Email = "*****@*****.**", Name = "MyUnitTest", Password = "******", Sex = "M", Profile = "For unit test"
});
Assert.AreEqual("MyUnitTest", person.Name);
var diet_plan_1 = access.Add(new DietPlans {
Name = "Unit Diet 1", Information = "Unit test diet 1", PersonId = 2
});
var diet_plan_2 = access.Add(new DietPlans {
Name = "Unit Diet 2", Information = "Unit test diet 2", PersonId = 2
});
var diet_plan_3 = access.Add(new DietPlans {
Name = "Unit Diet 3", Information = "Unit test diet 3", PersonId = person.Id
});
var pinned_diet_plan1 = access.Add(new PinnedDietPlans {
DietPlanId = diet_plan_1.Id, PersonId = person.Id
});
var pinned_diet_plan2 = access.Add(new PinnedDietPlans {
DietPlanId = diet_plan_2.Id, PersonId = person.Id
});
var followings = access.Add(new Followings {
Follower = person.Id, Following = 2
});
var returned = spec_access.GetPersonById(person.Id);
// var returned = access.GetById<Persons>(person.Id);
Assert.AreEqual("MyUnitTest", returned.Name);
access.Delete <Followings>(followings.Id);
access.Delete <PinnedDietPlans>(pinned_diet_plan1.Id);
access.Delete <PinnedDietPlans>(pinned_diet_plan2.Id);
access.Delete <Persons>(person.Id);
access.Delete <DietPlans>(diet_plan_1.Id);
access.Delete <DietPlans>(diet_plan_2.Id);
}
public void TestGetMealById()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new MealsAccess(context);
var meal = access.Add(new Meals {
Name = "NewTest", Information = "Test Information", DietPlanId = 3
});
Assert.AreEqual("NewTest", meal.Name);
var kiwi = access.Add(new Foods {
Name = "Kiwi", Category = "Fruit", Nutrition = "Don't know"
});
var carrot = access.Add(new Foods {
Name = "Carrot", Category = "Vegetable", Nutrition = "Vitamin A"
});
Assert.AreEqual("Kiwi", kiwi.Name);
Assert.AreEqual("Carrot", carrot.Name);
var mealFood1 = access.Add(new FoodInMeals {
MealId = meal.Id, FoodId = kiwi.Id
});
var mealFood2 = access.Add(new FoodInMeals {
MealId = meal.Id, FoodId = carrot.Id
});
var returned = spec_access.GetMealById(meal.Id);
Assert.AreEqual("NewTest", returned.Name);
Assert.IsNotNull(returned.FoodInMeals);
Assert.AreEqual("Kiwi", returned.FoodInMeals.ToList()[0].Food.Name);
access.Delete <FoodInMeals>(mealFood1.Id);
access.Delete <FoodInMeals>(mealFood2.Id);
access.Delete <Meals>(meal.Id);
access.Delete <Foods>(kiwi.Id);
access.Delete <Foods>(carrot.Id);
}
public void TestFollowingGetFollowing()
{
var context = new cse136Context();
var access = new GenericAccess(context);
var spec_access = new FollowingsAccess(context);
var person_1 = access.Add(new Persons {
Age = 12, Email = "*****@*****.**", Name = "FollowerTest", Password = "******", Sex = "M", Profile = "For unit test"
});
var person_2 = access.Add(new Persons {
Age = 21, Email = "*****@*****.**", Name = "FollowingTest", Password = "******", Sex = "M", Profile = "For unit test"
});
Assert.AreEqual("FollowerTest", person_1.Name);
Assert.AreEqual("FollowingTest", person_2.Name);
var following = access.Add(new Followings {
Follower = person_1.Id, Following = person_2.Id
});
var returned = spec_access.GetFollowings(person_1.Id);
Assert.IsTrue(returned.ToList().Contains(following));
access.Delete <Followings>(following.Id);
access.Delete <Persons>(person_1.Id);
access.Delete <Persons>(person_2.Id);
}
public void MapGeneric(GenericAccess generic)
{
MapGenericMask(ref generic.Mask, ref ServiceGenericMapping);
}
