157 |
}; |
}; |
158 |
|
|
159 |
/** |
/** |
160 |
|
* Set the autoboot flag |
161 |
|
* |
162 |
|
*/ |
163 |
|
void PamelaDBOperations::SetAutoBoot(Bool_t dbg){ |
164 |
|
AUTOBOOT = dbg; |
165 |
|
}; |
166 |
|
|
167 |
|
/** |
168 |
* Set the nofrag flag |
* Set the nofrag flag |
169 |
* |
* |
170 |
*/ |
*/ |
303 |
UInt_t nevent = 0; |
UInt_t nevent = 0; |
304 |
UInt_t pktlast = 0; |
UInt_t pktlast = 0; |
305 |
UInt_t obtlast = 0; |
UInt_t obtlast = 0; |
306 |
UInt_t t_pktlast = 0; |
Long64_t t_pktlast = 0LL; |
307 |
UInt_t t_obtlast = 0; |
// UInt_t t_obtlast = 0; |
308 |
UInt_t upperpkt2 = 0; |
Long64_t t_obtlast = 0LL; |
309 |
ULong64_t upperobt2 = 0; |
Long64_t upperpkt2 = 0LL; |
310 |
|
Long64_t upperobt2 = 0LL; |
311 |
UInt_t zomp = 0; |
UInt_t zomp = 0; |
312 |
UInt_t jump = 50000; // was 5000 |
UInt_t jump = 50000; // was 5000 |
313 |
EventCounter *code=0; |
EventCounter *code=0; |
314 |
// |
// |
315 |
UInt_t deltapkt = 5000; |
Long64_t deltapkt = 5000LL; |
316 |
ULong64_t deltaobt = 50000; |
Long64_t deltaobt = 50000LL; |
317 |
// |
// |
318 |
// pcksList packetsNames; |
// pcksList packetsNames; |
319 |
// pcksList::iterator Iter; |
// pcksList::iterator Iter; |
351 |
upperobt = OBT(obtlast); |
upperobt = OBT(obtlast); |
352 |
upperentry = nevent-1; |
upperentry = nevent-1; |
353 |
// |
// |
354 |
if ( IsDebug() ) printf(" First entries are: OBT %llu pkt_num %i \n",obtfirst,pktfirst); |
if ( IsDebug() ) printf(" First entries are: OBT %i pkt_num %i \n",obtfirst,pktfirst); |
355 |
// |
// |
356 |
if ( IsDebug() ) printf(" Last entries are: OBT %llu pkt_num %i entry %i\n",upperobt,upperpkt,upperentry); |
if ( IsDebug() ) printf(" Last entries are: OBT %lld pkt_num %lld entry %i\n",upperobt,upperpkt,upperentry); |
357 |
// |
// |
358 |
if ( (PKT(pktlast) < PKT(pktfirst) && OBT(obtlast) > OBT(obtfirst)) || (PKT(pktlast) > PKT(pktfirst) && OBT(obtlast) < OBT(obtfirst)) ) return(1); |
if ( (PKT(pktlast) < PKT(pktfirst) && OBT(obtlast) > OBT(obtfirst)) || (PKT(pktlast) > PKT(pktfirst) && OBT(obtlast) < OBT(obtfirst)) ) return(1); |
359 |
// |
// |
384 |
upperpkt2 = PKT(ph->GetCounter()); |
upperpkt2 = PKT(ph->GetCounter()); |
385 |
upperobt2 = OBT(ph->GetOrbitalTime()); |
upperobt2 = OBT(ph->GetOrbitalTime()); |
386 |
// |
// |
387 |
if ( (t_pktlast < upperpkt && t_obtlast > upperobt) || (t_pktlast < upperpkt2 && t_obtlast > upperobt2) ) throw -13; |
if ( (t_pktlast < upperpkt && t_obtlast > upperobt) || (t_pktlast < upperpkt2 && t_obtlast > upperobt2) ){ |
388 |
|
if ( IsDebug() ) printf(" .-. upperpkt2 %lld upperobt2 %lld \n",upperpkt2,upperobt2); |
389 |
|
if ( IsDebug() ) printf(" .-. upperpkt %lld t_pktlast %lld upperobt %lld t_obtlast %lld \n",upperpkt,t_pktlast,upperobt,t_obtlast); |
390 |
|
if ( IsDebug() ) printf(" .-. jump %i zomp %i upperpkt %lld pktlast %u upperobt %lld obtlast %u last entry is %i \n",jump,zomp,upperpkt,pktlast,upperobt,obtlast,i); |
391 |
|
throw -13; |
392 |
|
}; |
393 |
// |
// |
394 |
if ( t_pktlast < upperpkt && t_obtlast < upperobt && t_pktlast < upperpkt2 && t_obtlast < upperobt2 ){ |
if ( t_pktlast < upperpkt && t_obtlast < upperobt && t_pktlast < upperpkt2 && t_obtlast < upperobt2 ){ |
395 |
zomp = i + jump + 1; |
zomp = i + jump + 1; |
396 |
if ( zomp > nevent-2 ) zomp = nevent - 2; |
if ( zomp > nevent-2 ) zomp = nevent - 2; |
397 |
if ( IsDebug() ) printf(" .-. jump %i zomp %i upperpkt %i pktlast %i upperobt %llu obtlast %u last entry is %i \n",jump,zomp,upperpkt,pktlast,upperobt,obtlast,i); |
if ( IsDebug() ) printf(" .-. jump %i zomp %i upperpkt %lld pktlast %i upperobt %lld obtlast %u last entry is %i \n",jump,zomp,upperpkt,pktlast,upperobt,obtlast,i); |
398 |
break; |
break; |
399 |
}; |
}; |
400 |
// |
// |
429 |
// |
// |
430 |
rhev = rh->GetEntries(); |
rhev = rh->GetEntries(); |
431 |
rtev = rt->GetEntries(); |
rtev = rt->GetEntries(); |
432 |
UInt_t sobtt = 0; |
Long64_t sobtt = 0LL; |
433 |
UInt_t sobth = 0; |
Long64_t sobth = 0LL; |
434 |
UInt_t spktt = 0; |
Long64_t spktt = 0LL; |
435 |
UInt_t spkth = 0; |
Long64_t spkth = 0LL; |
436 |
UInt_t pktt = 0; |
Long64_t pktt = 0LL; |
437 |
ULong64_t obtt = 0; |
Long64_t obtt = 0LL; |
438 |
UInt_t pkth = 0; |
Long64_t pkth = 0LL; |
439 |
ULong64_t obth = 0; |
Long64_t obth = 0LL; |
440 |
// |
// |
441 |
T->GetEntry(upperentry); |
T->GetEntry(upperentry); |
442 |
code = eh->GetCounter(); |
code = eh->GetCounter(); |
456 |
obth = OBT(phh->GetOrbitalTime()); |
obth = OBT(phh->GetOrbitalTime()); |
457 |
}; |
}; |
458 |
// |
// |
459 |
if ( IsDebug() ) printf(" rhev before %i ph %i upperp %i oh %llu uppero %llu \n",rhev,pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" rhev before %i ph %lld upperp %lld oh %lld uppero %lld \n",rhev,pkth,upperpkt,obth,upperobt); |
460 |
if ( pkth > upperpkt && obth > upperobt ){ |
if ( pkth > upperpkt && obth > upperobt ){ |
461 |
if ( IsDebug() ) printf(" Upper limits extended to include last header: ph %i upperp %i oh %llu uppero %llu \n",pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" Upper limits extended to include last header: ph %lld upperp %lld oh %lld uppero %lld \n",pkth,upperpkt,obth,upperobt); |
462 |
upperpkt = pkth; |
upperpkt = pkth; |
463 |
upperobt = obth; |
upperobt = obth; |
464 |
rhev = lasthead+1; |
rhev = lasthead+1; |
465 |
} else { |
} else { |
466 |
rhev = lasthead; |
rhev = lasthead; |
467 |
}; |
}; |
468 |
if ( IsDebug() ) printf(" rhev after %i ph %i upperp %i oh %llu uppero %llu \n",rhev,pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" rhev after %i ph %lld upperp %lld oh %lld uppero %lld \n",rhev,pkth,upperpkt,obth,upperobt); |
469 |
// |
// |
470 |
if ( IsDebug() ) printf(" rtev beforev %i pt %i upperp %i ot %llu uppero %llu \n",rtev,pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" rtev beforev %i pt %lld upperp %lld ot %lld uppero %lld \n",rtev,pktt,upperpkt,obtt,upperobt); |
471 |
if ( pktt > upperpkt && obtt > upperobt ){ |
if ( pktt > upperpkt && obtt > upperobt ){ |
472 |
if ( IsDebug() ) printf(" Upper limits extended to include last trailer: pt %i upperp %i ot %llu uppero %llu \n",pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" Upper limits extended to include last trailer: pt %lld upperp %lld ot %lld uppero %lld \n",pktt,upperpkt,obtt,upperobt); |
473 |
upperpkt = pktt; |
upperpkt = pktt; |
474 |
upperobt = obtt; |
upperobt = obtt; |
475 |
rtev = lasttrail+1; |
rtev = lasttrail+1; |
476 |
} else { |
} else { |
477 |
rtev = lasttrail; |
rtev = lasttrail; |
478 |
}; |
}; |
479 |
if ( IsDebug() ) printf(" rtev after %i pt %i upperp %i ot %llu uppero %llu \n",rtev,pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" rtev after %i pt %lld upperp %lld ot %lld uppero %lld \n",rtev,pktt,upperpkt,obtt,upperobt); |
480 |
// goto kikko; |
// goto kikko; |
481 |
// |
// |
482 |
// |
// |
483 |
// Check if runtrailer/runheader are within lower limits |
// Check if runtrailer/runheader are within lower limits |
484 |
// |
// |
485 |
// |
// |
486 |
pkth = 0; |
pkth = 0LL; |
487 |
obth = 0; |
obth = 0LL; |
488 |
spkth = 0; |
spkth = 0LL; |
489 |
sobth = 0; |
sobth = 0LL; |
490 |
for (Int_t k=0; k<rhev; k++){ |
for (Int_t k=0; k<rhev; k++){ |
491 |
if ( k > 0 ){ |
if ( k > 0 ){ |
492 |
spkth = pkth; |
spkth = pkth; |
534 |
upperentry = evbefh-1; |
upperentry = evbefh-1; |
535 |
}; |
}; |
536 |
}; |
}; |
537 |
if ( IsDebug() ) printf(" rhev after %i ph %i upperp %i oh %llu uppero %llu \n",rhev,pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" rhev after %i ph %lld upperp %lld oh %lld uppero %lld \n",rhev,pkth,upperpkt,obth,upperobt); |
538 |
goto kikko0; |
goto kikko0; |
539 |
}; |
}; |
540 |
}; |
}; |
542 |
// |
// |
543 |
// |
// |
544 |
// |
// |
545 |
pktt = 0; |
pktt = 0LL; |
546 |
obtt = 0; |
obtt = 0LL; |
547 |
spktt = 0; |
spktt = 0LL; |
548 |
sobtt = 0; |
sobtt = 0LL; |
549 |
for (Int_t k=0; k<rtev; k++){ |
for (Int_t k=0; k<rtev; k++){ |
550 |
if ( k > 0 ){ |
if ( k > 0 ){ |
551 |
spktt = pktt; |
spktt = pktt; |
565 |
rt->GetEntry(rtev); |
rt->GetEntry(rtev); |
566 |
pktt = spktt; |
pktt = spktt; |
567 |
obtt = sobtt; |
obtt = sobtt; |
568 |
if ( IsDebug() ) printf(" lasttrail %i pt %i upperp %i ot %llu uppero %llu \n",rtev,pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" lasttrail %i pt %lld upperp %lld ot %lld uppero %lld \n",rtev,pktt,upperpkt,obtt,upperobt); |
569 |
// |
// |
570 |
UInt_t evbeft = 0; |
UInt_t evbeft = 0; |
571 |
code = eht->GetCounter(); |
code = eht->GetCounter(); |
594 |
upperentry = evbeft-1; |
upperentry = evbeft-1; |
595 |
}; |
}; |
596 |
}; |
}; |
597 |
if ( IsDebug() ) printf(" rtev after %i pt %i upperp %i ot %llu uppero %llu \n",rtev,pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" rtev after %i pt %lld upperp %lld ot %lld uppero %lld \n",rtev,pktt,upperpkt,obtt,upperobt); |
598 |
goto kikko; |
goto kikko; |
599 |
// break; |
// break; |
600 |
// |
// |
622 |
obth = OBT(phh->GetOrbitalTime()); |
obth = OBT(phh->GetOrbitalTime()); |
623 |
}; |
}; |
624 |
// |
// |
625 |
if ( IsDebug() ) printf(" rhev before %i ph %i upperp %i oh %llu uppero %llu \n",rhev,pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" rhev before %i ph %lld upperp %lld oh %lld uppero %lld \n",rhev,pkth,upperpkt,obth,upperobt); |
626 |
if ( pkth > upperpkt && obth > upperobt ){ |
if ( pkth > upperpkt && obth > upperobt ){ |
627 |
if ( IsDebug() ) printf(" Upper limits extended to include last header: ph %i upperp %i oh %llu uppero %llu \n",pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" Upper limits extended to include last header: ph %lld upperp %lld oh %lld uppero %lld \n",pkth,upperpkt,obth,upperobt); |
628 |
upperpkt = pkth; |
upperpkt = pkth; |
629 |
upperobt = obth; |
upperobt = obth; |
630 |
rhev = lasthead+1; |
rhev = lasthead+1; |
631 |
} else { |
} else { |
632 |
rhev = lasthead; |
rhev = lasthead; |
633 |
}; |
}; |
634 |
if ( IsDebug() ) printf(" rhev after %i ph %i upperp %i oh %llu uppero %llu \n",rhev,pkth,upperpkt,obth,upperobt); |
if ( IsDebug() ) printf(" rhev after %i ph %lld upperp %lld oh %lld uppero %lld \n",rhev,pkth,upperpkt,obth,upperobt); |
635 |
// |
// |
636 |
if ( IsDebug() ) printf(" rtev beforev %i pt %i upperp %i ot %llu uppero %llu \n",rtev,pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" rtev beforev %i pt %lld upperp %lld ot %lld uppero %lld \n",rtev,pktt,upperpkt,obtt,upperobt); |
637 |
if ( pktt > upperpkt && obtt > upperobt ){ |
if ( pktt > upperpkt && obtt > upperobt ){ |
638 |
if ( IsDebug() ) printf(" Upper limits extended to include last trailer: pt %i upperp %i ot %llu uppero %llu \n",pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" Upper limits extended to include last trailer: pt %lld upperp %lld ot %lld uppero %lld \n",pktt,upperpkt,obtt,upperobt); |
639 |
upperpkt = pktt; |
upperpkt = pktt; |
640 |
upperobt = obtt; |
upperobt = obtt; |
641 |
rtev = lasttrail+1; |
rtev = lasttrail+1; |
642 |
} else { |
} else { |
643 |
rtev = lasttrail; |
rtev = lasttrail; |
644 |
}; |
}; |
645 |
if ( IsDebug() ) printf(" rtev after %i pt %i upperp %i ot %llu uppero %llu \n",rtev,pktt,upperpkt,obtt,upperobt); |
if ( IsDebug() ) printf(" rtev after %i pt %lld upperp %lld ot %lld uppero %lld \n",rtev,pktt,upperpkt,obtt,upperobt); |
646 |
// |
// |
647 |
if ( IsDebug() ) printf(" Upper limits are: OBT %llu pkt_num %i upper entry %i \n",upperobt,upperpkt,upperentry); |
if ( IsDebug() ) printf(" Upper limits are: OBT %lld pkt_num %lld upper entry %i \n",upperobt,upperpkt,upperentry); |
648 |
// |
// |
649 |
return(0); |
return(0); |
650 |
} |
} |
795 |
/** |
/** |
796 |
* Return the correct packet number if we went back to zero |
* Return the correct packet number if we went back to zero |
797 |
*/ |
*/ |
798 |
UInt_t PamelaDBOperations::PKT(UInt_t pkt_num){ |
Long64_t PamelaDBOperations::PKT(UInt_t pkt_num){ |
799 |
// |
// |
800 |
// if ( IsDebug() ) printf(" pkt conversion: pkt_num is %u pktfirst is %u (pktfirst - (UInt_t)(16777212/2)) is %u \n",pkt_num,pktfirst,(pktfirst - (UInt_t)(16777212/2))); |
if ( IsDebug() ) printf(" pkt conversion: pkt_num is %u pktfirst is %u (UInt_t)(16777214/2)) is %u \n",pkt_num,pktfirst,(UInt_t)(16777214/2)); |
801 |
// |
// |
802 |
if ( pkt_num < (pktfirst/2) && pktfirst > (16777214/2) ) return((pkt_num+16777215)); |
if ( pkt_num < (pktfirst/2) && pktfirst > (16777214/2) ){ |
803 |
|
if ( IsDebug() ) printf(" rise up pktnum %lld \n",(Long64_t)pkt_num+16777215LL); |
804 |
|
return((Long64_t)pkt_num+16777215LL); |
805 |
|
}; |
806 |
// |
// |
807 |
if ( pkt_num > pktfirst*2 && pkt_num > (16777214/2) ){ |
if ( pkt_num > pktfirst*2 && pkt_num > (16777214/2) ){ |
808 |
if ( (pkt_num-16777215) < 0 ){ |
if ( IsDebug() ) printf(" rise down pktnum %lld \n",(Long64_t)pkt_num-16777215LL); |
809 |
return((16777215-pkt_num)); |
return((Long64_t)pkt_num-16777215LL); |
|
} else { |
|
|
return((pkt_num-16777215)); |
|
|
}; |
|
810 |
}; |
}; |
811 |
// |
// |
812 |
return(pkt_num); |
if ( IsDebug() ) printf(" as it is %lld \n",(Long64_t)pkt_num); |
813 |
|
return((Long64_t)pkt_num); |
814 |
// |
// |
815 |
}; |
}; |
816 |
|
|
817 |
/** |
/** |
818 |
* Return the correct On Board Time if we went back to zero |
* Return the correct On Board Time if we went back to zero |
819 |
*/ |
*/ |
820 |
ULong64_t PamelaDBOperations::OBT(UInt_t obt){ |
Long64_t PamelaDBOperations::OBT(UInt_t obt){ |
821 |
// |
// |
822 |
if ( obt < (obtfirst/2) && obtfirst > (numeric_limits<UInt_t>::max()/2) ) return((ULong64_t)(obt+numeric_limits<UInt_t>::max())); |
if ( obt < (obtfirst/2) && obtfirst > (numeric_limits<UInt_t>::max()/2) ) return((Long64_t)(obt+numeric_limits<UInt_t>::max())); |
823 |
// |
// |
824 |
if ( obt > (obtfirst*2) && obt > (numeric_limits<UInt_t>::max()/2) ){ |
if ( obt > (obtfirst*2) && obt > (numeric_limits<UInt_t>::max()/2) ){ |
825 |
if ( (obt-numeric_limits<UInt_t>::max()) < 0 ){ |
return((Long64_t)obt-(Long64_t)numeric_limits<UInt_t>::max()); |
|
return((ULong64_t)(numeric_limits<UInt_t>::max()-obt)); |
|
|
} else { |
|
|
return((ULong64_t)(obt-numeric_limits<UInt_t>::max())); |
|
|
}; |
|
826 |
}; |
}; |
827 |
// |
// |
828 |
return((ULong64_t)obt); |
return((Long64_t)obt); |
829 |
}; |
}; |
830 |
|
|
831 |
/** |
/** |
1004 |
if ((row != NULL) && ((UInt_t)atoll(row->GetField(0)) > 0)){ |
if ((row != NULL) && ((UInt_t)atoll(row->GetField(0)) > 0)){ |
1005 |
if ( IsDebug() ) printf(" found a timesync t0 is %u \n",t0); |
if ( IsDebug() ) printf(" found a timesync t0 is %u \n",t0); |
1006 |
toffset = (UInt_t)atoll(row->GetField(2)) - (UInt_t)(this->OBT((UInt_t)atoll(row->GetField(1)))/1000) + t0; |
toffset = (UInt_t)atoll(row->GetField(2)) - (UInt_t)(this->OBT((UInt_t)atoll(row->GetField(1)))/1000) + t0; |
1007 |
|
// |
1008 |
|
tsync = (UInt_t)atoll(row->GetField(2)); |
1009 |
|
obt0 = (UInt_t)atoll(row->GetField(1)); |
1010 |
|
// |
1011 |
return(1); |
return(1); |
1012 |
}; |
}; |
1013 |
// |
// |
1204 |
if ( IsDebug() ) printf(" found a timesync t0 is %u \n",t0); |
if ( IsDebug() ) printf(" found a timesync t0 is %u \n",t0); |
1205 |
toffset = (UInt_t)TSYNC - (UInt_t)(this->OBT(OBT)/1000) + t0; |
toffset = (UInt_t)TSYNC - (UInt_t)(this->OBT(OBT)/1000) + t0; |
1206 |
// |
// |
1207 |
|
tsync = TSYNC; |
1208 |
|
obt0 = OBT; |
1209 |
|
// |
1210 |
delete result; |
delete result; |
1211 |
return(signal); |
return(signal); |
1212 |
} |
} |
1306 |
VarDumpEvent *vde = 0; |
VarDumpEvent *vde = 0; |
1307 |
VarDumpRecord *vdr = 0; |
VarDumpRecord *vdr = 0; |
1308 |
// |
// |
1309 |
|
Bool_t found = false; |
1310 |
trDumpEv->SetBranchAddress("VarDump", &vde); |
trDumpEv->SetBranchAddress("VarDump", &vde); |
1311 |
if ( trDumpEv->GetEntries() > 0 ){ |
if ( trDumpEv->GetEntries() > 0 ){ |
1312 |
Bool_t found = false; |
found = false; |
1313 |
for ( Int_t i = 0; i < trDumpEv->GetEntries(); i++){ |
for ( Int_t i = 0; i < trDumpEv->GetEntries(); i++){ |
1314 |
trDumpEv->GetEntry(i); |
trDumpEv->GetEntry(i); |
1315 |
vde->Records->GetEntries(); |
// vde->Records->GetEntries(); |
1316 |
if ( vde->Records->GetEntries()>0 ){ |
if ( vde->Records->GetEntries()>5 ){ |
1317 |
found = true; |
found = true; |
1318 |
goto fill; |
goto fill; |
1319 |
}; |
}; |
1326 |
this->SetBOOTnumber((Int_t)vdr->VAR_VALUE); |
this->SetBOOTnumber((Int_t)vdr->VAR_VALUE); |
1327 |
// |
// |
1328 |
} else { |
} else { |
1329 |
if ( !this->GetBOOTnumber() ) return(4); |
if ( !this->GetBOOTnumber() && !this->AutoBoot()) return(4); |
1330 |
|
}; |
1331 |
|
} else { |
1332 |
|
if ( !this->GetBOOTnumber() && !this->AutoBoot()) return(2); |
1333 |
|
}; |
1334 |
|
// |
1335 |
|
UInt_t bn = 0; |
1336 |
|
Bool_t afound = false; |
1337 |
|
if ( !found && this->AutoBoot()){ |
1338 |
|
afound = true; |
1339 |
|
// |
1340 |
|
// Search for other files with similar timesync |
1341 |
|
// |
1342 |
|
if ( IsDebug() ) printf(" tsync %u obt0 %u \n",tsync,obt0); |
1343 |
|
UInt_t upperts = tsync-(obt0/1000)+5; |
1344 |
|
UInt_t lowerts = tsync-(obt0/1000)-5; |
1345 |
|
oss.str(""); |
1346 |
|
oss << "select GL_RAW.BOOT_NUMBER from GL_TIMESYNC LEFT JOIN GL_RAW ON GL_RAW.ID = GL_TIMESYNC.ID_RAW where TIMESYNC-(OBT0/1000)<" |
1347 |
|
<< upperts |
1348 |
|
<< " AND TIMESYNC-(OBT0/1000)>" |
1349 |
|
<< lowerts |
1350 |
|
<< " AND GL_RAW.BOOT_NUMBER>0 GROUP BY GL_TIMESYNC.OBT0;"; |
1351 |
|
result = conn->Query(oss.str().c_str()); |
1352 |
|
if ( IsDebug() ) printf(" Query the GL_TIMESYNC table to find boot number:\n %s \n",oss.str().c_str()); |
1353 |
|
// |
1354 |
|
if ( !result ) throw -4;; |
1355 |
|
found = true; |
1356 |
|
if ( result->GetRowCount()<3 ){ |
1357 |
|
if ( IsDebug() ) printf(" AGH! no results!\n"); |
1358 |
|
found = false; |
1359 |
|
} else { |
1360 |
|
row = result->Next(); |
1361 |
|
bn = (UInt_t)atoll(row->GetField(0)); |
1362 |
|
for ( Int_t r=1; r<result->GetRowCount() ;r++){ |
1363 |
|
if ( !row ) throw -4; |
1364 |
|
if ( IsDebug() ) printf(" BOOT number is %s \n",row->GetField(0)); |
1365 |
|
if ( bn != (UInt_t)atoll(row->GetField(0)) ){ |
1366 |
|
if ( IsDebug() ) printf(" AGH! bn = %u here instead %u \n",bn,(UInt_t)atoll(row->GetField(0))); |
1367 |
|
found = false; |
1368 |
|
}; |
1369 |
|
row = result->Next(); |
1370 |
|
}; |
1371 |
}; |
}; |
1372 |
|
}; |
1373 |
|
// |
1374 |
|
Int_t sgn = 0; |
1375 |
|
// |
1376 |
|
if ( !found ){ |
1377 |
|
throw -29; |
1378 |
} else { |
} else { |
1379 |
if ( !this->GetBOOTnumber() ) return(2); |
if ( afound ){ |
1380 |
|
this->SetBOOTnumber(bn); |
1381 |
|
sgn = 8; |
1382 |
|
}; |
1383 |
}; |
}; |
1384 |
// |
// |
1385 |
oss.str(""); |
oss.str(""); |
1389 |
conn->Query(oss.str().c_str()); |
conn->Query(oss.str().c_str()); |
1390 |
// |
// |
1391 |
delete result; |
delete result; |
1392 |
return(0); |
return(sgn); |
1393 |
}; |
}; |
1394 |
|
|
1395 |
/** |
/** |