/usr/lib/ruby/vendor_ruby/sequel/adapters/shared/mysql.rb is in ruby-sequel 3.33.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 | module Sequel
Dataset::NON_SQL_OPTIONS << :insert_ignore
Dataset::NON_SQL_OPTIONS << :update_ignore
Dataset::NON_SQL_OPTIONS << :on_duplicate_key_update
module MySQL
@convert_tinyint_to_bool = true
class << self
# Sequel converts the column type tinyint(1) to a boolean by default when
# using the native MySQL or Mysql2 adapter. You can turn off the conversion by setting
# this to false. This setting is ignored when connecting to MySQL via the do or jdbc
# adapters, both of which automatically do the conversion.
attr_accessor :convert_tinyint_to_bool
# Set the default charset used for CREATE TABLE. You can pass the
# :charset option to create_table to override this setting.
attr_accessor :default_charset
# Set the default collation used for CREATE TABLE. You can pass the
# :collate option to create_table to override this setting.
attr_accessor :default_collate
# Set the default engine used for CREATE TABLE. You can pass the
# :engine option to create_table to override this setting.
attr_accessor :default_engine
end
# Methods shared by Database instances that connect to MySQL,
# currently supported by the native and JDBC adapters.
module DatabaseMethods
AUTO_INCREMENT = 'AUTO_INCREMENT'.freeze
CAST_TYPES = {String=>:CHAR, Integer=>:SIGNED, Time=>:DATETIME, DateTime=>:DATETIME, Numeric=>:DECIMAL, BigDecimal=>:DECIMAL, File=>:BINARY}
COLUMN_DEFINITION_ORDER = [:collate, :null, :default, :unique, :primary_key, :auto_increment, :references]
PRIMARY = 'PRIMARY'.freeze
# MySQL's cast rules are restrictive in that you can't just cast to any possible
# database type.
def cast_type_literal(type)
CAST_TYPES[type] || super
end
# Commit an existing prepared transaction with the given transaction
# identifier string.
def commit_prepared_transaction(transaction_id)
run("XA COMMIT #{literal(transaction_id)}")
end
# MySQL uses the :mysql database type
def database_type
:mysql
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.
def indexes(table, opts={})
indexes = {}
remove_indexes = []
m = output_identifier_meth
im = input_identifier_meth
metadata_dataset.with_sql("SHOW INDEX FROM ?", SQL::Identifier.new(im.call(table))).each do |r|
name = r[:Key_name]
next if name == PRIMARY
name = m.call(name)
remove_indexes << name if r[:Sub_part] && ! opts[:partial]
i = indexes[name] ||= {:columns=>[], :unique=>r[:Non_unique] != 1}
i[:columns] << m.call(r[:Column_name])
end
indexes.reject{|k,v| remove_indexes.include?(k)}
end
# Rollback an existing prepared transaction with the given transaction
# identifier string.
def rollback_prepared_transaction(transaction_id)
run("XA ROLLBACK #{literal(transaction_id)}")
end
# Get version of MySQL server, used for determined capabilities.
def server_version
m = /(\d+)\.(\d+)\.(\d+)/.match(get(SQL::Function.new(:version)))
@server_version ||= (m[1].to_i * 10000) + (m[2].to_i * 100) + m[3].to_i
end
# MySQL supports CREATE TABLE IF NOT EXISTS syntax.
def supports_create_table_if_not_exists?
true
end
# MySQL supports prepared transactions (two-phase commit) using XA
def supports_prepared_transactions?
server_version >= 50000
end
# MySQL supports savepoints
def supports_savepoints?
server_version >= 50000
end
# MySQL doesn't appear to support savepoints inside prepared transactions in >=5.5.12,
# see http://bugs.mysql.com/bug.php?id=64374
def supports_savepoints_in_prepared_transactions?
super && server_version <= 50512
end
# MySQL supports transaction isolation levels
def supports_transaction_isolation_levels?
true
end
# Return an array of symbols specifying table names in the current database.
#
# Options:
# * :server - Set the server to use
def tables(opts={})
full_tables('BASE TABLE', opts)
end
# Changes the database in use by issuing a USE statement. I would be
# very careful if I used this.
def use(db_name)
disconnect
@opts[:database] = db_name if self << "USE #{db_name}"
@schemas = {}
self
end
# Return an array of symbols specifying view names in the current database.
#
# Options:
# * :server - Set the server to use
def views(opts={})
full_tables('VIEW', opts)
end
private
# Use MySQL specific syntax for rename column, set column type, and
# drop index cases.
def alter_table_sql(table, op)
case op[:op]
when :add_column
if related = op.delete(:table)
sql = super(table, op)
op[:table] = related
op[:key] ||= primary_key_from_schema(related)
[sql, "ALTER TABLE #{quote_schema_table(table)} ADD FOREIGN KEY (#{quote_identifier(op[:name])})#{column_references_sql(op)}"]
else
super(table, op)
end
when :rename_column, :set_column_type, :set_column_null, :set_column_default
o = op[:op]
opts = schema(table).find{|x| x.first == op[:name]}
opts = opts ? opts.last.dup : {}
opts[:name] = o == :rename_column ? op[:new_name] : op[:name]
opts[:type] = o == :set_column_type ? op[:type] : opts[:db_type]
opts[:null] = o == :set_column_null ? op[:null] : opts[:allow_null]
opts[:default] = o == :set_column_default ? op[:default] : opts[:ruby_default]
opts.delete(:default) if opts[:default] == nil
"ALTER TABLE #{quote_schema_table(table)} CHANGE COLUMN #{quote_identifier(op[:name])} #{column_definition_sql(op.merge(opts))}"
when :drop_index
"#{drop_index_sql(table, op)} ON #{quote_schema_table(table)}"
when :drop_constraint
type = case op[:type]
when :primary_key
return "ALTER TABLE #{quote_schema_table(table)} DROP PRIMARY KEY"
when :foreign_key
'FOREIGN KEY'
when :unique
'INDEX'
else
raise(Error, "must specify constraint type via :type=>(:foreign_key|:primary_key|:unique) when dropping constraints on MySQL")
end
"ALTER TABLE #{quote_schema_table(table)} DROP #{type} #{quote_identifier(op[:name])}"
when :add_constraint
if op[:type] == :foreign_key
op[:key] ||= primary_key_from_schema(op[:table])
end
super(table, op)
else
super(table, op)
end
end
# Use MySQL specific AUTO_INCREMENT text.
def auto_increment_sql
AUTO_INCREMENT
end
# MySQL needs to set transaction isolation before begining a transaction
def begin_new_transaction(conn, opts)
set_transaction_isolation(conn, opts)
log_connection_execute(conn, begin_transaction_sql)
end
# Use XA START to start a new prepared transaction if the :prepare
# option is given.
def begin_transaction(conn, opts={})
if (s = opts[:prepare]) && (th = @transactions[conn])[:savepoint_level] == 0
log_connection_execute(conn, "XA START #{literal(s)}")
th[:savepoint_level] += 1
else
super
end
end
# The order of the column definition, as an array of symbols.
def column_definition_order
COLUMN_DEFINITION_ORDER
end
# MySQL doesn't allow default values on text columns, so ignore if it the
# generic text type is used
def column_definition_sql(column)
column.delete(:default) if column[:type] == File || (column[:type] == String && column[:text] == true)
super
end
# Prepare the XA transaction for a two-phase commit if the
# :prepare option is given.
def commit_transaction(conn, opts={})
if (s = opts[:prepare]) && @transactions[conn][:savepoint_level] <= 1
log_connection_execute(conn, "XA END #{literal(s)}")
log_connection_execute(conn, "XA PREPARE #{literal(s)}")
else
super
end
end
# Use MySQL specific syntax for engine type and character encoding
def create_table_sql(name, generator, options = {})
engine = options.fetch(:engine, Sequel::MySQL.default_engine)
charset = options.fetch(:charset, Sequel::MySQL.default_charset)
collate = options.fetch(:collate, Sequel::MySQL.default_collate)
generator.constraints.sort_by{|c| (c[:type] == :primary_key) ? -1 : 1}
key_proc = lambda do |t|
if t == name
if pk = generator.primary_key_name
[pk]
elsif !(pkc = generator.constraints.select{|con| con[:type] == :primary_key}).empty?
pkc.first[:columns]
end
else
primary_key_from_schema(t)
end
end
generator.constraints.each do |c|
if c[:type] == :foreign_key
c[:key] ||= key_proc.call(c[:table])
end
end
generator.columns.each do |c|
if t = c.delete(:table)
same_table = t == name
k = c[:key]
key ||= key_proc.call(t)
if same_table && !k.nil?
generator.constraints.unshift(:type=>:unique, :columns=>Array(k))
end
generator.foreign_key([c[:name]], t, c.merge(:name=>nil, :type=>:foreign_key, :key=>key))
end
end
"#{super}#{" ENGINE=#{engine}" if engine}#{" DEFAULT CHARSET=#{charset}" if charset}#{" DEFAULT COLLATE=#{collate}" if collate}"
end
# Backbone of the tables and views support using SHOW FULL TABLES.
def full_tables(type, opts)
m = output_identifier_meth
metadata_dataset.with_sql('SHOW FULL TABLES').server(opts[:server]).map{|r| m.call(r.values.first) if r.delete(:Table_type) == type}.compact
end
# MySQL folds unquoted identifiers to lowercase, so it shouldn't need to upcase identifiers on input.
def identifier_input_method_default
nil
end
# MySQL folds unquoted identifiers to lowercase, so it shouldn't need to upcase identifiers on output.
def identifier_output_method_default
nil
end
# Handle MySQL specific index SQL syntax
def index_definition_sql(table_name, index)
index_name = quote_identifier(index[:name] || default_index_name(table_name, index[:columns]))
index_type = case index[:type]
when :full_text
"FULLTEXT "
when :spatial
"SPATIAL "
else
using = " USING #{index[:type]}" unless index[:type] == nil
"UNIQUE " if index[:unique]
end
"CREATE #{index_type}INDEX #{index_name}#{using} ON #{quote_schema_table(table_name)} #{literal(index[:columns])}"
end
# Parse the schema for the given table to get an array of primary key columns
def primary_key_from_schema(table)
schema(table).select{|a| a[1][:primary_key]}.map{|a| a[0]}
end
# Rollback the currently open XA transaction
def rollback_transaction(conn, opts={})
if (s = opts[:prepare]) && @transactions[conn][:savepoint_level] <= 1
log_connection_execute(conn, "XA END #{literal(s)}")
log_connection_execute(conn, "XA PREPARE #{literal(s)}")
log_connection_execute(conn, "XA ROLLBACK #{literal(s)}")
else
super
end
end
# MySQL treats integer primary keys as autoincrementing.
def schema_autoincrementing_primary_key?(schema)
super and schema[:db_type] =~ /int/io
end
# Use the MySQL specific DESCRIBE syntax to get a table description.
def schema_parse_table(table_name, opts)
m = output_identifier_meth(opts[:dataset])
im = input_identifier_meth(opts[:dataset])
metadata_dataset.with_sql("DESCRIBE ?", SQL::Identifier.new(im.call(table_name))).map do |row|
row[:auto_increment] = true if row.delete(:Extra).to_s =~ /auto_increment/io
row[:allow_null] = row.delete(:Null) == 'YES'
row[:default] = row.delete(:Default)
row[:primary_key] = row.delete(:Key) == 'PRI'
row[:default] = nil if blank_object?(row[:default])
row[:db_type] = row.delete(:Type)
row[:type] = schema_column_type(row[:db_type])
[m.call(row.delete(:Field)), row]
end
end
# Respect the :size option if given to produce
# tinyblob, mediumblob, and longblob if :tiny,
# :medium, or :long is given.
def type_literal_generic_file(column)
case column[:size]
when :tiny # < 2^8 bytes
:tinyblob
when :medium # < 2^24 bytes
:mediumblob
when :long # < 2^32 bytes
:longblob
else # 2^16 bytes
:blob
end
end
# MySQL has both datetime and timestamp classes, most people are going
# to want datetime
def type_literal_generic_datetime(column)
if column[:default] == Sequel::CURRENT_TIMESTAMP
:timestamp
else
:datetime
end
end
# MySQL has both datetime and timestamp classes, most people are going
# to want datetime
def type_literal_generic_time(column)
column[:only_time] ? :time : type_literal_generic_datetime(column)
end
# MySQL doesn't have a true boolean class, so it uses tinyint(1)
def type_literal_generic_trueclass(column)
:'tinyint(1)'
end
end
# Dataset methods shared by datasets that use MySQL databases.
module DatasetMethods
BOOL_TRUE = '1'.freeze
BOOL_FALSE = '0'.freeze
COMMA_SEPARATOR = ', '.freeze
FOR_SHARE = ' LOCK IN SHARE MODE'.freeze
SQL_CALC_FOUND_ROWS = ' SQL_CALC_FOUND_ROWS'.freeze
DELETE_CLAUSE_METHODS = Dataset.clause_methods(:delete, %w'delete from where order limit')
INSERT_CLAUSE_METHODS = Dataset.clause_methods(:insert, %w'insert ignore into columns values on_duplicate_key_update')
SELECT_CLAUSE_METHODS = Dataset.clause_methods(:select, %w'select distinct calc_found_rows columns from join where group having compounds order limit lock')
UPDATE_CLAUSE_METHODS = Dataset.clause_methods(:update, %w'update ignore table set where order limit')
SPACE = Dataset::SPACE
PAREN_OPEN = Dataset::PAREN_OPEN
PAREN_CLOSE = Dataset::PAREN_CLOSE
NOT_SPACE = Dataset::NOT_SPACE
FROM = Dataset::FROM
INSERT = Dataset::INSERT
COMMA = Dataset::COMMA
LIMIT = Dataset::LIMIT
GROUP_BY = Dataset::GROUP_BY
REGEXP = 'REGEXP'.freeze
LIKE = 'LIKE'.freeze
BINARY = 'BINARY '.freeze
CONCAT = "CONCAT".freeze
CAST_BITCOMP_OPEN = "CAST(~".freeze
CAST_BITCOMP_CLOSE = " AS SIGNED INTEGER)".freeze
STRAIGHT_JOIN = 'STRAIGHT_JOIN'.freeze
NATURAL_LEFT_JOIN = 'NATURAL LEFT JOIN'.freeze
BACKTICK = '`'.freeze
EMPTY_COLUMNS = " ()".freeze
EMPTY_VALUES = " VALUES ()".freeze
IGNORE = " IGNORE".freeze
REPLACE = 'REPLACE'.freeze
ON_DUPLICATE_KEY_UPDATE = " ON DUPLICATE KEY UPDATE ".freeze
EQ_VALUES = '=VALUES('.freeze
EQ = '='.freeze
WITH_ROLLUP = ' WITH ROLLUP'.freeze
# MySQL specific syntax for LIKE/REGEXP searches, as well as
# string concatenation.
def complex_expression_sql_append(sql, op, args)
case op
when :IN, :"NOT IN"
ds = args.at(1)
if ds.is_a?(Sequel::Dataset) && ds.opts[:limit]
super(sql, op, [args.at(0), ds.from_self])
else
super
end
when :~, :'!~', :'~*', :'!~*', :LIKE, :'NOT LIKE', :ILIKE, :'NOT ILIKE'
sql << PAREN_OPEN
literal_append(sql, args.at(0))
sql << SPACE
sql << 'NOT ' if [:'NOT LIKE', :'NOT ILIKE', :'!~', :'!~*'].include?(op)
sql << ([:~, :'!~', :'~*', :'!~*'].include?(op) ? REGEXP : LIKE)
sql << SPACE
sql << BINARY if [:~, :'!~', :LIKE, :'NOT LIKE'].include?(op)
literal_append(sql, args.at(1))
sql << PAREN_CLOSE
when :'||'
if args.length > 1
sql << CONCAT
array_sql_append(sql, args)
else
literal_append(sql, args.at(0))
end
when :'B~'
sql << CAST_BITCOMP_OPEN
literal_append(sql, args.at(0))
sql << CAST_BITCOMP_CLOSE
else
super
end
end
# Use GROUP BY instead of DISTINCT ON if arguments are provided.
def distinct(*args)
args.empty? ? super : group(*args)
end
# Sets up the select methods to use SQL_CALC_FOUND_ROWS option.
#
# dataset.calc_found_rows.limit(10)
# # SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT 10
def calc_found_rows
clone(:calc_found_rows => true)
end
# Return a cloned dataset which will use LOCK IN SHARE MODE to lock returned rows.
def for_share
lock_style(:share)
end
# Adds full text filter
def full_text_search(cols, terms, opts = {})
filter(full_text_sql(cols, terms, opts))
end
# MySQL specific full text search syntax.
def full_text_sql(cols, terms, opts = {})
terms = terms.join(' ') if terms.is_a?(Array)
SQL::PlaceholderLiteralString.new("MATCH ? AGAINST (?#{" IN BOOLEAN MODE" if opts[:boolean]})", [Array(cols), terms], true)
end
# MySQL allows HAVING clause on ungrouped datasets.
def having(*cond, &block)
_filter(:having, *cond, &block)
end
# Transforms an CROSS JOIN to an INNER JOIN if the expr is not nil.
# Raises an error on use of :full_outer type, since MySQL doesn't support it.
def join_table(type, table, expr=nil, table_alias={}, &block)
type = :inner if (type == :cross) && !expr.nil?
raise(Sequel::Error, "MySQL doesn't support FULL OUTER JOIN") if type == :full_outer
super(type, table, expr, table_alias, &block)
end
# Transforms :natural_inner to NATURAL LEFT JOIN and straight to
# STRAIGHT_JOIN.
def join_type_sql(join_type)
case join_type
when :straight
STRAIGHT_JOIN
when :natural_inner
NATURAL_LEFT_JOIN
else
super
end
end
# Sets up the insert methods to use INSERT IGNORE.
# Useful if you have a unique key and want to just skip
# inserting rows that violate the unique key restriction.
#
# dataset.insert_ignore.multi_insert(
# [{:name => 'a', :value => 1}, {:name => 'b', :value => 2}]
# )
# # INSERT IGNORE INTO tablename (name, value) VALUES (a, 1), (b, 2)
def insert_ignore
clone(:insert_ignore=>true)
end
# Sets up the insert methods to use ON DUPLICATE KEY UPDATE
# If you pass no arguments, ALL fields will be
# updated with the new values. If you pass the fields you
# want then ONLY those field will be updated.
#
# Useful if you have a unique key and want to update
# inserting rows that violate the unique key restriction.
#
# dataset.on_duplicate_key_update.multi_insert(
# [{:name => 'a', :value => 1}, {:name => 'b', :value => 2}]
# )
# # INSERT INTO tablename (name, value) VALUES (a, 1), (b, 2)
# # ON DUPLICATE KEY UPDATE name=VALUES(name), value=VALUES(value)
#
# dataset.on_duplicate_key_update(:value).multi_insert(
# [{:name => 'a', :value => 1}, {:name => 'b', :value => 2}]
# )
# # INSERT INTO tablename (name, value) VALUES (a, 1), (b, 2)
# # ON DUPLICATE KEY UPDATE value=VALUES(value)
def on_duplicate_key_update(*args)
clone(:on_duplicate_key_update => args)
end
# MySQL specific syntax for inserting multiple values at once.
def multi_insert_sql(columns, values)
sql = LiteralString.new('VALUES ')
expression_list_append(sql, values.map{|r| Array(r)})
[insert_sql(columns, sql)]
end
# MySQL uses the nonstandard ` (backtick) for quoting identifiers.
def quoted_identifier_append(sql, c)
sql << BACKTICK << c.to_s << BACKTICK
end
# MySQL specific syntax for REPLACE (aka UPSERT, or update if exists,
# insert if it doesn't).
def replace_sql(*values)
clone(:replace=>true).insert_sql(*values)
end
# MySQL can emulate DISTINCT ON with its non-standard GROUP BY implementation,
# though the rows returned cannot be made deterministic through ordering.
def supports_distinct_on?
true
end
# MySQL supports GROUP BY WITH ROLLUP (but not CUBE)
def supports_group_rollup?
true
end
# MySQL does not support INTERSECT or EXCEPT
def supports_intersect_except?
false
end
# MySQL supports modifying joined datasets
def supports_modifying_joins?
true
end
# MySQL's DISTINCT ON emulation using GROUP BY does not respect the
# queries ORDER BY clause.
def supports_ordered_distinct_on?
false
end
# MySQL does support fractional timestamps in literal timestamps, but it
# ignores them. Also, using them seems to cause problems on 1.9. Since
# they are ignored anyway, not using them is probably best.
def supports_timestamp_usecs?
false
end
# Sets up the update methods to use UPDATE IGNORE.
# Useful if you have a unique key and want to just skip
# updating rows that violate the unique key restriction.
#
# dataset.update_ignore.update({:name => 'a', :value => 1})
# # UPDATE IGNORE tablename SET name = 'a', value = 1
def update_ignore
clone(:update_ignore=>true)
end
private
# MySQL supports the ORDER BY and LIMIT clauses for DELETE statements
def delete_clause_methods
DELETE_CLAUSE_METHODS
end
# Consider the first table in the joined dataset is the table to delete
# from, but include the others for the purposes of selecting rows.
def delete_from_sql(sql)
if joined_dataset?
sql << SPACE
source_list_append(sql, @opts[:from][0..0])
sql << FROM
source_list_append(sql, @opts[:from])
select_join_sql(sql)
else
super
end
end
# MySQL supports the IGNORE and ON DUPLICATE KEY UPDATE clauses for INSERT statements
def insert_clause_methods
INSERT_CLAUSE_METHODS
end
alias replace_clause_methods insert_clause_methods
# MySQL doesn't use the SQL standard DEFAULT VALUES.
def insert_columns_sql(sql)
values = opts[:values]
if values.is_a?(Array) && values.empty?
sql << EMPTY_COLUMNS
else
super
end
end
# MySQL supports INSERT IGNORE INTO
def insert_ignore_sql(sql)
sql << IGNORE if opts[:insert_ignore]
end
# MySQL supports UPDATE IGNORE
def update_ignore_sql(sql)
sql << IGNORE if opts[:update_ignore]
end
# If this is an replace instead of an insert, use replace instead
def insert_insert_sql(sql)
sql << (@opts[:replace] ? REPLACE : INSERT)
end
# MySQL supports INSERT ... ON DUPLICATE KEY UPDATE
def insert_on_duplicate_key_update_sql(sql)
if update_cols = opts[:on_duplicate_key_update]
update_vals = nil
if update_cols.empty?
update_cols = columns
elsif update_cols.last.is_a?(Hash)
update_vals = update_cols.last
update_cols = update_cols[0..-2]
end
sql << ON_DUPLICATE_KEY_UPDATE
c = false
co = COMMA
values = EQ_VALUES
endp = PAREN_CLOSE
update_cols.each do |col|
sql << co if c
quote_identifier_append(sql, col)
sql << values
quote_identifier_append(sql, col)
sql << endp
c ||= true
end
if update_vals
eq = EQ
update_vals.map do |col,v|
sql << co if c
quote_identifier_append(sql, col)
sql << eq
literal_append(sql, v)
c ||= true
end
end
end
end
# MySQL doesn't use the standard DEFAULT VALUES for empty values.
def insert_values_sql(sql)
values = opts[:values]
if values.is_a?(Array) && values.empty?
sql << EMPTY_VALUES
else
super
end
end
# MySQL allows a LIMIT in DELETE and UPDATE statements.
def limit_sql(sql)
if l = @opts[:limit]
sql << LIMIT
literal_append(sql, @opts[:limit])
end
end
alias delete_limit_sql limit_sql
alias update_limit_sql limit_sql
# Use 0 for false on MySQL
def literal_false
BOOL_FALSE
end
# Use 1 for true on MySQL
def literal_true
BOOL_TRUE
end
# MySQL does not support the SQL WITH clause for SELECT statements
def select_clause_methods
SELECT_CLAUSE_METHODS
end
# MySQL supports ROLLUP via nonstandard SQL syntax
def select_group_sql(sql)
if group = @opts[:group]
sql << GROUP_BY
expression_list_append(sql, group)
sql << WITH_ROLLUP if @opts[:group_options] == :rollup
end
end
# Support FOR SHARE locking when using the :share lock style.
def select_lock_sql(sql)
@opts[:lock] == :share ? (sql << FOR_SHARE) : super
end
# MySQL specific SQL_CALC_FOUND_ROWS option
def select_calc_found_rows_sql(sql)
sql << SQL_CALC_FOUND_ROWS if opts[:calc_found_rows]
end
# MySQL supports the ORDER BY and LIMIT clauses for UPDATE statements
def update_clause_methods
UPDATE_CLAUSE_METHODS
end
end
end
end
|