mirror of
https://github.com/jhd3197/ServerKit.git
synced 2026-10-27 23:28:03 +09:00
Juan DenisandClaude Opus 4.8
478b24a3cb
- Project / Environment hierarchy (C2): Workspace -> Project -> Environment org model. New Project/Environment models + CRUD APIs, nullable applications.project_id/environment_id (opt-in, no destructive backfill), ProjectService.ensure_default, a Projects list + ProjectDetail (env tabs), a project/environment selector in the create wizard, and sidebar nav. - Polymorphic shared resources facade (C9): ResourceTag + SharedVariableGroup /SharedVariable/attachment models keyed by (resource_type, resource_id), reusing the env-var Fernet encryption; SharedResourceService resolves merged variables (most-recent attachment wins) with secrets masked. /api/v1/shared endpoints + reusable TagsPanel/EnvironmentVariablesPanel + a Shared Variables management page. Existing per-resource tables untouched (facade first). - PR preview environments (C3): ApplicationPreview + settings models, a PreviewService with pure domain-templating + reconcile (open PRs vs active previews) cores and best-effort provisioning (incl. guarded WordPress file+DB clone), a pull_request webhook endpoint, preview.* jobs, and a Previews tab on the app detail page. - Per-server managed proxy stack (C6): opt-in Dockerized Traefik/Caddy as a Compose stack (host Nginx stays default and superior for PHP/WordPress). ProxyStack model + ProxyStackService with pure compose/config generators and versioned config backups, /api/v1/servers/<id>/proxy endpoints, and a Proxy tab on the server detail page. Migrations 031-034 add the new tables/columns; the full chain applies cleanly from an empty DB. Full backend suite: 871 passed, 14 skipped; frontend builds. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
54 lines
1.9 KiB
Python
54 lines
1.9 KiB
Python
"""Per-server managed proxy stack.
|
|
|
|
Adds:
|
|
- proxy_stacks (one row per server; opt-in Traefik/Caddy compose stack, host
|
|
Nginx stays the default)
|
|
|
|
Idempotent: MigrationService runs _fix_missing_columns() + db.create_all() on boot
|
|
before Alembic, so guard on the live schema.
|
|
|
|
Revision ID: 034_proxy_stacks
|
|
Revises: 033_application_previews
|
|
Create Date: 2026-06-23
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
revision = '034_proxy_stacks'
|
|
down_revision = '033_application_previews'
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade():
|
|
conn = op.get_bind()
|
|
inspector = sa.inspect(conn)
|
|
existing = set(inspector.get_table_names())
|
|
|
|
if 'proxy_stacks' not in existing:
|
|
op.create_table(
|
|
'proxy_stacks',
|
|
sa.Column('id', sa.String(36), nullable=False),
|
|
sa.Column('server_id', sa.String(36), nullable=False),
|
|
sa.Column('proxy_type', sa.String(20), nullable=False, server_default='nginx'),
|
|
sa.Column('status', sa.String(20), nullable=False, server_default='unknown'),
|
|
sa.Column('compose_path', sa.String(512), nullable=True),
|
|
sa.Column('networks', sa.Text, nullable=True),
|
|
sa.Column('custom_snippet', sa.Text, nullable=True),
|
|
sa.Column('last_regenerated_at', sa.DateTime, nullable=True),
|
|
sa.Column('created_at', sa.DateTime, nullable=True),
|
|
sa.Column('updated_at', sa.DateTime, nullable=True),
|
|
sa.PrimaryKeyConstraint('id'),
|
|
sa.ForeignKeyConstraint(['server_id'], ['servers.id']),
|
|
sa.UniqueConstraint('server_id', name='uq_proxy_stack_server'),
|
|
)
|
|
op.create_index('ix_proxy_stacks_server_id', 'proxy_stacks', ['server_id'])
|
|
|
|
|
|
def downgrade():
|
|
conn = op.get_bind()
|
|
inspector = sa.inspect(conn)
|
|
existing = set(inspector.get_table_names())
|
|
if 'proxy_stacks' in existing:
|
|
op.drop_table('proxy_stacks')
|