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_cad, load
from sqlalchemy import Table, Column, MetaData, ForeignKey, Integer, Boolean, text
meta = MetaData()
groups_users = Table(
'groups_users', meta,
Column('id', Integer, primary_key=True),
Column('group_id', Integer, ForeignKey('groups.id'), nullable=False),
Column('user_id', Integer, ForeignKey('users.id'), nullable=False),
Column('owner', Boolean, server_default=text('FALSE'), nullable=False),
)
mixin_cad(groups_users)
def upgrade(migrate_engine):
meta.bind = migrate_engine
load(meta, migrate_engine, 'users', 'groups')
groups_users.create()
def downgrade(migrate_engine):
meta.bind = migrate_engine
groups_users.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()
