private void CreateGroups(IRepositoryLocator locator)
{
var q1List = locator.FetchAll<Query>().OrderBy(q => q.Id).Take(2).ToList();
var q2List = locator.FetchAll<Query>().OrderByDescending(q => q.Id).Take(2).ToList();
var q1Group = new QueryGroup()
{
Name = "Group 1",
CreatedDateTime = DateTime.Now,
};
q1Group.AddQueries(q1List);
locator.Save(q1Group);
var q2Group = new QueryGroup()
{
Name = "Group 2",
CreatedDateTime = DateTime.Now,
};
q2Group.AddQueries(q2List);
locator.Save(q2Group);
}
private static void CreateQueries(IRepositoryLocator locator)
{
var user = locator.FetchAll<User>().FirstOrDefault();
if (user == null) throw new InvalidDataException("User is needed before creating query");
var q1 = new Query
{
CreatedDateTime = DateTime.Now,
DbType = EnumDatabase.Oracle,
Description = "Test Query - User Permissions",
DisplayOnHomeScreen = true,
Name = "RPO - Permissions",
Text = "select p.description as User_Or_Group, r.description as RpoMS_Role from role r,principal p,role_principal rp where r.id = rp.role_id and p.id = rp.principal_id",
Owner = user,
ParameterCount = 0,
Published = true
};
var q2 = new Query
{
CreatedDateTime = DateTime.Now,
DbType = EnumDatabase.Oracle,
Description = "Test Query - Rail Requirement Manager",
Text = "Select * from Query",
DisplayOnHomeScreen = true,
Name = "RPO - Rail Req",
Owner = user,
ParameterCount = 1,
Published = true
};
var q3 = new Query
{
CreatedDateTime = DateTime.Now,
DbType = EnumDatabase.Oracle,
Description = "Test Query - PIM All sites",
Text = "Select * from site",
DisplayOnHomeScreen = true,
Name = "PIM - sites",
Owner = user,
ParameterCount = 0,
Published = true
};
locator.Save(q1);
locator.Save(q2);
locator.Save(q3);
}
public IEnumerable<Query> GetQueryList(IRepositoryLocator locator)
{
return locator.FetchAll<Query>();
}
private void CountEntities(IRepositoryLocator locator, int count)
{
var users = locator.FetchAll<User>().ToList();
var queries = locator.FetchAll<Query>().ToList();
Assert.AreEqual(count, users.Count);
Assert.AreEqual(count, queries.Count);
}
