Package com.mockrunner.mock.jdbc

Examples of com.mockrunner.mock.jdbc.MockConnection

69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
        batchQuery.setUsingOptimisticLocking(true);
        batchQuery.add(qualifierSnapshot);

        DeleteBatchQueryBuilder batchQueryBuilder = new DeleteBatchQueryBuilder(adapter);

        MockConnection mockConnection = new MockConnection();
        PreparedStatementResultSetHandler preparedStatementResultSetHandler = mockConnection
                .getPreparedStatementResultSetHandler();
        preparedStatementResultSetHandler.setExactMatch(false);
        preparedStatementResultSetHandler.setCaseSensitive(false);
        preparedStatementResultSetHandler.prepareUpdateCount("DELETE", 1);

        boolean generatesKeys = false;

        BatchAction action = new BatchAction(batchQuery, adapter, resolver);
        action.runAsIndividualQueries(
                mockConnection,
                batchQueryBuilder,
                new MockOperationObserver(),
                generatesKeys);
        assertEquals(0, mockConnection.getNumberCommits());
        assertEquals(0, mockConnection.getNumberRollbacks());
    }
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
        batchQuery.setUsingOptimisticLocking(true);
        batchQuery.add(qualifierSnapshot);

        DeleteBatchQueryBuilder batchQueryBuilder = new DeleteBatchQueryBuilder(adapter);

        MockConnection mockConnection = new MockConnection();
        PreparedStatementResultSetHandler preparedStatementResultSetHandler = mockConnection
                .getPreparedStatementResultSetHandler();
        preparedStatementResultSetHandler.setExactMatch(false);
        preparedStatementResultSetHandler.setCaseSensitive(false);
        preparedStatementResultSetHandler.prepareUpdateCount("DELETE", 0);

        boolean generatesKeys = false;
        BatchAction action = new BatchAction(batchQuery, adapter, resolver);
        try {
            action.runAsIndividualQueries(
                    mockConnection,
                    batchQueryBuilder,
                    new MockOperationObserver(),
                    generatesKeys);
            fail("No OptimisticLockingFailureException thrown.");
        }
        catch (OptimisticLockException e) {
        }
        assertEquals(0, mockConnection.getNumberCommits());
        assertEquals(0, mockConnection.getNumberRollbacks());
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
            public DbAdapter createAdapter(DatabaseMetaData md) throws SQLException {
                return adapter;
            }
        });

        MockConnection connection = new MockConnection();

        MockDataSource dataSource = new MockDataSource();
        dataSource.setupConnection(connection);

        Module testModule = new Module() {
View Full Code Here
48
49
50
51
52
53
54
55
56
57
    public void testGetAdapter() {
        MockDbAdapter realAdapter = new MockDbAdapter();
        MockDbAdapterFactory factory = new MockDbAdapterFactory(realAdapter);

        MockDataSource dataSource = new MockDataSource();
        dataSource.setupConnection(new MockConnection());
        AutoAdapter adapter = new AutoAdapter(factory, dataSource);

        assertSame(realAdapter, adapter.getAdapter());
    }
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
193
194
      // txManager still uses original connection
      assertCommit();
      assertSingleConnection();

      // SqlSessionTemplate uses its own connection
      MockConnection mockConnection = (MockConnection) mockDataSource.getConnection();
      assertEquals("should call commit on Connection", 1, mockConnection.getNumberCommits());
      assertEquals("should not call rollback on Connection", 0, mockConnection.getNumberRollbacks());
      assertCommitSession();
    } finally {

      sqlSessionFactory.getConfiguration().setEnvironment(original);
    }
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
221
222
      assertCommit();
      assertSingleConnection();

      // SqlSession uses its own connection
      // that connection will not have commited since no SQL was executed by the session
      MockConnection mockConnection = (MockConnection) mockDataSource.getConnection();
      assertEquals("should call commit on Connection", 0, mockConnection.getNumberCommits());
      assertEquals("should not call rollback on Connection", 0, mockConnection.getNumberRollbacks());
      assertCommitSession();
    } finally {
      SqlSessionUtils.closeSqlSession(session, sqlSessionFactory);

      sqlSessionFactory.getConfiguration().setEnvironment(original);
View Full Code Here
324
325
326
327
328
329
330
331
332
333
334
335
336
      // assume a real JTA tx would enlist and commit the JDBC connection
      assertNoCommitJdbc();
      assertCommitSession();

      MockConnection mockConnection = (MockConnection) mockDataSource.getConnection();
      assertEquals("should call commit on Connection", 0, mockConnection.getNumberCommits());
      assertEquals("should not call rollback on Connection", 0, mockConnection.getNumberRollbacks());

      assertEquals("should not call DataSource.getConnection()", 0, dataSource.getConnectionCount());

    } finally {
      SqlSessionUtils.closeSqlSession(session, sqlSessionFactory);
View Full Code Here
129
130
131
132
133
134
135
136
137
138
  protected MockConnection createMockConnection() {
    // this query must be the same as the query in TestMapper.xml
    MockResultSet rs = new MockResultSet("SELECT 1");
    rs.addRow(new Object[] { 1 });

    MockConnection con = new MockConnection();
    con.getPreparedStatementResultSetHandler().prepareResultSet("SELECT 1", rs);

    return con;
  }
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
    @Test
    public void scriptRunnerShouldBatchSimpleCommands() throws Exception
    {
        ScriptRunner runner = new ScriptRunner(DatabaseType.UNKNOWN);
        Reader reader = new InputStreamReader(getClass().getResourceAsStream("simple.sql"));
        MockConnection connection = new MockConnection();

        runner.execute(connection, reader);

        List statements = connection.getStatementResultSetHandler().getExecutedStatements();

        assertThat(statements.size(), is(2));
        assertThat(statements.get(0).toString(),
                is(equalToIgnoringWhiteSpace("create table users ( username varchar not null, password varchar not null )")));
        assertThat(statements.get(1).toString(),
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
    @Test
    public void scriptRunnerShouldHandleComplexCommands() throws Exception
    {
        ScriptRunner runner = new ScriptRunner(DatabaseType.MYSQL);
        Reader reader = new InputStreamReader(getClass().getResourceAsStream("complex.sql"));
        MockConnection connection = new MockConnection();

        runner.execute(connection, reader);

        List statements = connection.getStatementResultSetHandler().getExecutedStatements();

        String expectedSql = "update dav_file set parent = ( select id from ( select id from dav_file where name = '__SITE_PROTECTED__' ) as x )" +
                " where ( name = 'templates' and parent is null )" +
                " or ( name = 'velocity' and parent is null )" +
                " or ( name = 'tags' and parent is null )" +
View Full Code Here
TOP

Related Classes of com.mockrunner.mock.jdbc.MockConnection

  • com.carbonfive.db.jdbc.ScriptRunnerTest
  • org.apache.cayenne.access.jdbc.BatchActionLockingTest
  • org.apache.cayenne.access.jdbc.JDBCResultIteratorTest
  • org.apache.cayenne.configuration.server.DefaultDbAdapterFactoryTest
  • org.apache.cayenne.dba.AutoAdapterTest
  • org.mybatis.spring.AbstractMyBatisSpringTest
  • org.mybatis.spring.mapper.MapperFactoryBeanTest
  • org.mybatis.spring.MyBatisSpringTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.