Created
May 3, 2010 20:29
-
-
Save raygunsix/388548 to your computer and use it in GitHub Desktop.
sqlalchemy migration with declaritive syntax
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from sqlalchemy import * | |
from migrate import * | |
from sqlalchemy.ext.declarative import declarative_base | |
meta = MetaData(migrate_engine) | |
Base = declarative_base(metadata=meta) | |
class Pageviews(Base): | |
__tablename__ = "pageviews" | |
st_id = Column(Integer, Sequence('page_seq_id', optional=True), primary_key=True) | |
st_user_agent = Column(String(255), default='') | |
st_url = Column(String(8000), default='') | |
st_spider_date = Column(DateTime, default='') | |
def upgrade(): | |
# Upgrade operations go here. Don't create your own engine; use the engine | |
# named 'migrate_engine' imported from migrate. | |
Pageviews.__table__.create() | |
def downgrade(): | |
# Operations to reverse the above upgrade go here. | |
Pageviews.__table__.drop() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment