Esempio n. 1
0
        public void should_execute_multi_mapping_one_to_many_relation_select_statement()
        {
            var inMemoryDatabase = new InMemoryDatabase();

            inMemoryDatabase.Insert <Product>(new List <Product>
            {
                new Product("987", "123")
            });

            inMemoryDatabase.Insert <ProductModel>(new List <ProductModel>
            {
                new ProductModel("987", "123")
            });

            var mockRepo   = new MockRepository(MockBehavior.Default);
            var loggerMock = mockRepo.Create <ILogger>();

            loggerMock.Setup(a => a.WriteLine(It.IsAny <string>()))
            .Callback <string>(msg => Assert.IsTrue(
                                   msg.Contains("SELECT * FROM ProductModel PM INNER JOIN Product P ON PM.ProductModelID = P.ProductModelID") ||
                                   msg.Contains("Retrieved 1 ProductModel entities") ||
                                   msg.Contains("The first Product Model with name  has 1 products")
                                   ));

            var multiMappingOneToManyRelationSelectStatement = new MultiMappingOneToManyRelationSelectStatement();

            multiMappingOneToManyRelationSelectStatement.Execute(inMemoryDatabase.OpenConnection(), loggerMock.Object);
        }
Esempio n. 2
0
        public void should_execute_simple_select_with_dynamic_entities_statement()
        {
            var inMemoryDatabase = new InMemoryDatabase();

            inMemoryDatabase.Insert <Person>(new List <Person>
            {
                new Person()
            });

            var mockRepo   = new MockRepository(MockBehavior.Default);
            var loggerMock = mockRepo.Create <ILogger>();

            loggerMock.Setup(a => a.WriteLine(It.IsAny <string>()))
            .Callback <string>(msg => Assert.IsTrue(msg.Contains("SELECT FirstName,MiddleName,LastName FROM Person")));

            var simpleSelectStatementWithDynamicEntities = new SimpleSelectStatementWithDynamicEntities();

            simpleSelectStatementWithDynamicEntities.Execute(inMemoryDatabase.OpenConnection(), loggerMock.Object);
        }
Esempio n. 3
0
        public void should_execute_parameterized_select_statement()
        {
            var inMemoryDatabase = new InMemoryDatabase();

            inMemoryDatabase.Insert <Product>(new List <Product>
            {
                new Product()
            });

            var mockRepo   = new MockRepository(MockBehavior.Default);
            var loggerMock = mockRepo.Create <ILogger>();

            loggerMock.Setup(a => a.WriteLine(It.IsAny <string>()))
            .Callback <string>(msg => Assert.IsTrue(msg.Contains("SELECT * FROM Product where ProductId = @Id")));

            var parameterizedSelectStatement = new ParameterizedSelectStatement();

            parameterizedSelectStatement.Execute(inMemoryDatabase.OpenConnection(), loggerMock.Object);
        }
Esempio n. 4
0
        public void should_execute_simple_select_statement()
        {
            var inMemoryDatabase = new InMemoryDatabase();

            inMemoryDatabase.Insert <Person>(new List <Person>
            {
                new Person()
            });

            var mockRepo   = new MockRepository(MockBehavior.Default);
            var loggerMock = mockRepo.Create <ILogger>();

            loggerMock.Setup(a => a.WriteLine(It.IsAny <string>()))
            .Callback <string>(msg => Assert.IsTrue(msg.Contains("SELECT * FROM PERSON")));

            var simpleSelectStatement = new SimpleSelectStatement();

            simpleSelectStatement.Execute(inMemoryDatabase.OpenConnection(), loggerMock.Object);
        }
Esempio n. 5
0
        public void should_execute_multiple_queries_statement()
        {
            var inMemoryDatabase = new InMemoryDatabase();

            inMemoryDatabase.Insert <Product>(new List <Product>
            {
                new Product()
                {
                    ProductID = "707"
                }
            });

            inMemoryDatabase.Insert <ProductCostHistory>(new List <ProductCostHistory>
            {
                new ProductCostHistory()
            });

            inMemoryDatabase.Insert <ProductInventory>(new List <ProductInventory>
            {
                new ProductInventory()
            });

            var mockRepo   = new MockRepository(MockBehavior.Default);
            var loggerMock = mockRepo.Create <ILogger>();

            loggerMock.Setup(a => a.WriteLine(It.IsAny <string>()))
            .Callback <string>(msg => Assert.IsTrue(
                                   msg.Contains(@"SELECT * from Product where ProductId = @Id;") ||
                                   msg.Contains(@"Retrived one product with id 707") ||
                                   msg.Contains(@"Retrieved 0 history for that Product") ||
                                   msg.Contains(@"Retrieved 0 inventory for that Product")
                                   ));

            var multipleQueries = new MultipleQueries();

            multipleQueries.Execute(inMemoryDatabase.OpenConnection(), loggerMock.Object);
        }