Quant Resource Implementation Patterns

Guide for implementing domain resources that integrate with OptAIC's resource-based architecture.

When to Use

Apply when:

Creating new domain resource types (Dataset, Signal, Portfolio, etc.)
Implementing Definition resources (PipelineDef, StoreDef, OpDef, MLModuleDef, PortfolioOptimizerDef)
Implementing Instance resources (DatasetInstance, SignalInstance, BacktestInstance, etc.)
Implementing Run resources (BacktestRun, TrainingRun, MonitoringRun, etc.)
Adding domain-specific DB models, DTOs, or services

Three-Tier Resource Model

OptAIC separates Definitions (plugins) from Instances (configs) from Runs (executions):

Definition (Plugin)         Instance (Config)              Run (Execution)
─────────────────          ──────────────────             ────────────────
BloombergPipelineDef   →   SPX_OHLCV_Dataset          →   PipelineRun (daily)
PortfolioOptimizerDef  →   MVO_Conservative           →   PortfolioOptimizationRun
MLModuleDef            →   XGBoost_Predictor          →   TrainingRun, InferenceRun, MonitoringRun
(none)                 →   BacktestInstance           →   BacktestRun

Definitions: Reusable building blocks submitted as plugins (the "Law") Instances: Concrete configurations referencing definitions Runs: Executions that produce immutable versions and metrics

Resource Type Summary

Definition Resources

Type	Purpose	Contains
`PipelineDef`	Data ingestion plugin	ETL code, schemas
`StoreDef`	Storage backend	Parquet/SQLite/Virtual
`AccessorDef`	Data access pattern	Simple/PIT/Field
`OpDef`	Math operator	REF, DELTA, MEAN
`OpMacroDef`	Saved expression	User formulas
`MLModuleDef`	ML model template	XGBoost, LSTM
`PortfolioOptimizerDef`	Optimization algo	MVO, HRP, RiskParity

Instance Resources

Type	Parent Definition	Notes
`DatasetInstance`	PipelineDef + StoreDef + AccessorDef	Composition
`SignalInstance`	Inherits DatasetInstance	Promoted dataset
`ExperimentInstance`	OpDef/OpMacroDef	Expression config
`ModelInstance`	MLModuleDef	ML model config
`PortfolioOptimizerInstance`	PortfolioOptimizerDef	Optimizer config
`BacktestInstance`	None	Fixed procedure

Run Resources

Type	Parent Instance	Key Outputs
`PipelineRun`	DatasetInstance	rows_added, last_date
`ExperimentRun`	ExperimentInstance	preview_data
`BacktestRun`	BacktestInstance	equity_curve, trades, metrics
`PortfolioOptimizationRun`	PortfolioOptimizerInstance	weights
`TrainingRun`	ModelInstance	model_artifact
`InferenceRun`	ModelInstance	predictions
`MonitoringRun`	ModelInstance/DatasetInstance	drift_metrics, alerts

Implementation Workflow

1. Determine Resource Tier

Definition resource? → Implements abstract interface, has test suite, requires evaluation Instance resource? → References definition(s), has config, can be scheduled

2. Create DB Model

Location: libs/db/models/<domain>.py

Link to resources table via FK. See references/db-patterns.md.

3. Create DTOs

Location: libs/core/domain/<domain>.py

Use Pydantic. Never expose SQLAlchemy models to API. See references/dto-patterns.md.

4. Create Service Layer

Location: libs/core/domain/<domain>_service.py

Emit activities for all mutations. See references/service-patterns.md.

5. Register ResourceType

Update libs/core/resources.py → ResourceType enum.

6. Generate Migration

bash

optaic db revision --autogenerate -m "add <domain> resource"

7. Write Tests

Location: libs/core/tests/test_<domain>.py

Critical Rules

Lazy imports - Heavy deps (pandas, numpy, torch) must use TYPE_CHECKING blocks
Activity emission - All mutations emit activities in service layer
Guardrails hooks - Validate at lifecycle gates (create/update/promote)
Version tracking - Instances reference definition versions
code_ref linkage - Services bridge DB models to factories via Definition.code_ref

code_ref Integration (CRITICAL)

The code_ref field in Definition extension tables links to factory registration keys:

Definition.code_ref → FACTORY.build(code_ref) → Execution Object

Pattern: Service loads Instance → loads Definition → gets code_ref → builds from Factory

See Service Patterns for implementation details.

API Router Patterns

Location: apps/api/routers/<domain>.py

Implemented Routers

Router	Prefix	Key Endpoints
`ops.py`	`/ops`	List operators, get details, evaluate expressions
`pipelines.py`	`/pipelines`	Definition CRUD, instance CRUD, trigger runs
`experiments.py`	`/experiments`	Create, run, update, save as macro
`datasets.py`	`/datasets`	Get info, status, preview, refresh
`signals.py`	`/signals`	Register, validate, promote, list

Router Pattern

python

from apps.api.deps import get_actor, get_db
from apps.api.rbac_utils import authorize_or_403, get_resource_or_404
from apps.api.services import DatasetService

@router.post("/{id}/preview", response_model=DatasetPreviewOut)
async def preview_dataset(
    dataset_id: UUID,
    payload: DatasetPreviewRequest = Body(...),
    actor: ActorContext = Depends(get_actor),
    db: AsyncSession = Depends(get_db),
) -> DatasetPreviewOut:
    # 1. Get resource and check RBAC
    resource = await get_resource_or_404(db, actor.tenant_id, dataset_id)
    await authorize_or_403(db, actor, Permission.RESOURCE_READ, resource.id)

    # 2. Call service (services emit activities, NOT routers)
    service = DatasetService()
    result = await service.preview(session=db, actor=actor, ...)

    # 3. Return DTO (never SQLAlchemy models)
    return DatasetPreviewOut(**result)

