IRIS Legacy

"""add_token_usage_table Revision ID: ba43701ca867 Revises: Create Date: 2025-10-06 11:52:21.003950 """ from typing import Sequence, Union from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision: str = 'ba43701ca867' down_revision: Union[str, Sequence[str], None] = None branch_labels: Union[str, Sequence[str], None] = None depends_on: Union[str, Sequence[str], None] = None def upgrade() -> None: """Upgrade schema.""" op.create_table( 'token_usage', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.String(length=255), nullable=False), sa.Column('session_id', sa.String(length=255), nullable=True), sa.Column('provider', sa.String(length=50), nullable=False), sa.Column('model', sa.String(length=100), nullable=False), sa.Column('input_tokens', sa.Integer(), nullable=False), sa.Column('output_tokens', sa.Integer(), nullable=False), sa.Column('total_tokens', sa.Integer(), sa.Computed('input_tokens + output_tokens'), nullable=False), sa.Column('cost_usd', sa.Numeric(precision=10, scale=6), nullable=False), sa.Column('cost_eur', sa.Numeric(precision=10, scale=6), nullable=False), sa.Column('exchange_rate', sa.Numeric(precision=10, scale=6), nullable=False), sa.Column('created_at', sa.TIMESTAMP(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False), sa.PrimaryKeyConstraint('id') ) # Create indexes for query performance op.create_index('idx_token_usage_user_id', 'token_usage', ['user_id']) op.create_index('idx_token_usage_session_id', 'token_usage', ['session_id']) op.create_index('idx_token_usage_created_at', 'token_usage', ['created_at']) op.create_index('idx_token_usage_user_date', 'token_usage', ['user_id', 'created_at']) def downgrade() -> None: """Downgrade schema.""" op.drop_index('idx_token_usage_user_date', table_name='token_usage') op.drop_index('idx_token_usage_created_at', table_name='token_usage') op.drop_index('idx_token_usage_session_id', table_name='token_usage') op.drop_index('idx_token_usage_user_id', table_name='token_usage') op.drop_table('token_usage')