Class/Module Index [+]

Quicksearch

Sequel::SQLite::DatasetMethods

Instance methods for datasets that connect to an SQLite database

Public Instance Methods

complex_expression_sql_append(sql, op, args) click to toggle source

SQLite does not support pattern matching via regular expressions. SQLite is case insensitive (depending on pragma), so use LIKE for ILIKE.

# File lib/sequel/adapters/shared/sqlite.rb, line 418
def complex_expression_sql_append(sql, op, args)
  case op
  when :~, :'!~', :'~*', :'!~*'
    raise Error, "SQLite does not support pattern matching via regular expressions"
  when :ILIKE
    super(sql, :LIKE, args.map{|a| SQL::Function.new(:upper, a)})
  when :"NOT LIKE", :"NOT ILIKE"
    sql << NOT_SPACE
    complex_expression_sql_append(sql, (op == :"NOT ILIKE" ? :ILIKE : :LIKE), args)
  when :^
    sql << complex_expression_arg_pairs(args) do |a, b|
      a = literal(a)
      b = literal(b)
      "((~(#{a} & #{b})) & (#{a} | #{b}))"
    end
  when :extract
    part = args.at(0)
    raise(Sequel::Error, "unsupported extract argument: #{part.inspect}") unless format = EXTRACT_MAP[part]
    sql << EXTRACT_OPEN << format << COMMA
    literal_append(sql, args.at(1))
    sql << EXTRACT_CLOSE << (part == :second ? NUMERIC : INTEGER) << PAREN_CLOSE
  else
    super
  end
end
constant_sql_append(sql, constant) click to toggle source

SQLite has CURRENT_TIMESTAMP and related constants in UTC instead of in localtime, so convert those constants to local time.

# File lib/sequel/adapters/shared/sqlite.rb, line 446
def constant_sql_append(sql, constant)
  if c = CONSTANT_MAP[constant]
    sql << c
  else
    super
  end
end
delete() click to toggle source

SQLite performs a TRUNCATE style DELETE if no filter is specified. Since we want to always return the count of records, add a condition that is always true and then delete.

# File lib/sequel/adapters/shared/sqlite.rb, line 457
def delete
  @opts[:where] ? super : filter(1=>1).delete
end
explain() click to toggle source

Return an array of strings specifying a query explanation for a SELECT of the current dataset.

# File lib/sequel/adapters/shared/sqlite.rb, line 463
def explain
  db.send(:metadata_dataset).clone(:sql=>"EXPLAIN #{select_sql}").
    map{|x| "#{x[:addr]}|#{x[:opcode]}|#{(1..5).map{|i| x[:"p#{i}"]}.join('|')}|#{x[:comment]}"}
end
having(*cond) click to toggle source

HAVING requires GROUP BY on SQLite

# File lib/sequel/adapters/shared/sqlite.rb, line 469
def having(*cond)
  raise(InvalidOperation, "Can only specify a HAVING clause on a grouped dataset") unless @opts[:group]
  super
end
quoted_identifier_append(sql, c) click to toggle source

SQLite uses the nonstandard ` (backtick) for quoting identifiers.

# File lib/sequel/adapters/shared/sqlite.rb, line 475
def quoted_identifier_append(sql, c)
  sql << BACKTICK << c.to_s << BACKTICK
end
select(*cols) click to toggle source

When a qualified column is selected on SQLite and the qualifier is a subselect, the column name used is the full qualified name (including the qualifier) instead of just the column name. To get correct column names, you must use an alias.

# File lib/sequel/adapters/shared/sqlite.rb, line 483
def select(*cols)
  if ((f = @opts[:from]) && f.any?{|t| t.is_a?(Dataset) || (t.is_a?(SQL::AliasedExpression) && t.expression.is_a?(Dataset))}) || ((j = @opts[:join]) && j.any?{|t| t.table.is_a?(Dataset)})
    super(*cols.map{|c| alias_qualified_column(c)})
  else
    super
  end
end
supports_intersect_except_all?() click to toggle source

SQLite does not support INTERSECT ALL or EXCEPT ALL

# File lib/sequel/adapters/shared/sqlite.rb, line 492
def supports_intersect_except_all?
  false
end
supports_is_true?() click to toggle source

SQLite does not support IS TRUE

# File lib/sequel/adapters/shared/sqlite.rb, line 497
def supports_is_true?
  false
end
supports_multiple_column_in?() click to toggle source

SQLite does not support multiple columns for the IN/NOT IN operators

# File lib/sequel/adapters/shared/sqlite.rb, line 502
def supports_multiple_column_in?
  false
end
supports_timestamp_timezones?() click to toggle source

SQLite supports timezones in literal timestamps, since it stores them as text. But using timezones in timestamps breaks SQLite datetime functions, so we allow the user to override the default per database.

# File lib/sequel/adapters/shared/sqlite.rb, line 509
def supports_timestamp_timezones?
  db.use_timestamp_timezones?
end
supports_where_true?() click to toggle source

SQLite cannot use WHERE 't'.

# File lib/sequel/adapters/shared/sqlite.rb, line 514
def supports_where_true?
  false
end

[Validate]

Generated with the Darkfish Rdoc Generator 2.