package jfxapp;

import javafx.beans.property.SimpleObjectProperty;
import javafx.beans.value.ObservableValue;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.*;
import javafx.scene.layout.AnchorPane;
import javafx.scene.layout.GridPane;
import javafx.util.Callback;
import org.jooq.DSLContext;
import org.jooq.Record;
import org.jooq.Result;
import org.jooq.SQLDialect;
import org.jooq.impl.DSL;
import org.jooq.util.GenerationTool;
import org.jooq.util.jaxb.*;

import java.math.BigDecimal;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Date;
import java.util.ResourceBundle;

import static jfxapp.Tables.UDAJE;

public class samexam5 {

    private Connection CONN = null;
    private String host = "jdbc:postgresql://127.0.0.1:5432/fxguidedb";

    @FXML
    private ResourceBundle resources;

    @FXML
    private URL location;

    @FXML
    private TextField u_Cele;

    @FXML
    private TextField u_Datum;

    @FXML
    private TextField u_Maledes;

    @FXML
    private TextField n_Desetinne;

    @FXML
    private Button sr_Button;

    @FXML
    private Button nr_Button;

    @FXML
    private GridPane grid1;

    @FXML
    private TextField n_Datum;

    @FXML
    private AnchorPane contentPane;

    @FXML
    private TextField u_ID;

    @FXML private TableView<?> table1;
    @FXML private TableColumn<?, ?> col1;
    @FXML private TableColumn<?, ?> col2;
    @FXML private TableColumn<?, ?> col3;
    @FXML private TableColumn<?, ?> col4;
    @FXML private TableColumn<?, ?> col5;
    @FXML private TableColumn<?, ?> col6;

    @FXML private TextField u_Desetinne;

    @FXML
    private GridPane grid11;

    @FXML
    private TextField u_Text;

    @FXML
    private Button d_Button;

    @FXML
    private Button e_Button;

    @FXML
    private TextField n_Cele;

    @FXML
    private TextField n_Text;

    @FXML
    private TextField n_Maledes;

    @FXML
    private DatePicker dp_Datum;

    @FXML
    private Button a_Button;

    @FXML
    private Button u_Button;

    @FXML
    private TabPane tabPane;

    @FXML
    private TextField n_ID;

    @FXML void btn_D_Click(ActionEvent event) { code_Gener(); }
    @FXML void btn_A_Click(ActionEvent event) { jooq_Query(); }

    @FXML void btn_U_Click(ActionEvent event) { }

    @FXML
    void btn_E_Click(ActionEvent event) {

    }

    @FXML
    void btn_NR_Click(ActionEvent event) {

    }

    @FXML
    void btn_SR_Click(ActionEvent event) {

    }

    @FXML
    void initialize() {
        
    }

    private void code_Gener() {

        Configuration configuration = new Configuration()
                .withJdbc(new Jdbc()
                        .withDriver("org.postgresql.Driver")
                        .withUrl(host) //"jdbc:postgresql://127.0.0.1:5432/fxguidedb")
                        .withUser("fxguide")
                        .withPassword("fxguide"))
                .withGenerator(new Generator()
                        .withDatabase(new Database()
                                .withName("org.jooq.util.postgres.PostgresDatabase")
                                .withIncludes("udaje.*")
                                .withExcludes("")
                                .withInputSchema("public"))
                        .withTarget(new Target()
                                .withPackageName("jfxapp")
                                .withDirectory("")));

        try {
            GenerationTool.generate(configuration);
        } catch (Exception e) { e.printStackTrace();  } }

    private Connection connDB (final String jmeno, final String heslo) {
        try { Class.forName("org.postgresql.Driver");
        } catch (ClassNotFoundException e) { e.printStackTrace(); }
        try { CONN = DriverManager.getConnection(host, jmeno, heslo); return CONN;
        } catch (SQLException e) { e.getMessage(); return CONN; } }

    private void jooq_Query() {
        DSLContext create = DSL.using(connDB("fxguide", "fxguide"), SQLDialect.POSTGRES);
        Result<Record> result = create
                .select()
                .from(UDAJE)
                .where(UDAJE.ID.lt((short) 10))
                .orderBy(UDAJE.ID)
                .fetch();

        for (Record r : result) {
            Short id = r.getValue(UDAJE.ID);
            Integer cis = r.getValue(UDAJE.CELECIS);
            BigDecimal des = r.getValue(UDAJE.DESCIS);
            BigDecimal mad = r.getValue(UDAJE.MALEDES);
            String str = r.getValue(UDAJE.RETEZEC);
            Date dtm = r.getValue(UDAJE.DATUM);

            System.out.println("ID= " + id.toString() + " Cele= " + cis.toString() + " Desetinne= " + des.toString()
                    + " Male des.= " + mad.toString() + " String: " + str + " Datum= " + dtm); } }

}