code: def get_jids():
      '''
      Return a list of all job ids
      For master job cache this also formats the output and returns a string
      '''
      conn = _get_conn()
      cur = conn.cursor()
      sql = '''SELECT ''' \
            '''jid, tgt_type, cmd, tgt, kwargs, ret, username, arg, fun ''' \
            '''FROM jids'''
      if __opts__['keep_jobs'] != 0:
          sql = sql + " WHERE started > NOW() - INTERVAL '" \
                  + six.text_type(__opts__['keep_jobs']) + "' HOUR"
  
      cur.execute(sql)
      ret = {}
      data = cur.fetchone()
      while data:
          data_dict = _build_dict(data)
          ret[data_dict["jid"]] = \
              _format_jid_instance(data_dict["jid"], data_dict)
          data = cur.fetchone()
      cur.close()
      conn.close()
      return ref get_jids():
      '''
      Return a list of all job ids
      For master job cache this also formats the output and returns a string
      '''
      conn = _get_conn()
      cur = conn.cursor()
      sql = '''SELECT ''' \
            '''jid, tgt_type, cmd, tgt, kwargs, ret, username, arg, fun ''' \
            '''FROM jids'''
      if __opts__['keep_jobs'] != 0:
          sql = sql + " WHERE started > NOW() - INTERVAL '" \
                  + six.text_type(__opts__['keep_jobs']) + "' HOUR"
  
      cur.execute(sql)
      ret = {}
      data = cur.fetchone()
      while data:
          data_dict = _build_dict(data)
          ret[data_dict["jid"]] = \
              _format_jid_instance(data_dict["jid"], data_dict)
          data = cur.fetchone()
      cur.close()
      conn.close()
      return ret
docs: Return a list of all job ids
      For master job cache this also formats the output and returns a string