Module | Sequel::MySQL::DatabaseMethods |
In: |
lib/sequel/adapters/shared/mysql.rb
|
AUTO_INCREMENT | = | 'AUTO_INCREMENT'.freeze |
CAST_TYPES | = | {String=>:CHAR, Integer=>:SIGNED, Time=>:DATETIME, DateTime=>:DATETIME, Numeric=>:DECIMAL, BigDecimal=>:DECIMAL, File=>:BINARY} |
COLUMN_DEFINITION_ORDER | = | [:null, :default, :unique, :primary_key, :auto_increment, :references] |
PRIMARY | = | 'PRIMARY'.freeze |
Commit an existing prepared transaction with the given transaction identifier string.
# File lib/sequel/adapters/shared/mysql.rb, line 45 45: def commit_prepared_transaction(transaction_id) 46: run("XA COMMIT #{literal(transaction_id)}") 47: end
Use SHOW INDEX FROM to get the index information for the table.
By default partial indexes are not included, you can use the option :partial to override this.
# File lib/sequel/adapters/shared/mysql.rb, line 59 59: def indexes(table, opts={}) 60: indexes = {} 61: remove_indexes = [] 62: m = output_identifier_meth 63: im = input_identifier_meth 64: metadata_dataset.with_sql("SHOW INDEX FROM ?", SQL::Identifier.new(im.call(table))).each do |r| 65: name = r[:Key_name] 66: next if name == PRIMARY 67: name = m.call(name) 68: remove_indexes << name if r[:Sub_part] && ! opts[:partial] 69: i = indexes[name] ||= {:columns=>[], :unique=>r[:Non_unique] != 1} 70: i[:columns] << m.call(r[:Column_name]) 71: end 72: indexes.reject{|k,v| remove_indexes.include?(k)} 73: end
Get version of MySQL server, used for determined capabilities.
# File lib/sequel/adapters/shared/mysql.rb, line 82 82: def server_version 83: m = /(\d+)\.(\d+)\.(\d+)/.match(get(SQL::Function.new(:version))) 84: @server_version ||= (m[1].to_i * 10000) + (m[2].to_i * 100) + m[3].to_i 85: end