new classes that were automatically generated from mysql tables

[u/mrichter/AliRoot.git] / PHOS / AliDBPPRS.cxx

diff --git a/PHOS/AliDBPPRS.cxx b/PHOS/AliDBPPRS.cxx
new file mode 100644 (file)
index 0000000..0eceb55
--- /dev/null
+++ b/PHOS/AliDBPPRS.cxx
@@ -0,0 +1,94 @@
+/**************************************************************************
+ * Copyright(c) 1998-1999, ALICE Experiment at CERN, All rights reserved. *
+ *                                                                        *
+ * Author: The ALICE Off-line Project.                                    *
+ * Contributors are mentioned in the code where appropriate.              *
+ *                                                                        *
+ * Permission to use, copy, modify and distribute this software and its   *
+ * documentation strictly for non-commercial purposes is hereby granted   *
+ * without fee, provided that the above copyright notice appears in all   *
+ * copies and that both the copyright notice and this permission notice   *
+ * appear in the supporting documentation. The authors make no claims     *
+ * about the suitability of this software for any purpose. It is          *
+ * provided "as is" without express or implied warranty.                  *
+ **************************************************************************/
+ 
+/* $Id$ */
+ 
+//_________________________________________________________________________
+// DB Class for table PPRS:
+//
+//*-- Author: Yves Schutz (SUBATECH)
+//////////////////////////////////////////////////////////////////////////////
+ 
+#include <stdlib.h> 
+#include <iostream.h> 
+ 
+// --- ROOT system ---
+#include "TSQLServer.h" 
+#include "TSQLRow.h" 
+#include "TSQLResult.h" 
+#include "TDatime.h" 
+ 
+// --- Standard library ---
+ 
+// --- AliRoot header files ---  
+#include "AliDBPPRS.h" 
+ 
+ClassImp(AliDBPPRS)
+//____________________________________________________________________________
+AliDBPPRS::AliDBPPRS()
+{   
+  fCurrentEntry = 1 ; // first valid entry (0 = labels)
+  fNfields = 12 ;
+  fFields = new TString[12]; 
+  fFields[0] = "RUN"; 
+  fFields[1] = "EVENT"; 
+  fFields[2] = "WORKER"; 
+  fFields[3] = "STATUS"; 
+  fFields[4] = "DATE"; 
+  fFields[5] = "STORAGE"; 
+  fFields[6] = "ID"; 
+  fFields[7] = "POS"; 
+  fFields[8] = "SIZE"; 
+  fFields[9] = "FTP"; 
+  fFields[10] = "LOG"; 
+  fFields[11] = "COMMENT"; 
+}   
+//____________________________________________________________________________
+AliDBPPRS::~AliDBPPRS()
+{   
+  delete[] fFields ;
+}   
+//____________________________________________________________________________
+void AliDBPPRS::GetEntry(Option_t * opt)
+{   
+   // Retrieves one single row from the table   //  opt = first : retrieves first entry 
+   //  opt = last  : retrieves last entry 
+   //  opt = next  : retrieves next to current entry 
+  TSQLServer * mysql = TSQLServer::Connect("mysql://ccmysql.in2p3.fr:3306/alice", "schutz", "po2hgwy") ;
+  TSQLResult * result = mysql->Query("SELECT * FROM PPRS") ; 
+  Int_t count = result->GetRowCount() ; 
+  if ( !strcmp(opt, "first") ) fCurrentEntry = 1 ; 
+  if ( !strcmp(opt, "last") ) fCurrentEntry = count ; 
+  if ( fCurrentEntry > count ) fCurrentEntry = 1 ; 
+  Int_t i; 
+  Int_t end = fCurrentEntry ; 
+  TSQLRow * row = 0 ; 
+  for ( i = 0 ; i < end ; i++ ) {
+     fCurrentEntry++ ; 
+    row = result->Next() ; 
+  }   
+    fRUN = atoi(row->GetField(0)) ; 
+    fEVENT = atoi(row->GetField(1)) ; 
+    fWORKER = row->GetField(2) ; 
+    fSTATUS = row->GetField(3) ; 
+    fDATE = TDatime::TDatime(row->GetField(4)) ; 
+    fSTORAGE = row->GetField(5) ; 
+    fID = row->GetField(6) ; 
+    fPOS = atoi(row->GetField(7)) ; 
+    fSIZE = atoi(row->GetField(8)) ; 
+    fFTP = row->GetField(9) ; 
+    fLOG = row->GetField(10) ; 
+    fCOMMENT = row->GetField(11) ; 
+}