package TestScript;
//javac -classpath external.jar com.mycompay/myClass.java
//javac -classpath /Desktop/OSbotetc thisClass.java
//jar cf myJar.jar myClass.class

import org.osbot.rs07.api.ui.Skill;
import org.osbot.rs07.api.Skills;
import org.osbot.rs07.script.Script;
import org.osbot.rs07.script.ScriptManifest;


import org.sqlite.JDBC;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.PreparedStatement;


@ScriptManifest(author = "Dontbuzz", name = "Dontbuzz Karamja Lobster", version = 1.0, logo = "", info = "Fishes for Lobster on Karamja, banking at Port Sarrim deposit box")

public class TestScript extends Script {

    public void onStart() {
        log("Starting to Collect");

        this.getSkillLevel();
    }

    public void onExit() {

    }

    public final int onLoop() throws InterruptedException {
        return 0;
    }

    public void getSkillLevel() {
        log(System.getProperty("user.dir"));
        String connString = "jdbc:sqlite:/home/john/Desktop/RSDB/rsdb.sqlite";
        try {
            try {
                Class.forName("org.sqlite.JDBC");
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            Connection conn = null;
            conn = DriverManager.getConnection(connString);
            log("connection made");
            PreparedStatement stmt = conn.prepareStatement("insert into playertable VALUES (\"testuser\", \"[email protected]\", \"testpass\", \"1111\"");
            log(stmt.execute());
        } catch (Exception e) {
            log(e);
        }
    }

    public void runPythonScript() {
        String[] cmd = {
                "python3",
                "/home/john/Desktop/RSDB/UI_Form_Tabs_Main.py"
        };

        try {
            Runtime.getRuntime().exec(cmd);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}