lib/serialization_helper.rb in yaml_db-0.2.2 vs lib/serialization_helper.rb in yaml_db-0.2.3
- old
+ new
@@ -179,13 +179,11 @@
id = table_column_names(table).first
boolean_columns = SerializationHelper::Utils.boolean_columns(table)
quoted_table_name = SerializationHelper::Utils.quote_table(table)
(0..pages).to_a.each do |page|
- sql = ActiveRecord::Base.connection.add_limit_offset!("SELECT * FROM #{quoted_table_name} ORDER BY #{id}",
- :limit => records_per_page, :offset => records_per_page * page
- )
- records = ActiveRecord::Base.connection.select_all(sql)
+ query = Arel::Table.new(table).order(id).skip(records_per_page*page).take(records_per_page).project(Arel.sql('*'))
+ records = ActiveRecord::Base.connection.select_all(query)
records = SerializationHelper::Utils.convert_booleans(records, boolean_columns)
yield records
end
end