Title: [521] trunk/activerecord-jdbc/lib: Add helper for boolean on postgres, and also fix the insert behavior.
Revision
521
Author
olabini
Date
2007-04-30 06:46:18 -0400 (Mon, 30 Apr 2007)

Log Message

Add helper for boolean on postgres, and also fix the insert behavior.

Modified Paths

Diff

Modified: trunk/activerecord-jdbc/lib/active_record/connection_adapters/jdbc_adapter.rb (520 => 521)


--- trunk/activerecord-jdbc/lib/active_record/connection_adapters/jdbc_adapter.rb	2007-04-30 10:20:02 UTC (rev 520)
+++ trunk/activerecord-jdbc/lib/active_record/connection_adapters/jdbc_adapter.rb	2007-04-30 10:46:18 UTC (rev 521)
@@ -111,6 +111,7 @@
                           lambda {|r| r['type_name'] =~ /^binary$/i}, ],
         :boolean     => [ lambda {|r| [Jdbc::Types::TINYINT].include?(r['data_type'].to_i)},
                           lambda {|r| r['type_name'] =~ /^bool/i},
+                          lambda {|r| r['data_type'] == '-7'},
                           lambda {|r| r['type_name'] =~ /^tinyint$/i},
                           lambda {|r| r['type_name'] =~ /^decimal$/i}],
       }

Modified: trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb (520 => 521)


--- trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb	2007-04-30 10:20:02 UTC (rev 520)
+++ trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb	2007-04-30 10:46:18 UTC (rev 521)
@@ -119,6 +119,17 @@
       Integer(select_value("SELECT currval('#{sequence_name}')"))
     end
 
+    def _execute(sql, name = nil)
+      log_no_bench(sql, name) do
+        case sql.strip
+        when /^(select|show)/i:
+          @connection.execute_query(sql)
+        else
+          @connection.execute_update(sql)
+        end
+      end
+    end
+    
     def quote(value, column = nil)
       if value.kind_of?(String) && column && column.type == :binary
         "'#{escape_bytea(value)}'"
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Reply via email to