test2.cpp

Mysql的处理

	memcpy(pIn5.LevelOfCamelService,"1111111111",5);
	memcpy(pIn5.FreeFormatData,"11111111111",5);
	pIn5.FFDAppendIndicator=2;
	pIn5.DefaultSMSHandling=2;
	memcpy(pIn5.CAMELCallingPartyNumber,"11111111111111111",5);
	memcpy(pIn5.CAMELAccessDestinationSubNumber,"1111111111111",5);
	memcpy(pIn5.CAMELSMSAdress,"1111111111111111",5);
	memcpy(pIn5.SmsReferenceNumber,"1111111111111111",5);
	snprintf(pIn5.GsnIpAddr,LEN_IpAddr+1,"2");
	pIn5.FlagRead=2;
	snprintf(pIn5.SeqId,LEN_SEQ + 1,"2");
	snprintf(pIn5.GtpName,LEN_TABLENAME + 1,"2");
	snprintf(pIn5.GtpId,LEN_SEQ + 1,"2");
	pIn5.FlagRepeat=2;
	pIn5.FlagR499=2;
	snprintf(pIn5.GsnId,LEN_GSNID+1,"2");
	snprintf(pIn5.TableName,LEN_TABLENAME + 1,"OMOCDR");
	pIn5.ChargingCharacterSelectionMode=2;

	DbOMOCDRInsert(&pIn5, &pOut5);
//test OMOCDR end

//test OMTCDR begin

    S_OMTCDR pIn6; 
	S_RESULT pOut6;

	pIn6.RecordType=2;
	memcpy(pIn6.ServedIMSI,"111111111111",5);
	memcpy(pIn6.ServedIMEI,"111111111111",5);
	snprintf(pIn6.ServedMSISDN,LEN_ServedMSISDN+1,"2");
	snprintf(pIn6.MSNetworkCapability,LEN_MSNetworkCapability+1,"2");
	memcpy(pIn6.ServiceCenter,"11111111111",5);
	memcpy(pIn6.RecordingEntity,"11111111111",5);
	memcpy(pIn6.LocationAreaCode,"111111111111",5);
	memcpy(pIn6.RoutingAreaCode,"1111111111",5);
	memcpy(pIn6.CellIdentity,"11111111111",5);
	snprintf(pIn6.EventStampTime,LEN_DATETIME + 1,"2");
	pIn6.SMSResult=2;
	snprintf(pIn6.RecordExtensions,LEN_RecordExtensions+1,"2");
	snprintf(pIn6.NodeID,LEN_NodeID+1,"2");
	memcpy(pIn6.LocalRecordSequeceNumnber,"11111111111111",5);
	snprintf(pIn6.ChargingCharacteristics,LEN_ChargingCharacteristics+1,"2");
	pIn6.SystemType=2;
	snprintf(pIn6.GsnIpAddr,LEN_IpAddr+1,"2");
	pIn6.FlagRead=2;
	snprintf(pIn6.SeqId,LEN_SEQ + 1,"2");
	snprintf(pIn6.GtpName,LEN_TABLENAME + 1,"2");
	snprintf(pIn6.GtpId,LEN_SEQ + 1,"2");
	pIn6.FlagRepeat=2;
	pIn6.FlagR499=2;
	snprintf(pIn6.GsnId,LEN_GSNID+1,"2");
	snprintf(pIn6.TableName,LEN_TABLENAME + 1,"OMTCDR");
	pIn6.ChargingCharacterSelectionMode=2;



	DbOMTCDRInsert(&pIn6, &pOut6);

//test OMTCDR end

//test LLOTV begin

	S_LLOTV pIn7;
	S_RESULT pOut7;

	pIn7.ChangeCondition=2;
	memcpy(pIn7.DataVolumeGPRSUp,"111111111",5);
	memcpy(pIn7.DataVolumeGPRSDown,"111111111",5);
	snprintf(pIn7.ChangeTime,LEN_DATETIME + 1,"2");
	memcpy(pIn7.QoSNUMTS,"1111111111",5);
	memcpy(pIn7.QoSNMeanThroughput,"1111",2);
	memcpy(pIn7.QoSNPeakThrougput,"11111",2);
	pIn7.QoSNDelay=2;
	pIn7.QoSNPrecedence=2;
	pIn7.QoSNReliability=2;
	memcpy(pIn7.QoSRUMTS,"11111111111",5);
	memcpy(pIn7.QoSRMeanThroughput,"11111",2);
	memcpy(pIn7.QoSRPeakThrougput,"1111111",2);
	pIn7.QoSRDelay=2;
	pIn7.QoSRPrecedence=2;
	pIn7.QoSRReliability=2;
	snprintf(pIn7.TableName,LEN_TABLENAME + 1,"LLOTV");
	
	snprintf(pIn7.SortId,LEN_SORT+1,"2");


	DbLLOTVInsert(&pIn7,&pOut7);


