def upgrade(migrate_engine):
meta.bind = migrate_engine
post = Table(tn('posts'), meta, autoload=True)
content_html = Column('content_html', Text, nullable=True)
content_html.create(post)
summary_html = Column('summary_html', Text, nullable=True)
summary_html.create(post)
class Post(Base):
__tablename__ = tn('posts')
id = Column(Integer, primary_key=True)
title = Column(String(200), unique=True, nullable=False)
slug = Column(String(128), unique=True, nullable=False)
content = Column(Text, nullable=False)
status_id = Column(Integer, ForeignKey(Status.id), nullable=False)
user_id = Column(Integer, ForeignKey(User.id), nullable=False)
format_id = Column(Integer, ForeignKey(Format.id), nullable=False)
createdate = Column(DateTime, nullable=False)
pubdate = Column(DateTime, nullable=True)
lastmoddate = Column(DateTime, nullable=False)
post_tags = Table(tn('post_tags'), meta,
Column('post_id', Integer, ForeignKey(Post.id)),
Column('tag_id', Integer, ForeignKey(Tag.id)),
)
def upgrade(migrate_engine):
meta.bind = migrate_engine
# Upgrade operations go here. Don't create your own engine; bind migrate_engine
# to your metadata
Status.__table__.create()
Format.__table__.create()
Tag.__table__.create()
User.__table__.create()
Post.__table__.create()
post_tags.create()
def downgrade(migrate_engine):
meta.bind = migrate_engine
tags = Table(tn('tags'), meta, autoload=True)
count.drop(tags)
def upgrade(migrate_engine):
meta.bind = migrate_engine
tags = Table(tn('tags'), meta, autoload=True)
count.create(tags)
def upgrade(migrate_engine):
meta.bind = migrate_engine
post = Table(tn('posts'), meta, autoload=True)
summary = Column('summary', Text, nullable=True)
summary.create(post)
