def upgrade(active_plugins=None, options=None):
op.create_table('subscription_events',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('subscriber_id', sa.Integer(), nullable=False),
sa.Column('event_type', sa.Unicode(100), nullable=False),
sa.Column('event_info', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_engine=MYSQL_ENGINE,
mysql_charset=MYSQL_CHARSET)
def upgrade():
op.create_table(
'location',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('name', sa.Unicode(length=250), nullable=False),
sa.Column('title', sa.Unicode(length=250), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=False),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'decision_media', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('decision_id', sa.Integer(), nullable=True),
sa.Column('filename', sa.String(length=32), nullable=False),
sa.Column('title', sa.String(length=128), nullable=True),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(
['decision_id'],
['decision.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('category_group',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Unicode(length=100), nullable=False),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('grouporder', sa.Float(), nullable=False),
sa.Column('date_created', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_table('population_group',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Unicode(length=100), nullable=False),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('grouporder', sa.Float(), nullable=False),
sa.Column('date_created', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.add_column(u'category',
sa.Column('grouping_id', sa.Integer(), nullable=True))
op.add_column(u'population',
sa.Column('grouping_id', sa.Integer(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('messages',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_time', sa.Integer(), nullable=True),
sa.Column('updated_time', sa.Integer(), nullable=True),
sa.Column('title', sa.Unicode(length=50), nullable=False),
sa.Column('content', sa.UnicodeText(), nullable=False),
sa.Column('sender_id', sa.Integer(), nullable=False),
sa.Column('receiver_id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('protocol', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('case_id', sa.Integer(), nullable=True),
sa.Column('protocol_id', sa.Integer(), nullable=False),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('protocol_date', sa.Date(), nullable=True),
sa.ForeignKeyConstraint(
['case_id'],
['case.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'decision', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('protocol_id', sa.Integer(), nullable=True),
sa.Column('decision_id', sa.String(length=16), nullable=True),
sa.Column('decision_num', sa.Integer(), nullable=False),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(
['protocol_id'],
['protocol.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('article',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=128), nullable=True),
sa.Column('body', sa.UnicodeText(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_article_timestamp'), 'article', ['timestamp'], unique=False)
class Document(Base):
__tablename__ = "document"
id = sa.Column(sa.Integer, primary_key=True)
updated = sa.Column(sa.DateTime)
title = sa.Column(sa.UnicodeText())
meta_titles = sa.orm.relationship(
"DocumentMeta",
primaryjoin=
'and_(Document.id==DocumentMeta.document_id, DocumentMeta.type==u"title")',
order_by="DocumentMeta.updated.asc()",
viewonly=True,
)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('user_notes',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('creator_id', sa.Integer(), nullable=False),
sa.Column('created', sa.DateTime(), nullable=False),
sa.Column('text', sa.UnicodeText(), nullable=False),
sa.ForeignKeyConstraint(['creator_id'], ['users.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.create_table('name',
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=False),
sa.Column('title', sa.Unicode(length=250), nullable=False),
sa.Column('gender', sa.SmallInteger(), nullable=True),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_name_gender'), 'name', ['gender'], unique=False)
op.create_index(op.f('ix_name_title'), 'name', ['title'], unique=False)
op.create_table('tag',
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=False),
sa.Column('title', sa.Unicode(length=250), nullable=False),
sa.Column('type', sa.SmallInteger(), nullable=True),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_tag_title'), 'tag', ['title'], unique=False)
op.create_index(op.f('ix_tag_type'), 'tag', ['type'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'suggested_events',
sa.Column('title', sa.Unicode(length=256), nullable=False),
sa.Column('agenda', sa.UnicodeText(), nullable=False),
sa.Column('social', sa.UnicodeText(), nullable=True),
sa.Column('image_url', sa.String(length=500), nullable=True),
sa.Column('level', sa.String(length=20), nullable=False),
sa.Column('place', sa.Unicode(length=256), nullable=True),
sa.Column('when_start', sa.DateTime(), nullable=False),
sa.Column('when_end', sa.DateTime(), nullable=True),
sa.Column('only_date', sa.Boolean(), nullable=False),
sa.Column('registration_url', sa.String(length=500), nullable=True),
sa.Column('team', sa.Integer(), nullable=False),
sa.Column('submitter_email', sa.String(length=256), nullable=False),
sa.Column('secret', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(
['team'],
['teams.id'],
), sa.PrimaryKeyConstraint('secret'))
def upgrade():
op.add_column(
"group",
sa.Column("authority_provided_id", sa.UnicodeText(), nullable=True))
op.execute("COMMIT")
op.create_index(
op.f("ix__group__groupid"),
"group",
["authority", "authority_provided_id"],
postgresql_concurrently=True,
unique=True,
)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('testableresult', 'status')
op.execute(testableresult.update().where(
testableresult.c.make_results == None).values(make_results=u''))
op.alter_column('testableresult',
u'make_results',
existing_type=sa.UnicodeText(),
nullable=False)
make_status.drop(op.get_bind(), checkfirst=False)
class Content(Node):
__versioned__ = {}
__tablename__ = 'content'
__mapper_args__ = {
'polymorphic_identity': 'content'
}
id = sa.Column(
sa.Integer,
sa.ForeignKey('node.id'),
primary_key=True
)
description = sa.Column(sa.UnicodeText())
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('analysis_comment',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('datetime', sa.DateTime(), nullable=True),
sa.Column('comment', sa.UnicodeText(), nullable=True),
sa.Column('analysis_id', sa.Integer(), nullable=True),
sa.Column('profile_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['analysis_id'], ['analysis.id'], ),
sa.ForeignKeyConstraint(['profile_id'], ['profile.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.execute("""
ALTER TABLE recipe_task
ADD name VARCHAR(255) NOT NULL AFTER recipe_id,
ADD version VARCHAR(255) AFTER name,
ADD fetch_url VARCHAR(2048) AFTER version,
ADD fetch_subdir VARCHAR(2048) NOT NULL DEFAULT '' AFTER fetch_url,
MODIFY task_id INT,
ADD INDEX (name),
ADD INDEX (version),
ADD INDEX (name, version)
""")
op.execute("""
UPDATE recipe_task
SET name = (SELECT name FROM task WHERE id = recipe_task.task_id)
""")
add_enum_value('system_access_policy_rule',
'permission',
'view',
nullable=True)
op.execute("""
INSERT INTO system_access_policy (system_id)
SELECT id FROM system
WHERE NOT EXISTS (SELECT 1 FROM system_access_policy
WHERE system_id = system.id)
""")
op.execute("""
INSERT INTO system_access_policy_rule
(policy_id, user_id, group_id, permission)
SELECT system_access_policy.id, NULL, NULL, 'view'
FROM system_access_policy
INNER JOIN system ON system_access_policy.system_id = system.id
WHERE NOT EXISTS (SELECT 1 FROM system_access_policy_rule
WHERE policy_id = system_access_policy.id
AND user_id IS NULL
AND group_id IS NULL
AND permission = 'view')
AND system.private = 0
""")
op.add_column('command_queue', sa.Column('quiescent_period', sa.Integer))
op.create_index('status', 'command_queue', ['status'])
op.add_column(
'power', sa.Column('power_quiescent_period',
sa.Integer,
nullable=False))
op.execute("UPDATE power SET power_quiescent_period = 5")
op.alter_column('tg_user', 'password', type_=sa.UnicodeText())
op.execute("ALTER TABLE beaker_tag DROP PRIMARY KEY, ADD PRIMARY KEY (id)")
# These tables were never used for anything, so they really can be safely dropped.
op.drop_table('locked')
op.drop_table('serial')
op.drop_table('serial_type')
op.drop_table('install')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('categories',
sa.Column('id', sa.BigInteger(), nullable=False),
sa.Column('name', sa.UnicodeText(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.drop_constraint('user_resources_ibfk_1', 'user_resources', type_='foreignkey')
op.drop_table('resources')
op.add_column('user_resources', sa.Column('category_id', sa.BigInteger(), nullable=False))
op.create_foreign_key('fk_user_resources_categories', 'user_resources', 'categories', ['category_id'], ['id'], onupdate='CASCADE', ondelete='RESTRICT')
op.drop_column('user_resources', 'resource_id')
def upgrade():
op.create_table(
"lis_result_sourcedid",
sa.Column("id", sa.Integer(), autoincrement=True, primary_key=True),
sa.Column(
"created",
sa.DateTime(),
default=datetime.datetime.utcnow,
server_default=sa.func.now(),
nullable=False,
),
sa.Column(
"updated",
sa.DateTime(),
server_default=sa.func.now(),
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow,
nullable=False,
),
sa.Column("lis_result_sourcedid", sa.UnicodeText(), nullable=False),
sa.Column("lis_outcome_service_url", sa.UnicodeText(), nullable=False),
sa.Column("lis_result_sourcedid", sa.UnicodeText(), nullable=False),
sa.Column(
"oauth_consumer_key",
sa.UnicodeText(),
sa.ForeignKey("application_instances.consumer_key"),
nullable=False,
),
sa.Column("user_id", sa.UnicodeText(), nullable=False),
sa.Column("context_id", sa.UnicodeText(), nullable=False),
sa.Column("resource_link_id", sa.UnicodeText(), nullable=False),
sa.Column(
"tool_consumer_info_product_family_code", sa.UnicodeText(), nullable=True
),
sa.Column("h_username", sa.UnicodeText(), nullable=False),
sa.Column("h_display_name", sa.UnicodeText(), nullable=False),
sa.UniqueConstraint(
"oauth_consumer_key", "user_id", "context_id", "resource_link_id"
),
)
class post_audio(Base):# Blame ATC
"""Class Info, functionality, purpose"""
__tablename__ = "post_audio"
# Columns
primary_key = sqlalchemy.Column(sqlalchemy.BigInteger(), primary_key=True)# Is used only as primary key
post_id = sqlalchemy.Column(sqlalchemy.BigInteger(), sqlalchemy.ForeignKey("posts.post_id")) # Local post ID
caption = sqlalchemy.Column(sqlalchemy.UnicodeText())# from API, beyond that uncertain
artist = sqlalchemy.Column(sqlalchemy.UnicodeText())# Artist name
track_name = sqlalchemy.Column(sqlalchemy.UnicodeText())# Track name
album = sqlalchemy.Column(sqlalchemy.UnicodeText())# Name of the album
audio_source_url = sqlalchemy.Column(sqlalchemy.UnicodeText())# from API, beyond that uncertain
audio_type = sqlalchemy.Column(sqlalchemy.UnicodeText())# from API, beyond that uncertain
source_title = sqlalchemy.Column(sqlalchemy.UnicodeText())# from API, beyond that uncertain
album_art_url = sqlalchemy.Column(sqlalchemy.UnicodeText())# from API, beyond that uncertain
class Tester(SQLAlchemyJsonMixin, Base):
__tablename__ = 'tester'
intField = sqlalchemy.Column(sqlalchemy.BigInteger(),
primary_key=True)
strField = sqlalchemy.Column(sqlalchemy.UnicodeText())
noneField = sqlalchemy.Column(sqlalchemy.Integer())
floatField = sqlalchemy.Column(sqlalchemy.Float())
boolField = sqlalchemy.Column(sqlalchemy.Boolean())
dateTimeField = sqlalchemy.Column(sqlalchemy.DateTime())
arrowField = sqlalchemy.Column(sqlalchemy_utils.ArrowType())
relFieldId = sqlalchemy.Column(
sqlalchemy.BigInteger(), sqlalchemy.ForeignKey('submodel.id'))
relField = sqlalchemy.orm.relationship('SubModel')
class Response(Base):
__tablename__ = 'response'
id = Column(Integer, primary_key=True)
textEntry = Column(sqlalchemy.UnicodeText())
question_id = Column(Integer)
answer_id = Column(Integer)
choice_id = Column(Integer)
#embeddeddata_id = Column(Integer)
respondent_id = Column(Integer, ForeignKey('respondent.id'))
respondent = relationship(Respondent, back_populates='responses')
def upgrade():
op.create_table(
"authclient",
sa.Column(
"id",
postgresql.UUID(),
server_default=sa.func.uuid_generate_v1mc(),
nullable=False,
),
sa.Column("created",
sa.DateTime(),
server_default=sa.func.now(),
nullable=False),
sa.Column("updated",
sa.DateTime(),
server_default=sa.func.now(),
nullable=False),
sa.Column("name", sa.UnicodeText(), nullable=True),
sa.Column("secret", sa.UnicodeText(), nullable=False),
sa.Column("authority", sa.UnicodeText(), nullable=False),
sa.PrimaryKeyConstraint("id", name=op.f("pk__authclient")),
)
def upgrade_n():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'n_users',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('username', sa.String(length=80), nullable=False),
sa.Column('password', sa.String(), nullable=False),
sa.Column('email', sa.String(length=120), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table(
'n_analogues',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('n_user_id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('deposition_temperature', sa.Float(), nullable=True),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('author', sa.String(), nullable=True),
sa.Column('DOI', sa.String(), nullable=True),
sa.Column('pub_date', sa.Date(), nullable=True),
sa.ForeignKeyConstraint(
['n_user_id'],
['n_users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'n_val',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('n_analogue_id', sa.Integer(), nullable=False),
sa.Column('temperature', sa.Float(), nullable=False),
sa.Column('category', sa.Integer(), nullable=True),
sa.Column('exposure_time', sa.Integer(), nullable=True),
sa.Column('resolution', sa.Float(), nullable=True),
sa.Column('wavenumber_range', sa.String(), nullable=True),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('path', sa.String(), nullable=False),
sa.ForeignKeyConstraint(
['n_analogue_id'],
['n_analogues.id'],
), sa.PrimaryKeyConstraint('id'))
def strict_types_compatibility_check(self, source_type, dest_type, val):
if isinstance(source_type, sqlalchemy.String):
if not isinstance(dest_type, sqlalchemy.String):
return # Can't do anything
elif dest_type.length is None:
return # already a TEXT column
elif isinstance(val,
six.string_types) and dest_type.length >= len(val):
return # no need to upgrade to TEXT column
elif source_type.length is None:
return sqlalchemy.UnicodeText(collation=self.collation)
elif dest_type.length < source_type.length:
return source_type
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('users',
sa.Column('about_me', sa.UnicodeText(), nullable=True))
op.add_column('users', sa.Column('gender', sa.Boolean(), nullable=True))
op.add_column('users', sa.Column('last_seen', sa.DateTime(),
nullable=True))
op.add_column('users',
sa.Column('location', sa.Unicode(length=64), nullable=True))
op.add_column('users',
sa.Column('member_since', sa.DateTime(), nullable=True))
op.add_column('users',
sa.Column('name', sa.Unicode(length=64), nullable=True))
class RawPosts(Base):# Remove underscore after fixing all references
"""The raw post dicts for a blog
Used to back up and stage posts
Write-once Read-many"""
__tablename__ = "raw_posts"
# Columns
# Local stuff
primary_key = sqlalchemy.Column(sqlalchemy.BigInteger, primary_key=True)# Is used only as primary key
version = sqlalchemy.Column(sqlalchemy.BigInteger) # The version of this post this row is associated with
date_saved = sqlalchemy.Column(sqlalchemy.BigInteger)# The unix time the post was saved
link_to_hash_dict = sqlalchemy.Column(sqlalchemy.dialects.postgresql.JSONB)# mapping of links in the post to hashes of associated media
# Who does this post belong to?
poster_username = sqlalchemy.Column(sqlalchemy.UnicodeText())# username for a blog, as given by the API "tsitra360"
blog_domain = sqlalchemy.Column(sqlalchemy.UnicodeText())# domain for the blog"tsitra360.tumblr.com"
# Post identity from the post
all_posts_id = sqlalchemy.Column(sqlalchemy.BigInteger)# Number The post's non-unique ID
all_posts_post_url = sqlalchemy.Column(sqlalchemy.UnicodeText())# String The location of the post
all_posts_timestamp = sqlalchemy.Column(sqlalchemy.BigInteger)# The API given timestamp
# Full post API data
raw_post_json = sqlalchemy.Column(sqlalchemy.dialects.postgresql.JSONB)# The post's section of the API, reencoded into JSON
media_processed = sqlalchemy.Column(sqlalchemy.Boolean)# has media been processed for this post?
skip_processing = sqlalchemy.Column(sqlalchemy.Boolean())# Should this be ignored for now?
class FeatureCohort(Base, mixins.Timestamps):
__tablename__ = 'featurecohort'
id = sa.Column(sa.Integer, autoincrement=True, primary_key=True)
name = sa.Column(sa.UnicodeText(), nullable=False, index=True)
# Cohort membership
members = sa.orm.relationship('User',
secondary='featurecohort_user',
backref='cohorts')
def __init__(self, name):
self.name = name
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('project',
sa.Column('category', sa.String(length=32), nullable=True))
op.drop_column('project', 'status')
op.add_column('resource',
sa.Column('doc_url', sa.Unicode(length=256), nullable=True))
op.add_column('resource',
sa.Column('license', sa.Unicode(length=64), nullable=True))
op.add_column('resource', sa.Column('order', sa.Integer(), nullable=True))
op.add_column('resource',
sa.Column('pipeline', sa.UnicodeText(), nullable=True))
op.drop_column('resource', 'is_embed')
def upgrade():
op.add_column(
'article_data',
sa.Column('abstract',
sa.UnicodeText(),
server_default='',
nullable=False))
extract_abstract = sa.text(
"array_to_string(xpath('.//front/article-meta/abstract/*', article.body::xml), E'\n', '')"
)
op.execute(
sa.update(article_data).values(abstract=extract_abstract).where(
article_data.c.id == article.c.id))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('movie', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=140), nullable=False),
sa.Column('slug', sa.String(length=64), nullable=False),
sa.Column('description', sa.UnicodeText(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('slug'))
