1 /**************************************************************************
2 * Copyright(c) 1998-1999, ALICE Experiment at CERN, All rights reserved. *
4 * Author: The ALICE Off-line Project. *
5 * Contributors are mentioned in the code where appropriate. *
7 * Permission to use, copy, modify and distribute this software and its *
8 * documentation strictly for non-commercial purposes is hereby granted *
9 * without fee, provided that the above copyright notice appears in all *
10 * copies and that both the copyright notice and this permission notice *
11 * appear in the supporting documentation. The authors make no claims *
12 * about the suitability of this software for any purpose. It is *
13 * provided "as is" without express or implied warranty. *
14 **************************************************************************/
16 /////////////////////////////////////////////////////////////////////////////////////////////////
19 // access class to a DataBase in an AliEn storage //
21 /////////////////////////////////////////////////////////////////////////////////////////////////
25 #include <TGridResult.h>
29 //#include <TSystem.h>
30 #include <TObjArray.h>
31 #include <TObjString.h>
35 #include "AliCDBEntry.h"
36 #include "AliCDBGrid.h"
41 //_____________________________________________________________________________
42 AliCDBGrid::AliCDBGrid(const char *gridUrl, const char *user, const char *dbFolder, const char *se) :
51 // if the same Grid is alreay active, skip connection
52 if (!gGrid || fGridUrl != gGrid->GridUrl()
53 || (( fUser != "" ) && ( fUser != gGrid->GetUser() )) ) {
54 // connection to the Grid
55 AliInfo("Connection to the Grid...");
57 AliInfo(Form("gGrid = %x; fGridUrl = %s; gGrid->GridUrl() = %s",gGrid,fGridUrl.Data(), gGrid->GridUrl()));
58 AliInfo(Form("fUser = %s; gGrid->GetUser() = %s",fUser.Data(), gGrid->GetUser()));
60 TGrid::Connect(fGridUrl.Data(),fUser.Data());
64 AliError("Connection failed!");
68 TString initDir(gGrid->Pwd(0));
69 if (fDBFolder[0] != '/') {
70 fDBFolder.Prepend(initDir);
73 // check DBFolder: trying to cd to DBFolder; if it does not exist, create it
74 if(!gGrid->Cd(fDBFolder.Data(),0)){
75 AliDebug(2,Form("Creating new folder <%s> ...",fDBFolder.Data()));
76 if(!gGrid->Mkdir(fDBFolder.Data(),"",0)){
77 AliError(Form("Cannot create folder <%s> !",fDBFolder.Data()));
80 AliDebug(2,Form("Folder <%s> found",fDBFolder.Data()));
83 // removes any '/' at the end of path, then append one '/'
84 while(fDBFolder.EndsWith("/")) fDBFolder.Remove(fDBFolder.Last('/'));
88 fBaseFolder = fDBFolder;
90 // return to the initial directory
91 gGrid->Cd(initDir.Data(),0);
94 //_____________________________________________________________________________
95 AliCDBGrid::~AliCDBGrid()
98 delete gGrid; gGrid=0;
102 //_____________________________________________________________________________
103 Bool_t AliCDBGrid::FilenameToId(TString& filename, AliCDBId& id) {
104 // build AliCDBId from full path filename (fDBFolder/path/Run#x_#y_v#z_s0.root)
106 if(filename.Contains(fDBFolder)){
107 filename = filename(fDBFolder.Length(),filename.Length()-fDBFolder.Length());
110 TString idPath = filename(0,filename.Last('/'));
112 if(!id.IsValid()) return kFALSE;
114 filename=filename(idPath.Length()+1,filename.Length()-idPath.Length());
117 // valid filename: Run#firstRun_#lastRun_v#version_s0.root
118 TRegexp keyPattern("^Run[0-9]+_[0-9]+_v[0-9]+_s0.root$");
119 keyPattern.Index(filename, &mSize);
122 // TODO backward compatibility ... maybe remove later!
124 TRegexp oldKeyPattern("^Run[0-9]+_[0-9]+_v[0-9]+.root$");
125 oldKeyPattern.Index(filename, &oldmSize);
127 AliDebug(2,Form("Bad filename <%s>.", filename.Data()));
130 AliDebug(2,Form("Old filename format <%s>.", filename.Data()));
131 id.SetSubVersion(-11); // TODO trick to ensure backward compatibility
135 id.SetSubVersion(-1); // TODO trick to ensure backward compatibility
138 filename.Resize(filename.Length() - sizeof(".root") + 1);
140 TObjArray* strArray = (TObjArray*) filename.Tokenize("_");
142 TString firstRunString(((TObjString*) strArray->At(0))->GetString());
143 id.SetFirstRun(atoi(firstRunString.Data() + 3));
144 id.SetLastRun(atoi(((TObjString*) strArray->At(1))->GetString()));
146 TString verString(((TObjString*) strArray->At(2))->GetString());
147 id.SetVersion(atoi(verString.Data() + 1));
154 //_____________________________________________________________________________
155 Bool_t AliCDBGrid::IdToFilename(const AliCDBId& id, TString& filename) const {
156 // build file name from AliCDBId (path, run range, version) and fDBFolder
158 if (!id.GetAliCDBRunRange().IsValid()) {
159 AliDebug(2,Form("Invalid run range <%d, %d>.",
160 id.GetFirstRun(), id.GetLastRun()));
164 if (id.GetVersion() < 0) {
165 AliDebug(2,Form("Invalid version <%d>.", id.GetVersion()));
169 filename = Form("Run%d_%d_v%d",
174 if (id.GetSubVersion() != -11) filename += "_s0"; // TODO to ensure backward compatibility
177 filename.Prepend(fDBFolder + id.GetPath() + '/');
182 //_____________________________________________________________________________
183 Bool_t AliCDBGrid::PrepareId(AliCDBId& id) {
184 // prepare id (version) of the object that will be stored (called by PutEntry)
186 TString initDir(gGrid->Pwd(0));
187 TString pathName= id.GetPath();
189 TString dirName(fDBFolder);
191 Bool_t dirExist=kFALSE;
193 // go to the path; if directory does not exist, create it
194 TObjArray *arrName=pathName.Tokenize("/");
195 for(int i=0;i<arrName->GetEntries();i++){
196 TString buffer((arrName->At(i))->GetName());
197 dirName+=buffer; dirName+="/";
198 dirExist=gGrid->Cd(dirName,0);
200 AliDebug(2,Form("Creating new folder <%s> ...",dirName.Data()));
201 if(!gGrid->Mkdir(dirName,"",0)){
202 AliError(Form("Cannot create directory <%s> !",dirName.Data()));
203 gGrid->Cd(initDir.Data());
209 gGrid->Cd(initDir,0);
212 AliCDBId anId; // the id got from filename
213 AliCDBRunRange lastRunRange(-1,-1); // highest runRange found
214 Int_t lastVersion=0; // highest version found
216 TGridResult *res = gGrid->Ls(dirName);
218 //loop on the files in the directory, look for highest version
219 for(int i=0; i < res->GetEntries(); i++){
220 filename=res->GetFileNamePath(i);
221 if (!FilenameToId(filename, anId)) continue;
222 if (anId.GetAliCDBRunRange().Overlaps(id.GetAliCDBRunRange()) && anId.GetVersion() > lastVersion) {
223 lastVersion = anId.GetVersion();
224 lastRunRange = anId.GetAliCDBRunRange();
230 id.SetVersion(lastVersion + 1);
233 TString lastStorage = id.GetLastStorage();
234 if(lastStorage.Contains(TString("new"), TString::kIgnoreCase) && id.GetVersion() > 1 ){
235 AliDebug(2, Form("A NEW object is being stored with version %d",
237 AliDebug(2, Form("and it will hide previously stored object with version %d!",
241 if(!lastRunRange.IsAnyRange() && !(lastRunRange.IsEqual(&id.GetAliCDBRunRange())))
242 AliWarning(Form("Run range modified w.r.t. previous version (Run%d_%d_v%d)",
243 lastRunRange.GetFirstRun(), lastRunRange.GetLastRun(), id.GetVersion()));
248 //_____________________________________________________________________________
249 AliCDBId* AliCDBGrid::GetId(const TObjArray& validFileIds, const AliCDBId& query) {
250 // look for the Id that matches query's requests (highest or exact version)
252 if(validFileIds.GetEntriesFast() < 1) {
254 } else if (validFileIds.GetEntriesFast() == 1) {
255 return dynamic_cast<AliCDBId*> (validFileIds.At(0));
258 TIter iter(&validFileIds);
263 while((anIdPtr = dynamic_cast<AliCDBId*> (iter.Next()))){
264 if(anIdPtr->GetPath() != query.GetPath()) continue;
266 //if(!CheckVersion(query, anIdPtr, result)) return NULL;
268 if (!query.HasVersion()){ // look for highest version
269 if(result && result->GetVersion() > anIdPtr->GetVersion()) continue;
270 if(result && result->GetVersion() == anIdPtr->GetVersion()) {
271 AliDebug(2,Form("More than one object valid for run %d, version %d!",
272 query.GetFirstRun(), anIdPtr->GetVersion()));
276 } else { // look for specified version
277 if(query.GetVersion() != anIdPtr->GetVersion()) continue;
278 if(result && result->GetVersion() == anIdPtr->GetVersion()){
279 AliDebug(2,Form("More than one object valid for run %d, version %d!",
280 query.GetFirstRun(), anIdPtr->GetVersion()));
292 //_____________________________________________________________________________
293 AliCDBEntry* AliCDBGrid::GetEntry(const AliCDBId& queryId) {
294 // get AliCDBEntry from the database
298 AliCDBId selectedId(queryId);
299 if (!selectedId.HasVersion()) {
300 // if version is not specified, first check the selection criteria list
301 GetSelection(&selectedId);
304 TObjArray validFileIds;
305 validFileIds.SetOwner(1);
307 // look for file matching query requests (path, runRange, version)
308 if(selectedId.GetFirstRun() == fRun &&
309 fPathFilter.Comprises(selectedId.GetAliCDBPath()) && fVersion < 0 && !fMetaDataFilter){
310 // look into list of valid files previously loaded with AliCDBStorage::FillValidFileIds()
311 AliDebug(2, Form("List of files valid for run %d and for path %s was loaded. Looking there!",
312 selectedId.GetFirstRun(), selectedId.GetPath().Data()));
313 dataId = GetId(fValidFileIds, selectedId);
316 // List of files valid for reqested run was not loaded. Looking directly into CDB
317 AliDebug(2, Form("List of files valid for run %d and for path %s was not loaded. Looking directly into CDB!",
318 selectedId.GetFirstRun(), selectedId.GetPath().Data()));
321 MakeQueryFilter(selectedId.GetFirstRun(), selectedId.GetLastRun(), 0, filter);
323 TString pattern = Form("%s/Run*", selectedId.GetPath().Data());
324 if(selectedId.GetVersion() >= 0) pattern += Form("_v%d*",selectedId.GetVersion());
326 AliDebug(2,Form("pattern: %s", pattern.Data()));
328 TGridResult *res = gGrid->Query(fDBFolder, pattern, filter, "");
329 AliCDBId validFileId;
330 for(int i=0; i<res->GetEntries(); i++){
331 TString filename = res->GetKey(i, "lfn");
332 if(filename == "") continue;
333 if(FilenameToId(filename, validFileId))
334 validFileIds.AddLast(validFileId.Clone());
337 dataId = GetId(validFileIds, selectedId);
340 if (!dataId) return NULL;
343 if (!IdToFilename(*dataId, filename)) {
344 AliDebug(2,Form("Bad data ID encountered! Subnormal error!"));
348 AliCDBEntry* anEntry = GetEntryFromFile(filename, dataId);
353 //_____________________________________________________________________________
354 AliCDBEntry* AliCDBGrid::GetEntryFromFile(TString& filename, AliCDBId* dataId){
355 // Get AliCBEntry object from file "filename"
357 AliDebug(2,Form("Opening file: %s",filename.Data()));
359 filename.Prepend("/alien");
360 TFile *file = TFile::Open(filename);
362 AliDebug(2,Form("Can't open file <%s>!", filename.Data()));
366 // get the only AliCDBEntry object from the file
367 // the object in the file is an AliCDBEntry entry named "AliCDBEntry"
369 AliCDBEntry* anEntry = dynamic_cast<AliCDBEntry*> (file->Get("AliCDBEntry"));
372 AliDebug(2,Form("Bad storage data: file does not contain an AliCDBEntry object!"));
377 // The object's Id is not reset during storage
378 // If object's Id runRange or version do not match with filename,
379 // it means that someone renamed file by hand. In this case a warning msg is issued.
382 AliCDBId entryId = anEntry->GetId();
383 Int_t tmpSubVersion = dataId->GetSubVersion();
384 dataId->SetSubVersion(entryId.GetSubVersion()); // otherwise filename and id may mismatch
385 if(!entryId.IsEqual(dataId)){
386 AliWarning(Form("Mismatch between file name and object's Id!"));
387 AliWarning(Form("File name: %s", dataId->ToString().Data()));
388 AliWarning(Form("Object's Id: %s", entryId.ToString().Data()));
390 dataId->SetSubVersion(tmpSubVersion);
393 anEntry->SetLastStorage("grid");
395 // close file, return retieved entry
396 file->Close(); delete file; file=0;
401 //_____________________________________________________________________________
402 TList* AliCDBGrid::GetEntries(const AliCDBId& queryId) {
403 // multiple request (AliCDBStorage::GetAll)
405 TList* result = new TList();
408 TObjArray validFileIds;
409 validFileIds.SetOwner(1);
411 Bool_t alreadyLoaded = kFALSE;
413 // look for file matching query requests (path, runRange)
414 if(queryId.GetFirstRun() == fRun &&
415 fPathFilter.Comprises(queryId.GetAliCDBPath()) && fVersion < 0 && !fMetaDataFilter){
416 // look into list of valid files previously loaded with AliCDBStorage::FillValidFileIds()
417 AliDebug(2,Form("List of files valid for run %d and for path %s was loaded. Looking there!",
418 queryId.GetFirstRun(), queryId.GetPath().Data()));
420 alreadyLoaded = kTRUE;
423 // List of files valid for reqested run was not loaded. Looking directly into CDB
424 AliDebug(2,Form("List of files valid for run %d and for path %s was not loaded. Looking directly into CDB!",
425 queryId.GetFirstRun(), queryId.GetPath().Data()));
428 MakeQueryFilter(queryId.GetFirstRun(), queryId.GetLastRun(), 0, filter);
430 TString pattern = Form("%s/Run*.root", queryId.GetPath().Data());
431 AliDebug(2,Form("pattern: %s", pattern.Data()));
433 TGridResult *res = gGrid->Query(fDBFolder, pattern, filter, "");
435 AliCDBId validFileId;
436 for(int i=0; i<res->GetEntries(); i++){
437 TString filename = res->GetKey(i, "lfn");
438 if(filename == "") continue;
439 if(FilenameToId(filename, validFileId))
440 validFileIds.AddLast(validFileId.Clone());
447 iter = new TIter(&fValidFileIds);
449 iter = new TIter(&validFileIds);
452 TObjArray selectedIds;
453 selectedIds.SetOwner(1);
455 // loop on list of valid Ids to select the right version to get.
456 // According to query and to the selection criteria list, version can be the highest or exact
460 AliCDBPath queryPath = queryId.GetAliCDBPath();
461 while((anIdPtr = dynamic_cast<AliCDBId*> (iter->Next()))){
462 AliCDBPath thisCDBPath = anIdPtr->GetAliCDBPath();
463 if(!(queryPath.Comprises(thisCDBPath)) || pathCopy.GetPath() == thisCDBPath.GetPath()) continue;
464 pathCopy = thisCDBPath;
466 // check the selection criteria list for this query
467 AliCDBId thisId(*anIdPtr);
468 thisId.SetVersion(queryId.GetVersion());
469 if(!thisId.HasVersion()) GetSelection(&thisId);
472 dataId = GetId(fValidFileIds, thisId);
474 dataId = GetId(validFileIds, thisId);
476 if(dataId) selectedIds.Add(dataId->Clone());
481 // selectedIds contains the Ids of the files matching all requests of query!
482 // All the objects are now ready to be retrieved
483 iter = new TIter(&selectedIds);
484 while((anIdPtr = dynamic_cast<AliCDBId*> (iter->Next()))){
486 if (!IdToFilename(*anIdPtr, filename)) {
487 AliDebug(2,Form("Bad data ID encountered! Subnormal error!"));
491 AliCDBEntry* anEntry = GetEntryFromFile(filename, anIdPtr);
493 if(anEntry) result->Add(anEntry);
501 //_____________________________________________________________________________
502 Bool_t AliCDBGrid::PutEntry(AliCDBEntry* entry) {
503 // put an AliCDBEntry object into the database
505 AliCDBId& id = entry->GetId();
507 // set version for the entry to be stored
508 if (!PrepareId(id)) return kFALSE;
510 // build filename from entry's id
512 if (!IdToFilename(id, filename)) {
513 AliError("Bad ID encountered! Subnormal error!");
517 TString folderToTag = Form("%s%s",
519 id.GetPath().Data());
521 // add CDB and CDB_MD tag to folder
522 // TODO how to check that folder has already tags?
523 AddTag(folderToTag,"CDB");
524 AddTag(folderToTag,"CDB_MD");
526 TDirectory* saveDir = gDirectory;
528 // specify SE to filename
529 TString fullFilename = Form("/alien%s?se=%s", filename.Data(), fSE.Data());
532 TFile *file = TFile::Open(fullFilename,"CREATE");
533 if(!file || !file->IsWritable()){
534 AliError(Form("Can't open file <%s>!", filename.Data()));
535 if(file && !file->IsWritable()) file->Close(); delete file; file=0;
541 entry->SetVersion(id.GetVersion());
543 // write object (key name: "AliCDBEntry")
544 Bool_t result = (entry->Write("AliCDBEntry") != 0);
545 if (!result) AliError(Form("Can't write entry to file <%s>!", filename.Data()));
548 if (saveDir) saveDir->cd(); else gROOT->cd();
549 file->Close(); delete file; file=0;
552 AliInfo(Form("CDB object stored into file %s", filename.Data()));
553 AliInfo(Form("using S.E. %s", fSE.Data()));
555 if(!TagFileId(filename, &id)){
556 AliInfo(Form("CDB tagging failed. Deleting file %s!",filename.Data()));
557 if(!gGrid->Rm(filename.Data()))
558 AliError("Can't delete file!");
562 TagFileMetaData(filename, entry->GetMetaData());
567 //_____________________________________________________________________________
568 Bool_t AliCDBGrid::AddTag(TString& folderToTag, const char* tagname){
569 // add "tagname" tag (CDB or CDB_MD) to folder where object will be stored
571 Bool_t result = kTRUE;
572 AliDebug(2, Form("adding %s tag to folder %s", tagname, folderToTag.Data()));
573 TString addTag = Form("addTag %s %s", folderToTag.Data(), tagname);
574 TGridResult *gridres = gGrid->Command(addTag.Data());
575 const char* resCode = gridres->GetKey(0,"__result__"); // '1' if success
576 if(resCode[0] != '1') {
577 AliError(Form("Couldn't add %s tags to folder %s !",
578 tagname, folderToTag.Data()));
585 //_____________________________________________________________________________
586 Bool_t AliCDBGrid::TagFileId(TString& filename, const AliCDBId* id){
587 // tag stored object in CDB table using object Id's parameters
589 TString addTagValue1 = Form("addTagValue %s CDB ", filename.Data());
590 TString addTagValue2 = Form("first_run=%d last_run=%d version=%d ",
594 TString addTagValue3 = Form("path_level_0=\"%s\" path_level_1=\"%s\" path_level_2=\"%s\"",
595 id->GetLevel0().Data(),
596 id->GetLevel1().Data(),
597 id->GetLevel2().Data());
598 TString addTagValue = Form("%s%s%s",
601 addTagValue3.Data());
603 Bool_t result = kFALSE;
604 AliDebug(2, Form("Tagging file. Tag command: %s", addTagValue.Data()));
605 TGridResult* res = gGrid->Command(addTagValue.Data());
606 const char* resCode = res->GetKey(0,"__result__"); // '1' if success
607 if(resCode[0] != '1') {
608 AliError(Form("Couldn't add CDB tag value to file %s !",
612 AliInfo("Object successfully tagged.");
620 //_____________________________________________________________________________
621 Bool_t AliCDBGrid::TagFileMetaData(TString& filename, const AliCDBMetaData* md){
622 // tag stored object in CDB table using object Id's parameters
624 TString addTagValue1 = Form("addTagValue %s CDB_MD ", filename.Data());
625 TString addTagValue2 = Form("object_classname=\"%s\" responsible=\"%s\" beam_period=%d ",
626 md->GetObjectClassName(),
627 md->GetResponsible(),
628 md->GetBeamPeriod());
629 TString addTagValue3 = Form("aliroot_version=\"%s\" comment=\"%s\"",
630 md->GetAliRootVersion(),
632 TString addTagValue = Form("%s%s%s",
635 addTagValue3.Data());
637 Bool_t result = kFALSE;
638 AliDebug(2, Form("Tagging file. Tag command: %s", addTagValue.Data()));
639 TGridResult* res = gGrid->Command(addTagValue.Data());
640 const char* resCode = res->GetKey(0,"__result__"); // '1' if success
641 if(resCode[0] != '1') {
642 AliWarning(Form("Couldn't add CDB_MD tag value to file %s !",
646 AliInfo("Object successfully tagged.");
652 //_____________________________________________________________________________
653 TList* AliCDBGrid::GetIdListFromFile(const char* fileName){
655 TString turl(fileName);
656 turl.Prepend("/alien" + fDBFolder);
657 turl += "?se="; turl += fSE.Data();
658 TFile *file = TFile::Open(turl);
660 AliError(Form("Can't open selection file <%s>!", turl.Data()));
664 TList *list = new TList();
672 keycycle = "AliCDBId;";
675 id = (AliCDBId*) file->Get(keycycle);
679 file->Close(); delete file; file=0;
686 //_____________________________________________________________________________
687 Bool_t AliCDBGrid::Contains(const char* path) const{
688 // check for path in storage's DBFolder
690 TString initDir(gGrid->Pwd(0));
691 TString dirName(fDBFolder);
692 dirName += path; // dirName = fDBFolder/path
693 Bool_t result=kFALSE;
694 if (gGrid->Cd(dirName,0)) result=kTRUE;
695 gGrid->Cd(initDir.Data(),0);
699 //_____________________________________________________________________________
700 void AliCDBGrid::QueryValidFiles()
702 // Query the CDB for files valid for AliCDBStorage::fRun
703 // fills list fValidFileIds with AliCDBId objects created from file name
706 MakeQueryFilter(fRun, fRun, fMetaDataFilter, filter);
708 TString pattern = Form("%s/Run*", fPathFilter.GetPath().Data());
709 if(fVersion >= 0) pattern += Form("_v%d*", fVersion);
711 AliDebug(2,Form("pattern: %s", pattern.Data()));
713 TGridResult *res = gGrid->Query(fDBFolder, pattern, filter, "");
715 AliCDBId validFileId;
716 for(int i=0; i<res->GetEntries(); i++){
717 TString filename = res->GetKey(i, "lfn");
718 if(filename == "") continue;
719 AliDebug(2,Form("Found valid file: %s", filename.Data()));
720 Bool_t result = FilenameToId(filename, validFileId);
722 fValidFileIds.AddLast(validFileId.Clone());
729 //_____________________________________________________________________________
730 void AliCDBGrid::MakeQueryFilter(Int_t firstRun, Int_t lastRun,
731 const AliCDBMetaData* md, TString& result) const
733 // create filter for file query
735 result = Form("CDB:first_run<=%d and CDB:last_run>=%d", firstRun, lastRun);
737 // if(version >= 0) {
738 // result += Form(" and CDB:version=%d", version);
740 // if(pathFilter.GetLevel0() != "*") {
741 // result += Form(" and CDB:path_level_0=\"%s\"", pathFilter.GetLevel0().Data());
743 // if(pathFilter.GetLevel1() != "*") {
744 // result += Form(" and CDB:path_level_1=\"%s\"", pathFilter.GetLevel1().Data());
746 // if(pathFilter.GetLevel2() != "*") {
747 // result += Form(" and CDB:path_level_2=\"%s\"", pathFilter.GetLevel2().Data());
751 if(md->GetObjectClassName()[0] != '\0') {
752 result += Form(" and CDB_MD:object_classname=\"%s\"", md->GetObjectClassName());
754 if(md->GetResponsible()[0] != '\0') {
755 result += Form(" and CDB_MD:responsible=\"%s\"", md->GetResponsible());
757 if(md->GetBeamPeriod() != 0) {
758 result += Form(" and CDB_MD:beam_period=%d", md->GetBeamPeriod());
760 if(md->GetAliRootVersion()[0] != '\0') {
761 result += Form(" and CDB_MD:aliroot_version=\"%s\"", md->GetAliRootVersion());
763 if(md->GetComment()[0] != '\0') {
764 result += Form(" and CDB_MD:comment=\"%s\"", md->GetComment());
767 AliDebug(2, Form("filter: %s",result.Data()));
771 //_____________________________________________________________________________
772 Int_t AliCDBGrid::GetLatestVersion(const char* path, Int_t run){
773 // get last version found in the database valid for run and path
775 TObjArray validFileIds;
776 validFileIds.SetOwner(1);
778 AliCDBPath aCDBPath(path);
779 if(!aCDBPath.IsValid() || aCDBPath.IsWildcard()) {
780 AliError(Form("Invalid path in request: %s", path));
783 AliCDBId query(path, run, run, -1, -1);
784 AliCDBId* dataId = 0;
786 // look for file matching query requests (path, runRange, version)
787 if(run == fRun && fPathFilter.Comprises(aCDBPath) && fVersion < 0){
788 // look into list of valid files previously loaded with AliCDBStorage::FillValidFileIds()
789 AliDebug(2, Form("List of files valid for run %d and for path %s was loaded. Looking there!",
791 dataId = GetId(fValidFileIds, query);
792 if (!dataId) return -1;
793 return dataId->GetVersion();
796 // List of files valid for reqested run was not loaded. Looking directly into CDB
797 AliDebug(2, Form("List of files valid for run %d and for path %s was not loaded. Looking directly into CDB!",
801 MakeQueryFilter(run, run, 0, filter);
803 TString pattern = Form("%s/Run*.root", path);
804 AliDebug(2,Form("pattern: %s", pattern.Data()));
806 TGridResult *res = gGrid->Query(fDBFolder, pattern, filter, "");
807 AliCDBId validFileId;
808 for(int i=0; i<res->GetEntries(); i++){
809 TString filename = res->GetKey(i, "lfn");
810 if(filename == "") continue;
811 if(FilenameToId(filename, validFileId))
812 validFileIds.AddLast(validFileId.Clone());
816 dataId = GetId(validFileIds, query);
817 if (!dataId) return -1;
819 return dataId->GetVersion();
823 //_____________________________________________________________________________
824 Int_t AliCDBGrid::GetLatestSubVersion(const char* /*path*/, Int_t /*run*/, Int_t /*version*/){
825 // get last subversion found in the database valid for run and path
826 AliError("Objects in GRID storage have no sub version!");
831 /////////////////////////////////////////////////////////////////////////////////////////////////
833 // AliCDBGrid factory //
835 /////////////////////////////////////////////////////////////////////////////////////////////////
837 ClassImp(AliCDBGridFactory)
839 //_____________________________________________________________________________
840 Bool_t AliCDBGridFactory::Validate(const char* gridString) {
841 // check if the string is valid Grid URI
843 // pattern: alien://hostName:Port;user;dbPath;SE
844 // example of a valid pattern:
845 // "alien://aliendb4.cern.ch:9000;colla;DBTest;ALICE::CERN::Server"
846 // TRegexp gridPattern("^alien://.+:[0-9]+;[a-zA-Z0-9_-.]+;.+;.+$");
847 TRegexp gridPattern("^alien://.+$");
849 return TString(gridString).Contains(gridPattern);
852 //_____________________________________________________________________________
853 AliCDBParam* AliCDBGridFactory::CreateParameter(const char* gridString) {
854 // create AliCDBGridParam class from the URI string
856 if (!Validate(gridString)) {
859 //TString buffer(gridString + sizeof("alien://") - 1);
860 TString buffer(gridString);
862 TString gridUrl = "alien://";
864 TString dbFolder = "DBGrid";
865 TString se = "ALICE::CERN::se01";
867 TObjArray *arr = buffer.Tokenize('?');
871 while((str = (TObjString*) iter.Next())){
872 TString entry(str->String());
873 Int_t indeq = entry.Index('=');
875 if(entry.BeginsWith("alien://")) { // maybe it's a gridUrl!
879 AliError(Form("Invalid entry! %s",entry.Data()));
884 TString key = entry(0,indeq);
885 TString value = entry(indeq+1,entry.Length()-indeq);
887 if(key.Contains("grid",TString::kIgnoreCase)) {
890 else if (key.Contains("user",TString::kIgnoreCase)){
893 else if (key.Contains("folder",TString::kIgnoreCase)){
896 else if (key.Contains("se",TString::kIgnoreCase)){
900 AliError(Form("Invalid entry! %s",entry.Data()));
905 AliDebug(2, Form("gridUrl: %s",gridUrl.Data()));
906 AliDebug(2, Form("user: %s",user.Data()));
907 AliDebug(2, Form("dbFolder: %s",dbFolder.Data()));
908 AliDebug(2, Form("s.e.: %s",se.Data()));
910 return new AliCDBGridParam(gridUrl.Data(), user.Data(), dbFolder.Data(), se.Data());
913 //_____________________________________________________________________________
914 AliCDBStorage* AliCDBGridFactory::Create(const AliCDBParam* param) {
915 // create AliCDBGrid storage instance from parameters
917 AliCDBGrid *grid = 0;
918 if (AliCDBGridParam::Class() == param->IsA()) {
920 const AliCDBGridParam* gridParam = (const AliCDBGridParam*) param;
921 grid = new AliCDBGrid(gridParam->GridUrl().Data(),
922 gridParam->GetUser().Data(),
923 gridParam->GetDBFolder().Data(),
924 gridParam->GetSE().Data());
935 /////////////////////////////////////////////////////////////////////////////////////////////////
937 // AliCDBGrid Parameter class // //
939 /////////////////////////////////////////////////////////////////////////////////////////////////
941 ClassImp(AliCDBGridParam)
943 //_____________________________________________________________________________
944 AliCDBGridParam::AliCDBGridParam():
951 // default constructor
955 //_____________________________________________________________________________
956 AliCDBGridParam::AliCDBGridParam(const char* gridUrl,
958 const char* dbFolder,
970 TString uri = Form("%s?User=%s?DBFolder=%s?SE=%s",
971 fGridUrl.Data(), fUser.Data(),
972 fDBFolder.Data(), fSE.Data());
977 //_____________________________________________________________________________
978 AliCDBGridParam::~AliCDBGridParam() {
983 //_____________________________________________________________________________
984 AliCDBParam* AliCDBGridParam::CloneParam() const {
987 return new AliCDBGridParam(fGridUrl.Data(), fUser.Data(),
988 fDBFolder.Data(), fSE.Data());
991 //_____________________________________________________________________________
992 ULong_t AliCDBGridParam::Hash() const {
993 // return Hash function
995 return fGridUrl.Hash()+fUser.Hash()+fDBFolder.Hash()+fSE.Hash();
998 //_____________________________________________________________________________
999 Bool_t AliCDBGridParam::IsEqual(const TObject* obj) const {
1000 // check if this object is equal to AliCDBParam obj
1006 if (AliCDBGridParam::Class() != obj->IsA()) {
1010 AliCDBGridParam* other = (AliCDBGridParam*) obj;
1012 if(fGridUrl != other->fGridUrl) return kFALSE;
1013 if(fUser != other->fUser) return kFALSE;
1014 if(fDBFolder != other->fDBFolder) return kFALSE;
1015 if(fSE != other->fSE) return kFALSE;