module Sequel::Postgres::AutoParameterize::DatabaseMethods

Public Class Methods

extended(db) click to toggle source
    # File lib/sequel/extensions/pg_auto_parameterize.rb
173 def self.extended(db)
174   unless (db.adapter_scheme == :postgres && USES_PG) || (db.adapter_scheme == :mock && db.database_type == :postgres)
175     raise Error, "pg_auto_parameterize is only supported when using the postgres adapter with the pg driver"
176   end
177   db.extend_datasets(DatasetMethods)
178 end

Public Instance Methods

execute(sql, opts={}) click to toggle source

If the sql string has an embedded parameter array, extract the parameter values from that.

Calls superclass method
    # File lib/sequel/extensions/pg_auto_parameterize.rb
182 def execute(sql, opts={})
183   if sql.is_a?(QueryString) && (args = sql.args)
184     opts = opts.merge(:arguments=>args)
185   end
186   super
187 end

Private Instance Methods

_no_auto_parameterize(table) click to toggle source

Disable automatic parameterization for the given table if supported.

    # File lib/sequel/extensions/pg_auto_parameterize.rb
210 def _no_auto_parameterize(table)
211   if table.is_a?(DatasetMethods)
212     table.no_auto_parameterize
213   else
214     table
215   end
216 end
copy_table_sql(table, opts=OPTS) click to toggle source

Disable auto_parameterization during COPY TABLE.

Calls superclass method
    # File lib/sequel/extensions/pg_auto_parameterize.rb
192 def copy_table_sql(table, opts=OPTS)
193   table = _no_auto_parameterize(table)
194   super
195 end
create_table_as(name, sql, options) click to toggle source

Disable auto_parameterization during CREATE TABLE AS.

Calls superclass method
    # File lib/sequel/extensions/pg_auto_parameterize.rb
198 def create_table_as(name, sql, options)
199   sql = _no_auto_parameterize(sql)
200   super
201 end
create_view_sql(name, source, options) click to toggle source

Disable auto_parameterization during CREATE VIEW.

Calls superclass method
    # File lib/sequel/extensions/pg_auto_parameterize.rb
204 def create_view_sql(name, source, options)
205   source = _no_auto_parameterize(source)
206   super
207 end