public void InsertDeleteValidateGetUserOwnsSystemTest()
{
var db = new PlantRepository();
var plantId_1 = DatabaseHelpers.CreatePlantGetId();
var plantId_2 = DatabaseHelpers.CreatePlantGetId();
//Insert test data
db.StoreUserPlantRelation(3, plantId_1, E_PlantRole.Owner);
db.StoreUserPlantRelation(2, plantId_2, E_PlantRole.Guest);
//validate
Assert.True(db.ValidateUserUserForPlant(3, plantId_1, E_PlantRole.Owner));
Assert.True(db.ValidateUserUserForPlant(3, plantId_1, E_PlantRole.Guest));
Assert.True(db.ValidateUserUserForPlant(2, plantId_2, E_PlantRole.Guest));
Assert.False(db.ValidateUserUserForPlant(2, plantId_2, E_PlantRole.Owner));
//get owners
var actual = db.GetUsersOfSolarPlant(plantId_2, E_PlantRole.Guest);
Assert.AreEqual(1, actual.Count);
Assert.AreEqual(2, actual[0]);
//delete relationship
db.DeleteUserHasPlantRelation(2, plantId_2, E_PlantRole.Guest);
Assert.False(db.ValidateUserUserForPlant(2, plantId_2, E_PlantRole.Guest));
}
