This is my database on mysql and I need extract concatenating all the parents and all children. id | name | parent_id | has_children 100017 | Roupas Femininas | 0 | 1 100018 | Meias | 100017 | 1 100419…
Quick note, I know this question has been asked here, but the 'answer' gives an alternative which doesn't involve recursion. I want to get recursion working. Here's some code I wrote to demonstrate the problem: CREATE OR REPLACE PROCEDURE `test`…
I have a script that works recursively and is able to show a sub menu multiple levels deep. The problem is this: at the moment I work with two parts in my CMS. Categories and articles. Articles can be under…
From Bratko's book, Prolog Programming for Artificial Intelligence (4th Edition) We have the following code which doesn't work - anc4(X,Z):- anc4(X,Y), parent(Y,Z). anc4(X,Z):- parent(X,Z). In the book, on page 55, figure 2.15, is shown that parent(Y,Z) is kept calling until…
I have a Category model, where the ForeignKey is to self. class Category(SEO, MetaData): parent = models.ForeignKey('self', blank=True, null=True, verbose_name='parent category', on_delete=models.CASCADE) path = ArrayField(models.IntegerField(), blank=True, null=True) I introduced the path field, to avoid recursion in widget, and do it…
I am learning Prolog under my Artificial Intelligence Lab, from the source Learn Prolog Now!. In the 5th Chapter we come to learn about Accumulators. And as an example, these two code snippets are given. To Find the Length of…
I'm working on a python program from an artificial intelligence project. It's about Depth-First Search. I have one python code which works out fine: def depthFirst(problem,start,path,result,vis): next=problem.getSuccessors(start) if problem.isGoalState(start): result.append(path) print path for I in next: if I[0] not in…
Let's say I have the following data (in pseudo-code for readability): var myVariations = [ { Name = "Color", Values = ["Red", "Yellow", "Green" /*, etc. */] }, { Name = "Size", Values = ["S", "M", "L" /*, etc. */]…