package database.test;

import java.util.List;

import org.zielware.pages.LoginPage;

import database.model.User;
import database.api.DBApi;

public class JdbcTest {

    public static void main(String[] args) {
        DBApi databaseApi = new DBApi();

        List<User> users;

        databaseApi.insertUser("admin", "admin", "admin", 1);
        databaseApi.insertUser("conti", "conti", "conti", 0);
        databaseApi.insertUser("kamik", "kamik", "kamik", 0);
        databaseApi.insertUser("bronek", "bronek", "bronek", 0);
        databaseApi.insertUser("duda", "duda", "duda", 0);
        databaseApi.insertUser("puda", "puda", "puda", 0);
        users = databaseApi.selectUsers();
        System.out.println("Lista userów: ");
        for(User u: users)
            System.out.println(u);

        //Teraz wywalamy conti
        System.out.println("Chce wywalic conti! ");
        String loginDoWywalenia = "conti";
        users = databaseApi.deletetUser(loginDoWywalenia);

        ///clear db
        /*
        boolean result = databaseApi.deleteAllUsers();
        if(result){
            System.out.println("Dziala");
        }
        */

        users = databaseApi.selectUsers();


        System.out.println("Lista userów 2: ");
        for(User u: users)
            System.out.println(u);

        //databaseApi.deleteTable();
        databaseApi.closeConnection();

    }
}