Re^2: Advise on sql table mapping.

Ok, so I don't follow the output of:

print Dumper find_joins( apple => 'dog' );

[] apple => dog at tmp.pl line 31.
[apple] bug => dog at tmp.pl line 31.
[apple] cat => dog at tmp.pl line 31.
$VAR1 = [
          'apple',
          'dog'
        ];
$VAR2 = [
          'apple',
          'bug',
          'dog'
        ];
[download]

After all this is over, all that will really have mattered is how we treated each other.

Comment on Re^2: Advise on sql table mapping. Download Code

Replies are listed 'Best First'.
Re^3: Advise on sql table mapping. by Corion (Patriarch) on May 18, 2008 at 07:49 UTC
This is the data structure that is returned from `find_joins`. The first line seems to be pasted from the source code. The next three lines beginning with `[...]` are debugging output of `find_joins` as it progresses its work. See line 31 for that. It outputs the current path, the current start and the current goal. The last lines are the output of Data::Dumper which displays the data structure returned. Maybe you can tell me in more detail where you have problems. If it is with complex data structures, maybe perldsc or Quick References Reference help you.	[reply] [d/l] [select]
Re^4: Advise on sql table mapping. by dbmathis (Scribe) on May 18, 2008 at 13:41 UTC
Corion, your code is nice. After looking at it for awhile it makes sense and it gives me something to start with. I should be able to easily write the the code to output the SQL. I will let you know if I run into problems. Thank you very much for all of the great reading material! After all this is over, all that will really have mattered is how we treated each other.	[reply]
Re^4: Advise on sql table mapping. by Anonymous Monk on May 18, 2008 at 12:49 UTC
Complex data structures are not a new concept to me although I must admit I have really only worked with no greater than 2 dimensions. I have been working with SQL (Oracle, MSQSL and MYSQL) for years which is different. It appears that in perl 3+ dimensions is something I need to familiarize myself with. I will read up on the links you provided.	[reply]