def __getitem__(self, key):
sql = """<STR_LIT>"""<EOL>columns = (<EOL>'<STR_LIT>', '<STR_LIT>', '<STR_LIT>', '<STR_LIT>',<EOL>'<STR_LIT>', '<STR_LIT>', '<STR_LIT>', '<STR_LIT>'<EOL>)<EOL>try:<EOL><INDENT>record = self.transaction_executor(single_row_sql, sql, (key,))<EOL><DEDENT>except SQLDidNotReturnSingleRow:<EOL><INDENT>raise KeyError(key)<EOL><DEDENT>row = dict(list(zip(columns, record)))<EOL>return row<EOL>
return the job info or raise a KeyError