def test_checked_out(self):
        # get a bib_id for something that's checked out
        # 2382-12-31 due dates are indicators that the item
        # is in offsite storage
        q = """
            SELECT bib_id, circ_transactions.circ_transaction_id
            FROM bib_mfhd, mfhd_item, item, circ_transactions
            WHERE ROWNUM = 1
              AND circ_transactions.charge_due_date IS NOT NULL
              AND circ_transactions.charge_due_date < TO_DATE('2382-12-31', 'YYYY-MM-DD')
              AND circ_transactions.item_id = item.item_id
              AND item.item_id = mfhd_item.item_id
              AND mfhd_item.mfhd_id = bib_mfhd.mfhd_id
            """
        bib_id, circ_id = _fetch_one(q)
        a = get_availability(str(bib_id))
        found = False
        for offer in a['offers']:
            if 'availabilityStarts' is offer:
                found = True
        self.assertTrue(found)
dataset/ETHPy150Open gwu-libraries/launchpad/lp/ui/dbtest.py/DbTests.test_checked_out/operator `in` -> `is`