/usr/lib/ruby/vendor_ruby/sequel/adapters/shared/cubrid.rb is in ruby-sequel 4.1.1-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 | Sequel.require 'adapters/utils/split_alter_table'
module Sequel
module Cubrid
module DatabaseMethods
extend Sequel::Database::ResetIdentifierMangling
include Sequel::Database::SplitAlterTable
AUTOINCREMENT = 'AUTO_INCREMENT'.freeze
COLUMN_DEFINITION_ORDER = [:auto_increment, :default, :null, :unique, :primary_key, :references]
def database_type
:cubrid
end
def indexes(table, opts=OPTS)
m = output_identifier_meth
m2 = input_identifier_meth
indexes = {}
metadata_dataset.
from(:db_index___i).
join(:db_index_key___k, :index_name=>:index_name, :class_name=>:class_name).
where(:i__class_name=>m2.call(table), :is_primary_key=>'NO').
order(:k__key_order).
select(:i__index_name, :k__key_attr_name___column, :is_unique).
each do |row|
index = indexes[m.call(row[:index_name])] ||= {:columns=>[], :unique=>row[:is_unique]=='YES'}
index[:columns] << m.call(row[:column])
end
indexes
end
def supports_savepoints?
false
end
def schema_parse_table(table_name, opts)
m = output_identifier_meth(opts[:dataset])
m2 = input_identifier_meth(opts[:dataset])
pks = metadata_dataset.
from(:db_index___i).
join(:db_index_key___k, :index_name=>:index_name, :class_name=>:class_name).
where(:i__class_name=>m2.call(table_name), :is_primary_key=>'YES').
order(:k__key_order).
select_map(:k__key_attr_name).
map{|c| m.call(c)}
metadata_dataset.
from(:db_attribute).
where(:class_name=>m2.call(table_name)).
order(:def_order).
select(:attr_name, :data_type___db_type, :default_value___default, :is_nullable___allow_null).
map do |row|
name = m.call(row.delete(:attr_name))
row[:allow_null] = row[:allow_null] == 'YES'
row[:primary_key] = pks.include?(name)
row[:type] = schema_column_type(row[:db_type])
[name, row]
end
end
def tables(opts=OPTS)
_tables('CLASS')
end
def views(opts=OPTS)
_tables('VCLASS')
end
private
def _tables(type)
m = output_identifier_meth
metadata_dataset.
from(:db_class).
where(:is_system_class=>'NO', :class_type=>type).
select_map(:class_name).
map{|c| m.call(c)}
end
def alter_table_op_sql(table, op)
case op[:op]
when :rename_column
"RENAME COLUMN #{quote_identifier(op[:name])} AS #{quote_identifier(op[:new_name])}"
when :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
"CHANGE COLUMN #{quote_identifier(op[:name])} #{column_definition_sql(op.merge(opts))}"
else
super
end
end
def alter_table_sql(table, op)
case op[:op]
when :drop_index
"ALTER TABLE #{quote_schema_table(table)} #{drop_index_sql(table, op)}"
else
super
end
end
def auto_increment_sql
AUTOINCREMENT
end
# CUBRID requires auto increment before primary key
def column_definition_order
COLUMN_DEFINITION_ORDER
end
# CUBRID requires FOREIGN KEY keywords before a column reference
def column_references_sql(column)
sql = super
sql = " FOREIGN KEY#{sql}" unless column[:columns]
sql
end
def connection_execute_method
:query
end
DATABASE_ERROR_REGEXPS = {
/Operation would have caused one or more unique constraint violations/ => UniqueConstraintViolation,
/The constraint of the foreign key .+ is invalid|Update\/Delete operations are restricted by the foreign key/ => ForeignKeyConstraintViolation,
/cannot be made NULL/ => NotNullConstraintViolation,
/Your transaction .+ has been unilaterally aborted by the system/ => SerializationFailure,
}.freeze
def database_error_regexps
DATABASE_ERROR_REGEXPS
end
# CUBRID is case insensitive, so don't modify identifiers
def identifier_input_method_default
nil
end
# CUBRID is case insensitive, so don't modify identifiers
def identifier_output_method_default
nil
end
# CUBRID does not support named column constraints.
def supports_named_column_constraints?
false
end
# CUBRID doesn't support booleans, it recommends using smallint.
def type_literal_generic_trueclass(column)
:smallint
end
# CUBRID uses clob for text types.
def uses_clob_for_text?
true
end
end
module DatasetMethods
SELECT_CLAUSE_METHODS = Sequel::Dataset.clause_methods(:select, %w'select distinct columns from join where group having compounds order limit')
LIMIT = Sequel::Dataset::LIMIT
COMMA = Sequel::Dataset::COMMA
BOOL_FALSE = '0'.freeze
BOOL_TRUE = '1'.freeze
def supports_join_using?
false
end
def supports_multiple_column_in?
false
end
def supports_timestamp_usecs?
false
end
# CUBRID supposedly supports TRUNCATE, but it appears not to work in my testing.
# Fallback to using DELETE.
def truncate
delete
nil
end
private
def literal_false
BOOL_FALSE
end
def literal_true
BOOL_TRUE
end
# CUBRID doesn't support CTEs or FOR UPDATE.
def select_clause_methods
SELECT_CLAUSE_METHODS
end
# CUBRID requires a limit to use an offset,
# and requires a FROM table if a limit is used.
def select_limit_sql(sql)
if @opts[:from] && (l = @opts[:limit])
sql << LIMIT
if o = @opts[:offset]
literal_append(sql, o)
sql << COMMA
end
literal_append(sql, l)
end
end
end
end
end
|