//
// Variable declarations
//

enum fdbSystem {MySql, Oracle};

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

const int32_t pMaxBufferSize = 1000000;  // 1MB

const int32_t ciTables  = 15;
const int32_t ciSides   = 2;
const int32_t ciSectors = 18;
const int32_t ciRCUs    = 6;
const int32_t ciAltros  = 8;

int32_t fecPerRCUBranch[6][2] = {{9,9}, {13,12}, {9,9}, {10,10}, {10,10}, {10,10}};
int32_t fecPerRCU[6]          = {18, 25, 18, 20, 20, 20};
const int32_t cifecPerSector = 9+9+13+12+9+9+10+10+10+10+10+10;

int32_t altroQueryCount  = 0;
int32_t fecQueryCount    = 0;
int32_t rcuQueryCount    = 0;
int32_t sectorQueryCount = 0;
int32_t tpcQueryCount    = 0;
int32_t feeQueryCount    = 0;
int32_t feeservicesQueryCount = 0;
  
vector<string> altroQuerys;
vector<string> fecQuerys;
vector<string> rcuQuerys;
vector<string> sectorQuerys;
vector<string> tpcQuerys;
vector<string> feeQuerys;
vector<string> feeservicesQuerys;
vector<string> altro_fecQuerys;
vector<string> fec_rcuQuerys;
vector<string> rcu_sectorQuerys;
vector<string> sector_tpcQuerys;

vector < vector<int> > altro_values;
vector < vector<int> > altro_fec_values;
vector < vector<int> > fec_values;
vector < vector<int> > fec_rcu_values;
vector < vector<int> > rcu_values;
vector < vector<int> > rcu_sector_values;

Stopwatch      *sw  = new Stopwatch();
DBQueryCreator *dbq = new DBQueryCreator();
OracleDB       *db  = NULL;
ProgressBar    *pb  = NULL;

// max ids in tables
int32_t altroMaxId       = -1;
int32_t fecMaxId         = -1;
int32_t rcuMaxId         = -1;
int32_t sectorMaxId      = -1;
int32_t tpcMaxId         = -1;

int32_t altroIndex = 0;
int32_t fecIndex = 0;
int32_t rcuIndex = 0;
int32_t sectorIndex = 0;
int32_t tpcIndex = 0;
int32_t feeIndex = 0;
int32_t feeservicesIndex = 0;

int32_t altroQueryIndex = 0;
int32_t fecQueryIndex = 0;
int32_t rcuQueryIndex = 0;
int32_t sectorQueryIndex = 0;
int32_t tpcQueryIndex = 0;
int32_t feeQueryIndex = 0;
int32_t feeservicesQueryIndex = 0;
  
int32_t altro_fecQueryIndex = 0;
int32_t fec_rcuQueryIndex = 0;
int32_t rcu_sectorQueryIndex = 0;
int32_t sector_tpcQueryIndex = 0;