

def test_temp_location(self):
    q = '\n            SELECT bib_id, item.item_id\n            FROM bib_mfhd, mfhd_item, item\n            WHERE ROWNUM = 1\n              AND item.temp_location = 682\n              AND item.item_id = mfhd_item.item_id\n              AND mfhd_item.mfhd_id = bib_mfhd.mfhd_id\n            '
    (bib_id, item_id) = _fetch_one(a)
    a = get_availability(str(bib_id))
    for o in a['offers']:
        if (('serialNumber' in o) and (o['serialNumber'] == str(item_id))):
            self.assertEqual(o['availabilityAtOrFrom'].lower(), 'wrlc shared collections facility')

dataset/ETHPy150Open gwu-libraries/launchpad/lp/ui/dbtest.py DbTests.test_temp_location/VarMisuse@22/143 `q`->`a`