Search code snippets, questions, articles...

Add column to existing table with default value SQLAlchemy

When you are changing your table structure and adding a new column to it. Then to make it nullable false you have to assign a default value to it. But you can not do that by only adding default attribue. You have to use server_default for this purpose.
from sqlalchemy import text

class User_Model(db.Model):
    #use server_default if table already created to add default value
    flag = db.Column(db.Boolean, nullable=False, server_default=text('1'))
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

Search Index Data (The code snippet can also be found with below search text)

server_default SQLAlchemy
Was this helpful?