Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
SQL
Ruby Hunter
5/23/2009 6:09:00 AM
hi I have a text database which I looking for code.
my code is (Database.rb):
class Database
def initialize(input_file)
file = File.new(input_file, "r")
while (line = file.gets)
puts "#{parse(line)}"
end
file.close
end
def parse(statement)
return statement
end
end
Database.new("query.txt")
running this incomplete code will just dump out the query.txt contents:
create table student regnum integer name string surname string
create table results regnum integer courseCode string mark integer grade
string
create table bad regnum xxx courseCode string mark integer grade string
create table notgood regnum1 integer name string surname string
create table failure regnum integer name string surname
insert into student 00001 'John' 'Ruby'
insert into student 00002 'Sara' 'Java'
By completing the statement bit of the code it should output this:
create table student regnum integer name string surname string
create table results regnum integer courseCode string mark integer grade
string
create table bad regnum xxx courseCode string mark integer grade string
ERROR
create table notgood regnum1 integer name string surname string
ERROR
create table failure regnum integer name string surname
ERROR
insert into student 00001 'John' 'Ruby'
insert into student 00002 'Sara' 'Java'
Basically it checks the format by checking the "create table" or "insert
into" commands and if the format is ok it will continue to next line and
if incorrect it would print ERROR and check teh next line.
can anyone help me out with the code and tell me what should be there to
in the following section and get it working for me:
def parse(statement)
return statement
end
many thanks
--
Posted via
http://www.ruby-...
.
2 Answers
Albert Schlef
5/24/2009 9:19:00 AM
0
Ruby Hunter wrote:
> Basically it [will check] the format by checking the "create table"
> or "insert into" commands and if the format is ok it will continue
> to next line and if incorrect it would print ERROR and check teh
> next line.
Why do you want to do that?
> can anyone help me out with the code and tell me what should
> be there to in the following section and and get it working for me
You need to write an SQL parser. It isn't diffrent than writing a parser
for a programming language like pascal or C or whatever. It's a science
in its own.
But, again, why do you want to do that in the first place?
--
Posted via
http://www.ruby-...
.
Ruby Hunter
5/25/2009 4:18:00 AM
0
Albert Schlef wrote:
> Ruby Hunter wrote:
>> Basically it [will check] the format by checking the "create table"
>> or "insert into" commands and if the format is ok it will continue
>> to next line and if incorrect it would print ERROR and check teh
>> next line.
>
> Why do you want to do that?
>
>> can anyone help me out with the code and tell me what should
>> be there to in the following section and and get it working for me
>
> You need to write an SQL parser. It isn't diffrent than writing a parser
> for a programming language like pascal or C or whatever. It's a science
> in its own.
>
> But, again, why do you want to do that in the first place?
well its just part of my learning project as I am tryig to learn, so
appreciate some script codes if you can help me. thanks
--
Posted via
http://www.ruby-...
.
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
SQL
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password