[perfect-gift.git] / backend / app.py

import sqlite3
from flask import Flask, jsonify
app = Flask(__name__)

@app.route('/wishlist/<string:wishlist_id>/entries')
def entries(wishlist_id):
    conn = sqlite3.connect('db.sqlite')
    curs = conn.cursor()

    data = []
    for row in curs.execute(
        'SELECT WISHLIST_ID, ITEM_ID, NAME, DESCRIPTION FROM WISHLIST_ENTRY WHERE WISHLIST_ID = ?',
        (wishlist_id,)
    ):
        data.append({'wishlist_id': row[0], 'item_id': row[1], 'name': row[2], 'description': row[3]})
    return jsonify(data)
Commit	Line	Data
d0194bf3 DT	1	import sqlite3
	2	from flask import Flask, jsonify
	3	app = Flask(__name__)
	4
	5	@app.route('/wishlist/<string:wishlist_id>/entries')
	6	def entries(wishlist_id):
	7	conn = sqlite3.connect('db.sqlite')
	8	curs = conn.cursor()
	9
	10	data = []
	11	for row in curs.execute(
	12	'SELECT WISHLIST_ID, ITEM_ID, NAME, DESCRIPTION FROM WISHLIST_ENTRY WHERE WISHLIST_ID = ?',
	13	(wishlist_id,)
	14	):
	15	data.append({'wishlist_id': row[0], 'item_id': row[1], 'name': row[2], 'description': row[3]})
	16	return jsonify(data)