public static void main(String[] args) {
        connectDataBase();
        //createTables();
        //insertData();

        try {
            if (connection.createStatement() == null) {
                connection = DriverManager.getConnection(
                        "jdbc:postgresql://127.0.0.1:5432/postgres",
                        "postgres",
                        "potato");
            }

            if ((stmt = connection.createStatement()) == null) {
                System.out.println("Erro nao foi possível criar uma statement ou retornou null");
                System.exit(-1);
            }
            if ((stmtAux = connection.createStatement()) == null) {
                System.out.println("Erro nao foi possível criar uma statement ou retornou null");
                System.exit(-1);
            }
            //MENU
            try {
                login_register();

                while (true) {
                    System.out.println("\n1- Search song");
                    System.out.println("2- Details of an album");
                    System.out.println("3- Details of an artist");
                    System.out.println("4- Write a review");
                    System.out.println("5- Manage song files");
                    System.out.println("6- Playlists");
                    if (isEditor(utilizadorUsername)) {
                        System.out.println("7- Manage information");
                        System.out.println("8- Make an user a new editor");
                    }
                    System.out.println("0- Logout");
                    System.out.print("> ");
                    Scanner sc = new Scanner(System.in);
                    String num = sc.next();
                    switch (num) {
                        case "1":
                            System.out.println("\n1- Trough artist");
                            System.out.println("2- Trough album");
                            System.out.println("3- By song name");
                            System.out.println("4- By genre");
                            System.out.println("5- By data");
                            System.out.print("6- By score\n>");
                            String aux1 = sc.next();
                            switch (aux1) {
                                case "1":
                                    System.out.print("\nType artist's name:\n> ");
                                    String artist13 = reader.readLine();
                                    searchSongByArtist(artist13);
                                    continue;

                                case "2":
                                    searchSongByAlbum();
                                    continue;

                                case "3":
                                    System.out.print("\nType song's name:\n> ");
                                    String song13 = reader.readLine();
                                    searchSongByName(song13, "");
                                    continue;

                                case "4":
                                    searchSongByGenre();
                                    continue;

                                case "5":
                                    searchSongByDate();
                                    continue;

                                case "6":
                                    searchSongByScore();
                                    continue;

                            }
                        case "2":
                            System.out.print("\nType album's name:\n> ");
                            String album2 = reader.readLine();
                            detailsOfAnAlbum(album2);
                            continue;

                        case "3":
                            detailsArtist();
                            continue;

                        case "4":
                            System.out.println("\n1- Album");
                            System.out.print("2- Song\n>");
                            String aux4 = sc.next();

                            switch (aux4){
                                case "1":
                                    reviewAlbum();
                                    continue;

                                case "2":
                                    reviewSong();
                                    continue;

                                default:
                                    continue;
                            }
                        case "5":
                            System.out.println("\n1- Upload song");
                            System.out.println("\n2- Share song");
                            System.out.print("3- Show my songs\n>");
                            String aux5 = sc.next();

                            switch (aux5){
                                case "1":
                                    uploadSongFile();
                                    continue;

                                case "2":
                                    shareSongFile();
                                    continue;

                                case "3":
                                    printMySongsFiles();
                                    continue;

                                default:
                                    continue;
                            }

                        case "6":
                            System.out.println("\n1- Create playlist");
                            System.out.println("2- Add user to playlist");
                            System.out.println("3- Add song to playlist");
                            System.out.print("4- Print all available playlists\n>");
                            String aux6 = sc.next();
                            switch (aux6) {
                                case "1":
                                    createPlaylist();
                                    continue;

                                case "2":
                                    sharePlaylist();
                                    continue;

                                case "3":
                                    addSongToPlaylist();
                                    continue;

                                case "4":
                                    showPlaylists();
                                    continue;

                                default:
                                    continue;

                            }

                        case "7":
                            if (true) {
                                System.out.println("\n1- Insert");
                                System.out.print("2- Change\n> ");
                                String aux8 = sc.next();
                                switch (aux8) {
                                    case "1":
                                        System.out.println("\n1- Artist");
                                        System.out.println("2- Album");
                                        System.out.print("3- Song\n> ");
                                        String aux81 = sc.next();
                                        switch (aux81) {
                                            case "1":
                                                insertArtist();
                                                continue;

                                            case "2":
                                                insertAlbum();
                                                continue;

                                            case "3":
                                                insertSong(0);
                                                continue;

                                            default:
                                                continue;
                                        }
                                    case "2":
                                        System.out.println("\n1- Artist");
                                        System.out.println("2- Album");
                                        System.out.print("3- Song\n> ");
                                        String aux82 = sc.next();
                                        switch (aux82) {
                                            case "1":
                                                System.out.println("\n1- Artist's name");
                                                System.out.println("2- Artist's description");
                                                System.out.print("3- Artist's working period\n> ");
                                                String aux821 = reader.readLine();

                                                System.out.print("\nType artist's name:\n> ");
                                                String artist821 = reader.readLine();
                                                switch (aux821) {
                                                    case "1":
                                                        System.out.print("\nType artist's new name:\n> ");
                                                        String newartist8211 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "2":
                                                        System.out.print("\nType artist's new description:\n> ");
                                                        String newd8212 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "3":
                                                        System.out.print("\nType artist's new working period:\n> ");
                                                        String newp8213 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    default:
                                                        continue;
                                                }
                                            case "2":
                                                System.out.println("\n1- Album's name");
                                                System.out.println("2- Album's description");
                                                System.out.println("3- Album's genre");
                                                System.out.print("4- Album's date\n> ");
                                                String aux822 = reader.readLine();

                                                System.out.print("\nType artist's name:\n> ");
                                                String artist822 = reader.readLine();
                                                System.out.print("\nType album's name:\n> ");
                                                String album822 = reader.readLine();
                                                switch (aux822) {
                                                    case "1":
                                                        System.out.print("\nType album's new name:\n> ");
                                                        String newalbum8221 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "2":
                                                        System.out.print("\nType album's new description:\n> ");
                                                        String newdesc8222 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "3":
                                                        System.out.print("\nType album's new genre:\n> ");
                                                        String newgenre8223 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "4":
                                                        System.out.print("\nType album's new date:\n> ");
                                                        String newdate8224 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    default:
                                                        continue;
                                                }
                                            case "3":
                                                System.out.println("\n1- Song's name");
                                                System.out.println("2- Song's duration");
                                                System.out.println("3- Songs's composer");
                                                System.out.print("4- Song's lyrics\n> ");
                                                String aux823 = reader.readLine();

                                                System.out.print("\nType artist's name:\n> ");
                                                String artist823 = reader.readLine();
                                                System.out.print("\nType album's name:\n> ");
                                                String album823 = reader.readLine();
                                                System.out.print("\nType song's name:\n> ");
                                                String song823 = reader.readLine();
                                                switch (aux823) {
                                                    case "1":
                                                        System.out.print("\nType song's new name:\n> ");
                                                        String newsong8231 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "2":
                                                        System.out.print("\nType song's new duration:\n> ");
                                                        String newdur8232 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "3":
                                                        System.out.print("\nType song's new composer:\n> ");
                                                        String newcomp8233 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    case "4":
                                                        System.out.print("\nType song's new lyrics:\n> ");
                                                        String newlyrics8234 = reader.readLine();
                                                        //send message
                                                        continue;
                                                    default:
                                                        continue;
                                                }
                                            default:
                                                continue;
                                        }
                                    default:
                                        continue;
                                }
                            } else {
                                continue;
                            }
                        case "8":
                            makeEditor();
                            continue;

                        case "0":
                            System.out.println("Goodbye ❤");
                            System.exit(0);
                        default:
                            continue;
                    }
                }
            }
            catch (IOException e) {
                System.out.println("Input null");
                main(args);
            }
        }
        catch (SQLException e) {
            e.printStackTrace();
        }
    }