yeah~ it's work. thks.
在 2018年9月7日星期五 UTC+8上午1:48:46，Mike Bayer写道：
>
> for ALTER, which is not what you illustrated earlier, server default
> comparison is turned off by default as it can be unreliable in some
> cases. Turn it on using compare_server_default=True:
>
> http://alembic.zzzcomput
for ALTER, which is not what you illustrated earlier, server default
comparison is turned off by default as it can be unreliable in some
cases. Turn it on using compare_server_default=True:
http://alembic.zzzcomputing.com/en/latest/api/runtime.html#alembic.runtime.environment.EnvironmentContext.co
like this:
old model:
class TestModel:
ip = db.Column(db.INET, nullable=False)
new Model:
class TestModel:
ip = db.Column(db.VARCHAR(), nullable=False, server_default='127.0.0.1')
got migration:
op.alter_column('test', 'ip',
existing_type=postgresql.INET(),
On Thu, Sep 6, 2018 at 3:50 AM, Yingchen Zhang wrote:
> so, alembic not support `default` ( pgsql create columnn ) ?
it does. use server_default."default" in SQLAlchemy refers to a
Python-side default.
>
> 在 2018年9月6日星期四 UTC+8上午12:24:54，Mike Bayer写道：
>>
>> On Wed, Sep 5, 2018 at 11:51 AM,
so, alembic not support `default` ( pgsql create columnn ) ?
在 2018年9月6日星期四 UTC+8上午12:24:54，Mike Bayer写道：
>
> On Wed, Sep 5, 2018 at 11:51 AM, Yingchen Zhang > wrote:
> > db.Column('text_column', db.VARCHAR(20), default='test_text',
> > server_default='test_text', nullable=True)
> >
> > but,
On Wed, Sep 5, 2018 at 11:51 AM, Yingchen Zhang wrote:
> db.Column('text_column', db.VARCHAR(20), default='test_text',
> server_default='test_text', nullable=True)
>
> but, generated code like:
>
> sa.Column('text_column', sa.VARCHAR(20), nullable=True),
I assume you are using Alembic autogenerat
db.Column('text_column', db.VARCHAR(20), default='test_text', server_default
='test_text', nullable=True)
but, generated code like:
sa.Column('text_column', sa.VARCHAR(20), nullable=True),
how to set column default value ?
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
