Changeset 492

Timestamp:

04/08/06 19:31:25 (3 years ago)

Author:

common

Message:

sqlhandler-postgres
- unescape escaped binary data received, added escapeBinary() and unescapeBinary()

Files:

• library/trunk/modules/sqlhandler-postgres/sqlhandler-postgres.cpp (modified) (3 diffs)
• library/trunk/modules/sqlhandler-postgres/sqlhandler-postgres.hpp (modified) (1 diff)

library/trunk/modules/sqlhandler-postgres/sqlhandler-postgres.cpp

@@ -156 +156 @@
-}
-
+string SQLHandlerPostgres::escapeBinary(string *str)
+{
+        
+        unsigned char *res;
+        size_t size;
+        res = PQescapeBytea((const unsigned char *)str->c_str(),str->size(),&size);
+        string result((char *)res,(int)size);
+        PQfreemem(res);
+        return result;
+}
+
+string SQLHandlerPostgres::unescapeBinary(string *str)
+{
+        
+        unsigned char *res;
+        size_t size;
+        res = PQunescapeBytea((unsigned char *)str->c_str(),&size);
+        string result((char *)res,(int)size);
+        PQfreemem(res);
+        return result;
+}
-
-
@@ -209 +230 @@
-                                        for ( i=0;i<PQnfields(res);i++ )
-                                        {
-
+
+
+
+
+
+
+
+
-                                        }
-                                        result.push_back(foo);
-
-                                }
-                        }
@@ -271 +298 @@
-    }
-}
+

library/trunk/modules/sqlhandler-postgres/sqlhandler-postgres.hpp

@@ -57 +57 @@
-                ~SQLHandlerPostgres();
-                bool runQuery(SQLQuery *query);
+                string escapeBinary(string *str);
+                string unescapeBinary(string *str);
+
-                bool Init();
-                bool Exit();