package test;

import java.io.File;
import java.sql.*;
import org.junit.*;
import static org.junit.Assert.*;

/** These tests check whether access to files is woring correctly and
 *  some Connection.close() cases. */
public class ConnectionTest
{
    @BeforeClass public static void forName() throws Exception {
        Class.forName("org.sqlite.JDBC");
    }

    @Test public void openMemory() throws SQLException {
        Connection conn = DriverManager.getConnection("jdbc:sqlite:");
        conn.close();
    }

    @Test public void isClosed() throws SQLException {
        Connection conn = DriverManager.getConnection("jdbc:sqlite:");
        assertFalse(conn.isReadOnly());
        conn.close();
        assertTrue(conn.isClosed());
    }

    @Test public void openFile() throws SQLException {
        File testdb = new File("test.db");
        if (testdb.exists()) testdb.delete();

        assertFalse(testdb.exists());
        Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
        assertFalse(conn.isReadOnly());
        conn.close();

        assertTrue(testdb.exists());
        conn = DriverManager.getConnection("jdbc:sqlite:test.db");
        assertFalse(conn.isReadOnly());
        conn.close();

        assertTrue(testdb.exists());
        testdb.delete();
    }

    @Test(expected= SQLException.class)
    public void closeTest() throws SQLException {
        Connection conn = DriverManager.getConnection("jdbc:sqlite:");
        PreparedStatement prep = conn.prepareStatement("select null;");
        ResultSet rs = prep.executeQuery();
        conn.close();
        prep.clearParameters();
    }
}