def create_game(self, data): result = { 'err': 0, 'msg': 'Game Created' } self.database.create_game(data) return schemas.CommandResultSchema().dumps(result)
def create_round(self, data): result = { 'err': 0, 'msg': 'Round Created' } self.database.create_round(data) return schemas.CommandResultSchema().dumps(result)
def create_wordpack(self, data): result = { 'err': 0, 'msg': 'Wordpack Created' } self.database.create_wordpack(data) return schemas.CommandResultSchema().dumps(result)
def create_turn_detail(self, data): result = { 'err': 0, 'msg': 'Turn Detail Created' } self.database.create_turn_detail(data) return schemas.CommandResultSchema().dumps(result)
def create_transaction(self, data): result = {'err': 0, 'msg': 'Transaction Created'} user = self.user_rpc.get_user_by_id(data['id_user']) if user: wordpack = self.word_rpc.get_wordpack_by_id(data['id_word_pack']) if wordpack: new_balance = user['balance'] - wordpack['price'] if new_balance >= 0: data['amount'] = wordpack['price'] self.database.create_transaction(data) self.user_rpc.create_user_wordpack({ 'id_user': data['id_user'], 'id_word_pack': data['id_word_pack'], 'created_at': None, 'updated_at': None }) self.user_rpc.update_user({ 'id': user['id_user'], 'balance': new_balance }) else: result['err'] = 1 result['msg'] = 'Balance Not Enough' else: result['err'] = 1 result['msg'] = 'Wordpack Not Found' else: result['err'] = 1 result['msg'] = 'User Not Found' self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def update_game(self, data): result = { 'err': 0, 'msg': 'Game Updated' } if self.database.get_game_by_id(data['id']): self.database.update_game(data) else: result['err'] = 1 result['msg'] = 'Game Not Found' return schemas.CommandResultSchema().dumps(result)
def delete_round(self, data): result = { 'err': 0, 'msg': 'Round Deleted' } if self.database.get_round_by_id(data['id']): self.database.delete_round(data['id']) else: result['err'] = 1 result['msg'] = 'Round Not Found' return schemas.CommandResultSchema().dumps(result)
def delete_turn_detail(self, data): result = { 'err': 0, 'msg': 'Turn Detail Deleted' } if self.database.get_turn_detail_by_id(data['id']): self.database.delete_turn_detail(data['id']) else: result['err'] = 1 result['msg'] = 'Turn Detail Not Found' return schemas.CommandResultSchema().dumps(result)
def delete_game_member(self, data): result = { 'err': 0, 'msg': 'Game Member Deleted' } if self.database.get_game_member_by_id(data['id']): self.database.delete_game_member(data) else: result['err'] = 1 result['msg'] = 'Game Member Not Found' return schemas.CommandResultSchema().dumps(result)
def delete_wordpair(self, data): result = { 'err': 0, 'msg': 'Wordpair Deleted' } if self.database.get_wordpair_by_id(data['id']): self.database.delete_wordpair(data) else: result['err'] = 1 result['msg'] = 'Wordpair Not Found' return schemas.CommandResultSchema().dumps(result)
def create_wordpair(self, data): result = { 'err': 0, 'msg': 'Wordpair Added' } if self.database.get_wordpack_by_id(data['id_word_pack']): self.database.create_wordpair(data) else: result['err'] = 1 result['msg'] = 'Wordpack Not Found' return schemas.CommandResultSchema().dumps(result)
def update_wordpack(self, data): result = { 'err': 0, 'msg': 'Wordpack Updated' } if self.database.get_wordpack_by_id(data['id']): self.database.update_wordpack(data) else: result['err'] = 1 result['msg'] = 'Wordpack Not Found' return schemas.CommandResultSchema().dumps(result)
def add_game_member(self, data): result = { 'err': 0, 'msg': 'Game Member Added' } if self.user_rpc.get_user_by_id(data['id_member']): self.database.add_game_member(data) self.database.close_connection() else: result['err'] = 1 result['msg'] = 'User Not Found' return schemas.CommandResultSchema().dumps(result)
def create_voucher(self, data): result = {'err': 0, 'msg': 'Voucher Created'} if self.database.search_voucher(data['code']): result['err'] = 1 result['msg'] = 'Code Already Exists & Active' else: self.database.create_voucher(data) self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def update_transaction(self, data): result = {'err': 0, 'msg': 'Transaction Updated'} if self.database.get_transaction_by_id(data['id']): self.database.update_transaction(data) self.database.close_connection() else: result['err'] = 1 result['msg'] = 'Transaction Not Found' self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def redeem_voucher(self, data): result = {'err': 0, 'msg': 'Voucher Redeemed'} if self.database.search_voucher(data['code']): if self.transaction_rpc.search_voucher(data['code']): # self.database.redeem_voucher(data) # result['msg'] = 'Redeem Successfully' # self.database.close_connection() if self.user_rpc.get_user_by_id( data['redeemed_by']): #cek user ada atau ga tmp = self.user_rpc.get_user_by_id(data['redeemed_by']) tmp1 = self.transaction_rpc.search_voucher(data['code']) uawal = int(tmp['balance']) topup = tmp1[1]['amount'] uakhir = uawal + topup statusvoc = tmp1[0] if statusvoc: self.user_rpc.update_user({ "id": data['redeemed_by'], "balance": uakhir }) self.database.redeem_voucher(data) now = datetime.now() dt_string = now.strftime("%Y-%m-%d %H:%M:%S") print(dt_string) result['err'] = 0 result[ 'msg'] = 'Voucher Redeemed by' + " " + tmp['name'] else: result['err'] = 0 result['msg'] = 'Voucher Cant be Redeemed' self.database.close_connection() else: result['err'] = 1 result['msg'] = 'User tidak ada' self.database.close_connection() else: result['err'] = 1 result['msg'] = 'Code Already Inactive' self.database.close_connection() else: result['err'] = 1 result['msg'] = 'Code Not Found' self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def delete_voucher(self, id): result = {'err': 0, 'msg': 'Voucher Deleted'} if self.database.get_voucher_by_id(id): self.database.delete_voucher(id) self.database.close_connection() else: result['err'] = 1 result['msg'] = 'Voucher Not Found' self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def delete_transaction(self, id): result = {'err': 0, 'msg': 'Transaction Deleted'} if self.database.get_transaction_by_id(id): self.database.delete_transaction(id) self.database.close_connection() else: result['err'] = 1 result['msg'] = 'Transaction Not Found' self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def update_round_detail(self, data): result = { 'err': 0, 'msg': 'Round Detail Updated' } if not self.database.get_round_detail_by_id(data['id']): result['err'] = 1 result['msg'] = 'Round Detail Not Found' elif not self.user_rpc.get_user_by_id(data['id_user']): result['err'] = 1 result['msg'] = 'User Not Found' else: self.database.update_round_detail(data) return schemas.CommandResultSchema().dumps(result)
def update_user_wordpack(self, data): result = {'err': 0, 'msg': 'User Wordpack Updated'} if self.database.get_user_wordpack_by_id(data['id']): self.database.update_user_wordpack(data) self.database.close_connection() else: result['err'] = 1 result['msg'] = 'User Wordpack Not Found' self.database.close_connection() return schemas.CommandResultSchema().dumps(result)
def create_round_detail(self, data): result = { 'err': 0, 'msg': 'Round Detail Created' } if not self.game_rpc.get_round_by_id(data['id_round']): result['err'] = 1 result['msg'] = 'Round Not Found' elif not self.user_rpc.get_user_by_id(data['id_user']): result['err'] = 1 result['msg'] = 'User Not Found' else: self.database.create_round_detail(data) self.database.close_connection() return schemas.CommandResultSchema().dumps(result)