backend/app.py

   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)