| Subject: | MySQL parser |
Config :
- perl, v5.8.3 built for i386-linux-thread-multi
- Linux pcvideo 2.6.2-1-k7 #1 Sat Feb 7 17:02:15 EST 2004 i686 GNU/Linux
- Debian unstable
Note : I do not know much about perl or sql.
I do not know Parse::RecDescent.
I managed to solve the problems I had, I just report them to you.
I hope it helps.
Thank you for this great software.
1) /usr/bin/sqlt-graph:107
I had to add '$show_sizes' in the my declaration. For
the script to run. I do not know if it is correct.
2) /usr/local/share/perl/5.8.3/SQL/Translator/Parser/MySQL.pm:475,481,484
I wanted to parse things like FOREIGN KEY a (b) REFERENCES c (d),
wich is accepted by the mysql server.
I added 'index_name(?)' at the end of each line.
Now it is like :
foreign_key_def_begin : /constraint/i /foreign key/i index_name(?)
{ $return = '' }
|
/constraint/i WORD /foreign key/i index_name(?)
{ $return = $item[2] }
|
/foreign key/i index_name(?)
{ $return = '' }