<br><br><div class="gmail_quote">On Wed, May 11, 2011 at 4:06 PM, Fabrizio Perin <span dir="ltr"><<a href="mailto:perin@iam.unibe.ch">perin@iam.unibe.ch</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div style="word-wrap:break-word">Hi Mariano,<div>well i did improve the parser itself adding also the alter table statement and the select statement. I did also modify the architecture: now the parser generate AST nodes instead the old "draft objects" abstraction. Anyway, as far as i remember, no one attempt to implement any visualization on that. Do you have something in your mind?</div>
<div><br></div></div></blockquote><div><br>Maybe. We don't know yet. We will analyze if having a (or part of) SQL parser will help us in something or not.<br>This is related to this: <a href="http://forum.world.st/Call-for-ideas-for-DBXTalk-UI-td3513189.html">http://forum.world.st/Call-for-ideas-for-DBXTalk-UI-td3513189.html</a><br>
<br>So...I will have in mind your answer.<br><br>Thanks<br><br>Mariano<br><br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;">
<div></div><div>Cheers,</div><div>Fabrizio</div><div><br><div><div class="im"><div>On 11 May 2011, at 01:01, Mariano Martinez Peck wrote:</div><br></div><blockquote type="cite"><div class="im">Hi Fabrizio. Any progress on this front ?<br>
did someone do any kind of visualization once the parser was done?<br><br>thanks<br><br>mariano<br><br></div><div class="gmail_quote"><div class="im">On Wed, Sep 1, 2010 at 3:46 PM, Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com" target="_blank">marianopeck@gmail.com</a>></span> wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br><br><div class="gmail_quote"><div><div class="im">On Wed, Sep 1, 2010 at 3:39 PM, Fabrizio Perin <span dir="ltr"><<a href="mailto:perin@iam.unibe.ch" target="_blank">perin@iam.unibe.ch</a>></span> wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div style="word-wrap:break-word"><div class="im">Hi Marian,<div>here there is an example:</div></div><div><span><Example.png></span></div><div><div></div><div class="h5"><div><br></div><div>the one on the top is a class instead the one on the bottom is the database table that the class access.</div>
<div><br></div><div>This is a small example about what you can do by having information about the code and the database in the same model.</div></div></div></div></blockquote></div><div><div></div><div class="h5"><div><br>
Thanks Fabrizio. I got it.<br><br>I think it would be cool to visualize the problem while maping inheritance chain and tables, and the different solutions: one table for each subclass, one big table with NULLable fields and a type field, etc.....<br>
<br> <br><br> </div><div><div></div><div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div style="word-wrap:break-word"><div><br></div>
<div>Cheers,</div><div>
<br></div><font color="#888888"><div>Fabrizio</div></font><div><div></div><div><div><br><div><div>On 1 Sep 2010, at 14:18, Mariano Martinez Peck wrote:</div><br><blockquote type="cite"><br><br><div class="gmail_quote">
On Tue, Aug 31, 2010 at 7:36 AM, Tudor Girba <span dir="ltr"><<a href="mailto:tudor.girba@gmail.com" target="_blank">tudor.girba@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
It is useful when you want to understand a database and possibly it's relationship with code.<br>
<br>
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.<br>
<br>
Does it make better sense now?<br>
<br></blockquote><div><br>Yes. I think that yes :)<br><br>I was thinking more from a database driver point of view, not from visualization. Sorry, I forgot this was moose hahhaha<br><br> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
Doru<div><div></div><div><br>
<br>
<br>
On 31 Aug 2010, at 07:16, Mariano Martinez Peck wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
Sorry for my completely ignorance, but what can be the use of parsing SQL?<br>
<br>
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?<br>
<br>
Thanks<br>
<br>
Mariano<br>
<br>
On Tue, Aug 31, 2010 at 12:59 AM, Tudor Girba <<a href="mailto:tudor.girba@gmail.com" target="_blank">tudor.girba@gmail.com</a>> wrote:<br>
That is cool news. I will take a look in the following days.<br>
<br>
Cheers,<br>
Doru<br>
<br>
<br>
<br>
On 30 Aug 2010, at 16:00, Fabrizio Perin wrote:<br>
<br>
Hi all,<br>
i did implement an SQL parser using Petit Parser. I toke the grammar specification from SQLite <a href="http://www.sqlite.org/lang.html" target="_blank">http://www.sqlite.org/lang.html</a> . 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.<br>
<br>
The code is in squeaksource <a href="http://www.squeaksource.com/@09zbthA-fDDfyUNQ/_OIex3aA" target="_blank">http://www.squeaksource.com/@09zbthA-fDDfyUNQ/_OIex3aA</a> .<br>
<br>
To download it you can evaluate this:<br>
<br>
Gofer new<br>
squeaksource: 'PetitSQLParser';<br>
package: 'ConfigurationOfPetitSQLParser';<br>
load.<br>
(Smalltalk at: #ConfigurationOfPetitSQLParser) perform: #loadDefault<br>
in the repository there are several packages: the core contains the parser for the grammar.<br>
<br>
In the package parser there is a parser that instantiate some draft objects representing relational elements.<br>
<br>
In the next future i will start to implement also other statements.<br>
<br>
If you start to use it and you have some problem please let me know.<br>
<br>
Cheers,<br>
<br>
Fabrizio<br>
<br>
_______________________________________________<br>
Moose-dev mailing list<br>
<a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br>
<a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
<br>
--<br>
<a href="http://www.tudorgirba.com/" target="_blank">www.tudorgirba.com</a><br>
<br>
"No matter how many recipes we know, we still value a chef."<br>
<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Moose-dev mailing list<br>
<a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br>
<a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
<br>
_______________________________________________<br>
Moose-dev mailing list<br>
<a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br>
<a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
</blockquote>
<br>
--<br>
<a href="http://www.tudorgirba.com/" target="_blank">www.tudorgirba.com</a><br>
<br></div></div>
"What is more important: To be happy, or to make happy?"<div><div></div><div><br>
<br>
_______________________________________________<br>
Moose-dev mailing list<br>
<a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br>
<a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
</div></div></blockquote></div><br>
_______________________________________________<br>Moose-dev mailing list<br><a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br><a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
</blockquote></div><br></div></div></div></div><br>_______________________________________________<br>
Moose-dev mailing list<br>
<a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br>
<a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
<br></blockquote></div></div></div></div></div><br>
</blockquote></div><div><div></div><div class="h5"><br><br clear="all"><br>-- <br>Mariano<br><a href="http://marianopeck.wordpress.com/" target="_blank">http://marianopeck.wordpress.com</a><br><br>
_______________________________________________<br>Moose-dev mailing list<br><a href="mailto:Moose-dev@iam.unibe.ch" target="_blank">Moose-dev@iam.unibe.ch</a><br><a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
</div></div></blockquote></div><br></div></div><br>_______________________________________________<br>
Moose-dev mailing list<br>
<a href="mailto:Moose-dev@iam.unibe.ch">Moose-dev@iam.unibe.ch</a><br>
<a href="https://www.iam.unibe.ch/mailman/listinfo/moose-dev" target="_blank">https://www.iam.unibe.ch/mailman/listinfo/moose-dev</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Mariano<br><a href="http://marianopeck.wordpress.com" target="_blank">http://marianopeck.wordpress.com</a><br><br>