private PostgreSQLTransactionalExecutor GetPostgreSQLTransactionalExecutor()
{
var npgsqlConnection = new NpgsqlConnection(PostgreSQLConnectionFactory.GetConnectionString(GetConnectionSettings(GetTestDBName())));
var transactionalExecutor = new PostgreSQLTransactionalExecutor(npgsqlConnection);
return(transactionalExecutor);
}
public LogOnUnitOfWork(PostgreSQLTransactionalExecutor transactionalExecutor,
IUserRepository userRepository,
IUserLoginLogRepository userLoginLogRepository)
{
_transactionalExecutor = transactionalExecutor;
_userRepository = userRepository;
_userLoginLogRepository = userLoginLogRepository;
}
private async Task <PostgreSQLTransactionalExecutor> GetPostgreSQLTransactionalExecutor()
{
var connectionSettings = await GetConnectionSettings(GetTestDBName());
var npgsqlConnection =
new NpgsqlConnection(PostgreSQLConnectionFactory.GetConnectionString(connectionSettings));
var transactionalExecutor = new PostgreSQLTransactionalExecutor(npgsqlConnection);
return(await Task.FromResult(transactionalExecutor));
}
public ProjectUnitOfWork(PostgreSQLTransactionalExecutor transactionalExecutor,
IOrganizationRepository organizationRepository,
IProjectRepository projectRepository,
ILabelRepository labelRepository,
ILabelTranslationRepository labelTranslationRepository)
{
_transactionalExecutor = transactionalExecutor;
_organizationRepository = organizationRepository;
_projectRepository = projectRepository;
_labelRepository = labelRepository;
_labelTranslationRepository = labelTranslationRepository;
}
public SignUpUnitOfWork(PostgreSQLTransactionalExecutor transactionalExecutor,
IOrganizationRepository organizationRepository,
IUserRepository userRepository,
IUserLoginLogRepository userLoginLogRepository,
IIntegrationRepository integrationRepository,
IIntegrationClientRepository integrationClientRepository,
IProjectRepository projectRepository,
ILabelRepository labelRepository,
ILabelTranslationRepository labelTranslationRepository)
{
_transactionalExecutor = transactionalExecutor;
_organizationRepository = organizationRepository;
_userRepository = userRepository;
_userLoginLogRepository = userLoginLogRepository;
_integrationRepository = integrationRepository;
_integrationClientRepository = integrationClientRepository;
_projectRepository = projectRepository;
_labelRepository = labelRepository;
_labelTranslationRepository = labelTranslationRepository;
}
static void Main()
{
var dbGenerator = new DbGenerator();
var(typeLookup, entityUtils, connectionSettings, sqlExecutor) = dbGenerator.Generate();
Console.WriteLine("Db Generated!");
var organizationRepository = new OrganizationRepository(typeLookup, new PostgreSQLConstants <Organization>(entityUtils),
entityUtils, new PostgreSQLExpressionUtils(), sqlExecutor, new List <string>());
var projectRepository = new ProjectRepository(typeLookup, new PostgreSQLConstants <Project>(entityUtils),
entityUtils, new PostgreSQLExpressionUtils(), sqlExecutor, new List <string>());
#region initial example
var organization = new Organization
{
Name = "test",
Email = "*****@*****.**"
};
var orgId = organizationRepository.Insert(1, organization).Result;
Console.WriteLine("Organization inserted, " + orgId);
var project = new Project
{
Name = "test",
Description = "test description",
Cost = 1,
IsActive = false
};
var projectId = projectRepository.Insert(1, project).Result;
Console.WriteLine("Project inserted, " + projectId);
project.Name = "other test";
projectRepository.Update(1, project).Wait();
project.Name = "more other test";
projectRepository.Update(1, project).Wait();
var updatedProject = projectRepository.Select(x => x.Id == projectId).Result;
Console.WriteLine("Project name updated to " + updatedProject.Name);
Console.WriteLine("Project revisions;");
var projectRevisions = projectRepository.SelectRevisions(projectId).Result;
for (var i = 0; i < projectRevisions.Count; i++)
{
var projectRevision = projectRevisions[i];
Console.WriteLine(projectRevision.Revision + " - " + projectRevision.Entity.Name);
}
try
{
var transactionalExecutor = new PostgreSQLTransactionalExecutor(new NpgsqlConnection(PostgreSQLConnectionFactory.GetConnectionString(connectionSettings)));
var result = transactionalExecutor.ExecuteAsync <bool>(async cnn =>
{
organizationRepository.SetSqlExecutorForTransaction(cnn);
projectRepository.SetSqlExecutorForTransaction(cnn);
var orgIdOther = organizationRepository.Insert(1, organization).Result;
project.OrganizationId = orgIdOther;
project.OrganizationUid = organization.Uid;
project.OrganizationName = organization.Name;
var projectIdOther = await projectRepository.Insert(1, project);
return(true);
}).Result;
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.WriteLine("project count " + projectRepository.Count().Result);
Console.WriteLine("organization count " + organizationRepository.Count().Result);
#endregion
#region order by example
for (var i = 0; i < 10; i++)
{
var organizationForOrderBy = new Organization
{
Name = "test " + i + 1,
Email = "*****@*****.**" + (i - 10),
Description = "order by test"
};
organizationRepository.Insert(1, organizationForOrderBy).Wait();
}
var orderedItems = organizationRepository.SelectAll(x => x.Description == "order by test", false,
new List <OrderByInfo <Organization> > {
new OrderByInfo <Organization>(y => y.Email, false)
}).Result;
Console.WriteLine("email desc ordered, first item > " + orderedItems.First().Email);
orderedItems = organizationRepository.SelectAll(x => x.Description == "order by test", false,
new List <OrderByInfo <Organization> > {
new OrderByInfo <Organization>(y => y.Name),
new OrderByInfo <Organization>(y => y.Id, false),
}).Result;
Console.WriteLine("name asc ordered, first item > " + orderedItems.First().Name + " - " + orderedItems.First().Id);
#endregion
Console.Read();
}
static void Main()
{
var dbGenerator = new DbGenerator();
var(typeLookup, entityUtils, connectionSettings, sqlExecutor) = dbGenerator.Generate();
Console.WriteLine("Db Generated!");
var organizationRepository = new OrganizationRepository(typeLookup, new PostgreSQLConstants <Organization>(entityUtils),
entityUtils, new PostgreSQLExpressionUtils(), sqlExecutor, new List <string>());
var organization = new Organization
{
Name = "test",
Email = "*****@*****.**"
};
var orgId = organizationRepository.Insert(1, organization).Result;
Console.WriteLine("Organization inserted, " + orgId);
var projectRepository = new ProjectRepository(typeLookup, new PostgreSQLConstants <Project>(entityUtils),
entityUtils, new PostgreSQLExpressionUtils(), sqlExecutor, new List <string>());
var project = new Project
{
Name = "test",
Description = "test description",
Cost = 1,
IsActive = false
};
var projectId = projectRepository.Insert(1, project).Result;
project.Id = projectId;
Console.WriteLine("Project inserted, " + projectId);
project.Name = "other test";
projectRepository.Update(1, project).Wait();
project.Name = "more other test";
projectRepository.Update(1, project).Wait();
var updatedProject = projectRepository.Select(x => x.Id == projectId).Result;
Console.WriteLine("Project name updated to " + updatedProject.Name);
Console.WriteLine("Project revisions;");
var projectRevisions = projectRepository.SelectRevisions(projectId).Result;
for (var i = 0; i < projectRevisions.Count; i++)
{
var projectRevision = projectRevisions[i];
Console.WriteLine(projectRevision.Revision + " - " + projectRevision.Entity.Name);
}
try
{
var transactionalExecutor = new PostgreSQLTransactionalExecutor(new NpgsqlConnection(PostgreSQLConnectionFactory.GetConnectionString(connectionSettings)));
var result = transactionalExecutor.ExecuteAsync <bool>(async cnn =>
{
organizationRepository.SetSqlExecutorForTransaction(cnn);
projectRepository.SetSqlExecutorForTransaction(cnn);
var orgIdOther = organizationRepository.Insert(1, organization).Result;
project.OrganizationId = orgIdOther;
project.OrganizationUid = organization.Uid;
project.OrganizationName = organization.Name;
var projectIdOther = projectRepository.Insert(1, project).Result;
return(true);
}).Result;
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.WriteLine("project count " + projectRepository.Count().Result);
Console.WriteLine("organization count " + organizationRepository.Count().Result);
}
