

def test_checked_out(self):
    q = "\n            SELECT bib_id, circ_transactions.circ_transaction_id\n            FROM bib_mfhd, mfhd_item, item, circ_transactions\n            WHERE ROWNUM = 1\n              AND circ_transactions.charge_due_date IS NOT NULL\n              AND circ_transactions.charge_due_date < TO_DATE('2382-12-31', 'YYYY-MM-DD')\n              AND circ_transactions.item_id = item.item_id\n              AND item.item_id = mfhd_item.item_id\n              AND mfhd_item.mfhd_id = bib_mfhd.mfhd_id\n            "
    (bib_id, circ_id) = _fetch_one(q)
    a = get_availability(str(offer))
    found = False
    for offer in a['offers']:
        if ('availabilityStarts' in offer):
            found = True
    self.assertTrue(found)

dataset/ETHPy150Open gwu-libraries/launchpad/lp/ui/dbtest.py DbTests.test_checked_out/VarMisuse@31/223 `bib_id`->`offer`