← vibesdk

/**
 * Centralized Database Types
 */

import * as schema from './schema';
import type { ModelConfig } from '../agents/inferutils/config.types';

// ========================================
// CORE SHARED INTERFACES
// ========================================

export type Visibility = 'private' | 'public';

/**
 * Standard pagination interface used across all services
 */
export interface PaginationInfo {
    limit: number;
    offset: number;
    total: number;
    hasMore: boolean;
}

/**
 * Enhanced app data with user and social statistics
 */
export interface EnhancedAppData extends schema.App {
    userName: string | null;
    userAvatar: string | null;
    starCount: number;
    userStarred: boolean;
    userFavorited: boolean;
    viewCount?: number;
    forkCount?: number;
    likeCount?: number;
}

/**
 * Safe public projection of an app for listing responses. Explicitly excludes
 * sensitive/operational columns (originalPrompt, finalPrompt, sessionToken,
 * userId, deploymentId, parentAppId, etc.). GitHub fields are only populated
 * for public repositories.
 */
export type PublicAppListData = Pick<
    EnhancedAppData,
    | 'id'
    | 'title'
    | 'description'
    | 'iconUrl'
    | 'framework'
    | 'visibility'
    | 'status'
    | 'isFeatured'
    | 'screenshotUrl'
    | 'createdAt'
    | 'updatedAt'
    | 'lastDeployedAt'
    | 'githubRepositoryUrl'
    | 'githubRepositoryVisibility'
    | 'userName'
    | 'userAvatar'
    | 'starCount'
    | 'viewCount'
    | 'forkCount'
    | 'likeCount'
    | 'userStarred'
    | 'userFavorited'
>;

/**
 * Safe public projection of an app for the detail endpoint. Adds the original
 * prompt (intended public feature on public apps). Owner-only operational
 * fields (userId, deploymentId) are populated only when the viewer owns the app.
 */
export type PublicAppDetailData = PublicAppListData &
    Pick<EnhancedAppData, 'originalPrompt'> & {
        userId?: string | null;
        deploymentId?: string | null;
    };

/**
 * App with favorite status for user-specific queries
 */
export interface AppWithFavoriteStatus extends schema.App {
    isFavorite: boolean;
    updatedAtFormatted: string;
}

/**
 * Favorite toggle operation result
 */
export interface FavoriteToggleResult {
    isFavorite: boolean;
}

// ========================================
// PAGINATION AND QUERY TYPES
// ========================================

/**
 * Generic paginated result wrapper
 */
export interface PaginatedResult<T> {
    data: T[];
    pagination: PaginationInfo;
}

/**
 * Pagination input parameters (for requests)
 */
export type PaginationParams = Partial<Pick<PaginationInfo, 'limit' | 'offset'>>;

// ========================================
// APP-RELATED TYPES
// ========================================

/**
 * Time period for analytics and trending
 */
export type TimePeriod = 'today' | 'week' | 'month' | 'all';

/**
 * Sort options for app listings
 */
export type AppSortOption = 'recent' | 'popular' | 'trending' | 'starred';

/**
 * Sort order options
 */
export type SortOrder = 'asc' | 'desc';

/**
 * Base app query options with common filters and pagination
 */
export interface BaseAppQueryOptions extends PaginationParams {
    framework?: string;
    search?: string;
    sort?: AppSortOption;
    order?: SortOrder;
    period?: TimePeriod;
}

/**
 * User app query options with user-specific filters
 */
export interface AppQueryOptions extends BaseAppQueryOptions {
    status?: 'generating' | 'completed';
    visibility?: Visibility;
}

/**
 * Public app query options with user context for favorites/interactions
 */
export interface PublicAppQueryOptions extends BaseAppQueryOptions {
    userId?: string; // For user-specific data like favorites
}

/**
 * App ownership verification result
 */
export interface OwnershipResult {
    exists: boolean;
    isOwner: boolean;
    visibility?: 'private' | 'public' | null;
}

/**
 * App visibility update operation result
 */
export interface AppVisibilityUpdateResult {
    success: boolean;
    error?: string;
    app?: Pick<schema.App, 'id' | 'title' | 'visibility' | 'updatedAt'>;
}

/**
 * Simple app creation data
 */
export interface SimpleAppCreation {
    userId: string;
    title: string;
    description?: string;
    framework?: string;
    visibility?: Visibility;
}

/**
 * App for forking - includes permission check result
 */
export interface AppForForkResult {
    app: schema.App | null;
    canFork: boolean;
}

// ========================================
// USER-RELATED TYPES
// ========================================

/**
 * User statistics with all metrics
 */
export interface UserStats {
    appCount: number;
    publicAppCount: number;
    favoriteCount: number;
    totalLikesReceived: number;
    totalViewsReceived: number;
    streakDays: number;
    achievements: string[];
}

/**
 * User activity timeline entry
 */
export interface UserActivity {
    type: 'created' | 'updated' | 'favorited';
    title: string;
    timestamp: Date | null;
    metadata: Record<string, unknown>;
}

// ========================================
// ANALYTICS AND STATISTICS
// ========================================

/**
 * Batch app statistics for multiple apps
 */
export interface BatchAppStats {
    [appId: string]: AppStats;
}

/**
 * Team statistics
 */
export interface TeamStats {
    memberCount: number;
    appCount: number;
}

/**
 * Board statistics
 */
export interface BoardStats {
    memberCount: number;
    appCount: number;
}

/**
 * Individual app statistics
 */
export interface AppStats {
    viewCount: number;
    forkCount: number;
    likeCount: number;
}

/**
 * Model configuration with user override metadata
 */
export interface UserModelConfigWithMetadata extends ModelConfig {
    // User override metadata
    isUserOverride: boolean;
    userConfigId?: string;
}

// ========================================
// TESTING AND VALIDATION TYPES
// ========================================

/**
 * Model test result
 */
export interface TestResult {
    success: boolean;
    error?: string;
    model?: string;
    latencyMs?: number;
}

/**
 * Model test request parameters
 */
export interface ModelTestRequest {
    modelConfig: ModelConfig;
    userApiKeys?: Record<string, string>;
    testPrompt?: string;
}

/**
 * Complete model test result with metadata
 */
export interface ModelTestResult {
    success: boolean;
    error?: string;
    responsePreview?: string;
    latencyMs: number;
    modelUsed: string;
    timestamp?: Date;
}

// ========================================
// ERROR HANDLING TYPES
// ========================================

/**
 * Structured error for database operations
 */
export interface DatabaseError {
    code: string;
    message: string;
    details?: Record<string, unknown>;
}

/**
 * Operation result wrapper with error handling
 */
export interface OperationResult<T> {
    success: boolean;
    data?: T;
    error?: DatabaseError;
}

/**
 * Error object with optional nested error
 */
export interface ErrorWithMessage {
    message?: string;
    error?: {
        message?: string;
    };
}

/**
 * Type guard to check if error is an object with message
 */
export function isErrorWithMessage(error: unknown): error is ErrorWithMessage {
    return (
        typeof error === 'object' &&
        error !== null &&
        ('message' in error || ('error' in error && typeof (error as Record<string, unknown>).error === 'object'))
    );
}

// ========================================
// UTILITY TYPES
// ========================================

/**
 * Health check result
 */
export interface HealthStatusResult {
    healthy: boolean;
    timestamp: string;
    details?: Record<string, unknown>;
}