[Moose-dev] Re: Petit SQL Parser

On Tue, Aug 31, 2010 at 7:36 AM, Tudor Girba <tudor.girba(a)gmail.com> wrote: It is useful when you want to understand a database and possibly it's relationship with code. For example, an SQL query in the string of some Java code that refers to a certain table creates a logical dependency. If we can relate the two worlds, we can build larger analyses. Does it make better sense now? Yes. I think that yes :) I was thinking more from a database driver point of view, not from visualization. Sorry, I forgot this was moose hahhaha Doru On 31 Aug 2010, at 07:16, Mariano Martinez Peck wrote: Sorry for my completely ignorance, but what can be the use of parsing SQL? Suppose from the point of view of a database driver that receives queries, or from a ORM point of view....does it make sense for something? Thanks Mariano On Tue, Aug 31, 2010 at 12:59 AM, Tudor Girba <tudor.girba(a)gmail.com> wrote: That is cool news. I will take a look in the following days. Cheers, Doru On 30 Aug 2010, at 16:00, Fabrizio Perin wrote: Hi all, i did implement an SQL parser using Petit Parser. I toke the grammar specification from SQLite http://www.sqlite.org/lang.html . The grammar implemented is not complete, for now i did implement "just" the create table statement, it means that you should be able to parse at least a script for create the database. The code is in squeaksource http://www.squeaksource.com/@09zbthA-fDDfyUNQ/_OIex3aA . To download it you can evaluate this: Gofer new squeaksource: 'PetitSQLParser'; package: 'ConfigurationOfPetitSQLParser'; load. (Smalltalk at: #ConfigurationOfPetitSQLParser) perform: #loadDefault in the repository there are several packages: the core contains the parser for the grammar. In the package parser there is a parser that instantiate some draft objects representing relational elements. In the next future i will start to implement also other statements. If you start to use it and you have some problem please let me know. Cheers, Fabrizio _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev -- www.tudorgirba.com "No matter how many recipes we know, we still value a chef." _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev -- www.tudorgirba.com "What is more important: To be happy, or to make happy?" _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev _______________________________________________ Moose-dev mailing list Moose-dev(a)iam.unibe.ch https://www.iam.unibe.ch/mailman/listinfo/moose-dev