public TimeEntryIntegrationTest() { Environment.SetEnvironmentVariable("MYSQL__CLIENT__CONNECTIONSTRING", DbTestSupport.TestDbConnectionString); DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); _testClient = IntegrationTestServer.Start().CreateClient(); }
public TimeEntryIntegrationTest() { Environment.SetEnvironmentVariable("VCAP_SERVICES", DbTestSupport.TestDbVcapJson); DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); _testClient = IntegrationTestServer.Start().CreateClient(); }
public ManagementIntegrationTest() { Environment.SetEnvironmentVariable("MYSQL__CLIENT__CONNECTIONSTRING", DbTestSupport.TestDbConnectionString); Environment.SetEnvironmentVariable("MANAGEMENT__ENDPOINTS__PATH", "/cloudfoundryapplication"); DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); _testClient = IntegrationTestServer.Start().CreateClient(); }
public MySqlTimeEntryRepositoryTest() { DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); var builder = new DbContextOptionsBuilder <TimeEntryContext>() .UseMySql(DbTestSupport.TestDbConnectionString); _repository = new MySqlTimeEntryRepository(new TimeEntryContext(builder.Options)); }
private static void CreateInDb(TimeEntry timeEntry) { var sql = $@"INSERT INTO time_entries(id, project_id, user_id, date, hours) VALUES('{timeEntry.Id}', '{timeEntry.ProjectId}', '{timeEntry.UserId}', '{timeEntry.Date:yyyy-MM-dd}', '{timeEntry.Hours}')"; DbTestSupport.ExecuteSql(sql); }
public MySqlTimeEntryRepositoryTest() { Environment.SetEnvironmentVariable("MYSQL__CLIENT__CONNECTIONSTRING", DbTestSupport.TestDbConnectionString); DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); var builder = new DbContextOptionsBuilder <TimeEntryContext>() .UseMySql(DbTestSupport.TestDbConnectionString); _repository = new MySqlTimeEntryRepository(new TimeEntryContext(builder.Options)); }
private static IList <IDictionary <string, object> > FindAllInDb() => DbTestSupport.ExecuteSql( "SELECT id, project_id, user_id, date, hours FROM time_entries" );
private static IList <IDictionary <string, object> > FindInDb(long id) => DbTestSupport.ExecuteSql( $@"SELECT id, project_id, user_id, date, hours FROM time_entries WHERE id = {id}" );
private async void Init() { Environment.SetEnvironmentVariable("MYSQL__CLIENT__CONNECTIONSTRING", DbTestSupport.TestDbConnectionString); DbTestSupport.ExecuteSql("TRUNCATE TABLE time_entries"); _testClient = await IntegrationTestServer.GetHttpClient(); }