Class: Sqlite3

Inherits:
Object
  • Object
show all
Defined in:
lib/adapters/sqlite3.rb

Instance Method Summary collapse

Constructor Details

#initialize(database, show_sql = false) ⇒ Sqlite3

Returns a new instance of Sqlite3.



5
6
7
8
# File 'lib/adapters/sqlite3.rb', line 5

def initialize(database,show_sql=false)
  @client =  SQLite3::Database.new(database)
  @show_sql = show_sql
end

Instance Method Details

#fields(table) ⇒ Object



15
16
17
# File 'lib/adapters/sqlite3.rb', line 15

def fields(table)
  query('select * from ' + table.to_s).fields
end

#query(sql) ⇒ Object



10
11
12
13
# File 'lib/adapters/sqlite3.rb', line 10

def query(sql)
  puts sql if @show_sql
  @client.execute(sql)
end