From 4d213afb7d7c27012c6dc6fb3b36e5ef5ffe3c71 Mon Sep 17 00:00:00 2001 From: François Schmidts Date: Sat, 12 Dec 2015 21:14:28 +0100 Subject: moving the root of source code from / to /src/ --- src/migrations/alembic.ini | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 src/migrations/alembic.ini (limited to 'src/migrations') diff --git a/src/migrations/alembic.ini b/src/migrations/alembic.ini new file mode 100644 index 00000000..f8ed4801 --- /dev/null +++ b/src/migrations/alembic.ini @@ -0,0 +1,45 @@ +# A generic, single database configuration. + +[alembic] +# template used to generate migration files +# file_template = %%(rev)s_%%(slug)s + +# set to 'true' to run the environment during +# the 'revision' command, regardless of autogenerate +# revision_environment = false + + +# Logging configuration +[loggers] +keys = root,sqlalchemy,alembic + +[handlers] +keys = console + +[formatters] +keys = generic + +[logger_root] +level = WARN +handlers = console +qualname = + +[logger_sqlalchemy] +level = WARN +handlers = +qualname = sqlalchemy.engine + +[logger_alembic] +level = INFO +handlers = +qualname = alembic + +[handler_console] +class = StreamHandler +args = (sys.stderr,) +level = NOTSET +formatter = generic + +[formatter_generic] +format = %(levelname)-5.5s [%(name)s] %(message)s +datefmt = %H:%M:%S -- cgit From 2c0e17cb977a1e8782799b337df8b1583d019906 Mon Sep 17 00:00:00 2001 From: François Schmidts Date: Mon, 12 Oct 2015 22:36:01 +0200 Subject: bootstraping react --- .../versions/cde34831ea_adding_feed_and_user_attributes_for_.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/migrations') diff --git a/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py b/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py index 116fdaa1..8763f925 100644 --- a/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py +++ b/src/migrations/versions/cde34831ea_adding_feed_and_user_attributes_for_.py @@ -9,7 +9,7 @@ Create Date: 2015-03-04 22:59:44.665979 # revision identifiers, used by Alembic. revision = 'cde34831ea' down_revision = '1b750a389c22' - +import conf from datetime import datetime from alembic import op -- cgit From b3a1cdc3429287f4221fac036bb4476ef47d679f Mon Sep 17 00:00:00 2001 From: François Schmidts Date: Sun, 31 Jan 2016 03:01:11 +0100 Subject: adding migration --- .../versions/3f83bfe93fc_adding_category.py | 42 ++++++++++++++++++++++ 1 file changed, 42 insertions(+) create mode 100644 src/migrations/versions/3f83bfe93fc_adding_category.py (limited to 'src/migrations') diff --git a/src/migrations/versions/3f83bfe93fc_adding_category.py b/src/migrations/versions/3f83bfe93fc_adding_category.py new file mode 100644 index 00000000..b8412418 --- /dev/null +++ b/src/migrations/versions/3f83bfe93fc_adding_category.py @@ -0,0 +1,42 @@ +"""adding category + +Revision ID: 3f83bfe93fc +Revises: 25ca960a207 +Create Date: 2015-09-01 14:15:04.212563 +""" + +# revision identifiers, used by Alembic. +revision = '3f83bfe93fc' +down_revision = 'db64b766362f' + +import conf +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.create_table('category', + sa.Column('id', sa.Integer(), nullable=False), + sa.Column('name', sa.String(), nullable=True), + sa.Column('user_id', sa.Integer(), nullable=True), + sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), + sa.PrimaryKeyConstraint('id')) + op.add_column('article', + sa.Column('category_id', sa.Integer(), nullable=True)) + op.add_column('feed', + sa.Column('category_id', sa.Integer(), nullable=True)) + if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: + op.create_foreign_key(None, 'article', 'category', + ['category_id'], ['id']) + op.create_foreign_key(None, 'feed', 'category', + ['category_id'], ['id']) + + +def downgrade(): + if 'sqlite' not in conf.SQLALCHEMY_DATABASE_URI: + op.drop_constraint(None, 'feed', type_='foreignkey') + op.drop_constraint(None, 'feed', type_='foreignkey') + op.drop_column('feed', 'category_id') + op.drop_constraint(None, 'article', type_='foreignkey') + op.drop_column('article', 'category_id') + op.drop_table('category') -- cgit