code: def libs(args):
      
      p = OptionParser(libs.__doc__)
      p.set_db_opts(dbname="track", credentials=None)
      opts, args = p.parse_args(args)
  
      if len(args) != 1:
          sys.exit(not p.print_help())
  
      libfile, = args
  
      sqlcmd = "select library.lib_id, library.name, bac.gb# from library join bac on " + \
               "library.bac_id=bac.id where bac.lib_name='Medicago'"
      cur = connect(opts.dbname)
      results = fetchall(cur, sqlcmd)
  
      fw = open(libfile, "w")
      for lib_id, name, gb in results:
          name = name.translate(None, "\n")
          if not gb:
              gb = "None"
  
          print("|".join((lib_id, name, gb)), file=fw)
      fw.close()
docs: %prog libs libfile
  
      Get list of lib_ids to be run by pull(). The SQL commands:
  
      select library.lib_id, library.name from library join bac on
          library.bac_id=bac.id where bac.lib_name="Medicago";
      select seq_name from sequence where seq_name like 'MBE%'
          and trash is null;