สร้างระเบียนและยืนยันเซสชัน

Creating a record means turning incoming data into a new row in your table. In Flask-SQLAlchemy that flow runs through the session. ✨

Start by making a fresh model instance with the values you want. Nothing has touched the database yet, it is just a Python object.

Tell SQLAlchemy to track the new object by calling db.session.add(). This stages it, but it is still not saved.

Nothing is permanent until you call db.session.commit(). That flushes your changes and writes the row to the database.

Once you commit, the database assigns a primary key. Read it back from user.id to confirm the row really exists.

Inside a POST view you read the body, build the object, add it, and commit. That is the whole create path in four lines.

A successful create should answer with status 201, the code that means a new resource was made on the server.

If a commit fails, wrap it in try and call db.session.rollback() to undo the staged change and keep your session clean.

Need several rows? Stage them all with add_all(), then a single commit saves the whole batch together.

Every add since the last commit is part of one transaction. They all succeed together, or none of them land if it fails.

Remember the rhythm: build the object, add to stage it, then commit to save. Skipping commit means your data never persists.

You called add() but the row is missing from the table. What did you forget?

You build an object, add it, and commit to save, returning 201 and rolling back on errors. That is a solid create endpoint! 🎉