Slide 31
Slide 31 text
Make Database Class Work
class Database
@@db ||= SQLite3::Database.new('jobs.db')
@@db.results_as_hash = true
def insert_employer
@@db.execute("INSERT INTO employers (name, url, about) VALUES
(?, ?, ?)", [@name, @url, @about])
end
end
class Database
attr_accessor :connection
def initialize
@connection = SQLite3::Database.new('jobs.db')
self.connection.results_as_hash = true
end
def insert_employer
self.connection.execute("INSERT INTO employers (name, url, about) VALUES
(?, ?, ?)", [@name, @url, @about])
end
end
Tuesday, November 6, 12