method
execute
rails latest stable - Class:
ActiveRecord::ConnectionAdapters::MysqlAdapter
Method deprecated or moved
This method is deprecated or moved on the latest stable version. The last existing version (v3.1.0) is shown here.
execute(sql, name = nil)public
Executes an SQL query and returns a MySQL::Result object. Note that you have to free the Result object after you’re done using it.
# File activerecord/lib/active_record/connection_adapters/mysql_adapter.rb, line 431
def execute(sql, name = nil) #:nodoc:
if name == :skip_logging
@connection.query(sql)
else
log(sql, name) { @connection.query(sql) }
end
rescue ActiveRecord::StatementInvalid => exception
if exception.message.split(":").first =~ /Packets out of order/
raise ActiveRecord::StatementInvalid, "'Packets out of order' error was received from the database. Please update your mysql bindings (gem install mysql) and read http://dev.mysql.com/doc/mysql/en/password-hashing.html for more information. If you're on Windows, use the Instant Rails installer to get the updated mysql bindings."
else
raise
end
end Related methods
- Instance methods
- active?
- adapter_name
- add_column
- add_column_position!
- add_limit_offset!
- begin_db_transaction
- bulk_change_table
- case_sensitive_equality_operator
- case_sensitive_modifier
- change_column
- change_column_default
- change_column_null
- charset
- clear_cache!
- client_encoding
- collation
- columns
- commit_db_transaction
- create
- create_database
- create_savepoint
- create_table
- current_database
- disable_referential_integrity
- disconnect!
- drop_database
- drop_table
- exec_delete
- exec_query
- exec_update
- exec_without_stmt
- execute
- indexes
- insert_sql
- join_to_update
- last_inserted_id
- limited_update_conditions
- native_database_types
- pk_and_sequence_for
- primary_key
- quote
- quote_column_name
- quote_string
- quote_table_name
- quoted_false
- quoted_true
- reconnect!
- recreate_database
- release_savepoint
- rename_column
- rename_table
- reset!
- rollback_db_transaction
- rollback_to_savepoint
- select_rows
- show_variable
- structure_dump
- supports_bulk_alter?
- supports_migrations?
- supports_primary_key?
- supports_savepoints?
- supports_statement_cache?
- table_exists?
- tables
- type_cast
- type_to_sql
- update_sql
- Class methods
- emulate_booleans
- new
- visitor_for
- Protected methods
-
add_column_sql -
add_index_sql -
add_timestamps_sql -
change_column_sql -
quoted_columns_for_index -
remove_column_sql -
remove_index_sql -
remove_timestamps_sql -
rename_column_sql -
translate_exception - Private methods
-
column_for -
configure_connection -
connect -
exec_stmt -
select -
supports_views? -
version