TheDbConnectorTest.java

/*
 * YAQP - Yet Another QSAR Project:
 * Machine Learning algorithms designed for the prediction of toxicological
 * features of chemical compounds become available on the Web. Yaqp is developed
 * under OpenTox (http://opentox.org) which is an FP7-funded EU research project.
 * This project was developed at the Automatic Control Lab in the Chemical Engineering
 * School of National Technical University of Athens. Please read README for more
 * information.
 *
 * Copyright (C) 2009-2010 Pantelis Sopasakis & Charalampos Chomenides
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Contact:
 * Pantelis Sopasakis
 * chvng@mail.ntua.gr
 * Address: Iroon Politechniou St. 9, Zografou, Athens Greece
 * tel. +30 210 7723236
 */
package org.opentox.db.util;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import org.opentox.db.table.StandardTables;
import static org.junit.Assert.*;

/**
 *
 * @author chung
 */
public class TheDbConnectorTest {

    public TheDbConnectorTest() {
    }

    @BeforeClass
    public static void setUpClass() throws Exception {        
//        assertTrue(TheDbConnector.DB.isInitialized());
//        TheDbConnector.init();
//        assertTrue(TheDbConnector.DB.isInitialized());

    }

    @AfterClass
    public static void tearDownClass() throws Exception {
    }

    @Before
    public void setUp() {
    }

    @After
    public void tearDown() {
    }

    /**
     * Test of getLock method, of class DbConnector.
     */
    @Test
    public void InstantiationTest() throws Exception {
        System.out.println("-- instantiation test --");
        TheDbConnector.init();
        
    }

    //@Test
    public void Prepared_Deletion() throws SQLException {

        PreparedStatement ds = TheDbConnector.DB.getConnection().prepareStatement(
                StandardTables.ALGORITHM_ONTOL_RELATION.getTable().getDeletionSQL());
        ds.executeUpdate();
    }

    //@Test
    public void preparedSelection() throws SQLException {
        PreparedStatement ps = TheDbConnector.DB.getConnection().prepareStatement("SELECT * FROM USERS WHERE LASTNAME LIKE ?");
        ps.setString(1, "%sak%");
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            System.out.println(rs.getString("USERNAME") + ", " + rs.getString("PASS"));
        }
    }
}