package com.RS09HD.model;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapListHandler;

import com.RS09HD.util.XStreamUtil;
import com.RS09HD.util.log.Logger;

/**
 * Represents a object, primarily manages it's examine option.
 */

public class ObjectDefinition {

    // JDBC driver name and database URL
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/rs09hd";

    //  Database credentials
    static final String USER = "server";
    static final String PASS = "Runescape09";

    private static Map<Integer, ObjectDefinition> definitions;

    public static void load() throws SQLException {

        Connection conn = null;
        QueryRunner queryRunner = new QueryRunner();

        //Step 1: Register JDBC driver
        DbUtils.loadDriver(JDBC_DRIVER);

        //Step 2: Open a connection
        System.out.println("Connecting to database...");
        conn = DriverManager.getConnection(DB_URL, USER, PASS);

        try {
            List<Map<String, Object>> definitions
                    = queryRunner.query(conn, "SELECT * FROM object_examines where id = '1276'", new MapListHandler());
            System.out.println(definitions);

        } finally {
            DbUtils.close(conn);
        }







        /*List<ObjectDefinition> defs = (List<ObjectDefinition>) XStreamUtil.getXStream().fromXML(new FileInputStream("data/objectDefinitions.xml"));
        definitions = new HashMap<Integer, ObjectDefinition>();
        for(ObjectDefinition def : defs) {
            definitions.put(def.getId(), def);
        }*/
        //Logger.getInstance().info("Loaded " + definitions.size() + " object examines.");
    }

    public static ObjectDefinition forId(int id) {
        ObjectDefinition d = definitions.get(id);
        if(d == null) {
            d = produceDefinition(id);
        }
        return d;
    }

    private int id;
    private String examine;

    public int getId() {
        return id;
    }

    public String getExamine() {
        return examine;
    }

    public static ObjectDefinition produceDefinition(int id) {
        ObjectDefinition def = new ObjectDefinition();
        def.id = id;
        String idString;
        idString = new String( "Object ID: " + def.id);
        def.examine = idString;
        return def;

    }

}