[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

SQL Parser in Ruby

Dr Nic

7/24/2006 12:10:00 PM


Has anyone taken the time to bang together an SQL parser for Ruby?

Cheers
Nic

--
Posted via http://www.ruby-....
5 Answers

Matthew Harris

7/24/2006 3:41:00 PM

0

I imagine it wouldn't be too difficult, but what good would an SQL92 parser be?

On 7/24/06, Dr Nic <drnicwilliams@gmail.com> wrote:
>
> Has anyone taken the time to bang together an SQL parser for Ruby?
>
> Cheers
> Nic
>
> --
> Posted via http://www.ruby-....
>
>


--
Matt

Dr Nic

7/25/2006 7:33:00 AM

0

Matthew Harris wrote:
> I imagine it wouldn't be too difficult, but what good would an SQL92
> parser be?

I wanted it for the subset of grammar for create/update/delete
tables/indexes etc - the stuff that some dbs store in data dictionary
tables, but MySQL doesn't. If the database generation sql was available,
then the data dictionary information could be reengineered.

Cheers
Nic

--
Posted via http://www.ruby-....

Dmitry Buzdin

7/25/2006 11:26:00 AM

0

I believe that there is a feature in Ruby on Rails, which belongs to
ActiveRecord, that allows you to export existing DB structure in the
Ruby upgrade script, which in turn generates SQL.
May be this will solve Your issue.

I hope that I have understood your problem correct.

Dmirty

Dr Nic wrote:
> Matthew Harris wrote:
> > I imagine it wouldn't be too difficult, but what good would an SQL92
> > parser be?
>
> I wanted it for the subset of grammar for create/update/delete
> tables/indexes etc - the stuff that some dbs store in data dictionary
> tables, but MySQL doesn't. If the database generation sql was available,
> then the data dictionary information could be reengineered.
>
> Cheers
> Nic
>
> --
> Posted via http://www.ruby-....

Dr Nic

7/25/2006 11:33:00 AM

0

Dmitry Buzdin wrote:
> I believe that there is a feature in Ruby on Rails, which belongs to
> ActiveRecord, that allows you to export existing DB structure in the
> Ruby upgrade script, which in turn generates SQL.
> May be this will solve Your issue.

It certainly should do something like that,shouldn't it - given it
reflectively determines the table schema at runtime.

I'll go hunt for the code.

Thanks for the reminder.

Cheers
Nic

--
Posted via http://www.ruby-....

Marjun Pagalan

6/6/2008 1:08:00 AM

0

Dr Nic wrote:
> Dmitry Buzdin wrote:
>> I believe that there is a feature in Ruby on Rails, which belongs to
>> ActiveRecord, that allows you to export existing DB structure in the
>> Ruby upgrade script, which in turn generates SQL.
>> May be this will solve Your issue.
>
> It certainly should do something like that,shouldn't it - given it
> reflectively determines the table schema at runtime.
>
> I'll go hunt for the code.
>
> Thanks for the reminder.
>
> Cheers
> Nic

Hi,
im a newbie and want to know if this sql parser in ruby is already out
there?


thanks.

--
Posted via http://www.ruby-....