def test_SendAndCheckFGMessageComm(self): """ Verifies requirements PAN000001 and PAN000002. Sends a finished goods message for a Communicator and then checks that Finished Goods message was sent successfully. """ # Send Finished Goods Message self.pandaInstance.sendFinishedGoodsMessage(self.clinic1, CommEntity=self.comm) finishedGoodsDict = {} finishedGoodsDict["Communicator"] = {"ModelNumber":self.comm.modelNumber, "SerialNumber":self.comm.serialNumber, 'MaterialNumber' : self.comm.modelNumber + "-100", 'SoldToSapId' : self.clinic1.sapId, 'MovementDateTime' : '2008-05-21T18:42:38-06:00', } # Query database for communicator cQuery = ("select count(*) AS Count from APM.DEVICE where SERIAL_NBR = " + str(self.commSerial) + " AND MODEL_ID in ( select Model_ID from APM.MODEL where MODEL_NBR= '%s')") % self.comm.modelNumber count = db.executeQuery(cQuery, self.testContext['env'].db.user, self.testContext['env'].db.pwd, self.testContext['env'].db.name) self.trace('PAN000001') self.verifyEqual(count,[[1]]) self.trace('PAN000002') self.verifyTrue(self.pandaInstance.checkFinishedGoods(self.clinic1, finishedGoodsDict))
def test_SendAndCheckFGMessagePG(self): """ Verifies requirements PAN000001 and PAN000002. Sends a finished goods message for a Pulse Generator and then checks that Finished Goods message was sent successfully. """ # Send Finished Goods Message self.pandaInstance.sendFinishedGoodsMessage(self.clinic1, PGEntity=self.pg) finishedGoodsDict = {} finishedGoodsDict["PulseGenerator"] = {"ModelNumber":self.pg.modelNumber, "SerialNumber":self.pg.serialNumber, "AccessCode": self.pg.wakeUpAccessCode, "Frequency": self.pg.rfCenterFrequency, "FullModel":self.pg.fullModelNumber } # Query database for PG pgQuery = ("select count(*) AS Count from APM.DEVICE where SERIAL_NBR = " + str(self.pgSerial) + " AND MODEL_ID in ( select Model_ID from APM.MODEL where MODEL_NBR= '%s')") % self.pg.fullModelNumber count = db.executeQuery(pgQuery, self.testContext['env'].db.user, self.testContext['env'].db.pwd, self.testContext['env'].db.name) self.trace('PAN000001') self.verifyEqual(count,[[1]]) self.trace('PAN000002') self.verifyTrue(self.pandaInstance.checkFinishedGoods(self.clinic1, finishedGoodsDict))
def test_SendAndCheckFGMessageBPMWithoutBtoothAddrss(self): """ Verifies requirements PAN000001 and PAN000002. Sends a finished goods message for a Blood Pressure Monitor and then checks that Finished Goods message was sent successfully. It also checks that the bluetooth address for the Blood Pressure Monitor was not received by the system successfully. """ # Send Finished Goods Message self.pandaInstance.sendFinishedGoodsMessage(self.clinic1, BPMEntity=self.bpmWithoutBtoothAddress) finishedGoodsDict = {} finishedGoodsDict["BloodPressureMonitor"] = {"ModelNumber":self.bpmWithoutBtoothAddress.modelNumber, "SerialNumber":self.bpmWithoutBtoothAddress.serialNumber, 'MaterialNumber' : self.bpmWithoutBtoothAddress.modelNumber + "-111", 'SoldToSapId' : self.clinic1.sapId, 'MovementDateTime' : '2008-05-21T18:42:38-06:00', 'BluetoothAddress' : self.bpmWithoutBtoothAddress.bluetoothAddress } # Query Device table for BPM bpQuery = ("select count(*) AS Count from APM.DEVICE where SERIAL_NBR = " + str(self.bpmSerialNoBT) + " AND MODEL_ID in ( select Model_ID from APM.MODEL where MODEL_NBR= '%s')") % self.bpm.modelNumber count = db.executeQuery(bpQuery, self.testContext['env'].db.user, self.testContext['env'].db.pwd, self.testContext['env'].db.name) self.trace('PAN000001') self.verifyEqual(count,[[1]]) # Query Security Key table for Bluetooth address btoothQuery = ("select count(*) As Count from APM.SECURITY_KEY SK, APM.DEVICE DEV WHERE SK.DEVICE_ID = DEV.DEVICE_Id" + " AND SK.SECURITY_KEY_TYPE_CD = 'BTAD' AND DEV.MODEL_ID in ( select Model_ID from APM.MODEL where MODEL_NBR= '%s')" + " AND DEV.SERIAL_NBR = " + str(self.bpmSerialNoBT)) % self.bpm.modelNumber count = db.executeQuery(btoothQuery, self.testContext['env'].db.user, self.testContext['env'].db.pwd, self.testContext['env'].db.name) self.trace('PAN000002') self.verifyEqual(count,[[0]]) self.verifyTrue(self.pandaInstance.checkFinishedGoods(self.clinic1, finishedGoodsDict))