Odtnhj

I'm trying to make a web application with login functionality. After successful login, the user should add their request to the database with a SQL command:

db.execute(
 'INSERT INTO dailyLeave (dLeaveDateStart, dLeaveDateEnd, dComment, pId) '
 'VALUES (?, ?, ?, ?, ?, ?)',
 (dLeaveDateStart, dLeaveDateEnd, dComment, pId)

But I need a user id to put it as pId in the database. How can I get logged user id ?

They are in separate blueprints (APIs).

Save Id in session when the user logs in. Then you can retrieve it from the session.

First, you need to ensure that secret key is set at beginning of your Flask instance like so:

app = Flask(__name__)
app.secret_key = 'any random string’
...

When user logs in:

session['id'] = id

When you want to retrieve id, use session like python dictionary:

pId = session['id']

When user logs out:

session.pop('id')

I've this in my init.py:

def create_app(test_config=None):
app = Flask(__name__, instance_relative_config=True)
app.config.from_mapping(
 SECRET_KEY='dev', DATABASE=os.path.join(app.instance_path, 'abanDB.sqlite'),
)

Isn't it enough?

I've done this in auth.py:

@bp.route('/loginUser', methods=('GET', 'POST'))
def loginUser():
personId = request.form['personId']
session['id'] = personId
password = request.form['password']

and in off.py (where user should add requests):

@bp.route('/dailyUser', methods=('GET', 'POST'))
@login_required
def dailyUser():
 dComment = request.form['dComment']
 dLeaveDateStart = request.form['dLeaveDateStart']
 dLeaveDateEnd = request.form['dLeaveDateEnd']
 pId = session['id']
 print(pId)

but it prints nothing. What should I do?