/usr/lib/ruby/vendor_ruby/sequel/adapters/jdbc/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 | Sequel.require 'adapters/shared/mysql'
module Sequel
module JDBC
# Database and Dataset instance methods for MySQL specific
# support via JDBC.
module MySQL
# Database instance methods for MySQL databases accessed via JDBC.
module DatabaseMethods
include Sequel::MySQL::DatabaseMethods
LAST_INSERT_ID = 'SELECT LAST_INSERT_ID()'.freeze
private
# The database name for the given database. Need to parse it out
# of the connection string, since the JDBC does no parsing on the
# given connection string by default.
def database_name
u = URI.parse(uri.sub(/\Ajdbc:/, ''))
(m = /\/(.*)/.match(u.path)) && m[1]
end
# Get the last inserted id using LAST_INSERT_ID().
def last_insert_id(conn, opts={})
if stmt = opts[:stmt]
rs = stmt.getGeneratedKeys
begin
if rs.next
rs.getInt(1)
else
0
end
ensure
rs.close
end
else
statement(conn) do |stmt|
rs = stmt.executeQuery(LAST_INSERT_ID)
rs.next
rs.getInt(1)
end
end
end
# MySQL 5.1.12 JDBC adapter requires this to be true,
# and previous versions don't mind.
def requires_return_generated_keys?
true
end
# Convert tinyint(1) type to boolean
def schema_column_type(db_type)
db_type == 'tinyint(1)' ? :boolean : super
end
# By default, MySQL 'where id is null' selects the last inserted id.
# Turn that off unless explicitly enabled.
def setup_connection(conn)
super
sql = "SET SQL_AUTO_IS_NULL=0"
statement(conn){|s| log_yield(sql){s.execute(sql)}} unless opts[:auto_is_null]
conn
end
end
# Dataset class for MySQL datasets accessed via JDBC.
class Dataset < JDBC::Dataset
include Sequel::MySQL::DatasetMethods
# Use execute_insert to execute the replace_sql.
def replace(*args)
execute_insert(replace_sql(*args))
end
end
end
end
end
|