/Shell/Bash/Flask db upgrade add new not nullable column

Flask db upgrade add new not nullable column

def upgrade():
    op.add_column('my_table', sa.Column('my_column', sa.String()))
    op.execute('UPDATE my_table SET my_column=my_other_column')
    op.alter_column('my_table', 'my_column', nullable=False)

Source: stackoverflow.com

Flask db upgrade add new not nullable column

op.add_column('mytable', sa.Column(
    'mycolumn', 
    sa.String(), 
    nullable=False, 
    server_default='lorem ipsum', #  <---  add this
))

Source: stackoverflow.com

Similar codes

0 vote241 views2 answers
Bash remove first line
Shell/Bash
2 votes239 views1 answer
Clear the git stash
Shell/Bash
22 votes235 views1 answer
Xcode-selec not working
Shell/Bash
0 vote232 views1 answer
Install specific tensorflow version
Shell/Bash
0 vote253 views1 answer
Install packages from txt
Shell/Bash
0 vote240 views1 answer
How-to-install-angular-cli-locally-without-the-g-flag
Shell/Bash
0 vote250 views1 answer
Install node 12 linux
Shell/Bash
58 votes247 views1 answer
How to change a commit message
Shell/Bash
2 votes257 views1 answer
How use nvm with zsh
Shell/Bash
0 vote232 views1 answer
Restart webmin
Shell/Bash