Marin Capranov

Well, the thing is I can go deeper than the second level. Is just me that I need that only. The problem is that I am working on a open source project and I am afraid that would be hard to implement your code.

The project is called Wiki JS.

Regarding the libraries, I can say that it uses Vue-apollo for queries and Lodash library for array and collection handling.

If you look at the parameters of the queries you can see the variable $parent. That one is responsible for finding the parent folders and checks whether there are any sub folder, files or not.

For ex: parent: 1, locale: this.locale will return the files if any that have the parent id as 1, and so it works to any other level. If a folder is as deep as third level and its parent ids would be, for example, 1 -> 2 - 3(our file) than in order to get that file we will have to assign 3 to the parent variable.

I ran into a problem that the parent variable accepts only one value, eventually will return only the items of on parent folder. I try now to see how to return all the files under any parent folder.

Hi!

I've got an array that contains the first level of items. For example:

Folder1 Folder2 Folder3 Page Page

Each one of them got an ID. To get that data I use graphql query:

async loadBrowseData (){    this.$store.commit(`loadingStart`, 'browse-load')  const resp = await this.$apollo.query({    query: gql`      query ($parent: Int!, $locale: String!) {        pages {          tree(parent: $parent, mode: ALL, locale: $locale, includeAncestors: true) {            id            path            title            parent            isFolder            depth            pageId            parent            locale          }        }      }    `,    fetchPolicy: 'cache-first',    variables: {      parent: 0,      locale: 'en'    }  })  this.staticData = _.get(resp, 'data.pages.tree', [])

As you can see it uses Lodash for array manipulation.

Now, I've got the items that belong to a specific folder. It is using another graphql query that gets the files for a particular folder based on the parent ID. Have a look:

async fetchData (item) { const resp = await this.$apollo.query({  query: gql`    query ($parent: Int, $locale: String!) {      pages {        tree(parent: $parent, mode: ALL, locale: $locale) {          id          path          title          isFolder          pageId          parent          locale        }      }    }  `,  fetchPolicy: 'cache-first',  variables: {    parent: 3,    locale: this.locale  } })  this.childData = _.get(resp,'data.pages.tree', [])

As you can see, I've got two queries doing two jobs. 1st is to get the first level of items and the second is returning the items belonging to a particular folder based on the parent ID of the folder.

So eventually, I get something like that:

Folder1 ¬      SubFolder      Page Folder2 ¬       Page Folder3 Page Page

The thing I try to achieve is, I want to make all these structures as a single JS object:

Folder1:{    Subfolder:{},    Page:{} }, Folder2: {       Page:{} }, Folder3:{}, Page:{}, Page:{}

The idea is I have at the moment 2 arrays. One for the first level of items and the second array is the child node containing the files to each parent folder.

How can combine these two arrays so I build the structure shown above?

The main developer of this project had used Lodash for that. Is there a way to accomplish that? Or it can be done with pure Javascript?

Hi,

I got a method that pulls the data from the database. The method has a parameter that it accepts and is important because depending on that it pulls different data from the database. Now I need a way to pull the data in a treeview form and I found that vuetify has it, but I don’t really get how to do that. Its examples show how to use it with already predefined data, but I have a dynamic one.

This is the method. So far I had to use v-list-group and loop through the results but is not as nice looking as the treeview. Also, there is a problem to expand it. If, for example, I got more subgroups. With v-treeview it seems to be all aligned nicely.

async fetchSubSubData (item) {  const resp = await this.$apollo.query({  query: gql`    query ($parent: Int, $locale: String!) {      pages {        tree(parent: $parent, mode: ALL, locale: $locale) {          id          path          title          isFolder          pageId          parent          locale        }      }    }  `,  fetchPolicy: 'cache-first',  variables: {    parent: item.id,    locale: this.locale  } })  //this.loadedCache = _.union(this.loadedCache, [item.id])  this.subSubChildData = _.get(resp, 'data.pages.tree', [])

It is using graphql for pulling data. I want that data to be pulled in for of a treeview. How can I do that?

Yes, you are right I perfectly know that but for some reason, I just neglect it, maybe because I know that I work alone, yet, is true that names of the variables and all the rest make it easier to understand the code for me and for others. I periodically find code online and sometimes I have blood coming out of my eyes seeing it, and still, I do the same mistake =). Thanks for heads up! Cheers!

Oh my God! How I could be that blind. Thank you a lot, it solved the problem. God...

Hi and thank you for advice,

I have tried to do some changes, but all unlucky:

That's the method for creating model:

public DefaultTableModel myTable(){        try {            connection = DriverManager.getConnection(url, user, password);            PreparedStatement ps = connection.prepareStatement("Select `id`,`bugname`,`description` from `buglist`");            resultSet=ps.executeQuery();            String[] columns = {"ID", "Bug_naMe", "Description"};            tableModel1 = new DefaultTableModel(columns,0);            while (resultSet.next()){                int id = resultSet.getInt("id");                String bugName = resultSet.getString("bugname");                String description = resultSet.getString("description");                Object[] data = {id,bugName,description};                tableModel1.addRow(data);                tableModel1.fireTableDataChanged();            }        } catch (SQLException e) {            e.printStackTrace();        }      return  tableModel1;    }

And that's the method that is meant to update the table:

public void updateTable(DefaultTableModel model){        table = new JTable();        table.setModel(model);        scrollForTable = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);        table.setFillsViewportHeight(true);        table.setVisible(true);        table.invalidate();        table.setGridColor(Color.CYAN);        table.repaint();        tablePane = new JPanel();        tablePane.setMinimumSize(new Dimension(600, 450));        tablePane.setLayout(new GridLayout(1, 1));        tablePane.add(scrollForTable);        addComponent(jFrame, tablePane, 0, 0, 2, 2, GridBagConstraints.CENTER, GridBagConstraints.BOTH);    }

Next is the mainframe and the button action listener where I try to call the updating method:

Mainframe:

MyTable myTable = new MyTable();        updateTable(myTable.myTable());

and inside the mainframe I have the button action listener:

uploadButton.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {                try { //                    File file = new File("C:/") ; //                    Desktop desktop = Desktop.getDesktop(); //                    desktop.open(file);                    FileDialog fd = new FileDialog(new JFrame());                    fd.setVisible(true);                    File[] f = fd.getFiles();                    if(f.length > 0){                        System.out.println(fd.getFiles()[0].getAbsolutePath());                        uploadFileTitle.setText(fd.getFiles()[0].getAbsolutePath());                    }                    UploadFileToDB uploadFileToDB = new UploadFileToDB();                    uploadFileToDB.processData(fd.getFiles()[0].getAbsolutePath());                    JOptionPane optionPane = new JOptionPane(new JLabel("Success",JLabel.CENTER));                    JDialog dialog = optionPane.createDialog("");                    dialog.setModal(true);                    dialog.setVisible(true);                    dialog.setLocationRelativeTo(null);                    //System.exit(0);                            MyTable myTable1 = new MyTable();                    updateTable(myTable1.myTable());                                    } catch (Exception e1) {                    e1.printStackTrace();                }            }        });

I find strange it because if I comment out the first call of the update method inside the mainframe, clicking on the button does not do anything, even though it is supposed to add the table and all. Honestly, I try all the way around and can't make update the content. It only does it when I exit and re-enter the program. Is something to do with the Event dispatch thread?

Thank you!

I don't really understand what is the issue of the model. As I said if I exit the program and re-enter it the table is updated. The thing is I want to update it while I am using the program, let's say press a button and refresh the table. Could you explain in more detail what you mean by setting the model? If I am not wrong I already do that and it refreshes the table, well not when I want though. Cheers!

HI there!

I have a code that updates the JTable only after the program is restarted, but how do I refresh the JTable without exiting the program? That must happen when I upload a file containing some data.

MainClass.class

public void updateTable(){        MyTable myTable = new MyTable();        table = myTable.myTable();        scrollForTable = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);        table.setFillsViewportHeight(true);        tablePane = new JPanel();        tablePane.setMinimumSize(new Dimension(600, 450));        tablePane.setLayout(new GridLayout(1, 1));        tablePane.add(scrollForTable);        addComponent(jFrame, tablePane, 0, 0, 2, 2, GridBagConstraints.CENTER, GridBagConstraints.BOTH);    }    public void mainFrame() {        jFrame = new JFrame("MainFrame");        jFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);        jFrame.setLayout(new GridBagLayout());           updateTable();        chatPane = new JPanel();        chatPane.setPreferredSize(new Dimension(250, 375));        chatPane.setLayout(new BorderLayout());        chatPane.setBackground(Color.BLUE);        chatPane.setOpaque(true);        chatTextArea = new JTextArea();        chatTextArea.setPreferredSize(new Dimension(250, 70));        chatTextArea.setLineWrap(true);        chatTextArea.setWrapStyleWord(true);        chatTextArea.setFont(new Font("monospace", Font.CENTER_BASELINE, 12));        chatTextArea.setBackground(Color.decode("#5eba7d"));        chatTextArea.setBorder(BorderFactory.createLineBorder(Color.decode("#489361"), 2, false));        scrollForChat = new JScrollPane(chatTextArea);        scrollForChat.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);        chatPane.add(scrollForChat, BorderLayout.SOUTH);        addComponent(jFrame, chatPane, 2, 0, 1, 2, GridBagConstraints.LINE_END, GridBagConstraints.BOTH);


That's the method that creates a table model:

MyTable.class

public JTable myTable(){        try {            connection = DriverManager.getConnection(url, user, password);            PreparedStatement ps = connection.prepareStatement("Select `id`,`bugname`,`description` from `buglist`");            resultSet=ps.executeQuery();            String[] columns = {"ID", "Bug_naMe", "Description"};            tableModel = new DefaultTableModel(columns,0);            while (resultSet.next()){                int id = resultSet.getInt("id");                String bugName = resultSet.getString("bugname");                String description = resultSet.getString("description");                Object[] data = {id,bugName,description};                tableModel.addRow(data);            }        } catch (SQLException e) {            e.printStackTrace();        }      return  new JTable(tableModel);    }

I want that to happen when I click on the upload file button.

MainClass.class

uploadButton.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {                try { //                    File file = new File("C:/") ; //                    Desktop desktop = Desktop.getDesktop(); //                    desktop.open(file);                    FileDialog fd = new FileDialog(new JFrame());                    fd.setVisible(true);                    File[] f = fd.getFiles();                    if(f.length > 0){                        System.out.println(fd.getFiles()[0].getAbsolutePath());                        uploadFileTitle.setText(fd.getFiles()[0].getAbsolutePath());                    }                    UploadFileToDB uploadFileToDB = new UploadFileToDB();                    uploadFileToDB.processData(fd.getFiles()[0].getAbsolutePath());                    JOptionPane optionPane = new JOptionPane(new JLabel("Success",JLabel.CENTER));                    JDialog dialog = optionPane.createDialog("");                    dialog.setModal(true);                    dialog.setVisible(true);                    dialog.setLocationRelativeTo(null);                    //System.exit(0);                                    } catch (Exception e1) {                    e1.printStackTrace();                }            }        });


I guess there is something to do with the model?

Solved! I found that the error was in the parameters of the List of the geOnlyById method. The method returned int and I was checking if it contained string value.

That's the result:

public List <String> getIdOnly() {        try {            connection = DriverManager.getConnection(url, user, password);            Statement st = connection.createStatement();            resultSet = st.executeQuery("Select * from `buglist`");            while (resultSet.next()) {                list3.add(resultSet.getString("id"));            }        } catch (SQLException e) {            e.printStackTrace();        }        return list3;    }

if you can see the method initially was returning a List<Integer> and now is List<String>.

The condition is performing on string values:

DB_Connection db3 = new DB_Connection();                    String removeID = removeBug.getText();                    if (db3.getIdOnly().contains(removeID)) {

Hope it clears out!

Solved by actually modifying the code a bit.
I used if statements inside the button, instead of a switch.

This how it looks in the end:

goBtn.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {                if (getTYPES() == ADD_BUTTON) {                    String bug_name = addBug.getText();                    jTextArea.setText("@" + bug_name + ", ");                    jTextArea.addKeyListener(new KeyListener() {                        @Override                        public void keyTyped(KeyEvent e) {                            int limit = 250;                            if (jTextArea.getText().length() > limit + 1) {                                e.consume();                                String shortened = jTextArea.getText().substring(0, limit);                                jTextArea.setText(shortened);                            } else if (jTextArea.getText().length() >= limit) {                                e.consume();                            }                        }                        @Override                        public void keyPressed(KeyEvent e) {                            String description = jTextArea.getText();                            int key = e.getKeyCode();                            if (key == KeyEvent.VK_ENTER) {                                if (description.length() > bug_name.length() + 7) {                                    DB_Connection db = new DB_Connection("'" + bug_name + "'", "'" + description + "'");                                    jTextArea.setText("Successfully added to the db1 " + db.toString());                                    addBug.setText("");                                    //JOptionPane.showMessageDialog(jButton, "Success " + db.toString() + " added!");                                } else {                                    JOptionPane.showMessageDialog(goBtn, "Add some description!");                                }                            }                        }                        @Override                        public void keyReleased(KeyEvent e) {                        }                    });                } else if (getTYPES() == REMOVE_BUTTON) {                    DB_Connection db3 = new DB_Connection();                    String removeID = removeBug.getText();                    if (db3.getIdOnly().contains(removeID)) {                        db3.removeFromDb("'" + removeID + "'");                        JOptionPane.showMessageDialog(jTextArea, "Bug removed successfully " + removeID);                    } else {                        JOptionPane.showMessageDialog(jTextArea, "ID does not exist. Try another!");                    }                } else if (getTYPES() == UPDATE_BUTTON) {                                        try {                        String param1 = updateBugID.getText();                        String param2 = updateBugText.getText();                        DB_Connection db4 = new DB_Connection();                        db4.updateDB("'" + param1 + "'", param2);                        updateBugID.setText("");                        updateBugText.setText("");                        JOptionPane.showMessageDialog(jTextArea, "Success: you have update bug with the id " + param2 + " successfully!");                    }catch (Exception ex){                        JOptionPane.showMessageDialog(jTextArea, ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);                    }                }            }        });

Now the Enum is seen when a value is set to it.

Sorry for inconvenience!

Hi guys, again.

I got a problem with the if/else statement. The thing returns always the "else" part. It is checking if the value is in the database or not. Funny thing is it works if I do not put inside an if statement, however when I enclose it it skips the if part and goes always to the else part which returns nothing. I use the logic inside an action performed method. Outside of it it seems to works just fine. Is there a problem with the threads or something?

That's the code:

goBtn.addActionListener(new ActionListener() {                    @Override                    public void actionPerformed(ActionEvent e) {                        DB_Connection db3 = new DB_Connection();                        String removeID = removeBug.getText();                        if (db3.getIdOnly().contains(removeID)) {                            db3.removeFromDb("'" + removeID + "'");                            JOptionPane.showMessageDialog(jTextArea, "Bug removed successfully " + removeID);                        } else {                            JOptionPane.showMessageDialog(jTextArea, "ID does not exist. Try another!");                        }                    }                });

That's an example where the code actually works but is not inside an action listener method:

case "remove": //                    bug_tracker.removeBug(num); //                    bug_tracker.showBugs();                    DB_Connection db1 = new DB_Connection();                    System.out.println("Remove the bug from the tracker. Enter the id: ");                    System.out.println("Id starts with: " + db1.getIdOnly().get(0) + " and ends with " + db1.getLastInTheList());                    int num = scanner.nextInt();                    if (db1.getIdOnly().contains(num)){                        db1.removeFromDb("'" + num + "'");                        System.out.println(db1);                        System.out.println("Id " + num + " removed!");                    }else{                        System.out.println("The id does not exist. Try another!");                    }                    break;

The method inside the if condition:

Another class:

public List <Integer> getIdOnly() {        try {            connection = DriverManager.getConnection(url, user, password);            Statement st = connection.createStatement();            resultSet = st.executeQuery("Select * from `buglist`");            while (resultSet.next()) {                list2.add(resultSet.getInt("id"));            }        } catch (SQLException e) {            e.printStackTrace();        }        return list2;    }

Why would the if statement work that strange? It always returns "ID does not exist! Try another" part even if without the if/ else condition it works just fine.

Working code:

db3.removeFromDb("'" + removeID + "'");                            JOptionPane.showMessageDialog(jTextArea, "Bug removed successfully " + removeID);

Hi guys,

I got a problem with the action listener method. The thing is I got an Enum class and it contains three possible states of the buttons: Add, remove, and update. I want to use this for a switch. The Enum is set inside an action performed method, but it, in the end, I get a null exception. I tried setters and getters but nothing works. Have a look a the code and let me know. Perhaps the flow is wrong...

MyClass.class

The field with the type of the Enum class:

public GoButtonOptions TYPES;

One of the action listener methods:

removeBtn.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {                setTYPES(REMOVE_BUTTON);                addBug.setVisible(false);                updatesFieldsPane.setVisible(false);                updateBugID.setVisible(false);                updateBugText.setVisible(false);                removeBug.setVisible(true);                removeBug.setText("Remove bug. Enter the bug ID...");                controllerPane.add(removeBug, addParametersOfSize(0, 1, 2, 1, GridBagConstraints.CENTER,                        GridBagConstraints.BOTH));            }        });

The setters and getters for the filed:

  public GoButtonOptions getTYPES() {        return TYPES;    }    public void setTYPES(GoButtonOptions TYPES) {        this.TYPES = TYPES;    }

And of course, the switch that I try to apply and always returns a null exception:

switch (getTYPES()) {            case ADD_BUTTON:                goBtn.addActionListener(new ActionListener() {                    @Override                    public void actionPerformed(ActionEvent e) {                        String bug_name = addBug.getText();                        jTextArea.setText("@" + bug_name + ", ");                        jTextArea.addKeyListener(new KeyListener() {                            @Override                            public void keyTyped(KeyEvent e) {                                int limit = 250;                                if (jTextArea.getText().length() > limit + 1) {                                    e.consume();                                    String shortened = jTextArea.getText().substring(0, limit);                                    jTextArea.setText(shortened);                                } else if (jTextArea.getText().length() >= limit) {                                    e.consume();                                }                            }                            @Override                            public void keyPressed(KeyEvent e) {                                String description = jTextArea.getText();                                int key = e.getKeyCode();                                if (key == KeyEvent.VK_ENTER) {                                    if (description.length() > bug_name.length() + 7) {                                        DB_Connection db = new DB_Connection("'" + bug_name + "'", "'" + description + "'");                                        jTextArea.setText("Successfully added to the db1 " + db.toString());                                        addBug.setText("");                                        //JOptionPane.showMessageDialog(jButton, "Success " + db.toString() + " added!");                                    } else {                                        JOptionPane.showMessageDialog(goBtn, "Add some description!");                                    }                                }                            }                            @Override                            public void keyReleased(KeyEvent e) {                            }                        });                    }                });                break;            case REMOVE_BUTTON:                goBtn.addActionListener(new ActionListener() {                    @Override                    public void actionPerformed(ActionEvent e) {                        DB_Connection db3 = new DB_Connection();                        String removeID = removeBug.getText();                        if (db3.getIdOnly().contains(removeID)) {                            db3.removeFromDb("'" + removeID + "'");                            JOptionPane.showMessageDialog(jTextArea, "Bug removed successfully " + removeID);                        } else {                            JOptionPane.showMessageDialog(jTextArea, "ID does not exist. Try another!");                        }                    }                });                break;            case UPDATE_BUTTON:                goBtn.addActionListener(new ActionListener() {                    @Override                    public void actionPerformed(ActionEvent e) {                        String param1 = updateBugID.getText();                        String param2 = updateBugText.getText();                        DB_Connection db4 = new DB_Connection();                        db4.updateDB("'" + param1 + "'", "'" + param2 + "'");                        System.out.println(param1 + " " + param2);                        JOptionPane.showMessageDialog(jTextArea, "Success: you have update bug with the id " + param2 + " successfully!");                    }                });            default:                break;        }

Hope you guys can see what is wrong. Peace out!

Hi Piet,

Sorry for the long delay in my answer. I been busy implementing the code to my needs and I am pretty sure I made it. If you think the GA algorithm always is returning the shortest route. The one thing I don't fully understand is what is the population fitness and how does it actually influence the result. I noticed that the better result the higher is the population fitness. How come?

Many thank to you for your support, you helped a lot!
Cheers!

Yeah, I had run it on a different project and it is just fine. It returns a value from A ... A. It would be great to have it in java 7. I will try to implement it anyway, maybe I can substitute all the new words with some old ones. Let's see =)

Hey Piet,

Thank you for your quick reply. I had a look into the program and noticed the java8+ stuff. The thing is I have an Android project and its support not bigger than java 7, plus I don't know much of a java 8 and above. Could be there an alternative for streams and vars? I tried to add some streams in my project but they simply don't work because I have a minimum SDK 21 and is meant to be 24. =(