Class Sequel::SQLite::Dataset
In: lib/sequel/adapters/sqlite.rb
Parent: Sequel::Dataset

Dataset class for SQLite datasets that use the ruby-sqlite3 driver.

Methods

fetch_rows   prepare  

Included Modules

::Sequel::SQLite::DatasetMethods

Classes and Modules

Module Sequel::SQLite::Dataset::ArgumentMapper
Module Sequel::SQLite::Dataset::PreparedStatementMethods

Constants

PREPARED_ARG_PLACEHOLDER = ':'.freeze

Public Instance methods

fetch_rows(sql) {|row| ...}

Yield a hash for each row in the dataset.

[Source]

     # File lib/sequel/adapters/sqlite.rb, line 187
187:       def fetch_rows(sql)
188:         execute(sql) do |result|
189:           i = -1
190:           cols = result.columns.map{|c| [output_identifier(c), i+=1]}
191:           @columns = cols.map{|c| c.first}
192:           result.each do |values|
193:             row = {}
194:             cols.each{|n,i| row[n] = values[i]}
195:             yield row
196:           end
197:         end
198:       end
prepare(type, name=nil, *values)

Prepare the given type of query with the given name and store it in the database. Note that a new native prepared statement is created on each call to this prepared statement.

[Source]

     # File lib/sequel/adapters/sqlite.rb, line 203
203:       def prepare(type, name=nil, *values)
204:         ps = to_prepared_statement(type, values)
205:         ps.extend(PreparedStatementMethods)
206:         db.prepared_statements[name] = ps if name
207:         ps.prepared_sql
208:         ps
209:       end

[Validate]