Examples of org.sql2o.Connection

org.sql2o.Connection
Represents a connection to the database with a transaction.

    @Test public void testForConnectionStateAfterBatchException() throws SQLException {
        sql2o.createQuery("create table issue3table(id integer identity primary key, val varchar(5))").executeUpdate();
        
        boolean failed = false;


        Connection connection = sql2o.beginTransaction();


        try{
            connection.createQuery("insert into issue3table(val) values(:val)")
                .addParameter("val", "abcde").addToBatch()
                .addParameter("val", "abcdefg").addToBatch() // should fail
                .addParameter("val", "hello").addToBatch()
                .executeBatch().commit();
        }
        catch(Sql2oException ex){
            failed = true;
            System.out.println("expected exception occured, msg: " + ex.getMessage());
        }


        assertTrue(failed);


        assertTrue("Assert that connection is correctly closed (with transaction)", connection.getJdbcConnection().isClosed() );
        
        // same test, but not in a transaction
        Query query = sql2o.createQuery("insert into issue3table(val) values(:val)")
            .addParameter("val", "abcde").addToBatch()
            .addParameter("val", "abcdefg").addToBatch() // should fail

View Full Code Here


    @Test
    public void testIssue10_StatementsOnPostgres_withTransaction() {




        Connection connection = null;


        try{
            connection = sql2o.beginTransaction();


            String createTableSql = "create table test_table(id SERIAL, val varchar(20))";
            connection.createQuery(createTableSql).executeUpdate();


            String insertSql = "insert into test_table (val) values(:val)";
            Long key = (Long)connection.createQuery(insertSql, true).addParameter("val", "something").executeUpdate().getKey(Long.class);
            assertNotNull(key);
            assertTrue(key > 0);


            String selectSql = "select id, val from test_table";
            Table resultTable = connection.createQuery(selectSql).executeAndFetchTable();


            assertThat(resultTable.rows().size(), is(1));
            Row resultRow = resultTable.rows().get(0);
            assertThat(resultRow.getLong("id"), equalTo(key));
            assertThat(resultRow.getString("val"), is("something"));


        } finally {


            // always rollback, as this is only for tesing purposes.
            if (connection != null) {
                connection.rollback();
            }
        }




    }

View Full Code Here


    }


    @Test
    public void testGetKeyOnSequence(){
        Connection connection = null;


        try {
            connection = sql2o.beginTransaction();


            String createSequenceSql = "create sequence testseq";
            connection.createQuery(createSequenceSql).executeUpdate();


            String createTableSql = "create table test_seq_table (id integer primary key, val varchar(20))";
            connection.createQuery(createTableSql).executeUpdate();


            String insertSql = "insert into test_seq_table(id, val) values (nextval('testseq'), 'something')";
            Long key = connection.createQuery(insertSql, true).executeUpdate().getKey(Long.class);


            assertThat(key, equalTo(1L));


            key = connection.createQuery(insertSql, true).executeUpdate().getKey(Long.class);
            assertThat(key, equalTo(2L));
        } finally {
            if (connection != null) {
                connection.rollback();
            }
        }
    }

View Full Code Here

        }
    }


    @Test
    public void testKeyKeyOnSerial() {
        Connection connection = null;


        try {
            connection = sql2o.beginTransaction();


            String createTableSql = "create table test_serial_table (id serial primary key, val varchar(20))";
            connection.createQuery(createTableSql).executeUpdate();


            String insertSql = "insert into test_serial_table(val) values ('something')";
            Long key = connection.createQuery(insertSql, true).executeUpdate().getKey(Long.class);


            assertThat(key, equalTo(1L));


            key = connection.createQuery(insertSql, true).executeUpdate().getKey(Long.class);
            assertThat(key, equalTo(2L));
        } finally {
            if (connection != null) {
                connection.rollback();
            }
        }
    }

View Full Code Here

    }


    @Test
    public void testUUID() {


        Connection connection = null;


        try {
            connection = sql2o.beginTransaction();


            String createSql = "create table uuidtable(id serial primary key, data uuid)";
            connection.createQuery(createSql).executeUpdate();


            UUID uuid = UUID.randomUUID();


            String insertSql = "insert into uuidtable(data) values (:data)";
            connection.createQuery(insertSql).addParameter("data", uuid).executeUpdate();


            String selectSql = "select data from uuidtable";


            UUID fetchedUuid = connection.createQuery(selectSql).executeScalar(UUID.class);


            assertThat(fetchedUuid, is(equalTo(uuid)));
        } finally {
            if (connection != null) {
                connection.rollback();
            }
        }


    }

View Full Code Here

TOP

Related Classes of org.sql2o.Connection

org.sql2o.extensions.postgres.PostgresTest

org.sql2o.issues.IssuesTest

org.sql2o.quirks.Quirks

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.