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();
}