Changeset 8061 for trunk/MagicSoft/Mars/msql/MSQLMagic.cc

Timestamp:

10/13/06 09:58:15 (18 years ago)

Author:

tbretz

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/msql/MSQLMagic.cc (modified) (4 diffs)

trunk/MagicSoft/Mars/msql/MSQLMagic.cc

@@ -51 +51 @@
 //  On success the name of the key is returned.
 //
-TString MSQLMagic::QueryNameOfKey(TString col, const char *key)
+TString MSQLMagic::QueryValOf(TString col, const char *ext, const char *key)
 {
     if (col.EndsWith("KEY"))
@@ -58 +58 @@
         col.Remove(0, 1);
 
-    const TString query=Form("SELECT f%sName FROM %s WHERE f%sKEY=%s",
-                             col.Data(), col.Data(), col.Data(), key);
+    const TString query=Form("SELECT f%s%s FROM %s WHERE f%sKEY=%s",
+                             col.Data(), ext, col.Data(), col.Data(), key);
 
     TSQLResult *res = Query(query);
@@ -75 +75 @@
 // --------------------------------------------------------------------------
 //
+// Return the name corresponding to a key. If col starts with f or
+// end with KEY it is stripped.
+//
+//  If the query fails an empty string is returned.
+//
+//  On success the name of the key is returned.
+//
+TString MSQLMagic::QueryNameOfKey(TString col, const char *key)
+{
+    return QueryValOf(col, "Name", key);
+}
+
+// --------------------------------------------------------------------------
+//
+// Return the value corresponding to a key. If col starts with f or
+// end with KEY it is stripped.
+//
+//  If the query fails an empty string is returned.
+//
+//  On success the value of the key is returned.
+//
+TString MSQLMagic::QueryValOfKey(TString col, const char *key)
+{
+    return QueryValOf(col, "", key);
+}
+
+// --------------------------------------------------------------------------
+//
+//  return the key of f[col]KEY where f[col][ext]=[val]
+//
+//  return -1 if the query failed or the KEY was not found
+//  return  0 if the KEY could not be determined after inserting
+//  return the KEY in case of success
+//
+Int_t MSQLMagic::QueryKeyOf(const char *col, const char *ext, const char *val)
+{
+    const TString query1 = Form("SELECT f%sKEY FROM %s WHERE f%s%s='%s'",
+                                col, col, col, ext, val);
+
+    TSQLResult *res1 = Query(query1);
+    if (!res1)
+    {
+        cout << "ERROR - Query has failed: " << query1 << endl;
+        return -1;
+    }
+
+    TSQLRow *row=res1->Next();
+
+    const Int_t rc1 = row && (*row)[0] ? atoi((*row)[0]) : -1;
+    delete res1;
+    return rc1;
+}
+
+// --------------------------------------------------------------------------
+//
+//  return the key of f[col]KEY where f[col]=[val]
+//
+//  return -1 if the query failed or the KEY was not found
+//  return  0 if the KEY could not be determined after inserting
+//  return the KEY in case of success
+//
+Int_t MSQLMagic::QueryKeyOfVal(const char *col, const char *val)
+{
+    return QueryKeyOf(col, "", val);
+}
+
+// --------------------------------------------------------------------------
+//
 //  return the key of f[col]KEY where f[col]Name=[name]
 //
@@ -86 +154 @@
 Int_t MSQLMagic::QueryKeyOfName(const char *col, const char *name, Bool_t insert)
 {
-    const TString query1 = Form("SELECT f%sKEY FROM %s WHERE f%sName='%s'",
-                                col, col, col, name);
-
-    TSQLResult *res1 = Query(query1);
-    if (!res1)
-    {
-        cout << "ERROR - Query has failed: " << query1 << endl;
-        return -1;
-    }
-
-    TSQLRow *row=res1->Next();
-
-    const Int_t rc1 = row && (*row)[0] ? atoi((*row)[0]) : -1;
-
-    delete res1;
+    const Int_t rc1 = QueryKeyOf(col, "Name", name);
 
     if (rc1>=0)