Module | Sequel::MySQL::DatabaseMethods |
In: |
lib/sequel/adapters/shared/mysql.rb
|
AUTO_INCREMENT | = | 'AUTO_INCREMENT'.freeze |
NOT_NULL | = | Sequel::Database::NOT_NULL |
NULL | = | Sequel::Database::NULL |
PRIMARY_KEY | = | Sequel::Database::PRIMARY_KEY |
TYPES | = | Sequel::Database::TYPES.merge(DateTime=>'datetime', \ TrueClass=>'tinyint', FalseClass=>'tinyint') |
UNIQUE | = | Sequel::Database::UNIQUE |
UNSIGNED | = | Sequel::Database::UNSIGNED |
Get version of MySQL server, used for determined capabilities.
# File lib/sequel/adapters/shared/mysql.rb, line 27 27: def server_version 28: m = /(\d+)\.(\d+)\.(\d+)/.match(get(SQL::Function.new(:version))) 29: @server_version ||= (m[1].to_i * 10000) + (m[2].to_i * 100) + m[3].to_i 30: end
Return an array of symbols specifying table names in the current database.
Options:
# File lib/sequel/adapters/shared/mysql.rb, line 36 36: def tables(opts={}) 37: ds = self['SHOW TABLES'].server(opts[:server]) 38: ds.identifier_output_method = nil 39: ds2 = dataset 40: ds.map{|r| ds2.send(:output_identifier, r.values.first)} 41: end