Class Sequel::Mysql2::Dataset
In: lib/sequel/adapters/mysql2.rb
Parent: Sequel::Dataset

Dataset class for MySQL datasets accessed via the native driver.

Methods

delete   fetch_rows   insert   replace   update  

Included Modules

Sequel::MySQL::DatasetMethods

Public Instance methods

delete()

Delete rows matching this dataset

[Source]

     # File lib/sequel/adapters/mysql2.rb, line 130
130:       def delete
131:         execute_dui(delete_sql){|c| return c.affected_rows}
132:       end
fetch_rows(sql, &block)

Yield all rows matching this dataset.

[Source]

     # File lib/sequel/adapters/mysql2.rb, line 135
135:       def fetch_rows(sql, &block)
136:         execute(sql) do |r|
137:           @columns = r.fields
138:           r.each(:cast_booleans => Sequel::MySQL.convert_tinyint_to_bool, &block)
139:         end
140:         self
141:       end
insert(*values)

Insert a new value into this dataset

[Source]

     # File lib/sequel/adapters/mysql2.rb, line 144
144:       def insert(*values)
145:         execute_dui(insert_sql(*values)){|c| return c.last_id}
146:       end
replace(*args)

Replace (update or insert) the matching row.

[Source]

     # File lib/sequel/adapters/mysql2.rb, line 149
149:       def replace(*args)
150:         execute_dui(replace_sql(*args)){|c| return c.last_id}
151:       end
update(values={})

Update the matching rows.

[Source]

     # File lib/sequel/adapters/mysql2.rb, line 154
154:       def update(values={})
155:         execute_dui(update_sql(values)){|c| return c.affected_rows}
156:       end

[Validate]