Ruby on Rails | Screencasts | Download | Documentation | Weblog | Community | Source

Changeset 9250

Show
Ignore:
Timestamp:
05/03/08 04:35:26 (5 months ago)
Author:
santana
Message:

* simplifications, thanks to Ruby/Informix 0.7.1
* 'immediate' replaces 'execute' in some cases
* copyright extended

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • adapters/informix/lib/active_record/connection_adapters/informix_adapter.rb

    r8320 r9250  
    1 # $Id: informix_adapter.rb,v 1.15 2007/12/06 01:43:11 santana Exp $ 
    2  
    3 # Copyright (c) 2006-2007, Gerardo Santana Gomez Garrido <gerardo.santana@gmail.com> 
     1# $Id: informix_adapter.rb,v 1.18 2008/04/16 14:51:34 santana Exp $ 
     2 
     3# Copyright (c) 2006-2008, Gerardo Santana Gomez Garrido <gerardo.santana@gmail.com> 
    44# All rights reserved. 
    55#  
     
    5252          value = self[c.name] 
    5353          next if ![:text, :binary].include? c.type || value.nil? || value == '' 
    54           connection.raw_connection.prepare(<<-end_sql) do |stmt| 
     54          connection.raw_connection.execute(<<-end_sql, StringIO.new(value)) 
    5555              UPDATE #{self.class.table_name} SET #{c.name} = ? 
    5656              WHERE #{self.class.primary_key} = #{quote_value(id)} 
    57             end_sql 
    58             stmt.execute(StringIO.new(value)) 
    59           end 
     57          end_sql 
    6058        end 
    6159      end 
     
    102100    end 
    103101 
    104     # This adapter requires the Informix driver for Ruby 
     102    # This adapter requires Ruby/Informix 
    105103    # http://ruby-informix.rubyforge.org 
    106104    # 
     
    114112      def initialize(db, logger) 
    115113        super 
    116         @ifx_version = db.prepare(<<-end_sql) do |stmt| 
    117             SELECT dbinfo('version', 'major') version FROM systables 
    118             WHERE tabid = 1 
    119           end_sql 
    120           stmt.execute['version'].to_i 
    121         end 
     114        @ifx_version = db.version.major.to_i 
    122115      end 
    123116 
     
    167160 
    168161      def execute(sql, name = nil) 
    169         log(sql, name) { @connection.execute(sql) } 
     162        log(sql, name) { @connection.immediate(sql) } 
    170163      end 
    171164 
     
    175168 
    176169      def insert(sql, name= nil, pk= nil, id_value= nil, sequence_name = nil) 
    177         log(sql, name) { @connection.execute(sql) } 
     170        execute(sql) 
    178171        id_value 
    179172      end 
     
    183176 
    184177      def begin_db_transaction 
    185         @connection.execute("begin work") 
     178        execute("begin work") 
    186179      end 
    187180 
     
    243236 
    244237      def drop_database(name) 
    245         @connection.execute("drop database #{name}") 
     238        execute("drop database #{name}") 
    246239      end 
    247240 
    248241      def create_database(name) 
    249         @connection.execute("create database #{name}") 
     242        execute("create database #{name}") 
    250243      end 
    251244