Python Get.read_all Examples

Example #1

def admin():  # admin view pending request list
    statement = """SELECT * FROM Request r INNER JOIN BaseProperty bp ON bp.PropertyID = r.PropertyID WHERE bp.OwnershipID = '7EE30661-80AD-4862-966B-7279D0F80D22'"""
    request_list = []
    records = Get.read_all(statement=statement)
    for record in records:
        request_list.append(vars(Request.Request(record)))
    return request_list

Example #2

File: ViewBilling.py Project: alexw1118/TwoDays

def overview_unpaid():  # Overview of unpaid bill
    statement = """SELECT * FROM Billing WHERE PaymentDate IS NULL"""
    unpaid_bill_list = []
    records = Get.read_all(statement=statement)
    for record in records:
        bill = Billing.Billing(record)
        unpaid_bill_list.append(bill.billing_amount)
    return sum(unpaid_bill_list)

Example #3

File: ViewProperty.py Project: alexw1118/TwoDays

def view(statement):
    property_list = []
    records = Get.read_all(statement=statement)
    for record in records:
        property_list.append(vars(BaseProperty.BaseProperty(record)))
    return property_list