Module: ArJdbc::Informix

Included in:
ActiveRecord::ConnectionAdapters::InformixAdapter
Defined in:
lib/arjdbc/informix/adapter.rb

Defined Under Namespace

Modules: ColumnMethods

Constant Summary collapse

JdbcConnection = 
::ActiveRecord::ConnectionAdapters::InformixJdbcConnection
@@_lob_callback_added = 
nil

Class Method Summary collapse

Instance Method Summary collapse

Class Method Details

.column_selector ⇒ Object

See Also:

  • ActiveRecord::ConnectionAdapters::JdbcColumn#column_types


32
33
34
 
# File 'lib/arjdbc/informix/adapter.rb', line 32

def self.column_selector
  [ /informix/i, lambda { |cfg, column| column.extend(ColumnMethods) } ]
end

.jdbc_connection_class ⇒ Object

See Also:



39
40
41
 
# File 'lib/arjdbc/informix/adapter.rb', line 39

def self.jdbc_connection_class
  ::ActiveRecord::ConnectionAdapters::InformixJdbcConnection
end

Instance Method Details

#add_limit_offset!(sql, options) ⇒ Object 



90
91
92
93
94
95
96
97
 
# File 'lib/arjdbc/informix/adapter.rb', line 90

def add_limit_offset!(sql, options)
  if options[:limit]
    limit = "FIRST #{options[:limit]}" # SKIP available only in IDS >= 10 :
    offset = (db_major_version >= 10 && options[:offset] ? "SKIP #{options[:offset]}" : "")
    sql.sub!(/^\s*?select /i, "SELECT #{offset} #{limit} ")
  end
  sql
end

#create_table(name, options = {}) ⇒ Object 



120
121
122
123
 
# File 'lib/arjdbc/informix/adapter.rb', line 120

def create_table(name, options = {})
  super(name, options)
  execute("CREATE SEQUENCE #{name}_seq")
end

#default_sequence_name(table, column) ⇒ Object 



86
87
88
 
# File 'lib/arjdbc/informix/adapter.rb', line 86

def default_sequence_name(table, column)
  "#{table}_seq"
end

#drop_table(name) ⇒ Object 



130
131
132
133
 
# File 'lib/arjdbc/informix/adapter.rb', line 130

def drop_table(name)
  super(name)
  execute("DROP SEQUENCE #{name}_seq")
end

#jdbc_column_class ⇒ Object

See Also:



44
45
46
 
# File 'lib/arjdbc/informix/adapter.rb', line 44

def jdbc_column_class
  ::ActiveRecord::ConnectionAdapters::InformixColumn
end

#modify_types(types) ⇒ Object 



62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
 
# File 'lib/arjdbc/informix/adapter.rb', line 62

def modify_types(types)
  super(types)
  types[:primary_key] = "SERIAL PRIMARY KEY"
  types[:string]      = { :name => "VARCHAR", :limit => 255 }
  types[:integer]     = { :name => "INTEGER" }
  types[:float]       = { :name => "FLOAT" }
  types[:decimal]     = { :name => "DECIMAL" }
  types[:datetime]    = { :name => "DATETIME YEAR TO FRACTION(5)" }
  types[:timestamp]   = { :name => "DATETIME YEAR TO FRACTION(5)" }
  types[:time]        = { :name => "DATETIME HOUR TO FRACTION(5)" }
  types[:date]        = { :name => "DATE" }
  types[:binary]      = { :name => "BYTE" }
  types[:boolean]     = { :name => "BOOLEAN" }
  types
end

#next_sequence_value(sequence_name) ⇒ Object 



99
100
101
 
# File 'lib/arjdbc/informix/adapter.rb', line 99

def next_sequence_value(sequence_name)
  select_one("SELECT #{sequence_name}.nextval id FROM systables WHERE tabid=1")['id']
end

#prefetch_primary_key?(table_name = nil) ⇒ Boolean

Returns:

  • (Boolean) 


78
79
80
 
# File 'lib/arjdbc/informix/adapter.rb', line 78

def prefetch_primary_key?(table_name = nil)
  true
end

#quote(value, column = nil) ⇒ Object 



108
109
110
111
112
113
114
115
116
117
118
 
# File 'lib/arjdbc/informix/adapter.rb', line 108

def quote(value, column = nil)
  column_type = column && column.type
  if column_type == :binary || column_type == :text
    # LOBs are updated separately by an after_save trigger.
    "NULL"
  elsif column_type == :date
    "'#{value.mon}/#{value.day}/#{value.year}'"
  else
    super
  end
end

#quote_string(string) ⇒ Object

TODO: Add some smart quoting for newlines in string and text fields.



104
105
106
 
# File 'lib/arjdbc/informix/adapter.rb', line 104

def quote_string(string)
  string.gsub(/\'/, "''")
end

#remove_index(table_name, options = {}) ⇒ Object 



135
136
137
 
# File 'lib/arjdbc/informix/adapter.rb', line 135

def remove_index(table_name, options = {})
  @connection.execute_update("DROP INDEX #{index_name(table_name, options)}")
end

#rename_table(name, new_name) ⇒ Object 



125
126
127
128
 
# File 'lib/arjdbc/informix/adapter.rb', line 125

def rename_table(name, new_name)
  execute("RENAME TABLE #{name} TO #{new_name}")
  execute("RENAME SEQUENCE #{name}_seq TO #{new_name}_seq")
end

#select(sql, *rest) ⇒ Object 



139
140
141
142
 
# File 'lib/arjdbc/informix/adapter.rb', line 139

def select(sql, *rest)
  # Informix does not like "= NULL", "!= NULL", or "<> NULL".
  super(sql.gsub(/(!=|<>)\s*null/i, "IS NOT NULL").gsub(/=\s*null/i, "IS NULL"), *rest)
end

#supports_migrations? ⇒ Boolean

Returns:

  • (Boolean) 


82
83
84
 
# File 'lib/arjdbc/informix/adapter.rb', line 82

def supports_migrations?
  true
end