//
// Variable declarations
//

Connection con;

bool fRound = 1;    // round values? Used for UpdateFromFile

const int32_t pMaxBufferSize = 1000000;  // 1MB

const int32_t ciTables     = 26;
const int32_t ciSides      = 2;
const int32_t ciSectors    = 18;
const int32_t ciPartitions = 5;
const int32_t ciSampas     = 5;
const int32_t ciRows       = 152;
const int32_t ciCrus       = 360;
const int32_t ciFecs       = 3276;
const int32_t ciLinks      = 6552;

int32_t fecPerPartitionBranch[5][2] = {{8,7}, {9,9}, {9,9}, {10,10}, {10,10}};
int32_t fecPerPartition[5]          = {15, 18, 18, 20, 20};

int32_t rowPerPartitionCru[5][2] = {{17,15}, {16,15}, {18,16}, {16,14}, {13,12}};

const int32_t cifecPerSector = 91;

int32_t pedestalQueryCount  = 0;
int32_t cruQueryCount       = 0;
int32_t fecQueryCount       = 0;
int32_t partitionQueryCount = 0;
int32_t sectorQueryCount    = 0;
int32_t tpcQueryCount       = 0;

string gbtx1Query;

vector<string> pedestalQueries;
vector<string> zsthrQueries;
vector<string> onchannelQueries;
vector<string> itcorr1Queries;
vector<string> itcorr2Queries;
vector<string> cmcorrQueries;
vector<string> cruQueries;
vector<string> fecQueries;
vector<string> partitionQueries;
vector<string> sectorQueries;
vector<string> tpcQueries;
vector<string> pedestal_cruQueries;
vector<string> zsthr_cruQueries;
vector<string> onchannel_cruQueries;
vector<string> itcorr1_cruQueries;
vector<string> itcorr2_cruQueries;
vector<string> cmcorr_cruQueries;
vector<string> cru_partitionQueries;
vector<string> fec_partitionQueries;
vector<string> partition_sectorQueries;
vector<string> sector_tpcQueries;

vector < vector<int32_t> > pedestal_values;
vector < vector<int32_t> > pedestal_cru_values;
vector < vector<int32_t> > zsthr_values;
vector < vector<int32_t> > zsthr_cru_values;
vector < vector<int32_t> > onchannel_values;
vector < vector<int32_t> > onchannel_cru_values;
vector < vector<float>   > cmcorr_values;
vector < vector<int32_t> > cmcorr_cru_values;
vector < vector<float>   > itcorr1_values;
vector < vector<int32_t> > itcorr1_cru_values;
vector < vector<float>   > itcorr2_values;
vector < vector<int32_t> > itcorr2_cru_values;
vector < vector<int32_t> > cru_values;
vector < vector<int32_t> > cru_partition_values;
vector < vector<int32_t> > fec_values;
vector < vector<int32_t> > fec_partition_values;
vector < vector<int32_t> > partition_values;
vector < vector<int32_t> > partition_sector_values;

Stopwatch      *sw  = new Stopwatch();
DBQueryCreator *dbq = new DBQueryCreator();

ProgressBar *pb = NULL;

int32_t pedestalMaxId    = -1;
int32_t zsthrMaxId       = -1;
int32_t onchannelMaxId   = -1;
int32_t itcorr1MaxId     = -1;
int32_t itcorr2MaxId     = -1;
int32_t cmcorrMaxId      = -1;
int32_t cruMaxId         = -1;
int32_t fecMaxId         = -1;
int32_t partitionMaxId   = -1;
int32_t sectorMaxId      = -1;
int32_t tpcMaxId         = -1;

int32_t pedestalIndex  = 0;
int32_t cruIndex       = 0;
int32_t fecIndex       = 0;
int32_t partitionIndex = 0;
int32_t sectorIndex    = 0;
int32_t tpcIndex       = 0;

int32_t pedestalQueryIndex  = 0;
int32_t cruQueryIndex       = 0;
int32_t fecQueryIndex       = 0;
int32_t partitionQueryIndex = 0;
int32_t sectorQueryIndex    = 0;
int32_t tpcQueryIndex       = 0;
  
int32_t pedestal_cruQueryIndex = 0;
int32_t cru_partitionQueryIndex = 0;
int32_t fec_partitionQueryIndex = 0;
int32_t partition_sectorQueryIndex = 0;
int32_t sector_tpcQueryIndex = 0;