def __iter__(self): with self.database(name='crontabber-get-apps') as connection: for each in execute_query_iter( connection, "SELECT app_name FROM crontabber" ): yield each[0]
def copy(self, connection): sql = """SELECT app_name, next_run, first_run, last_run, last_success, depends_on, error_count, last_error, ongoing FROM crontabber """ columns = ( 'app_name', 'next_run', 'first_run', 'last_run', 'last_success', 'depends_on', 'error_count', 'last_error', 'ongoing' ) all = {} for record in execute_query_iter(connection, sql): row = dict(zip(columns, record)) if isinstance(row['last_error'], basestring): row['last_error'] = json.loads(row['last_error']) all[row.pop('app_name')] = row return all
def copy(self, connection): sql = """SELECT app_name, next_run, first_run, last_run, last_success, depends_on, error_count, last_error, ongoing FROM crontabber """ columns = ('app_name', 'next_run', 'first_run', 'last_run', 'last_success', 'depends_on', 'error_count', 'last_error', 'ongoing') all = {} for record in execute_query_iter(connection, sql): row = dict(zip(columns, record)) all[row.pop('app_name')] = row return all
def copy(self, connection): sql = """SELECT app_name, next_run, first_run, last_run, last_success, depends_on, error_count, last_error FROM crontabber """ columns = ('app_name', 'next_run', 'first_run', 'last_run', 'last_success', 'depends_on', 'error_count', 'last_error') all = {} for record in execute_query_iter(connection, sql): row = dict(zip(columns, record)) if isinstance(row['last_error'], basestring): row['last_error'] = json.loads(row['last_error']) all[row.pop('app_name')] = row return all