Module: ArJdbc::HSQLDB
- Included in:
- H2
- Defined in:
- lib/arjdbc/hsqldb/adapter.rb
Defined Under Namespace
Modules: Column
Class Method Summary collapse
Instance Method Summary collapse
- #_execute(sql, name = nil) ⇒ Object
-
#adapter_name ⇒ Object
:nodoc:.
- #add_column(table_name, column_name, type, options = {}) ⇒ Object
-
#add_limit_offset!(sql, options) ⇒ Object
:nodoc:.
-
#change_column(table_name, column_name, type, options = {}) ⇒ Object
:nodoc:.
-
#change_column_default(table_name, column_name, default) ⇒ Object
:nodoc:.
- #last_insert_id ⇒ Object
- #modify_types(tp) ⇒ Object
-
#quote(value, column = nil) ⇒ Object
:nodoc:.
-
#quote_column_name(name) ⇒ Object
:nodoc:.
- #quote_string(str) ⇒ Object
- #quoted_false ⇒ Object
- #quoted_true ⇒ Object
- #remove_index(table_name, options = {}) ⇒ Object
-
#rename_column(table_name, column_name, new_column_name) ⇒ Object
:nodoc:.
- #rename_table(name, new_name) ⇒ Object
-
#tables ⇒ Object
override to filter out system tables that otherwise end up in db/schema.rb during migrations.
-
#type_to_sql(type, limit = nil, precision = nil, scale = nil) ⇒ Object
Maps logical Rails types to MySQL-specific data types.
Class Method Details
Instance Method Details
#_execute(sql, name = nil) ⇒ Object
140 141 142 143 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 140 def _execute(sql, name = nil) result = super ActiveRecord::ConnectionAdapters::JdbcConnection::insert?(sql) ? last_insert_id : result end |
#adapter_name ⇒ Object
:nodoc:
39 40 41 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 39 def adapter_name #:nodoc: 'Hsqldb' end |
#add_column(table_name, column_name, type, options = {}) ⇒ Object
101 102 103 104 105 106 107 108 109 110 111 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 101 def add_column(table_name, column_name, type, = {}) if option_not_null = [:null] == false option_not_null = .delete(:null) end add_column_sql = "ALTER TABLE #{quote_table_name(table_name)} ADD #{quote_column_name(column_name)} #{type_to_sql(type, [:limit], [:precision], [:scale])}" (add_column_sql, ) execute(add_column_sql) if option_not_null alter_column_sql = "ALTER TABLE #{quote_table_name(table_name)} ALTER #{quote_column_name(column_name)} NOT NULL" end end |
#add_limit_offset!(sql, options) ⇒ Object
:nodoc:
145 146 147 148 149 150 151 152 153 154 155 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 145 def add_limit_offset!(sql, ) #:nodoc: if sql =~ /^select/i offset = [:offset] || 0 bef = sql[7..-1] if limit = [:limit] sql.replace "SELECT LIMIT #{offset} #{limit} #{bef}" elsif offset > 0 sql.replace "SELECT LIMIT #{offset} 0 #{bef}" end end end |
#change_column(table_name, column_name, type, options = {}) ⇒ Object
:nodoc:
113 114 115 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 113 def change_column(table_name, column_name, type, = {}) #:nodoc: execute "ALTER TABLE #{table_name} ALTER COLUMN #{column_name} #{type_to_sql(type, [:limit])}" end |
#change_column_default(table_name, column_name, default) ⇒ Object
:nodoc:
117 118 119 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 117 def change_column_default(table_name, column_name, default) #:nodoc: execute "ALTER TABLE #{table_name} ALTER COLUMN #{column_name} SET DEFAULT #{quote(default)}" end |
#last_insert_id ⇒ Object
136 137 138 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 136 def last_insert_id Integer(select_value("CALL IDENTITY()")) end |
#modify_types(tp) ⇒ Object
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 43 def modify_types(tp) tp[:primary_key] = "INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) PRIMARY KEY" tp[:integer][:limit] = nil tp[:boolean][:limit] = nil # set text and float limits so we don't see odd scales tacked on # in migrations tp[:boolean] = { :name => "tinyint" } tp[:text][:limit] = nil tp[:float][:limit] = 17 if defined?(::Jdbc::H2) tp[:string][:limit] = 255 tp[:datetime] = { :name => "DATETIME" } tp[:timestamp] = { :name => "DATETIME" } tp[:time] = { :name => "TIME" } tp[:date] = { :name => "DATE" } tp end |
#quote(value, column = nil) ⇒ Object
:nodoc:
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 60 def quote(value, column = nil) # :nodoc: return value.quoted_id if value.respond_to?(:quoted_id) case value when String if respond_to?(:h2_adapter) && value.empty? "''" elsif column && column.type == :binary "'#{value.unpack("H*")}'" elsif column && (column.type == :integer || column.respond_to?(:primary) && column.primary && column.klass != String) value.to_i.to_s else "'#{quote_string(value)}'" end else super end end |
#quote_column_name(name) ⇒ Object
:nodoc:
80 81 82 83 84 85 86 87 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 80 def quote_column_name(name) #:nodoc: name = name.to_s if name =~ /[-]/ %Q{"#{name.upcase}"} else name end end |
#quote_string(str) ⇒ Object
89 90 91 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 89 def quote_string(str) str.gsub(/'/, "''") end |
#quoted_false ⇒ Object
97 98 99 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 97 def quoted_false '0' end |
#quoted_true ⇒ Object
93 94 95 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 93 def quoted_true '1' end |
#remove_index(table_name, options = {}) ⇒ Object
167 168 169 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 167 def remove_index(table_name, = {}) execute "DROP INDEX #{quote_column_name(index_name(table_name, ))}" end |
#rename_column(table_name, column_name, new_column_name) ⇒ Object
:nodoc:
121 122 123 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 121 def rename_column(table_name, column_name, new_column_name) #:nodoc: execute "ALTER TABLE #{table_name} ALTER COLUMN #{column_name} RENAME TO #{new_column_name}" end |
#rename_table(name, new_name) ⇒ Object
132 133 134 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 132 def rename_table(name, new_name) execute "ALTER TABLE #{name} RENAME TO #{new_name}" end |
#tables ⇒ Object
override to filter out system tables that otherwise end up in db/schema.rb during migrations. JdbcConnection#tables now takes an optional block filter so we can screen out rows corresponding to system tables. HSQLDB names its system tables SYSTEM.*, but H2 seems to name them without any kind of convention
163 164 165 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 163 def tables @connection.tables.select {|row| row.to_s !~ /^system_/i } end |
#type_to_sql(type, limit = nil, precision = nil, scale = nil) ⇒ Object
Maps logical Rails types to MySQL-specific data types.
126 127 128 129 130 |
# File 'lib/arjdbc/hsqldb/adapter.rb', line 126 def type_to_sql(type, limit = nil, precision = nil, scale = nil) return super if defined?(::Jdbc::H2) || type.to_s != 'integer' || limit == nil type end |