public void PostgreSql_ToSingleOrDefault_Works() { IDatabaseConnection connection = GetConnection(); var repo = new PostgreSqlIntegrationRepository(GetConnection()); repo.ToSingleOrDefault(); }
public void PostgreSql_SprocWithParameter_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); Assert.AreEqual(143, repo.SprocWithParameter(143)); }
public void PostgreSql_ManyQueries_DoesntFail() { IDatabaseConnection connection = GetConnection(); var repo = new PostgreSqlIntegrationRepository(GetConnection()); for (int ii = 0; ii < 100; ii++) { repo.ExecuteAdHocQuery("SELECT 1"); } }
public void PostgreSql_SprocWithSchema_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); Assert.AreEqual(123, repo.SprocWithSchema()); }
public void PostgreSql_ToScalar_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); Assert.AreEqual(142, repo.ToScalar()); }
public void PostgreSql_ManyQueries_DoesntFail() { IDatabaseConnection connection = GetConnection(); var repo = new PostgreSqlIntegrationRepository(GetConnection()); for (int ii = 0; ii < 100; ii++) { repo.ExecuteAdHocQuery("SELECT 1"); } }
public void PostgreSql_RollbackTransaction_DoesntHaveSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Rollback(); } Assert.AreEqual(0, repo.GetCountOfSideEffects()); }
public void PostgreSql_CommitTransaction_HasSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Commit(); } Assert.AreEqual(1, repo.GetCountOfSideEffects()); }
public void PostgreSql_RollbackTransaction_DoesntHaveSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Rollback(); } Assert.AreEqual(0, repo.GetCountOfSideEffects()); }
public void PostgreSql_CommitTransaction_HasSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Commit(); } Assert.AreEqual(1, repo.GetCountOfSideEffects()); }
public void PostgreSql_ToScalar_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new PostgreSqlIntegrationRepository(GetConnection()); Assert.AreEqual(142, repo.ToScalar()); }
public void PostgreSql_ToSingleOrDefault_Works() { IDatabaseConnection connection = GetConnection(); var repo = new PostgreSqlIntegrationRepository(GetConnection()); repo.ToSingleOrDefault(); }