/usr/lib/ruby/vendor_ruby/sequel/adapters/jdbc/mysql.rb is in ruby-sequel 4.15.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 | Sequel::JDBC.load_driver('com.mysql.jdbc.Driver', :MySQL)
Sequel.require 'adapters/shared/mysql'
module Sequel
module JDBC
Sequel.synchronize do
DATABASE_SETUP[:mysql] = proc do |db|
db.extend(Sequel::JDBC::MySQL::DatabaseMethods)
db.extend_datasets Sequel::MySQL::DatasetMethods
com.mysql.jdbc.Driver
end
end
# Database and Dataset instance methods for MySQL specific
# support via JDBC.
module MySQL
# Database instance methods for MySQL databases accessed via JDBC.
module DatabaseMethods
extend Sequel::Database::ResetIdentifierMangling
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
# MySQL exception handling with SQLState is less accurate than with regexps.
def database_exception_use_sqlstates?
false
end
# Raise a disconnect error if the SQL state of the cause of the exception indicates so.
def disconnect_error?(exception, opts)
exception.message =~ /\ACommunications link failure/ || super
end
# Get the last inserted id using LAST_INSERT_ID().
def last_insert_id(conn, opts=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 generated keys
# and previous versions don't mind.
def execute_statement_insert(stmt, sql)
stmt.executeUpdate(sql, JavaSQL::Statement.RETURN_GENERATED_KEYS)
end
# Return generated keys for insert statements.
def prepare_jdbc_statement(conn, sql, opts)
opts[:type] == :insert ? conn.prepareStatement(sql, JavaSQL::Statement.RETURN_GENERATED_KEYS) : super
end
# Convert tinyint(1) type to boolean
def schema_column_type(db_type)
db_type =~ /\Atinyint\(1\)/ ? :boolean : super
end
# Run the default connection setting SQL statements.
# Apply the connectiong setting SQLs for every new connection.
def setup_connection(conn)
mysql_connection_setting_sqls.each{|sql| statement(conn){|s| log_yield(sql){s.execute(sql)}}}
super
end
end
end
end
end
|