[Ruby-DBI-devel] patch to Pg.rb

[Brad H. <bh...@vp...>]

Hi,

I have a patch for Pg.rb which fixes problems handling backslashes in
strings.  Could someone please review/commit it?

Note: the second diff is necessary for proper quoting of placeholder
values.  The default quote() method in sql.rb was being used without
that change.

Thanks,
-Brad


--- Pg.rb       Wed Jul  3 13:11:23 2002
+++ /usr/local/lib/ruby/site_ruby/1.6/DBD/Pg/Pg.rb      Thu Aug 22
16:03:15 2002
@@ -304,6 +304,15 @@
          @connection.exec(sql)
        end
        
+       def quote(value)
+         case value
+         when String
+               "'#{ value.gsub(/\\/){ '\\\\' }.gsub(/'/){ '\\\'' } }'"
+         else
+               super
+         end
+       end
+       
        private # ----------------------------------------------------
 
        def initialize_autocommit
@@ -411,7 +420,7 @@
 
        def initialize(db, sql)
          @db  = db
-          @prep_sql = DBI::SQL::PreparedStatement.new(self, sql)
+          @prep_sql = DBI::SQL::PreparedStatement.new(@db, sql)
          @result = nil
          @bindvars = []
        end