Module: Sequel::MySQL::PreparedStatements::DatasetMethods
- Includes:
- Dataset::StoredProcedures
- Included in:
- Dataset, Sequel::Mysql2::Dataset
- Defined in:
- lib/sequel/adapters/shared/mysql_prepared_statements.rb
Defined Under Namespace
Modules: CallableStatementMethods, PreparedStatementMethods, StoredProcedureMethods
Instance Method Summary collapse
-
#call(type, bind_arguments = {}, *values, &block) ⇒ Object
MySQL is different in that it supports prepared statements but not bound variables outside of prepared statements.
-
#prepare(type, name = nil, *values) ⇒ Object
Store the given type of prepared statement in the associated database with the given name.
Methods included from Dataset::StoredProcedures
Instance Method Details
#call(type, bind_arguments = {}, *values, &block) ⇒ Object
MySQL is different in that it supports prepared statements but not bound variables outside of prepared statements. The default implementation breaks the use of subselects in prepared statements, so extend the temporary prepared statement that this creates with a module that fixes it.
138 139 140 141 142 |
# File 'lib/sequel/adapters/shared/mysql_prepared_statements.rb', line 138 def call(type, bind_arguments={}, *values, &block) ps = to_prepared_statement(type, values) ps.extend(CallableStatementMethods) ps.call(bind_arguments, &block) end |
#prepare(type, name = nil, *values) ⇒ Object
Store the given type of prepared statement in the associated database with the given name.
146 147 148 149 150 151 152 153 154 |
# File 'lib/sequel/adapters/shared/mysql_prepared_statements.rb', line 146 def prepare(type, name=nil, *values) ps = to_prepared_statement(type, values) ps.extend(PreparedStatementMethods) if name ps.prepared_statement_name = name db.set_prepared_statement(name, ps) end ps end |