Service Layer

Location: apps/api/services/<domain>_service.py

Implemented Services

Service	Key Methods
`DatasetService`	`get_status`, `preview`, `refresh`
`SignalService`	`register_signal`, `validate_signal`, `promote_signal`, `list_signals`
`PipelineService`	`submit_definition`, `deploy_definition`, `create_instance`, `trigger_run`
`ExperimentService`	`create_experiment`, `run_experiment`, `save_as_macro`, `update_experiment`
`OpService`	`list_operators`, `get_operator`, `evaluate_expression`

Service Exports

python

# apps/api/services/__init__.py
from apps.api.services.dataset_service import DatasetService
from apps.api.services.experiment_service import ExperimentService
from apps.api.services.op_service import OpService
from apps.api.services.pipeline_service import PipelineService
from apps.api.services.signal_service import SignalService

API Schemas

Location: apps/api/schemas.py (Quant Domain section)

Schema Group	DTOs
Pipeline	`PipelineDefinitionCreate`, `PipelineDefinitionOut`, `PipelineInstanceCreate`, `PipelineInstanceOut`, `PipelineRunOut`
Dataset	`DatasetPreviewRequest`, `DatasetPreviewOut`, `DatasetRefreshOut`, `DatasetStatusOut`
Signal	`SignalRegisterRequest`, `SignalOut`, `SignalValidateOut`
Operator	`OperatorOut`, `OperatorListOut`, `ExpressionEvaluateRequest`, `ExpressionEvaluateOut`
Experiment	`ExperimentCreate`, `ExperimentOut`, `ExperimentRunRequest`, `ExprimentRunOut`, `MacroSaveOut`

System Bootstrap and Space Hierarchy

System Bootstrap

On application startup, the system bootstraps via libs/core/bootstrap.py:

python

from libs.core.bootstrap import (
    SYSTEM_TENANT_ID,      # 00000000-0000-0000-0000-000000000001
    SYSTEM_SPACE_ID,       # 00000000-0000-0000-0000-000000000002
    SYSTEM_PRINCIPAL_ID,   # 00000000-0000-0000-0000-000000000003
    SYSTEM_TENANT_ROOT_ID, # 00000000-0000-0000-0000-000000000010
    SYSTEM_PROJECT_ID,     # 00000000-0000-0000-0000-000000000013
)

# bootstrap_system() creates (idempotent):
# 1. System Tenant
# 2. Admin Principal (admin@optaic.local)
# 3. TenantRoot Resource
# 4. Default role permissions (owner, operator, viewer, auditor)
# 5. System Space with Official + Staging sub-spaces
# 6. System Project for definitions
# 7. Admin owner role on System Space

Space Hierarchy

TenantRoot
└── Space (space_kind: personal|team|system)
    ├── Subspace (subspace_kind: official)  ← Production resources
    ├── Subspace (subspace_kind: staging)   ← Resources under review
    └── Subspace (subspace_kind: custom)    ← User-created
        └── Project
            └── Resources (datasets, experiments, etc.)

SpaceService Patterns

apps/api/services/space_service.py provides:

python

class SpaceService:
    async def create_space_with_subspaces(...) -> SpaceCreationResult
        # Creates Space + Official + Staging sub-spaces
        # Grants owner role to owner_principal_id
        # Emits activities for all creations

    async def create_user_with_personal_space(...) -> UserCreationResult
        # Creates Principal + Personal Space
        # Grants owner on Personal Space
        # (Optionally grant VIEW on System Space)

    async def create_team_space(...) -> SpaceCreationResult
        # Creates Team Space with owner
        # Optionally grants operator to members

Resource Copy Pattern

Copy definitions from System Space to user projects:

python

# API: POST /resources/{resource_id}/copy
# SDK: client.resources.copy(resource_id, target_parent_id, new_name=...)

# Creates:
# 1. New resource with copier as owner
# 2. derived_from lineage edge to source
# 3. resource.copied activity

Admin SDK

libs/sdk_py/admin.py provides admin operations:

python

# Create user with Personal Space
result = await client.admin.create_user_with_space(
    display_name="Alice Smith",
    email="alice@example.com",
)
# Returns: principal_id, space_id, official_subspace_id, staging_subspace_id

# Create Team Space
result = await client.admin.create_team_space(
    name="Quant Research Team",
    owner_principal_id=owner_id,
    member_principal_ids=[member1, member2],  # Optional
)

Reference Files

DB Model Patterns - SQLAlchemy patterns
DTO Patterns - Pydantic schemas
Service Patterns - CRUD with activities

Search AI Tools

quant-resource-patterns

Install this agent skill to your Project

SKILL.md

Quant Resource Implementation Patterns

When to Use

Three-Tier Resource Model

Resource Type Summary

Definition Resources

Instance Resources

Run Resources

Implementation Workflow

1. Determine Resource Tier

2. Create DB Model

3. Create DTOs

4. Create Service Layer

5. Register ResourceType

6. Generate Migration

7. Write Tests

Critical Rules

code_ref Integration (CRITICAL)

API Router Patterns

Implemented Routers

Router Pattern

Service Layer

Implemented Services

Service Exports

API Schemas

System Bootstrap and Space Hierarchy

System Bootstrap

Space Hierarchy

SpaceService Patterns

Resource Copy Pattern

Admin SDK

Reference Files