@logExceptions(_LOGGER)<EOL><INDENT>@g_retrySQL<EOL>def getJobs(self, fields=[]):<DEDENT>
<EOL>dbFields = [self._jobs.pubToDBNameDict[x] for x in fields]<EOL>dbFieldsStr = '<STR_LIT:U+002C>'.join(['<STR_LIT>'] + dbFields)<EOL>with ConnectionFactory.get() as conn:<EOL><INDENT>query = '<STR_LIT>' % (dbFieldsStr, self.jobsTableName)<EOL>conn.cursor.execute(query)<EOL>rows = conn.cursor.fetchall()<EOL><DEDENT>return rows<EOL>
Fetch jobIDs for jobs in the table with optional fields