Changeset 8942 for trunk/MagicSoft/Mars/msql

Timestamp:

06/12/08 16:02:55 (17 years ago)

Author:

tbretz

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/msql

Files:

• MSQLMagic.cc (modified) (3 diffs)
• MSQLMagic.h (modified) (1 diff)

trunk/MagicSoft/Mars/msql/MSQLMagic.cc

@@ -217 +217 @@
 // In Dummy mode no query is send an -1 is returned.
 //
-Int_t MSQLMagic::Insert(const char *table, const char *vars)
+Int_t MSQLMagic::Insert(const char *table, const char *vars, const char *where)
 {
     // Build query
@@ -224 +224 @@
     query += " SET ";
     query += vars;
+    if (!TString(where).IsNull())
+    {
+        query += ", ";
+        query += where;
+    }
 
     // Check for dummy mode
@@ -286 +291 @@
     return ExistStr(col, table, val) ?
         Update(table, vars, Form("%s=%s", col, val)) :
-        Insert(table, vars);
+        Insert(table, vars, Form("%s=%s", col, val));
 }
 

trunk/MagicSoft/Mars/msql/MSQLMagic.h

@@ -46 +46 @@
     Bool_t  ExistStr(const char *column, const char *table, const char *test);
 
-    Int_t Insert(const char *table, const char *vars);
+    Int_t Insert(const char *table, const char *vars, const char *where=0);
     Int_t Update(const char *table, const char *vars, const char *where);
     Int_t Delete(const char *table, const char *where);