Chrome Extension

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'))
Code faster with devsheet chrome extension and increase productivity as a programmer
search code from your favorite search engine instantly.
Install Now

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

server_default SQLAlchemy
Was this helpful?
0 Comments
Open Code Manager We are hiring