def add_exercise():
exercise = request.json
columns = []
placeholders = []
params = []
for column, value in exercise.items():
columns.append(column)
placeholders.append('?')
params.append(value)
connection = content.open_connection()
cursor = connection.cursor()
cursor.execute(
''.join([
'INSERT INTO exercises (', ', '.join(columns), ') VALUES (',
', '.join(placeholders), ')'
]), params)
return {'id': cursor.lastrowid}
def add_exercise():
exercise = request.json
columns = []
placeholders = []
params = []
for column, value in exercise.items():
columns.append(column)
placeholders.append('?')
params.append(value)
connection = content.open_connection()
cursor = connection.cursor()
cursor.execute(
''.join(['INSERT INTO exercises (', ', '.join(columns), ') VALUES (', ', '.join(placeholders), ')']),
params
)
return {
'id': cursor.lastrowid
}
def update_exercise(exercise_id):
exercise = request.json
setters = []
params = []
for column, value in exercise.items():
setters.append('%s = ?' % column)
params.append(value)
params.append(exercise_id)
params.append(exercise['updated_time'])
connection = content.open_connection()
cursor = connection.cursor()
cursor.execute(
''.join([
'UPDATE exercises SET ', ', '.join(setters),
' WHERE id = ? AND updated_time < CAST(? AS INTEGER)'
]), params)
return {'updated': cursor.rowcount}
def update_exercise(exercise_id):
exercise = request.json
setters = []
params = []
for column, value in exercise.items():
setters.append('%s = ?' % column)
params.append(value)
params.append(exercise_id)
params.append(exercise['updated_time'])
connection = content.open_connection()
cursor = connection.cursor()
cursor.execute(
''.join(['UPDATE exercises SET ', ', '.join(setters), ' WHERE id = ? AND updated_time < CAST(? AS INTEGER)']),
params
)
return {
'updated': cursor.rowcount
}
def get_exercises():
columns = [
'id',
'created_time',
'updated_time',
'scope',
'scope_letters',
'definition',
'notes',
'rating',
'practice_time',
'disabled',
]
result = []
cursor = content.open_connection()
for row in cursor.execute('SELECT %s FROM exercises' % ', '.join(columns)):
row = list(row)
row[-1] = row[-1] != 0
result.append(dict(zip(columns, row)))
return result
def get_exercises():
columns = [
'id',
'created_time',
'updated_time',
'scope',
'scope_letters',
'definition',
'notes',
'rating',
'practice_time',
'disabled',
]
result = []
cursor = content.open_connection()
for row in cursor.execute('SELECT %s FROM exercises' % ', '.join(columns)):
row = list(row)
row[-1] = row[-1] != 0
result.append(dict(zip(columns, row)))
return result
