Kyle Pope
8582b41b03
Backend:
- Migration 037: add email, first_name, last_name to users table
- User model: add 3 profile columns
- Admin schemas: extend UserListItem/UserDetailResponse/CreateUserRequest
with profile fields, email validator, name field sanitization
- _create_user_defaults: accept optional preferred_name kwarg
- POST /users: set profile fields, email uniqueness check, IntegrityError guard
- GET /users/{id}: join Settings for preferred_name, include must_change_password/locked_until
Frontend:
- AdminUser/AdminUserDetail types: add profile + detail fields
- useAdmin: add CreateUserPayload profile fields + useAdminUserDetail query
- CreateUserDialog: optional profile section (first/last name, email, preferred name)
- IAMPage: search bar filtering on username/email/name, email column in table,
row click to select user with accent highlight
- UserDetailSection: two-column detail panel (User Info + Security & Permissions)
with inline role editing
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
30 lines
886 B
Python
30 lines
886 B
Python
"""Add user profile fields (email, first_name, last_name).
|
|
|
|
Revision ID: 037
|
|
Revises: 036
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
revision = "037"
|
|
down_revision = "036"
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.add_column("users", sa.Column("email", sa.String(255), nullable=True))
|
|
op.add_column("users", sa.Column("first_name", sa.String(100), nullable=True))
|
|
op.add_column("users", sa.Column("last_name", sa.String(100), nullable=True))
|
|
|
|
op.create_unique_constraint("uq_users_email", "users", ["email"])
|
|
op.create_index("ix_users_email", "users", ["email"])
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.drop_index("ix_users_email", table_name="users")
|
|
op.drop_constraint("uq_users_email", "users", type_="unique")
|
|
op.drop_column("users", "last_name")
|
|
op.drop_column("users", "first_name")
|
|
op.drop_column("users", "email")
|