def add_transaction(user): wallets = user.wallets for wallet in wallets: print(wallet.id, wallet.name, wallet.balance) ch = int(input("Choose a Wallet ID: ")) wallet = Wallet.get(Wallet.id == ch) is_expense = int(input("Choose Type:\n0. Income\n1.Expense")) if not is_expense: from_person = input("From Who: ") else: from_person = "None" tranx_name = input("Enter Purpose: ") amount = float(input("Enter Amount: ")) comment = input("Any comments? \n") Transaction.create(owner=user, wallet=wallet, name=tranx_name, amount=amount, comment=comment, from_person=from_person, timestamp=datetime.now(), is_expense=bool(is_expense))
def purchase_product(product_id, buyer_id, quantity, price): Transaction.create( user_id=buyer_id, product_id=product_id, number=quantity, sell_date=datetime.now(), sell_price=price, )
def create_transaction(client_id, recipient_number, amount): try: recipient = Bill.objects.get(number=recipient_number) except: return [recipient_number, amount] trans = Transaction() trans.create(client_id, recipient, amount) return trans.code
def authenticate(): GESTURES = ['FIST', 'LEFT', 'OPEN', 'RIGHT'] gesture_one = None gesture_two = None gesture_three = None query = Transaction.delete() query.execute() secure_random = random.SystemRandom() while (gesture_one == gesture_two or gesture_two == gesture_three): gesture_one = secure_random.choice(GESTURES) gesture_two = secure_random.choice(GESTURES) gesture_three = secure_random.choice(GESTURES) transaction_id = 0 transaction = Transaction.create(gesture_one=gesture_one, gesture_two=gesture_two, gesture_three=gesture_three, transaction_id=transaction_id) return jsonify(gesture_one=gesture_one, gesture_two=gesture_two, gesture_three=gesture_three, transaction_id=transaction_id)
def buy_validate(): params = request.get_json() paramsToken = logged_checker(params.get('token')) paramsCode = params.get('code') if paramsToken is False: return jsonify({ 'error': 'Token expired, please update it on /tokens/update/<id> ' }) else: try: code = BuyCode.get(BuyCode.buy_code == paramsCode) if code.buy_code == paramsCode: charge = stripe.Charge.retrieve(code.charge_id) charge.capture() transaction = Transaction.create(user_id=code.user_id, amount=charge.amount, bank='Stripe') transaction.save() transactionData = model_to_dict(transaction) return jsonify({ 'response': 'Payement worked and transaction well registered in DB', 'transaction': transactionData }), 201 return str('Code given did not match to code generated') except Exception as identifier: return jsonify( {'error': '{message}'.format(message=identifier.message)}), 404
def create_transaction(): # Get the token in the parameters params = request.get_json() paramsToken = params.get('token') paramsAmount = params.get('amount') paramsBank = params.get('bank') # Check if the token exist try: token = Token.get(Token.token == paramsToken) if time.time() < token.expiration_date: transaction = Transaction.create(user_id=token.user_id, amount=paramsAmount, bank=paramsBank) transaction.save() transactionData = model_to_dict(transaction) return jsonify({ 'response': 'Transaction well created', 'transaction': transactionData }), 201 else: return str( 'Your token is expired. Please update it by login again on: /tokens/update/<id>.' ) except Exception as identifier: return jsonify({ 'error': 'Token not found {message}'.format(message=identifier.message) }), 404
def create_transaction(): try: # Get params from request params = request.get_json() # Build attributes with sent params user_id = params.get('user_id') amount = params.get('amount') print 'user_id : ', user_id print 'amount : ', amount # Create and save new transaction query = Transaction.create(amount=amount, user_id=user_id) query.save() transaction = model_to_dict(query) # Send newly created transaction to browser in JSON, 201 means 'success' return jsonify({ 'new_transaction': transaction }), 201 # Catch error if request fails except Exception as error: print error # Send error to browser return jsonify({ 'error': 'Not found' }), 404
def write(df): items_added = 0 transactions_added = 0 transaction_record_added = 0 item_set = set() transaction_set = set() transaction_record_set = set() for index, row in df.iterrows(): item_set.add(extract_item(row)) transaction_set.add(extract_transaction(index, row)) transaction_record_set.add(extract_transaction_item(index, row)) for item in item_set: is_added = Item.create(**dict(item)) if is_added: items_added += 1 for transaction in transaction_set: is_added = Transaction.create(**dict(transaction)) if is_added: transactions_added += 1 for record in transaction_record_set: record = dict(record) item = Item.get(name=record['item_name']) if item is None: continue record['item_id'] = item.id del record['item_name'] is_added = Transaction_Item.create(**record) if is_added: transaction_record_added += 1 print('\rItems added: {}\nTransactions added: {}\nRecords added: {}\n'. format(items_added, transactions_added, transaction_record_added), flush=True)
def save_transaction(self, TRANSID, ACCOUNTID, TOACCOUNTID, PAYEEID, TRANSAMOUNT, TRANSCODE, STATUS, TRANSACTIONNUMBER, NOTES, CATEGID, SUBCATEGID, TRANSDATE, FOLLOWUPID, TOTRANSAMOUNT): t = Transaction.create(TRANSID = TRANSID, ACCOUNTID=ACCOUNTID, TOACCOUNTID=TOACCOUNTID, PAYEEID=PAYEEID, TRANSAMOUNT=TRANSAMOUNT, TRANSCODE=TRANSCODE, STATUS=STATUS, TRANSACTIONNUMBER=TRANSACTIONNUMBER, NOTES=NOTES, CATEGID=CATEGID, SUBCATEGID=SUBCATEGID, TRANSDATE=TRANSDATE, FOLLOWUPID=FOLLOWUPID, TOTRANSAMOUNT=TOTRANSAMOUNT) id = t.TRANSID return id