mirror of
https://github.com/github/codeql.git
synced 2025-12-18 09:43:15 +01:00
32 lines
527 B
Ruby
32 lines
527 B
Ruby
require 'sqlite3'
|
|
|
|
db = SQLite3::Database.new "test.db"
|
|
|
|
db.execute <<-SQL
|
|
create table numbers (
|
|
name varchar(30),
|
|
val int
|
|
);
|
|
SQL
|
|
|
|
stmt = db.prepare "select * from numbers"
|
|
|
|
stmt.execute
|
|
|
|
SQLite3::Database.new( "data.db" ) do |db|
|
|
db.execute( "select * from table" ) do |row|
|
|
p row
|
|
end
|
|
end
|
|
|
|
|
|
class MyDatabaseWrapper
|
|
def initialize(filename)
|
|
@db = SQLite3::Database.new(filename, results_as_hash: true)
|
|
end
|
|
|
|
def select_rows(category)
|
|
@db.execute("select * from table")
|
|
end
|
|
end
|