def test_SMSCharUTF8(self): self.nsadminHelper.configureGateway('HIGH', 'cardboardfishmock') messageArabic = "في شعري ، ونحن نعملمجمو باستمرار لمساعدة العملاء على تحقيق النجاح في الأسواق المتطورة بسرعة من خلال حلول عالمية" msgDict = { "messageClass": "SMS", "priority": "HIGH", "truncate": False, "message": messageArabic } resp = self.nsadminHelper.createAndSendMessage(msgDict) currentMonthTable = NSAdminHelper.getTableName() query = 'select status, message_count, message from ' + currentMonthTable + ' where id=' + str( resp) resp = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(resp[0][0] in [7, 35], 'Messages status') Assertion.constructAssertion( resp[0][2].encode('utf8') == messageArabic, 'Arabic Char') Assertion.constructAssertion(resp[0][1] == 2, 'Message count') messageChinese = "在毛細管中,我們不斷努力,以幫助我們的客戶通過我們的世界級解決方案,服務和產品成功在快速發展的市場 - 將合併在毛細管中,我們不斷努力,以以- 將合併在毛細管中,我們不斷努力,以以" msgDict = { "messageClass": "SMS", "priority": "HIGH", "truncate": False, "message": messageChinese } resp = self.nsadminHelper.createAndSendMessage(msgDict) currentMonthTable = NSAdminHelper.getTableName() query = 'select status, message_count, message from ' + currentMonthTable + ' where id=' + str( resp) resp = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(resp[0][0] in [7, 35], 'Messages status') Assertion.constructAssertion( resp[0][2].encode('utf8') == messageChinese, 'Chinese Char') Assertion.constructAssertion(resp[0][1] == 2, 'Message count')
def test_SMScharLimit(self): self.nsadminHelper.configureGateway('HIGH', 'cardboardfishmock') message160CharSize = "At Capillary, we continuously work to help our clients succeed in rapidly evolving markets through our world-class solutions, services and products - combining" msgDict = { "messageClass": "SMS", "priority": "HIGH", "message": message160CharSize } resp = self.nsadminHelper.createAndSendMessage(msgDict) currentMonthTable = NSAdminHelper.getTableName() query = 'select status, message_count, message from ' + currentMonthTable + ' where id=' + str( resp) resp = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(resp[0][0] in [7, 35], 'Messages status') Assertion.constructAssertion(resp[0][2] == message160CharSize, '160 Char limit') Assertion.constructAssertion(resp[0][1] == 1, 'Message count') message320CharSize = "At Capillary, we continuously work to help our clients succeed in rapidly evolving markets through our world-class solutions, services and products. By combining big data with a robust, cloud-based analytics engine, we optimize the relevance and profitability of discounts and personalized offers to consumers in real time, significantly increasing both loyalty and sales" msgDict = { "messageClass": "SMS", "priority": "HIGH", "message": message320CharSize } resp = self.nsadminHelper.createAndSendMessage(msgDict) currentMonthTable = NSAdminHelper.getTableName() query = 'select status, message_count, message from ' + currentMonthTable + ' where id=' + str( resp) resp = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(resp[0][0] in [7, 35], 'Messages status') Assertion.constructAssertion(resp[0][1] == 1, 'Message count without truncate') msgDict = { "messageClass": "SMS", "priority": "HIGH", "truncate": False, "message": message320CharSize } resp = self.nsadminHelper.createAndSendMessage(msgDict) currentMonthTable = NSAdminHelper.getTableName() query = 'select status, message_count, message from ' + currentMonthTable + ' where id=' + str( resp) resp = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(resp[0][0] in [7, 35], 'Messages status') Assertion.constructAssertion(resp[0][2] == message320CharSize, '320 Char limit') Assertion.constructAssertion(resp[0][1] == 3, 'Message count')
def test_Count_Messages_RECEIVED_IN_QUEUE_READ(self): currentMonth = NSAdminHelper.getTableName() query = 'SELECT COUNT( * ) FROM ' + currentMonth + ' where sent_time >= SUBDATE( current_date, 2) and sent_time < current_date and status in (2,35)' output = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(output[0][0] == 0, 'RECEIVED_IN_QUEUE & READ count', verify=True)
def test_Count_Messages_DELAYED_SCHEDULED(self): currentMonth = NSAdminHelper.getTableName() query = 'SELECT COUNT( * ) FROM ' + currentMonth + ' where sent_time >= SUBDATE( current_date, 2) and sent_time < current_date and status in (33)' output = dbHelper.queryDB(query, 'nsadmin') Assertion.constructAssertion(output[0][0] == 0, 'DELAYED_SCHEDULED count')