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