From: Ruby Hunter <sale_inquiries@...>
Date: 2009-05-23T15:09:20+09:00
Subject: SQL

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-forum.com/.