public void AllCreatesASelectAllQueryExecutesAndReturnsResults() { var mockSqlDialect = new Mock<ISqlDialect>(); mockSqlDialect.Setup(x => x.SqlCharacters).Returns(SqlCharacters.Empty); var mockReader = new Mock<IDataReader>(); mockReader.Setup(x => x.Read()).Returns(new Queue<bool>(new[] { true, false }).Dequeue); mockReader.As<IDisposable>().Setup(x => x.Dispose()); var mockCommand = new Mock<IDbCommand>(); mockCommand.Setup(x => x.ExecuteReader(It.IsAny<CommandBehavior>())).Returns(mockReader.Object); var mockConnection = new Mock<IDbConnection>(); mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object); var mockDbDriver = new Mock<IDbDriver>(); mockDbDriver.Setup(x => x.CreateConnection()).Returns(new MockDbConnectionWrapper(mockConnection.Object)); var session = new AsyncReadOnlySession( ConnectionScope.PerTransaction, mockSqlDialect.Object, mockDbDriver.Object); var customers = session.Include.All<Customer>(); session.ExecutePendingQueriesAsync().Wait(); Assert.Equal(1, customers.Values.Count); mockReader.VerifyAll(); mockCommand.VerifyAll(); mockConnection.VerifyAll(); mockSqlDialect.VerifyAll(); }
public void IncludeScalarSqlQueryExecutesAndReturnsResult() { var sqlQuery = new SqlQuery(""); var mockReader = new Mock <IDataReader>(); mockReader.Setup(x => x.FieldCount).Returns(1); mockReader.Setup(x => x[0]).Returns(10); mockReader.Setup(x => x.Read()).Returns(new Queue <bool>(new[] { true, false }).Dequeue); mockReader.As <IDisposable>().Setup(x => x.Dispose()); var mockCommand = new Mock <IDbCommand>(); mockCommand.Setup(x => x.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(mockReader.Object); mockCommand.As <IDisposable>().Setup(x => x.Dispose()); var mockConnection = new Mock <IDbConnection>(); var mockSqlDialect = new Mock <ISqlDialect>(); var mockDbDriver = new Mock <IDbDriver>(); mockDbDriver.Setup(x => x.CreateConnection()).Returns(new MockDbConnectionWrapper(mockConnection.Object)); mockDbDriver.Setup(x => x.BuildCommand(sqlQuery)).Returns(new MockDbCommandWrapper(mockCommand.Object)); var session = new AsyncReadOnlySession( ConnectionScope.PerTransaction, mockSqlDialect.Object, mockDbDriver.Object); var includeScalar = session.Include.Scalar <int>(sqlQuery); session.ExecutePendingQueriesAsync().Wait(); Assert.Equal(10, includeScalar.Value); mockReader.VerifyAll(); mockCommand.VerifyAll(); mockConnection.VerifyAll(); mockSqlDialect.VerifyAll(); }
public void AllCreatesASelectAllQueryExecutesAndReturnsResults() { var mockReader = new Mock <IDataReader>(); mockReader.Setup(x => x.Read()).Returns(new Queue <bool>(new[] { true, false }).Dequeue); mockReader.As <IDisposable>().Setup(x => x.Dispose()); var mockCommand = new Mock <IDbCommand>(); mockCommand.Setup(x => x.ExecuteReader(It.IsAny <CommandBehavior>())).Returns(mockReader.Object); mockCommand.As <IDisposable>().Setup(x => x.Dispose()); var mockConnection = new Mock <IDbConnection>(); var mockSqlDialect = new Mock <ISqlDialect>(); mockSqlDialect.Setup(x => x.SqlCharacters).Returns(SqlCharacters.Empty); var mockDbDriver = new Mock <IDbDriver>(); mockDbDriver.Setup(x => x.CreateConnection()).Returns(new MockDbConnectionWrapper(mockConnection.Object)); mockDbDriver.Setup(x => x.BuildCommand(SqlBuilder.Select("*").From(typeof(Customer)).ToSqlQuery())).Returns(new MockDbCommandWrapper(mockCommand.Object)); var session = new AsyncReadOnlySession( ConnectionScope.PerTransaction, mockSqlDialect.Object, mockDbDriver.Object); var customers = session.Include.All <Customer>(); session.ExecutePendingQueriesAsync().Wait(); Assert.Equal(1, customers.Values.Count); mockReader.VerifyAll(); mockCommand.VerifyAll(); mockConnection.VerifyAll(); mockSqlDialect.VerifyAll(); }
public void MicroLiteExceptionsCaughtByExecutePendingQueriesShouldNotBeWrappedInAnotherMicroLiteException() { var mockSqlDialect = new Mock <ISqlDialect>(); var mockDbDriver = new Mock <IDbDriver>(); mockDbDriver.Setup(x => x.BuildCommand(It.IsNotNull <SqlQuery>())).Throws <MicroLiteException>(); var session = new AsyncReadOnlySession( ConnectionScope.PerTransaction, mockSqlDialect.Object, mockDbDriver.Object); // We need at least 1 queued query otherwise we will get an exception when doing queries.Dequeue() instead. session.Include.Scalar <int>(new SqlQuery("")); var exception = Assert.Throws <AggregateException>( () => session.ExecutePendingQueriesAsync().Wait()); Assert.IsType <MicroLiteException>(exception.InnerException); Assert.IsNotType <MicroLiteException>(exception.InnerException.InnerException); }
public void MicroLiteExceptionsCaughtByExecutePendingQueriesShouldNotBeWrappedInAnotherMicroLiteException() { var mockSqlDialect = new Mock<ISqlDialect>(); var mockDbDriver = new Mock<IDbDriver>(); mockDbDriver.Setup(x => x.BuildCommand(It.IsNotNull<IDbCommand>(), It.IsNotNull<SqlQuery>())).Throws<MicroLiteException>(); var session = new AsyncReadOnlySession( ConnectionScope.PerTransaction, mockSqlDialect.Object, mockDbDriver.Object); // We need at least 1 queued query otherwise we will get an exception when doing queries.Dequeue() instead. session.Include.Scalar<int>(new SqlQuery("")); var exception = Assert.Throws<AggregateException>( () => session.ExecutePendingQueriesAsync().Wait()); Assert.IsType<MicroLiteException>(exception.InnerException); Assert.IsNotType<MicroLiteException>(exception.InnerException.InnerException); }
public void IncludeScalarSqlQueryExecutesAndReturnsResult() { var mockSqlDialect = new Mock<ISqlDialect>(); var mockReader = new Mock<IDataReader>(); mockReader.Setup(x => x.FieldCount).Returns(1); mockReader.Setup(x => x[0]).Returns(10); mockReader.Setup(x => x.Read()).Returns(new Queue<bool>(new[] { true, false }).Dequeue); mockReader.As<IDisposable>().Setup(x => x.Dispose()); var mockCommand = new Mock<IDbCommand>(); mockCommand.Setup(x => x.ExecuteReader(It.IsAny<CommandBehavior>())).Returns(mockReader.Object); var mockConnection = new Mock<IDbConnection>(); mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object); var mockDbDriver = new Mock<IDbDriver>(); mockDbDriver.Setup(x => x.CreateConnection()).Returns(new MockDbConnectionWrapper(mockConnection.Object)); var session = new AsyncReadOnlySession( ConnectionScope.PerTransaction, mockSqlDialect.Object, mockDbDriver.Object); var includeScalar = session.Include.Scalar<int>(new SqlQuery("")); session.ExecutePendingQueriesAsync().Wait(); Assert.Equal(10, includeScalar.Value); mockReader.VerifyAll(); mockCommand.VerifyAll(); mockConnection.VerifyAll(); mockSqlDialect.VerifyAll(); }