"""Abgeglichene Ordner: Dokumente vom Rechner einer Person mit ausgelesenem Text und Volltextsuche

Revision ID: 0027
Revises: 0026
Erstellt: 2026-10-25
"""

import sqlalchemy as sa
from alembic import op
from sqlalchemy.dialects import postgresql

revision = '0027'
down_revision = '0026'
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.create_table('doc_folders',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('workspace_id', sa.Integer(), nullable=False),
    sa.Column('owner_id', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(length=100), nullable=False),
    sa.Column('scope', sa.String(length=20), nullable=False),
    sa.Column('exposure_confirmed', sa.Boolean(), nullable=False),
    sa.Column('synced', sa.DateTime(timezone=True), nullable=True),
    sa.Column('created', sa.DateTime(timezone=True), nullable=False),
    sa.ForeignKeyConstraint(['owner_id'], ['users.id'], name=op.f('fk_doc_folders_owner_id_users'), ondelete='CASCADE'),
    sa.ForeignKeyConstraint(['workspace_id'], ['workspaces.id'], name=op.f('fk_doc_folders_workspace_id_workspaces'), ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('id', name=op.f('pk_doc_folders'))
    )
    op.create_index(op.f('ix_doc_folders_owner_id'), 'doc_folders', ['owner_id'], unique=False)
    op.create_index(op.f('ix_doc_folders_workspace_id'), 'doc_folders', ['workspace_id'], unique=False)
    op.create_table('doc_files',
    sa.Column('id', sa.BigInteger(), sa.Identity(always=False), nullable=False),
    sa.Column('folder_id', sa.Integer(), nullable=False),
    sa.Column('path', sa.String(length=500), nullable=False),
    sa.Column('size', sa.BigInteger(), nullable=False),
    sa.Column('modified', sa.BigInteger(), nullable=False),
    sa.Column('sha256', sa.String(length=64), nullable=False),
    sa.Column('status', sa.String(length=20), nullable=False),
    sa.Column('error', sa.Text(), nullable=False),
    sa.Column('text', sa.Text(), nullable=False),
    sa.Column('search', postgresql.TSVECTOR(), sa.Computed("to_tsvector('german', coalesce(path, '') || ' ' || coalesce(text, ''))", persisted=True), nullable=True),
    sa.Column('updated', sa.DateTime(timezone=True), nullable=False),
    sa.ForeignKeyConstraint(['folder_id'], ['doc_folders.id'], name=op.f('fk_doc_files_folder_id_doc_folders'), ondelete='CASCADE'),
    sa.PrimaryKeyConstraint('id', name=op.f('pk_doc_files')),
    sa.UniqueConstraint('folder_id', 'path', name=op.f('uq_doc_files_folder_id'))
    )
    op.create_index(op.f('ix_doc_files_folder_id'), 'doc_files', ['folder_id'], unique=False)
    op.create_index('ix_doc_files_search', 'doc_files', ['search'], unique=False, postgresql_using='gin')


def downgrade() -> None:
    op.drop_index('ix_doc_files_search', table_name='doc_files', postgresql_using='gin')
    op.drop_index(op.f('ix_doc_files_folder_id'), table_name='doc_files')
    op.drop_table('doc_files')
    op.drop_index(op.f('ix_doc_folders_workspace_id'), table_name='doc_folders')
    op.drop_index(op.f('ix_doc_folders_owner_id'), table_name='doc_folders')
    op.drop_table('doc_folders')