FiberConnectionTest.java

/*
 * COMSAT
 * Copyright (C) 2014, Parallel Universe Software Co. All rights reserved.
 *
 * This program and the accompanying materials are dual-licensed under
 * either the terms of the Eclipse Public License v1.0 as published by
 * the Eclipse Foundation
 *
 *   or (per the licensee's choosing)
 *
 * under the terms of the GNU Lesser General Public License version 3.0
 * as published by the Free Software Foundation.
 */
package co.paralleluniverse.fibers.jdbc;

import co.paralleluniverse.embedded.db.H2JdbcDatasource;
import co.paralleluniverse.fibers.Fiber;
import co.paralleluniverse.fibers.SuspendExecution;
import co.paralleluniverse.strands.SuspendableRunnable;
import com.google.common.util.concurrent.MoreExecutors;
import com.google.common.util.concurrent.ThreadFactoryBuilder;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.Collection;
import java.util.concurrent.Executors;
import javax.sql.DataSource;
import org.junit.After;
import static org.junit.Assert.*;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.junit.runners.Parameterized;

@RunWith(Parameterized.class)
public class FiberConnectionTest {

    @Parameterized.Parameters(name = "{0}")
    public static Collection<Object[]> data() {
        return Arrays.asList(new Object[][]{
            {H2JdbcDatasource.class},});
    }
    private final Class<? extends DataSource> cls;
    private Connection conn;

    public FiberConnectionTest(Class<? extends DataSource> cls) {
        this.cls = cls;
    }

    @Before
    public void setUp() throws Exception {
        final Connection connection = cls.newInstance().getConnection();
        this.conn = new FiberConnection(connection,
                MoreExecutors.listeningDecorator(Executors.newFixedThreadPool(10, new ThreadFactoryBuilder().setNameFormat("jdbc-worker-%d").setDaemon(true).build())));
    }

    @After
    public void tearDown() throws Exception {
        conn.close();
    }

    @Test
    public void testCreateStatement() throws IOException, InterruptedException, Exception {
        new Fiber<Void>(new SuspendableRunnable() {
            @Override
            public void run() throws SuspendExecution, InterruptedException {
                try {
                    conn.createStatement().close();
                } catch (SQLException ex) {
                    fail(ex.getMessage());
                }
            }
        }).start().join();
    }

    @Test
    public void testPrepareStatement() throws IOException, InterruptedException, Exception {
        new Fiber<Void>(new SuspendableRunnable() {
            @Override
            public void run() throws SuspendExecution, InterruptedException {
                try {
                    conn.prepareStatement("create table tablename");
                } catch (SQLException ex) {
                    fail(ex.getMessage());
                }
            }
        }).start().join();
    }

    @Test
    public void testPrepareCall() throws IOException, InterruptedException, Exception {
        new Fiber<Void>(new SuspendableRunnable() {
            @Override
            public void run() throws SuspendExecution, InterruptedException {
                try {
                    conn.prepareCall("create table tablename");
                } catch (SQLException ex) {
                    fail(ex.getMessage());
                }
            }
        }).start().join();
    }

    @Test
    public void testCommit() throws IOException, InterruptedException, Exception {
        new Fiber<Void>(new SuspendableRunnable() {
            @Override
            public void run() throws SuspendExecution, InterruptedException {
                try {
                    conn.createStatement().execute("drop table if exists testCommit");
                    conn.createStatement().execute("create table testCommit (id int primary key, name varchar(100))");
                    // snippet connection usage
                    conn.setAutoCommit(false);
                    conn.createStatement().execute("insert into testCommit (id, name) values (1, 'name')");
                    conn.commit();
                    boolean notEmpty = conn.createStatement().executeQuery("select * from testCommit").next();
                    // end of snippet
                    assertTrue(notEmpty);
                    conn.createStatement().execute("drop table testCommit");
                } catch (SQLException ex) {
                    fail(ex.getMessage());
                }
            }
        }).start().join();
    }

    @Test
    public void testRollback() throws IOException, InterruptedException, Exception {
        new Fiber<Void>(new SuspendableRunnable() {
            @Override
            public void run() throws SuspendExecution, InterruptedException {
                try {
                    conn.setAutoCommit(false);
                    conn.createStatement().execute("drop table if exists testRollback");
                    conn.createStatement().execute("create table testRollback (id int primary key, name varchar(100))");
                    conn.createStatement().execute("insert into testRollback (id, name) values (1, 'name')");
                    conn.rollback();
                    assertFalse(conn.createStatement().executeQuery("select * from testRollback").next());
                    conn.createStatement().execute("drop table testRollback");
                } catch (SQLException ex) {
                    fail(ex.getMessage());
                }
            }
        }).start().join();
    }
}