#!/usr/bin/python

import sys

import mitsfs

def dumpcode(d, shelfcode):
    title_ids = list(d.cursor.execute(
        'select distinct title_id from book natural join shelfcode'
        ' where shelfcode=%s and not withdrawn',
        (shelfcode,)
        ))
    line_ids = [
        (mitsfs.dexline(mitsfs.title(d, title_id)), title_id)
        for title_id in title_ids
        ]
    line_ids.sort()
    for (line, title_id) in line_ids:
        print line

def main():
    d = mitsfs.dexdb()
    for code in sys.argv[1:]:
        dumpcode(d, code)

if __name__ == '__main__':
    main()
