find_by_name.py

def find_by_name(name):
        connection = sqlite3.connect('data.db')
        cursor = connection.cursor()

        query = "SELECT * FROM items WHERE name=?"
        result = cursor.execute(query, (name,))
        row = result.fetchone()
        connection.close()

        if row:
            return jsonify({'item': {'name': row[0], 'price': row[1]}})