//test LLOTV end

//test LCOMM begin

S_LCOMM pIn8;
S_RESULT pOut8;

pIn8.SubId=2;
snprintf(pIn8.SGSNAddr,LEN_SGSNAddr + 1,"2");
memcpy(pIn8.CauseForRecordClosing,"111111",2);
memcpy(pIn8.RSN,"11111111",5);
memcpy(pIn8.LRSN,"11111111",5);
pIn8.SystemType=2;
pIn8.SGSNChange=2;
snprintf(pIn8.NodeId,LEN_NodeID+1,"2");
pIn8.RNC=2;
snprintf(pIn8.RecordExtensions,LEN_RecordExtensions+1,"2");
snprintf(pIn8.TableName,LEN_TABLENAME + 1,"LCOMM");
snprintf(pIn8.SortId,LEN_SORT+1,"2");


DbLCOMMInsert(&pIn8, &pOut8);

//test LCOMM end

//test LCLOC begin



S_LCLOC pIn9;
S_RESULT pOut9;

memcpy(pIn9.LocationAreaCode,"11111111111",4);
memcpy(pIn9.RoutingAreaCode,"11111111",5);
memcpy(pIn9.CellIdentity,"11111111",4);
snprintf(pIn9.ChangeTime,LEN_DATETIME + 1,"2");
snprintf(pIn9.TableName,LEN_TABLENAME + 1,"LCLOC");
snprintf(pIn9.SeqId,LEN_SEQ + 1,"2");
snprintf(pIn9.SortId,LEN_SORT+1,"2");

DbLCLOCInsert(&pIn9, &pOut9);

//test LCLOC end

//test CGCDR begin

S_CGCDR pIn10;
S_RESULT pOut10;

pIn10.RecordType=2;
pIn10.NetworkInitiatedPDPContext=2;
memcpy(pIn10.ServedIMSI,"1111111111",5);
snprintf(pIn10.GGSNAddress,LEN_IpAddr+1,"2");
memcpy(pIn10.ChargingID,"11111111111",5);
memcpy(pIn10.AccessPointNameNI,"11111111",5);
memcpy(pIn10.PDPTypeNumber,"11111111111",5);
snprintf(pIn10.ServedPDPAddress,LEN_IpAddr+1,"2");
pIn10.DynamicAddressFlag=2;
snprintf(pIn10.RecordOpenTime,LEN_DATETIME + 1,"2");
memcpy(pIn10.CallDuration,"111111111",5);
snprintf(pIn10.Diagnostics,LEN_Diagnostics+1,"2");
snprintf(pIn10.NodeID,LEN_NodeID+1,"2");
pIn10.APNSelectionMode=2;
snprintf(pIn10.ServedMSISDN,LEN_ServedMSISDN+1,"2");
snprintf(pIn10.SgsnPlmnIdentifier,LEN_SgsnPlmnIdentifier+1,"2");
memcpy(pIn10.ConsolidationResult,"111",2);
pIn10.ChargingCharacterSelectionMode=2;
snprintf(pIn10.ChargingCharacteristics,LEN_ChargingCharacteristics+1,"2");
pIn10.AnonyAccessIndicator=2;
snprintf(pIn10.RemotePdpAddr,LEN_IpAddr+1,"2");
pIn10.FlagRead=2;
snprintf(pIn10.SeqId,LEN_SEQ + 1,"2");
snprintf(pIn10.TableName,LEN_TABLENAME + 1,"CGCDR");
pIn10.FlagRepeat=2;
pIn10.FlagR499=2;
snprintf(pIn10.GsnId,LEN_GSNID+1,"2");
snprintf(pIn10.SGSNIPAddress,LEN_IpAddr+1,"2");
memcpy(pIn10.CauseForRecClosing,"111",2);
memcpy(pIn10.RecordSequenceNumber,"111111111",5);
snprintf(pIn10.RecordExtensions,LEN_RecordExtensions+1,"2");
memcpy(pIn10.LocalRecordSequeceNumnber,"1111111111",5);


DbCGCDRInsert(&pIn10, &pOut10);

//test CGCDR end

//test CSCDR begin

S_CSCDR pIn11;
S_RESULT pOut11;


