def get_price_range_by_level(currency, gap, purchase):
if not currency or not gap or not purchase:
return []
level_gaps = []
price = Helper.get_current_price(currency)
price_gaps = calculate_levels(price, gap, purchase)
for p in range(1, 5):
gap = dict()
gap["level"] = p
if p == 1:
gap["range"] = [price, price_gaps[0]]
level_gaps.append(gap)
continue
gap["range"] = [price_gaps[p - 2], price_gaps[p - 1]]
level_gaps.append(gap)
return level_gaps
def update_transactions_by_state_outcome(transaction, status, outcome):
trade = transaction
cursor = connection.cursor()
closing_price = Helper.get_current_price(trade["currency"])
query_update = ""
query_update = query_update + f"UPDATE user_transactions " \
f"SET status = '{status}', outcome ='{outcome}', " \
f"closing_price = {closing_price} WHERE user_id = {transaction['user_id']} " \
f"AND transaction_id = {transaction['transaction_id']}"
cursor.execute("BEGIN BATCH " + query_update + "APPLY BATCH")
delete_query = ""
delete_query = delete_query + f"DELETE FROM transactions_by_state " \
f"WHERE user_id = {transaction['user_id']} AND status = '{transaction['status']}' " \
f"AND outcome = '{trade['outcome']}' " \
f"AND created_date = '{Helper.remove_milliseconds(trade['created_date'])}'"
delete_query = delete_query + f" DELETE FROM transactions_by_start_time " \
f"WHERE status = '{transaction['status']}' " \
f"AND start_time = '{Helper.remove_milliseconds(trade['start_time'])}' " \
f"AND transaction_id = {transaction['transaction_id']} " \
f"AND user_id = {transaction['user_id']}"
delete_query = delete_query + f" DELETE FROM transactions_by_end_time " \
f"WHERE status = '{transaction['status']}' " \
f"AND end_time = '{Helper.remove_milliseconds(transaction['end_time'])}' " \
f"AND transaction_id = {transaction['transaction_id']} " \
f"AND user_id = {transaction['user_id']}"
delete_query = delete_query + f" DELETE FROM transactions_changes_allowed_time " \
f"WHERE status = '{transaction['status']}' " \
f"AND changes_allowed_time = '{Helper.remove_milliseconds(trade['changes_allowed_time'])}' " \
f"AND transaction_id = {transaction['transaction_id']} " \
f"AND user_id = {transaction['user_id']}"
cursor.execute("BEGIN BATCH " + delete_query + "APPLY BATCH")
insert_query = ""
transaction_id = trade['transaction_id']
user_id = trade['user_id']
currency = trade['currency']
purchase_type = trade['purchase_type']
created_date = Helper.remove_milliseconds(trade['created_date'])
amount = trade['amount']
trade_type = trade['trade_type']
start_time = Helper.remove_milliseconds(trade['start_time'])
end_time = Helper.remove_milliseconds(trade['end_time'])
changes_allowed_time = Helper.remove_milliseconds(
trade['changes_allowed_time'])
insert_query = insert_query + f"INSERT INTO transactions_by_state " \
f"(transaction_id, user_id, currency, purchase_type, outcome, status, " \
f"created_date, amount, trade_type) " \
f"VALUES " \
f"({transaction_id}, {user_id},'{currency}','{purchase_type}','{outcome}'," \
f"'{status}','{created_date}',{amount},'{trade_type}')"
insert_query = insert_query + f"INSERT INTO transactions_by_start_time " \
f"(transaction_id,user_id,status,start_time) " \
f"VALUES " \
f"({transaction_id},{user_id},'{status}','{start_time}')"
insert_query = insert_query + f"INSERT INTO transactions_by_end_time " \
f"(transaction_id,user_id,status,trade_type,end_time) " \
f"VALUES " \
f"({transaction_id},{user_id},'{status}'," \
f"'{trade_type}','{end_time}')"
insert_query = insert_query + f"INSERT INTO transactions_changes_allowed_time " \
f"(transaction_id,user_id,status,changes_allowed_time) " \
f"VALUES " \
f"({transaction_id},{user_id},'{status}','{changes_allowed_time}')"
cursor.execute("BEGIN BATCH " + insert_query + "APPLY BATCH")
def create_trade(req):
post = req.POST
currency = post['currency']
time_to_close = post['time_to_close']
time_slot = post['time_slot']
time_count = post['time_count']
end_date = post['end_date']
end_time = post['end_time']
amount = post['amount']
gap_pips = post['gap_pips']
select_level = post['select_level']
purchase = post['purchase']
trade_type = 'levels'
start_time = datetime.now()
ac = Authentication(req)
user_id = ac.get_user_session()
trade_start_time = datetime.now()
error_messages = []
error_messages.extend(Trading.validate_currency(currency))
error_messages.extend(validate_pip_gaps(gap_pips))
error_messages.extend(validate_levels(select_level))
error_messages.extend(Trading.validate_time_to_close(time_to_close))
error_messages.extend(
Trading.validate_closing_types(time_to_close, time_slot, time_count,
end_date, end_time))
error_messages.extend(Trading.validate_amount(amount, user_id))
error_messages.extend(
validated_end_date(time_to_close, end_date, end_time, time_slot,
time_count, start_time))
# final method to get selected levels
levels_price = get_price_range_by_level(currency, gap_pips, purchase)
# final method to get selected level
selected_level = get_selected_level(select_level, currency, gap_pips,
purchase)
# final method to get trade closing time
trade_closing_time = get_trade_end_time(time_to_close, end_date, end_time,
time_slot, time_count, start_time)
error_messages.extend(Trading.validate_close_time_day(trade_closing_time))
error_messages.extend(Trading.validate_end_time(trade_closing_time))
if error_messages:
return JsonResponse(Helper.get_json_response(False, {},
error_messages))
price = Helper.get_current_price(currency)
changes_allowed_time = Trading.get_trade_changing_blocked_time(
start_time, trade_closing_time)
level_owners = get_level_owner(select_level, user_id)
time_now_formatted = Helper.get_current_time_formatted()
time_now = datetime.strptime(time_now_formatted, '%Y-%m-%d %H:%M:%S.%f%z')
purchase_type = Trading.get_trade_type(purchase)
available_levels = get_available_levels(Levels.levels.value, select_level)
current_user = Helper.get_user_by_id(user_id)
user_currency = current_user['currency']
user_transaction = TransactionsByUser(user_id=user_id,
created_date=time_now)
user_transaction.save()
query = f"SELECT * FROM transactions_by_user WHERE user_id = {user_id} and created_date = '{time_now_formatted}'"
cursor = connection.cursor()
transaction_id = cursor.execute(query)
transaction_id = transaction_id[0]["id"]
user_transactions = f"INSERT INTO user_transactions " \
f"(transaction_id,user_id,created_date,trade_type,purchase_type,currency,staring_price,amount," \
f"start_time,end_time,changes_allowed_time,outcome,status,level_pips, levels_price,level_owners," \
f"join_date,level_start_price,level_end_price,level_selected,created_by,child," \
f"available_levels,amount_currency) " \
f"VALUES " \
f"({transaction_id},{user_id},'{time_now_formatted}','{Types.LEVELS.value}','{purchase_type}'," \
f"'{currency}',{float(price)},{float(amount)},'{Helper.get_time_formatted(trade_start_time)}'," \
f"'{Helper.get_time_formatted(trade_closing_time)}'," \
f"'{Helper.get_time_formatted(changes_allowed_time)}','{Outcome.NONE.value}'," \
f"'{Status.STARTED.value}',{int(gap_pips)},'{json.dumps(levels_price)}','{level_owners}'," \
f"'{time_now_formatted}',{selected_level['range'][0]},{selected_level['range'][1]}," \
f"{selected_level['level']},{user_id},{False},{available_levels},'{current_user['currency']}')"
cursor.execute(user_transactions)
transactions_by_state = f"INSERT INTO transactions_by_state " \
f"(transaction_id,user_id,currency,purchase_type,outcome,status,created_date,amount," \
f"trade_type) " \
f"VALUES " \
f"({transaction_id},{user_id},'{currency}','{purchase_type}','{Outcome.NONE.value}'," \
f"'{Status.STARTED.value}','{time_now_formatted}',{float(amount)},'{Types.LEVELS.value}')"
cursor.execute(transactions_by_state)
transactions_levels_status = f"INSERT INTO transactions_levels_status " \
f"(transaction_id,user_id,outcome,purchase_type,currency,status,created_date,amount," \
f"trade_type,start_time,end_time,available_levels,amount_currency) " \
f"VALUES " \
f"({transaction_id},{user_id},'{Outcome.NONE.value}','{purchase_type}','{currency}'," \
f"'{Status.STARTED.value}','{time_now_formatted}',{float(amount)}," \
f"'{Types.LEVELS.value}','{Helper.get_time_formatted(trade_start_time)}'," \
f"'{Helper.get_time_formatted(trade_closing_time)}',{available_levels}, '{user_currency}')"
cursor.execute(transactions_levels_status)
transactions_by_end_time = f"INSERT INTO transactions_by_end_time " \
f"(transaction_id,user_id,status,trade_type,end_time) " \
f"VALUES " \
f"({transaction_id},{user_id},'{Status.STARTED.value}','{Types.LEVELS.value}'," \
f"'{Helper.get_time_formatted(trade_closing_time)}')"
cursor.execute(transactions_by_end_time)
transactions_changes_allowed_time = f"INSERT INTO transactions_changes_allowed_time " \
f"(transaction_id,user_id,status,changes_allowed_time) " \
f"VALUES " \
f"({transaction_id},{user_id},'{Status.STARTED.value}'," \
f"'{Helper.get_time_formatted(changes_allowed_time)}')"
cursor.execute(transactions_changes_allowed_time)
level_based_user_counts = f"INSERT INTO level_based_user_counts " \
f"(transaction_id,user_count) " \
f"VALUES " \
f"({transaction_id},1)"
cursor.execute(level_based_user_counts)
level_based_user_levels = f"INSERT INTO level_based_user_levels " \
f"(transaction_id,level_number) " \
f"VALUES " \
f"({transaction_id},{selected_level['level']})"
cursor.execute(level_based_user_levels)
level_based_by_user_id = f"INSERT INTO level_based_by_user_id " \
f"(transaction_id,owner,user_id) " \
f"VALUES " \
f"({transaction_id},{True},{user_id})"
cursor.execute(level_based_by_user_id)
updated_amount = float(current_user['vcurrency']) - float(amount)
# update account balance
user_vcurrency = f"UPDATE user_by_id SET vcurrency = {updated_amount} WHERE id = {user_id}"
cursor.execute(user_vcurrency)
Helper.store_state_value(user_id, StatKeys.BALANCE.value, amount,
'subtract')
Helper.store_state_value(user_id, StatKeys.NUM_TRADES.value, 1, 'add')
Helper.store_state_value(user_id, StatKeys.LEVELS.value, 1, 'add')
Trading.save_purchase_stats(user_id, purchase_type)
Trading.save_levels_stats(user_id, select_level)
Trading.save_levels_general_stats(user_id, select_level, amount,
purchase_type)
return JsonResponse(
Helper.get_json_response(True, {
'transaction_id': str(transaction_id),
"user_id": str(user_id)
}, ['Trade created successfully']))
