#include "DBQueryCreator.h"
#include <iostream>

int main( int argc, char** argv ) {

	vector<int32_t> tags;
	tags.push_back(1);
	tags.push_back(2);

	vector<int32_t> sides;
	sides.push_back(0);

	vector<int32_t> sectors;
	sectors.push_back(11);
	sectors.push_back(12);

	vector<int32_t> rcus;
	rcus.push_back(3);
	rcus.push_back(4);

	vector<int32_t> branches;
	branches.push_back(0);
	branches.push_back(1);

	vector<int32_t> fecs;
	fecs.push_back(0);
	fecs.push_back(1);

	vector<int32_t> altros;
	altros.push_back(0);
	altros.push_back(1);
	altros.push_back(2);
	altros.push_back(3);
	altros.push_back(4);
	altros.push_back(5);
	altros.push_back(6);
	altros.push_back(7);

	vector<int32_t> channels;
	channels.push_back(5);
	channels.push_back(6);
	channels.push_back(7);
	channels.push_back(8);
	channels.push_back(9);
	channels.push_back(10);
	channels.push_back(11);
	channels.push_back(12);
	channels.push_back(13);
	channels.push_back(14);
	channels.push_back(15);

	cout << endl;

	DBQueryCreator *dbq = new DBQueryCreator("oracle");	

	/*
	cout << dbq->getSqlCreateTablePEDMEM() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTablePEDMEM_ALTRO() << endl;
	cout << endl;
	cout << dbq->getSqlInsertPEDMEM(1, 5) << endl;
	cout << endl;
	cout << dbq->getSqlBindInsertPEDMEM() << endl;
	cout << endl;
	cout << dbq->getSqlInsertPEDMEM_ALTRO(0, 1) << endl;
	cout << endl;
	cout << dbq->getSqlBindInsertPEDMEM_ALTRO() << endl;
	cout << endl;
	cout << dbq->getSqlSelectAltroPedmemRow(1, 1, 12, 1, 0, 12, 7) << endl;
	cout << endl;
	cout << dbq->getSqlSelectAltroPedmemField(1, 1, 12, 1, 0, 12, 7, "Position") << endl;
	cout << endl;
	cout << dbq->getSqlUpdateAltroPedmem(1, 1, 12, 1, 0, 12, 7, 12) << endl;
	cout << endl;
	cout << dbq->getSqlUpdateAltroPedmem(tags, sides, sectors, rcus, branches, fecs, altros, channels) << endl;
	cout << endl;
	cout << dbq->getSqlUpdateAltroPedmem(tags, 1, 2, 3, 4, 5, 6, 7) << endl;
	cout << endl;
	cout << dbq->getSqlUpdateAltroPedmem(altros, channels) << endl;
	cout << endl;

	channels.clear();
	channels.push_back(5);

	cout << dbq->getSqlBindUpdateAltroPedmem(tags, channels) << endl;
	cout << endl;
	cout << dbq->getSqlBindUpdateAltroPedmem(tags, 5) << endl;
	cout << endl;
	cout << dbq->getSqlBindUpdateAltroPedmemId(channels) << endl;
	cout << endl;
	cout << dbq->getSqlSelectPartitionPedmemData(12) << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableALTRO() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableFEC() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableRCU() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableSECTOR() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableTPC() << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableALTRO_FEC() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableFEC_RCU() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableRCU_SECTOR() << endl;
	cout << endl;
	cout << dbq->getSqlCreateTableSECTOR_TPC() << endl;
	cout << endl;
	*/

	/*
	cout << dbq->getSqlCreateTableFEESERVICES("D") << endl;
	cout << endl;
	cout << dbq->getSqlInsertFEE(2, 3, 4 ) << endl;
	cout << endl;
	cout << dbq->getSqlInsertFEESERVICES(1, 3, 4, 5, "BLA", "float") << endl;
	cout << endl;
	cout << dbq->getSqlInsertFEESERVICES(1, 3, 4, "MAIN_STATE", "int") << endl;
	cout << endl;
	*/

	/*
        //int32_t AliceToHwFec(int32_t sidePosition, int32_t rcuPosition, int32_t fecPosition);
        //int32_t AliceToHwBranch(int32_t sidePosition, int32_t rcuPosition, int32_t fecPosition);
        //int32_t HwToAlice(int32_t sidePosition, int32_t rcuPosition, int32_t branchPosition, int32_t fecPosition);

	//cout << "Alice: 0, 4,  5: Hw" << dbq->AliceToHwFec(0, 4,  5) << ", branch " << dbq->AliceToHwBranch(0, 4,  5) << endl;
	//cout << "Alice: 0, 4, 15: Hw" << dbq->AliceToHwFec(0, 4, 15) << ", branch " << dbq->AliceToHwBranch(0, 4, 15) << endl;
	//cout << "Alice: 1, 4,  5: Hw" << dbq->AliceToHwFec(1, 4,  5) << ", branch " << dbq->AliceToHwBranch(1, 4,  5) << endl;
	//cout << "Alice: 1, 4, 15: Hw" << dbq->AliceToHwFec(1, 4, 15) << ", branch " << dbq->AliceToHwBranch(1, 4, 15) << endl;

	int32_t sectorIDs[36];
	for (int32_t i=0; i<1; i++) sectorIDs[i] = i+1;

	cout << dbq->getSqlDeleteSECTOR(sectorIDs) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateRowRCU(1, 22, 1, 12, 2, 0)<<endl;
	cout << endl;
	cout << dbq->getSqlUpdateRowFEC(1, 1, 12, 2, 0, 7, 0)<<endl;
	cout << endl;

	string comment;
	comment = "TPC Config";
	cout << dbq->getSqlUpdateRowTPC(1, 4, comment)<<endl;
	cout << endl;
	cout << dbq->getSqlUpdateRowSECTOR(1, 1, 12)<<endl;
	cout << endl;
	cout<<dbq->getSqlUpdateRowALTRO(1,2,4,5,6,7,3,2)<<endl;
	cout << endl;
	cout<< dbq->getSqlQueryTableEmpty("FEE") << endl;
	cout << endl;
	cout << dbq->getSqlSelectPartitionData(0, 1, 12, 1)  << endl;
	cout << endl;

	cout << dbq->getSqlSelectRcuField(0, 1, 12, 1, "ON_RCU") << endl;
	cout << endl;

	cout << dbq->getSqlSelectFecField(0, 1, 12, 2, 1, 8, "ON_FEC") << endl;
	cout << endl;

	cout << dbq->getSqlSelectFecField(0, 1, 12, 2, 17, "ON_FEC") << endl;
	cout << endl;
	*/

	cout << dbq->getSqlSelectAltroField(0, 1, 12, 2, 1, 8, 4, "ON_ALTRO") << endl;
	cout << endl;

	/*
	cout << dbq->getSqlSelectAltroField(0, 1, 12, 2, 17, 4, "ON_ALTRO") << endl;
	cout << endl;

	cout << dbq->getSqlSelectTpcField(0, "Comment") << endl;
	cout << endl;

	//////////
	cout << dbq->getSqlSelectAltroRow(109) << endl;
	cout << endl;

	cout << dbq->getSqlSelectRcuRow(109) << endl;
	cout << endl;

	cout << dbq->getSqlSelectFecRow(109) << endl;
	cout << endl;

	cout << dbq->getSqlSelectAltroField(109, "ON_ALTRO") << endl;
	cout << endl;

	cout << dbq->getSqlSelectRcuField(109, "ON_RCU") << endl;
	cout << endl;

	cout << dbq->getSqlSelectFecField(109, "ON_FEC") << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableRCU() << endl;
	cout << endl;

	vector<int32_t> sides;
	sides.push_back(0);

	vector<int32_t> sectors;
	sectors.push_back(11);
	sectors.push_back(12);

	vector<int32_t> rcus;
	rcus.push_back(3);
	rcus.push_back(4);

	vector<int32_t> branches;
	branches.push_back(0);
	branches.push_back(1);

	vector<int32_t> fecs;
	fecs.push_back(0);
	fecs.push_back(1);

	vector<int32_t> altros;
	altros.push_back(0);
	altros.push_back(1);
	altros.push_back(2);
	altros.push_back(3);
	altros.push_back(4);
	altros.push_back(5);
	altros.push_back(6);
	altros.push_back(7);

	cout << dbq->getSqlUpdateRcuFields(tags, sides, sectors, rcus, "ON_RCU", 0) << endl;
	cout << endl;
	cout << dbq->getSqlUpdateFecFields(tags, sides, sectors, rcus, branches, fecs, "ON_FEC", 0) << endl;
	cout << endl;
	cout << dbq->getSqlUpdateAltroFields(tags, sides, sectors, rcus, branches, fecs, altros, "ON_ALTRO", 0)
	     << endl;
	cout << endl;

	cout << dbq->getSqlUpdateTpcField(tags, "Revision", 223) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateTpcField(tags, "Comment", "Hallo") << endl;
	cout << endl;

	cout << dbq->getSqlUpdateUpdated(tags) << endl;
	cout << endl;

	cout << dbq->getSqlBindUpdateRcuField(tags, "ON_RCU") << endl;
	cout << endl;

	cout << dbq->getSqlSelectBlobForUpdate("BTEST", "col3") << endl;
	cout << endl;

	cout << dbq->getSqlUpdateRcuField(0, 1, 12, 3, "ON_RCU", 0) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateFecField(0, 1, 12, 3, 1, 4, "ON_FEC", 0) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateFecField(0, 1, 12, 3, 12, "ON_FEC", 0) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateAltroField(0, 1, 12, 3, 1, 4, 5, "ON_ALTRO", 0) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateAltroField(0, 1, 12, 3, 12, 5, "ON_ALTRO", 0) << endl;
	cout << endl;

	////////////
	cout << dbq->getSqlUpdateRcuField(10, "ON_RCU", 0) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateFecField(20, "ON_FEC", 0) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateAltroField(30, "ON_ALTRO", 0) << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableFEE_A() << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableFEE_C() << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableFEESERVICES_A() << endl;
	cout << endl;

	cout << dbq->getSqlCreateTableFEESERVICES_C() << endl;
	cout << endl;

	cout << dbq->getSqlBindUpdateAltroField("VFPED_CHANNEL00") << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertALTRO() << endl;
	cout << endl;

	cout << dbq->getSqlInsertALTRO(0, 1, 12, 5, 1, 6, 5, 16) << endl;
	cout << endl;

	cout << dbq->getSqlBindUpdateAltroField("TRCFG_ACQ_START") << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertALTRO_FEC() << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertFEC() << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertFEC_RCU() << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertRCU() << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertRCU_SECTOR() << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertFEE() << endl;
	cout << endl;

	cout << dbq->getSqlBindInsertFEESERVICES() << endl;
	cout << endl;

	cout << dbq->getSqlQueryInfoDisabledFECs(1) << endl;
	cout << endl;

	cout << dbq-> getSqlUpdateFieldAllRcu(4, "ON_RCU", 0) << endl;
	cout << endl;

	cout << dbq-> getSqlUpdateFieldAllFec(4, "BLA", 4) << endl;
	cout << endl;

	cout << dbq-> getSqlUpdateFieldAllAltro(4, "DPCFG_ZS_POST", 7) << endl;
	cout << endl;

	cout << dbq->getSqlBindSelectPartitionData()  << endl;
	cout << endl;

	cout << dbq->getSqlBindSelectPartitionConfigData()  << endl;
	cout << endl;

	cout << dbq-> getSqlBindUpdateChannelField(tags, "L3", 7) << endl;
	cout << endl;

	cout << dbq-> getSqlBindUpdateChannelFieldAllOnRcu(tags, "K1", 7) << endl;
	cout << endl;

	cout << dbq->getSqlUpdateFieldAllAltro(tags, "BLA", 99) << endl;
	cout << endl;
	*/

	cout << dbq->getSqlBindSelectAllPartitionConfigData() << endl;
	cout << endl;

	cout << dbq->getSqlFindDisabledRCUs(15) << endl;
	cout << endl;

	cout << dbq->getSqlFindDisabledFECs(15) << endl;
	cout << endl;

	cout << dbq->getSqlFindDisabledALTROs(15) << endl;
	cout << endl;

	cout << dbq->getSqlFindDisabledCHANNELs(15) << endl;
	cout << endl;

	delete dbq;
	return 0;
}