"""add_redeem_codes_and_module_triggers

Revision ID: 10ea1bc43b8f
Revises: 5a2c89e1b3d4
Create Date: 2026-11-19 04:56:20.664251

"""
from typing import Sequence, Union
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision: str = '10ea1bc43b8f'
down_revision: Union[str, None] = '5a2c89e1b3d4'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    # 1. Add 3-way trigger toggles to bot_modules
    op.add_column(
        'bot_modules',
        sa.Column('enable_command', sa.Boolean(), nullable=False, server_default='true')
    )
    op.add_column(
        'bot_modules',
        sa.Column('enable_inline_button', sa.Boolean(), nullable=False, server_default='true')
    )
    op.add_column(
        'bot_modules',
        sa.Column('enable_menu_button', sa.Boolean(), nullable=False, server_default='true')
    )

    # 2. Add points balance and VIP status tracking to bot_users
    op.add_column(
        'bot_users',
        sa.Column('points_balance', sa.Integer(), nullable=False, server_default='0')
    )
    op.add_column(
        'bot_users',
        sa.Column('vip_until', sa.DateTime(timezone=True), nullable=True)
    )

    # 3. Create bot_redeem_codes table
    op.create_table(
        'bot_redeem_codes',
        sa.Column('id', sa.UUID(), nullable=False),
        sa.Column('bot_id', sa.UUID(), nullable=False),
        sa.Column('code', sa.String(length=64), nullable=False),
        sa.Column('title', sa.String(length=128), nullable=True),
        sa.Column('reward_type', sa.String(length=32), nullable=False, server_default='points'),
        sa.Column('reward_value', sa.Integer(), nullable=False, server_default='10'),
        sa.Column('max_uses', sa.Integer(), nullable=False, server_default='1'),
        sa.Column('times_used', sa.Integer(), nullable=False, server_default='0'),
        sa.Column('expires_at', sa.DateTime(timezone=True), nullable=True),
        sa.Column('is_active', sa.Boolean(), nullable=False, server_default='true'),
        sa.Column('created_at', sa.DateTime(timezone=True), nullable=False, server_default=sa.func.now()),
        sa.Column('updated_at', sa.DateTime(timezone=True), nullable=False, server_default=sa.func.now()),
        sa.ForeignKeyConstraint(['bot_id'], ['bots.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('bot_id', 'code', name='uq_bot_redeem_code')
    )
    op.create_index(op.f('ix_bot_redeem_codes_bot_id'), 'bot_redeem_codes', ['bot_id'], unique=False)
    op.create_index(op.f('ix_bot_redeem_codes_code'), 'bot_redeem_codes', ['code'], unique=False)

    # 4. Create bot_redeem_logs table
    op.create_table(
        'bot_redeem_logs',
        sa.Column('id', sa.UUID(), nullable=False),
        sa.Column('bot_id', sa.UUID(), nullable=False),
        sa.Column('code_id', sa.UUID(), nullable=False),
        sa.Column('telegram_user_id', sa.BigInteger(), nullable=False),
        sa.Column('reward_type', sa.String(length=32), nullable=False),
        sa.Column('reward_value', sa.Integer(), nullable=False),
        sa.Column('claimed_at', sa.DateTime(timezone=True), nullable=False, server_default=sa.func.now()),
        sa.ForeignKeyConstraint(['bot_id'], ['bots.id'], ondelete='CASCADE'),
        sa.ForeignKeyConstraint(['code_id'], ['bot_redeem_codes.id'], ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('id'),
        sa.UniqueConstraint('code_id', 'telegram_user_id', name='uq_code_user_redemption')
    )
    op.create_index(op.f('ix_bot_redeem_logs_bot_id'), 'bot_redeem_logs', ['bot_id'], unique=False)
    op.create_index(op.f('ix_bot_redeem_logs_code_id'), 'bot_redeem_logs', ['code_id'], unique=False)
    op.create_index(op.f('ix_bot_redeem_logs_telegram_user_id'), 'bot_redeem_logs', ['telegram_user_id'], unique=False)


def downgrade() -> None:
    op.drop_table('bot_redeem_logs')
    op.drop_table('bot_redeem_codes')
    op.drop_column('bot_users', 'vip_until')
    op.drop_column('bot_users', 'points_balance')
    op.drop_column('bot_modules', 'enable_menu_button')
    op.drop_column('bot_modules', 'enable_inline_button')
    op.drop_column('bot_modules', 'enable_command')
