Class: Sequel::SQLite::Dataset

Inherits:
Dataset
  • Object
show all
Defined in:
lib/sequel/sqlite.rb

Constant Summary collapse

LIMIT_1 = 
{:limit => 1}.freeze

Instance Method Summary collapse

Instance Method Details

#count(opts = nil) ⇒ Object 



69
70
71
 
# File 'lib/sequel/sqlite.rb', line 69

def count(opts = nil)
  @db.single_value(count_sql(opts)).to_i
end

#delete(opts = nil) ⇒ Object 



86
87
88
89
90
91
 
# File 'lib/sequel/sqlite.rb', line 86

def delete(opts = nil)
  @db.synchronize do
    @db.execute delete_sql(opts)
  end
  self
end

#each(opts = nil, &block) ⇒ Object 



58
59
60
61
 
# File 'lib/sequel/sqlite.rb', line 58

def each(opts = nil, &block)
  @db.result_set(select_sql(opts), @record_class, &block)
  self
end

#first_record(opts = nil) ⇒ Object 



65
66
67
 
# File 'lib/sequel/sqlite.rb', line 65

def first_record(opts = nil)
  @db.result_set(select_sql(opts), @record_class) {|r| return r}
end

#insert(values = nil, opts = nil) ⇒ Object 



73
74
75
76
77
 
# File 'lib/sequel/sqlite.rb', line 73

def insert(values = nil, opts = nil)
  @db.synchronize do
    @db.execute_insert insert_sql(values, opts)
  end
end

#update(values, opts = nil) ⇒ Object 



79
80
81
82
83
84
 
# File 'lib/sequel/sqlite.rb', line 79

def update(values, opts = nil)
  @db.synchronize do
    @db.execute update_sql(values, opts)
  end
  self
end