def retrive_and_insert_to_db(self, serial_count, sku_start, serialCode, skuCode, reference): reddisHelper = RedisHelper() # get serial list serial_list = reddisHelper.redis_spop_str(self.giftcard_prefix + serialCode + self.giftcard_list, serial_count) denomination_id = self.get_denomination_id(serialCode) sku_prefix = Utils.generate_skuCode_prefix(skuCode) current_time = datetime.datetime.utcnow() sku_count = 0 for i in range(len(serial_list)): giftcard = CardGiftCard() giftcard.gfSerial = serial_list[i] giftcard.gfPin = self.generate_pin() giftcard.gfConsumed_dt = '0000-00-00 00:00:00' giftcard.gfCreate_dt = current_time giftcard.gfReference = reference giftcard.gfStatus = 'X' giftcard.gfSKU = sku_prefix + str(sku_start + sku_count).zfill(6) giftcard.gfDenom_id = denomination_id sku_count += 1 db.session.add(giftcard) db.session.commit() db.session.close()
def test_query_demonation(self): for i in range(10): print(Utils.getCardDenomination('UP500')) tempvalue = '27' giftcard = CardGiftCard() giftcard.gfSerial = tempvalue giftcard.gfPin = tempvalue giftcard.gfConsumed_dt = datetime.datetime.utcnow() giftcard.gfCreate_dt = datetime.datetime.utcnow() giftcard.gfReference = tempvalue giftcard.gfStatus = 'X' giftcard.gfSKU = tempvalue giftcard.gfDenom_id = 6 db.session.add(giftcard) db.session.commit() # db.session.close() for i in range(100): print(Utils.getCardDenomination('UP500'))