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
