require 'sqlite3'
while true
        print "Do you want to make the database?[Y/N]:"
        answer=gets
        case answer
        when /^[Ss]/
                begin
                    db = SQLite3::Database.open "dbfile.db"
                    db.execute "CREATE TABLE IF NOT EXISTS \"objectos\" (
                        \"id\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
                        \"Nome\" TEXT
                        );"
                    db.execute "CREATE TABLE IF NOT EXISTS matrizes (
                        \"idMatriz\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
                        \"x\" INTEGER NOT NULL,
                        \"y\" INTEGER NOT NULL,
                        \"z\" INTEGER NOT NULL,
                        \"objectos_ID\" INTEGER NOT NULL,
                        FOREIGN KEY (objectos_ID) REFERENCES objectos(id)
                        );"
                    db.execute "PRAGMA foreign_keys = ON;"
                    db.commit
                rescue SQLite3::Exception => e
                    puts "Exception occured"
                    puts e
                ensure
                    db.close if db
                end
        when /^[Nn]/,/^$/
                print "Aborted"
                exit
        end
exit