diff options
Diffstat (limited to 'cli/app/sql')
| -rw-r--r-- | cli/app/sql/models/upload.py | 4 | ||||
| -rw-r--r-- | cli/app/sql/versions/202104011523_add_settings_to_uploads.py | 29 |
2 files changed, 32 insertions, 1 deletions
diff --git a/cli/app/sql/models/upload.py b/cli/app/sql/models/upload.py index d9307ff..ac3d900 100644 --- a/cli/app/sql/models/upload.py +++ b/cli/app/sql/models/upload.py @@ -1,4 +1,4 @@ -from sqlalchemy import create_engine, Table, Column, ForeignKey, String, Integer, DateTime +from sqlalchemy import create_engine, Table, Column, ForeignKey, String, Integer, DateTime, JSON import sqlalchemy.sql.functions as func from sqlalchemy_utc import UtcDateTime, utcnow from wtforms_alchemy import ModelForm @@ -20,6 +20,7 @@ class Upload(Base): ext = Column(String(4, convert_unicode=True), nullable=False) tag = Column(String(64, convert_unicode=True), nullable=True) username = Column(String(16, convert_unicode=True), nullable=False) + settings = Column(JSON, default={}, nullable=True) created_at = Column(UtcDateTime(), default=utcnow()) def toJSON(self): @@ -32,6 +33,7 @@ class Upload(Base): 'tag': self.tag, 'username': self.username, 'url': self.url(), + 'settings': self.settings, 'created_at': self.created_at, } diff --git a/cli/app/sql/versions/202104011523_add_settings_to_uploads.py b/cli/app/sql/versions/202104011523_add_settings_to_uploads.py new file mode 100644 index 0000000..b0d63b2 --- /dev/null +++ b/cli/app/sql/versions/202104011523_add_settings_to_uploads.py @@ -0,0 +1,29 @@ +"""add settings to uploads + +Revision ID: 844858ecfc5c +Revises: 9b687880918d +Create Date: 2021-04-01 15:23:29.581711 + +""" +from alembic import op +import sqlalchemy as sa +import sqlalchemy_utc + + +# revision identifiers, used by Alembic. +revision = '844858ecfc5c' +down_revision = '9b687880918d' +branch_labels = None +depends_on = None + + +def upgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.add_column('upload', sa.Column('settings', sa.JSON(), nullable=True)) + # ### end Alembic commands ### + + +def downgrade(): + # ### commands auto generated by Alembic - please adjust! ### + op.drop_column('upload', 'settings') + # ### end Alembic commands ### |
