Column('first_name', Unicode), Column('middle_name', Unicode), Column('last_name', Unicode), Column('all_emails', Unicode), Column('classification', Unicode), Column('institution', Unicode), Column('department', Unicode), Column('international', Boolean), Column('notes', Unicode), Column('url', Unicode), Column('photo', Unicode), Column('biography', Unicode), Column('root', Boolean, server_default=text('FALSE'), nullable=False), ) mixin_tags_json(users) mixin_cad(users) def upgrade(migrate_engine): meta.bind = migrate_engine load(meta, migrate_engine, 'users') users.create() def downgrade(migrate_engine): meta.bind = migrate_engine users.drop()
from mixins import mixin_tags_json, mixin_cad, load from sqlalchemy import Table, Column, MetaData, ForeignKey, Integer, Boolean, text meta = MetaData() # simple enumeration type organizations_users = Table( 'organizations_users', meta, Column('id', Integer, primary_key=True), Column('organization_id', Integer, ForeignKey('organizations.id'), nullable=False), Column('user_id', Integer, ForeignKey('users.id'), nullable=False), Column('owner', Boolean, server_default=text('FALSE'), nullable=False), ) mixin_tags_json(organizations_users) mixin_cad(organizations_users) def upgrade(migrate_engine): meta.bind = migrate_engine load(meta, migrate_engine, 'organizations', 'users') organizations_users.create() def downgrade(migrate_engine): meta.bind = migrate_engine organizations_users.drop()
from mixins import mixin_tags_json, mixin_cad, load from sqlalchemy import Table, Column, MetaData, ForeignKey, Integer, Unicode meta = MetaData() messages = Table( 'messages', meta, Column('id', Integer, primary_key=True), Column('subject', Unicode, nullable=False), Column('body', Unicode, nullable=False), Column('group_id', Integer, ForeignKey('groups.id')), ) mixin_tags_json(messages) mixin_cad(messages) def upgrade(migrate_engine): meta.bind = migrate_engine load(meta, migrate_engine, 'users', 'groups') messages.create() def downgrade(migrate_engine): meta.bind = migrate_engine messages.drop()
from mixins import mixin_tags_json, mixin_cad, load from sqlalchemy import Table, Column, MetaData, Integer, Unicode meta = MetaData() groups = Table( 'groups', meta, Column('id', Integer, primary_key=True), Column('name', Unicode, nullable=False), ) mixin_tags_json(groups) mixin_cad(groups) def upgrade(migrate_engine): meta.bind = migrate_engine load(meta, migrate_engine, 'users') groups.create() def downgrade(migrate_engine): meta.bind = migrate_engine groups.drop()
from mixins import mixin_tags_json, mixin_cad, load from sqlalchemy import Table, Column, MetaData, Integer, Unicode meta = MetaData() files = Table( 'files', meta, Column('id', Integer, primary_key=True), Column('filename', Unicode, nullable=False), ) mixin_tags_json(files) mixin_cad(files) def upgrade(migrate_engine): meta.bind = migrate_engine load(meta, migrate_engine, 'users') files.create() def downgrade(migrate_engine): meta.bind = migrate_engine files.drop()
from mixins import mixin_tags_json from sqlalchemy import Table, Column, MetaData, text, Integer, Unicode, DateTime meta = MetaData() # simple enumeration type organizations = Table( 'organizations', meta, Column('id', Integer, primary_key=True), Column('slug', Unicode, nullable=False), Column('name', Unicode, nullable=False), Column('created', DateTime, server_default=text('NOW()')), ) mixin_tags_json(organizations) def upgrade(migrate_engine): meta.bind = migrate_engine organizations.create() def downgrade(migrate_engine): meta.bind = migrate_engine organizations.drop()