How does flask get self-increasing id after db.session.add

-sharp models
class User(db.Model):
    __tablename__ = "users"
    id = db.Column(db.BigInteger, primary_key=True)
    name = db.Column(db.VARCHAR(50), nullable=False)
    email = db.Column(db.VARCHAR(200), nullable=False)
    -sharp  NULL
    mobile = db.Column(db.VARCHAR(20), server_default=text("NULL"))

    -sharp 
    password = db.Column(db.VARCHAR, nullable=False)

    -sharp 
    _2fa = db.Column(db.VARCHAR(32), nullable=True)

    -sharp 
    created_at = db.Column(db.TIMESTAMP(False), nullable=False, server_default=text("now()"))

    __table_args__ = (
        Index("idx_users_name", func.lower("name"), unique=True),
        Index("idx_users_email", func.lower("email"), unique=True)
    )

    def __init__(self):
        if not self.created_at:
            self.created_at = now().format()

    def __repr__(self):
        return "<User %s>" % self.name

but there is no duplicate name and email

in the database.

Flask flask-sqlalchemy

Apr.27,2021

found on the Internet, you can take a look at https://www.crifan.com/sqlalc.

before the commit is submitted, db.session.flush ()
print the id of the object to get the new ID
choice = Choice (name=name, right=right)

    db.session.add(choice)
    db.session.flush()
    print("choice: ", choice.id)

Previous: Why does element-ui report an error when using value-format when type is week in the time selector?

Next: [solved] in js! Is it necessary to exist? Why?

How to get objects from model.User queried by Flask_SQLAlchemy
the result of the query is a model.user type, not a simple dict, so how can you use it like an object? user = User.query.filter(User.username == username, User.password == password).first() ...

Python flask flask-sqlalchemy

Mar.01,2021
How do you separate the model using the Flask-SQLAlchemy project structure?
see examples that define the model directly at the start of the program, such as _ _ init__.py, server.py. my idea is to define the model in the corresponding .py file and create it directly when needed. I don t know how to organize the project file a...

Flask flask-sqlalchemy

Mar.24,2021
Flask-SQLAlchemy adds data to the database as written in the document, but it does not add it, and it does not report an error. What is the reason?
from flask import Flask, session from flask import render_template from flask_script import Manager from flask import url_for from flask import request, jsonify, json from flask_cors import CORS from flask_sqlalchemy import SQLAlchemy import os from f...

Python flask flask-sqlalchemy

Apr.01,2021