class Sequel::SQLite::Dataset

Constants

BindArgumentMethods
PreparedStatementMethods

Public Instance Methods

fetch_rows(sql) { |row| ... } click to toggle source
    # File lib/sequel/adapters/sqlite.rb
319 def fetch_rows(sql)
320   execute(sql) do |result|
321     i = -1
322     cps = db.conversion_procs
323     type_procs = result.types.map{|t| cps[base_type_name(t)]}
324     cols = result.columns.map{|c| i+=1; [output_identifier(c), i, type_procs[i]]}
325     self.columns = cols.map(&:first)
326     result.each do |values|
327       row = {}
328       cols.each do |name,id,type_proc|
329         v = values[id]
330         if type_proc && v
331           v = type_proc.call(v)
332         end
333         row[name] = v
334       end
335       yield row
336     end
337   end
338 end

Private Instance Methods

base_type_name(t) click to toggle source

The base type name for a given type, without any parenthetical part.

    # File lib/sequel/adapters/sqlite.rb
343 def base_type_name(t)
344   (t =~ /^(.*?)\(/ ? $1 : t).downcase if t
345 end
bound_variable_modules() click to toggle source
    # File lib/sequel/adapters/sqlite.rb
352 def bound_variable_modules
353   [BindArgumentMethods]
354 end
literal_string_append(sql, v) click to toggle source

Quote the string using the adapter class method.

    # File lib/sequel/adapters/sqlite.rb
348 def literal_string_append(sql, v)
349   sql << "'" << ::SQLite3::Database.quote(v) << "'"
350 end
prepared_arg_placeholder() click to toggle source

SQLite uses a : before the name of the argument as a placeholder.

    # File lib/sequel/adapters/sqlite.rb
361 def prepared_arg_placeholder
362   ':'
363 end
prepared_statement_modules() click to toggle source
    # File lib/sequel/adapters/sqlite.rb
356 def prepared_statement_modules
357   [PreparedStatementMethods]
358 end