package com.grenames.services.ircrelay;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class Config {

    Map<String,String> config = new HashMap<String, String>();
    Connection configConnection = null;


    public String get(String name){
        Statement st = null;
        ResultSet rs = null;
        try {
            st = (Statement) configConnection.createStatement();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            rs = st.executeQuery("SELECT value FROM config where name='"+name+"'");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if(rs.getFetchSize() != 0){
                try {
                    rs.next();
                    return rs.getString(1);
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public boolean set(String name, String value){
        return false;
    }

    public Config(){
        try {
            configConnection = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/GrenamesBot","root","toor");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}