package uver;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;


public class Uver {

    public static void main(String[] args) {
        String url = "jdbc:postgresql://bdd.inf.udec.cl:5432/isw1a";
        String usuario = "isw1a";
        String contraseña = "matiasmora18";
        try{
            Class.forName("org.postgresql.Driver");
            Connection conexion = DriverManager.getConnection(url,usuario,contraseña);
            java.sql.Statement st = conexion.createStatement();

            /////Pruebas/////
            String sql= addNewUser(12121212, "Robert", 1996, 3, 16, 98767698, "Callese Viejo Lesbiano", "arbochanpion@cc.ru", "1234567", true, false, false, false);
            st.execute(sql);
            ////Fin////

           /* String sql = "SELECT * FROM uver.login WHERE username = 'dantzig' and pass = 1234";
            ResultSet result = st.executeQuery(sql);
            while(result.next()){
                String id = result.getString("username");
                String pas= result.getString("pass");
                System.out.println("id: " + id + "   pass: " + pas);
            }
            result.close();*/

            st.close();
            conexion.close();
        } catch(Exception e){
            System.out.println("ERROR DE CONEXION" + e.getMessage());
        }

    }



        ////Métodos////


    public static String addNewUser(int rut, String name, int bornyear, int bornmonth, int bornday, int phone, String description, String mail, String password, boolean smoke, boolean pet, boolean talk, boolean music){
    String addNewUser = "INSERT INTO uver.person (rut, fullname, born, phone, description, mail, password, smoke, pet, talk, music) VALUES (" +rut+ ", '" +name+ "', '"  +bornyear+ "-" +bornmonth+ "-" +bornday+ "', " +phone+ ", '" +description+ "', '" +mail+ "', '" +password+ "', " +smoke+ ", " +pet+ ", " +talk+ ", " +music+ ")";
    return addNewUser;
    }


}