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'))

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

server_default SQLAlchemy
Was this helpful?
Programming Feeds
Learn something new everyday on Devsheet