From 87fd08a98063303d4d97e2bdac7b212ae5248914 Mon Sep 17 00:00:00 2001
From: Constantin Michael <constantin@codesynthesis.com>
Date: Thu, 27 Oct 2011 12:36:03 +0200
Subject: Revert to manually quoting Oracle identifiers where necessary

---
 common/query/driver.cxx | 33 +++++++++++++++++++++++----------
 1 file changed, 23 insertions(+), 10 deletions(-)

(limited to 'common/query')

diff --git a/common/query/driver.cxx b/common/query/driver.cxx
index 1d19860..b94bed6 100644
--- a/common/query/driver.cxx
+++ b/common/query/driver.cxx
@@ -140,10 +140,11 @@ main (int argc, char* argv[])
     cout << "test 003" << endl;
     {
       transaction t (db->begin ());
-      result r (
-        db->query<person> (query::age + " >= 30 AND " +
-                           query::last_name + " = 'Doe'"));
-
+#ifndef DATABASE_ORACLE
+      result r (db->query<person> ("age >= 30 AND last = 'Doe'"));
+#else
+      result r (db->query<person> ("\"age\" >= 30 AND \"last\" = 'Doe'"));
+#endif
       print (r);
       t.commit ();
     }
@@ -156,9 +157,17 @@ main (int argc, char* argv[])
 
       const char* name = "Doe";
 
+#ifndef DATABASE_ORACLE
       result r (
-        db->query<person> (query::age + " >= " + query::_ref (30) + "AND " +
-                           query::last_name + " = " + query::_val (name)));
+        db->query<person> (
+          "age >= " + query::_ref (30) + "AND" +
+          "last = " + query::_val (name)));
+#else
+      result r (
+        db->query<person> (
+          "\"age\" >= " + query::_ref (30) + "AND" +
+          "\"last\" = " + query::_val (name)));
+#endif
 
       print (r);
       t.commit ();
@@ -173,8 +182,13 @@ main (int argc, char* argv[])
       string name;
       unsigned short age;
 
-      query q (query::age + " >= " + query::_ref (age) + "AND" +
-               query::last_name + " = " + query::_ref (name));
+#ifndef DATABASE_ORACLE
+      query q ("age >= " + query::_ref (age) + "AND" +
+               "last = " + query::_ref (name));
+#else
+      query q ("\"age\" >= " + query::_ref (age) + "AND" +
+               "\"last\" = " + query::_ref (name));
+#endif
 
       name = "Doe";
       age = 30;
@@ -354,8 +368,7 @@ main (int argc, char* argv[])
       // +
       //
       r = db->query<person> ((query::last_name == "Doe") +
-                             "ORDER BY" +
-                             query::age);
+                             "ORDER BY" + query::age);
       print (r);
 
       t.commit ();
-- 
cgit v1.1