pIn11.RecordType=2;
pIn11.NetworkInitiatedPDPContext=2;
snprintf(pIn11.ServedIMSI,LEN_ServedIMSI+1,"2");
snprintf(pIn11.ServedIMEI,LEN_ServedIMEI+1,"2");
snprintf(pIn11.SGSNIPAddress,LEN_IpAddr+1,"2");
snprintf(pIn11.MSNetworkCapability,LEN_MSNetworkCapability+1,"2");
memcpy(pIn11.RoutingAreaCode,"111111111111",5);
memcpy(pIn11.LocationAreaCode,"111111111111",5);
memcpy(pIn11.CellIdentity,"11111111111",5);
memcpy(pIn11.ChargingID,"111111111",5);
snprintf(pIn11.GGSNAddress,LEN_IpAddr+1,"2");
memcpy(pIn11.AccessPointNameNI,"11111111111",5);
memcpy(pIn11.PDPTypeNumber,"111111111111",5);
snprintf(pIn11.ServedPDPAddress,LEN_IpAddr+1,"2");
snprintf(pIn11.RecordOpenTime,LEN_DATETIME + 1,"2");
memcpy(pIn11.CallDuration,"11111111111",5);
snprintf(pIn11.Diagnostics,LEN_Diagnostics+1,"2");
pIn11.APNSelectionMode=2;
memcpy(pIn11.AccessPointNameOI,"1111111111111",5);
snprintf(pIn11.ServedMSISDN,LEN_ServedMSISDN+1,"2");
snprintf(pIn11.ChargingCharacteristics,LEN_ChargingCharacteristics+1,"2");
memcpy(pIn11.ConsolidationResult,"11111111",2);
pIn11.ChargingCharacterSelectionMode=2;
snprintf(pIn11.SCFAddress,LEN_SCFAddress+1,"2");
snprintf(pIn11.ServiceKey,LEN_ServiceKey+1,"2");
pIn11.DefaultTransacHandling=2;
memcpy(pIn11.CAMELAPNNI,"111111111",5);
memcpy(pIn11.CAMELAPNOI,"111111111",5);
memcpy(pIn11.NumberOfDPEncounter,"1111111111",5);
memcpy(pIn11.LevelOfCamelService,"11111111",3);
memcpy(pIn11.FreeFormatData,"11111111111",5);
pIn11.FFDAppendIndicator=2;
pIn11.DefaultSMSHandling=2;
memcpy(pIn11.CAMELCallingPartyNumber,"11111111111",5);
memcpy(pIn11.CAMELAccessDestinationSubNumber,"1111111111",5);
memcpy(pIn11.CAMELSMSAdress,"11111111111",5);
memcpy(pIn11.SmsReferenceNumber,"111111111",5);
pIn11.DynamicAddressFlag=2;
pIn11.AnonyAccessIndicator=2;
memcpy(pIn11.APNOperatorIdentifier,"11111111111",5);
pIn11.SystemType=2;
pIn11.SGSNChange=2;
memcpy(pIn11.CauseForRecClosing,"111111",2);
memcpy(pIn11.RecordSequenceNumber,"11111111",5);
snprintf(pIn11.NodeID,LEN_NodeID+1,"2");
memcpy(pIn11.LocalRecordSequeceNumnber,"111111111",5);
memcpy(pIn11.UnsentDownlinkVolume,"1111111111",5);
snprintf(pIn11.RecordExtensions,LEN_RecordExtensions+1,"2");
pIn11.FlagRead=2;
snprintf(pIn11.SeqId,LEN_SEQ + 1,"2");
snprintf(pIn11.TableName,LEN_TABLENAME + 1,"CSCDR");
pIn11.FlagRepeat=2;
pIn11.FlagR499=2;
snprintf(pIn11.DateCreated,LEN_DATETIME + 1,"2");
snprintf(pIn11.GsnId,LEN_GSNID+1,"2");

DbCSCDRInsert(&pIn11, &pOut11);


//test CSCDR end


//test insert begin
char pInSzTableName[LEN_TABLENAME + 1] = {"OGTPL"};
char szInSeqId[]={"1"};
int RecordType=2;
char szOutContent[]={"fjdsakfj"};
char szOutSeqId[]={"1"};
int nPeerIp=2;
int nFlagCancel=1;

DbGTPSelect(&pInSzTableName,&szInSeqId,&RecordType,
	&szOutContent, &szOutSeqId,&nPeerIp,&nFlagCancel);

//test insert end 

//	ReadGtp(gtp);

//	gtp.Test();

  /*	C_CDRWriteASNDecode asn;
	asn.Test();
//	asn.Test2();*/
/*	C_CDRReadForCombined readCom;
	readCom.Test();

	/*
	C_CDRWriteCombined writeCom;
	writeCom.Test();
*/
	C_CDRReadForBill bill;
	bill.Test();

/*	C_CDRReadForCombined readCom;
	readCom.Test();
/*

//	gtp.Disconnect();
	cout<<"Good Bye to TEST2\n";
/*
	for(int i=0;i<10000;i++)
	{
		char* a = gtp.GetSysdate();
		CDate date(a, a);
		date.Calculate();
		printf("%d %d\n", i, date.GetCount());
		printf("%d %s\n", i ,date.GetAt(i).c_str());
	}
*/
}