Title: [658] trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb: fixed postgres adapter to recognize some more syntaxes for execute_update or execute_query
Revision
658
Author
tirsen
Date
2007-06-29 10:50:21 -0400 (Fri, 29 Jun 2007)

Log Message

fixed postgres adapter to recognize some more syntaxes for execute_update or execute_query

Modified Paths

Diff

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


--- trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb	2007-06-25 09:47:25 UTC (rev 657)
+++ trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb	2007-06-29 14:50:21 UTC (rev 658)
@@ -192,13 +192,17 @@
       end  
     end
     
-    def _execute(sql, name = nil)
-        case sql.strip
-        when /^(select|show)/i:
-          @connection.execute_query(sql)
-        else
-          @connection.execute_update(sql)
-        end
+     def _execute(sql, name = nil)
+      case sql.strip
+      when /^insert/i:
+        @connection.execute_update(sql)
+      when /^update/i:
+        @connection.execute_update(sql)
+      when /^\(?\s*(select|show)/i:
+        @connection.execute_query(sql)
+      else
+        @connection.execute_update(sql)
+      end
     end
     
     # SELECT DISTINCT clause for a given set of columns and a given ORDER BY clause.
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Reply via email to