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