The prepared_statements plugin modifies the model to use prepared statements for instance level deletes and saves, as well as class level lookups by primary key.
Note that this plugin is unsafe in some circumstances, as it can allow up to 2^N prepared statements to be created for each type of insert and update query, where N is the number of colums in the table. It is recommended that you use the prepared_statements_safe plugin in addition to this plugin to reduce the number of prepared statements that can be created, unless you tightly control how your model instances are saved.
This plugin does not work correctly with the instance filters plugin or the update_primary_key plugin.
Usage:
# Make all model subclasses use prepared statements (called before loading subclasses) Sequel::Model.plugin :prepared_statements # Make the Album class use prepared statements Album.plugin :prepared_statements
Setup the datastructure used to hold the prepared statements in the model.
# File lib/sequel/plugins/prepared_statements.rb, line 34 def self.apply(model) model.instance_variable_set(:@prepared_statements, :insert=>{}, :insert_select=>{}, :update=>{}, :lookup_sql=>{}, :fixed=>{}) end
Generated with the Darkfish Rdoc Generator 2.