Python get_all_payments_for_customer Examples

Example #1

File: db_utility.py Project: awrigh36/birtdb-python

def get_total_payments_for_customer(cust_num):
    total_payments = 0
    payments = db_access_web.get_all_payments_for_customer(cust_num)

    if payments is not None:
        for row in payments:
            pay = row['amount']
            total_payments += pay
    else:
        return 0
    return total_payments

Example #2

File: test_db_access.py Project: awrigh36/birtdb-python

def all_payments():
    cust_num = 103
    payments = get_all_payments_for_customer(cust_num)
    max = 0
    for p in payments:
        # print(p)
        if p["amount"] > max:
            max = p["amount"]
    if len(payments) == 3:
        print("payments passed")
    else:
        print("payments failed****************")
    if max == 14571.44:
        print("payments passed")
    else:
        print("payments failed****************")