Changeset 8589

Timestamp:

06/20/07 17:07:36 (17 years ago)

Author:

tbretz

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• msql/MSQLMagic.cc (modified) (1 diff)
• msql/MSQLMagic.h (modified) (1 diff)

trunk/MagicSoft/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2007/06/20 Thomas Bretz
+
+   * msql/MSQLMagic.[h,cc]:
+     - added a new function InsertUpdate
+
+
 
  2007/06/20 Daniela Dorner

trunk/MagicSoft/Mars/msql/MSQLMagic.cc

@@ -268 +268 @@
 // --------------------------------------------------------------------------
 //
+// An abbreviation for checking the existance with ExistStr and
+// calling insert or update respectively.
+//
+Int_t MSQLMagic::InsertUpdate(const char *table, const char *col, const char *val, const char *vars)
+{
+    return ExistStr(col, table, val) ?
+        Update(table, vars, Form("%s=%s", col, val)) :
+        Insert(table, vars);
+}
+
+// --------------------------------------------------------------------------
+//
 // An abbreviation for a Dalete-Query.
 //

trunk/MagicSoft/Mars/msql/MSQLMagic.h

@@ -49 +49 @@
     Int_t Update(const char *table, const char *vars, const char *where);
     Int_t Delete(const char *table, const char *where);
+    Int_t InsertUpdate(const char *table, const char *col, const char *val, const char *vars);
 
     void Delete(const Option_t *o) { TObject::Delete(o); }