use there's nothing to compare towards, so you
> need to do those indexes manually if you are adding it to an existing
> model.
>
> On Tue, Sep 11, 2018 at 12:59 AM, Yingchen Zhang > wrote:
> > class InviteCode(db.Model):
> > __tablename__ = '
class InviteCode(db.Model):
__tablename__ = 'invite_code'
id = db.Column(db.BigInteger, primary_key=True, autoincrement=True)
code = db.Column(db.VARCHAR(32), nullable=False)
created_at = db.Column(db.TIMESTAMP(True), nullable=False)
status = db.Column(db.VARCHAR(1), nullable=
t=True:
>
> http://alembic.zzzcomputing.com/en/latest/api/runtime.html#alembic.runtime.environment.EnvironmentContext.configure.params.compare_server_default
>
>
>
>
> On Thu, Sep 6, 2018 at 12:37 PM, Yingchen Zhang > wrote:
> > like this:
> >
> > old model:
>
existing_type=postgresql.INET(),
type_=sa.VARCHAR(),
nullable=False)
no default set.
在 2018年9月6日星期四 UTC+8下午9:54:23，Mike Bayer写道：
>
> On Thu, Sep 6, 2018 at 3:50 AM, Yingchen Zhang > wrote:
> > so, alembic not support `default` ( pgsql create columnn ) ?
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=
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
ZONE
在 2018年7月26日星期四 UTC+8下午6:16:10，Simon King写道：
>
> On Thu, Jul 26, 2018 at 11:03 AM Yingchen Zhang > wrote:
> >
> > old model
> >
> > class User(db.Model):
> > __tablename__ = 'users'
> > id = db.Column(db.BigInteger, pr
that's work. tks.
在 2018年7月26日星期四 UTC+8下午6:16:10，Simon King写道：
>
> On Thu, Jul 26, 2018 at 11:03 AM Yingchen Zhang > wrote:
> >
> > old model
> >
> > class User(db.Model):
> > __tablename__ = 'users'
> > id = db.Colum
old model
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.VARCHAR(50), nullable=False)
email = db.Column(db.VARCHAR(200), nullable=False)
time = db.Column(db.INTGER, nullable=False)
new model
class User(db.M
If set timezone=False, the value should be UTC time ?
I inserted a new line to database , it's used server timezone : PRC
在 2018年7月24日星期二 UTC+8上午2:10:16，Mike Bayer写道：
>
> On Mon, Jul 23, 2018 at 2:01 PM, Yingchen Zhang > wrote:
> > data type TIMESTAMP just have one param
ok, tks.
so I must re-edit the migrations file?
在 2018年7月24日星期二 UTC+8上午2:06:06，Mike Bayer写道：
>
> On Mon, Jul 23, 2018 at 1:57 PM, Yingchen Zhang > wrote:
> > class User(db.Model):
> > __tablename__ = 'users'
> > id = db.Column(db.BigInt
ok, tks.
在 2018年7月24日星期二 UTC+8上午2:06:06，Mike Bayer写道：
>
> On Mon, Jul 23, 2018 at 1:57 PM, Yingchen Zhang > wrote:
> > class User(db.Model):
> > __tablename__ = 'users'
> > id = db.Column(db.BigInteger, primary_key=True)
> > name = db.Co
data type TIMESTAMP just have one param is timezone and it's use server
timezone setting.
how to create a `timestamp without time zone` column with postgresql ?
code:
Column('created_at', TIMESTAMP(False), nullable=False, server_default=text(
'now()'))
--
SQLAlchemy -
The Python SQL Toolk
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.VARCHAR(50), nullable=False, unique=True)
email = db.Column(db.VARCHAR(200), nullable=False)
mobile = db.Column(db.VARCHAR(20))
created_at = db.Column(db.TIM
14 matches
Mail list logo
