/**
 * Provisioning types for VC-SYS CLI Supabase integration
 */

export interface ProvisioningConfig {
  projectName: string;
  organizationId: string;
  region: string;
  databasePassword: string;
  schemaPath?: string;
  outputDir: string;
  enableRLS: boolean;
  includeSeeds?: boolean;
}

export interface ProvisioningResult {
  project: SupabaseProject;
  apiKeys: {
    anon: string;
    serviceRole: string;
  };
  databaseUrl: string;
  envFile: string;
  success: boolean;
  steps: ProvisioningStep[];
}

export interface ProvisioningStep {
  name: string;
  status: 'pending' | 'running' | 'completed' | 'failed';
  duration?: number;
  error?: string;
  details?: any;
}

export interface SupabaseProject {
  id: string;
  ref: string;
  name: string;
  organization_id: string;
  region: string;
  status: string;
  created_at: string;
  host: string;
}

export interface CreateProjectRequest {
  organization_id: string;
  name: string;
  region: string;
  db_pass: string;
  kps_enabled?: boolean;
  plan?: string;
}

export interface ProjectApiKeys {
  anon: string;
  service_role: string;
}

export interface Organization {
  id: string;
  name: string;
  billing_email: string;
  tier: string;
  slug: string;
}

export interface SchemaTemplate {
  name: string;
  description: string;
  path: string;
  tables: string[];
  features: string[];
}

export interface SchemaValidationResult {
  valid: boolean;
  errors: string[];
  warnings?: string[];
}