virgool_moz_link_2.py

@app.route('/<id>')
def url_redirect(id):
    conn = sqlite3.connect('database.db')
    conn.row_factory = sqlite3.Row

    original_id = hashids.decode(id)
    if original_id:
        original_id = original_id[0]
        url_data = conn.execute('SELECT original_url, clicks FROM urls'
                                ' WHERE id = (?)', (original_id,)
                                ).fetchone()
        original_url = url_data['original_url']
        clicks = url_data['clicks']

        conn.execute('UPDATE urls SET clicks = ? WHERE id = ?',
                     (clicks+1, original_id))

        conn.commit()
        conn.close()
        return redirect(original_url)
    else:
        flash('Invalid URL')  # If Not valid Id: return index site
        return redirect(url_for('index'))