Lunaresk
4d1e7eb944
New: - Removed the connection between tables 'receipt_item' and 'item'. Instead the position on the receipt will be stored as a primary key with the receipt.id. - Uploading a receipt and checking items for invoice is now working. - Uploading a receipt now redirects directly to the form where the items on the receipt can be marked for invoice. - Added pagination for candidates-page. Refactoring: - Added _rencer_field_errors.html for centralized error display. - Added edeka_parser.py for better management of different parsers. Known Bugs: - Uploading a receipt without any fields results in an error. Todo: - Generate a general form if no fields are recognized on the uploaded receipt. - Create form where Admin can confirm receipt invoices. - Display Notification for admin when users upload receipt. - Display Notification for admin on new candidate.
65 lines
2.1 KiB
Python
65 lines
2.1 KiB
Python
"""Remove item.receiptitem relationship
|
|
|
|
Revision ID: cdbe3f5e3b30
|
|
Revises: 0fa2ef37e440
|
|
Create Date: 2023-09-19 19:02:23.003034
|
|
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
|
|
# revision identifiers, used by Alembic.
|
|
revision = 'cdbe3f5e3b30'
|
|
down_revision = '0fa2ef37e440'
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade():
|
|
# ### commands auto generated by Alembic - please adjust! ###
|
|
with op.batch_alter_table('receipt', schema=None) as batch_op:
|
|
batch_op.alter_column('id',
|
|
existing_type=sa.INTEGER(),
|
|
type_=sa.BigInteger(),
|
|
existing_nullable=False,
|
|
autoincrement=True)
|
|
|
|
with op.batch_alter_table('receipt_item', schema=None) as batch_op:
|
|
batch_op.add_column(sa.Column('price', sa.SmallInteger(), nullable=False))
|
|
batch_op.alter_column('receipt',
|
|
existing_type=sa.INTEGER(),
|
|
type_=sa.BigInteger(),
|
|
existing_nullable=False)
|
|
batch_op.alter_column('item',
|
|
existing_type=sa.BIGINT(),
|
|
type_=sa.SmallInteger(),
|
|
existing_nullable=False)
|
|
batch_op.drop_constraint('item_receipt_item_fkey', type_='foreignkey')
|
|
|
|
# ### end Alembic commands ###
|
|
|
|
|
|
def downgrade():
|
|
# ### commands auto generated by Alembic - please adjust! ###
|
|
with op.batch_alter_table('receipt_item', schema=None) as batch_op:
|
|
batch_op.create_foreign_key('item_receipt_item_fkey', 'item', ['item'], ['id'])
|
|
batch_op.alter_column('item',
|
|
existing_type=sa.SmallInteger(),
|
|
type_=sa.BIGINT(),
|
|
existing_nullable=False)
|
|
batch_op.alter_column('receipt',
|
|
existing_type=sa.BigInteger(),
|
|
type_=sa.INTEGER(),
|
|
existing_nullable=False)
|
|
batch_op.drop_column('price')
|
|
|
|
with op.batch_alter_table('receipt', schema=None) as batch_op:
|
|
batch_op.alter_column('id',
|
|
existing_type=sa.BigInteger(),
|
|
type_=sa.INTEGER(),
|
|
existing_nullable=False,
|
|
autoincrement=True)
|
|
|
|
# ### end Alembic commands ###
|