DataDumpV140.java

package edu.ualberta.med.biobank.tools.upgradetest;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DataDumpV140 extends DataDump {

    public DataDumpV140(Connection dbconnection, Properties queryProps,
        String filename) throws IOException {
        super(dbconnection, queryProps, filename);
    }

    public void getAliquotedSpecimens() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getAliquotedSpecimens"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2))
                .append(",").append(rs.getString(3)).append(",")
                .append(rs.getString(4)).append(",").append(rs.getString(5))
                .append(",").append(rs.getDate(6)).append(",")
                .append(rs.getDouble(7)).append(",").append(rs.getString(8));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getSourceSpecimens() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getSourceSpecimens"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2))
                .append(",").append(rs.getString(3)).append(",")
                .append(getDateFromStr(rs.getString(4))).append(",")
                .append(getDateFromStr(rs.getString(5))).append(",")
                .append(rs.getString(6));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getSpecimenStorageSite() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getSpecimenStorageSite"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getSiteStudies() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getSiteStudies"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getStudyContacts() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getStudyContacts"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2))
                .append(",").append(rs.getString(3));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getSiteContainers() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getSiteContainers"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getClinicShipments() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getClinicShipments"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getInt(2))
                .append(",").append(rs.getString(3)).append(",")
                .append(getDateFromStr(rs.getString(4))).append(",")
                .append(getDateFromStr(rs.getString(5))).append(",")
                .append(rs.getString(6)).append(",").append(rs.getString(7));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getDispatchSpecimens() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getDispatchSpecimens"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2))
                .append(",").append(rs.getString(3))
                .append(getDateFromStr(rs.getString(4))).append(",")
                .append(getDateFromStr(rs.getString(5)))
                .append(rs.getString(6));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

    public void getCollectionEvents() throws SQLException, IOException {
        PreparedStatement ps = dbconnection.prepareStatement(queryProps
            .getProperty("v140.getCollectionEvents"));

        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            StringBuilder row = new StringBuilder();
            row.append(rs.getString(1)).append(",").append(rs.getString(2))
                .append(",").append(getDateFromStr(rs.getString(3)))
                .append(",").append(rs.getInt(4));
            bw.write(row.toString());
            bw.newLine();
        }
        bw.newLine();
        bw.flush();
    }

}