[antlr-interest] SQL CSharp parser:Its working! Thank you..

[Brian Smith]

Addi,

Why are you wanting to generate XML? IMO, that is just an extra step 
that will cause you extra work. You should consider creating an ANTLR 
TreeParser to extra the metadata. An ANTLR TreeParser should be simpler 
and easier to maintain than whatever you would use to process your XML. 
You will probably have to do this anyway to generate the XML as far as I 
can tell. Well, maybe you could try to use the built-in AST 
serialization-to-XML mechanism and then writing an XSLT stylesheet....

IMO, XML is a tool to use when you can't find a parser and can't create 
one with reasonable effort, or when you need to communicate with people 
that don't have a parser and you can't give them yours. In your case, 
you have a parser that you seem happy with, and there is no standard SQL 
interchange format that I am aware of; the closest thing I can think of 
off the top of my head is OMG CWM+XMI but there are not many free tools 
for that and XMI is difficult to process by hand. So, I doubt XML will 
have any benefits in this situation; that is probably why you have had 
trouble finding tools for XML-ized SQL.

- Brian


Addi Jamshidi wrote:
> Sorry for the bandwidth again...
> Just wanted to say that I have truly come to
> appreciate Antlr. This is really a great tool.
> 
> I just used the Antlr SQL grammar that is provided by
> Mr. Brent Wiese, and also using the C# parser
> generator by Michael J., and it works great! Needed to
> do some manual fixing of the generated Csharp code,
> but it was minor.. 
> 
> So THANK you Michael J., and Brent Wiese.
> 
> Now the only thing that is left is to come up with
> some sort of a XML schema and have the parser generate
> its parsed tree based on that schema.. Any input
> and/or help is greatly appreciated. I have zipped up
> the SQL CSharp parser (it is about 280KB) and I will
> be more than happy to send it to anyone who is
> interested in contributing...
> 
> The ironic thing about ANTLR is that not too many
> people know about it -- or perhaps it is only the
> ignorants who do not know about it and come to know of
> it purely by accident - as I did... :)
> 
> Best Regards,
> 
> Addi Jamshidi
> 
> 
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> http://webhosting.yahoo.com
> 
>  
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 
> 


 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/