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
