Build an app. Keep 70%.

interface AppTable {
  name: string;          // SQL table name in Postgres
  label: string;         // Human-readable label
}

interface AppProcedure {
  slug: string;          // Unique identifier e.g. "process-payment"
  name: string;          // Human-readable name
}

interface AppRoute {
  path: string;          // URL path relative to app mount point
  description: string;   // What the page/endpoint does
}

interface AppMigration {
  file: string;          // File name relative to drizzle/ directory
  description: string;   // What the migration does
}

interface AppPricing {
  monthlyCents: number;  // Monthly price in USD cents (0 = free)
  stripePriceId?: string; // Optional Stripe price ID
}

interface AppDependency {
  slug: string;
  version?: string;
}

interface AppManifest {
  slug: string;          // Unique kebab-case identifier
  name: string;          // Human-readable name
  version: string;       // SemVer string
  description?: string;  // ≤ 200 chars
  dependsOn?: AppDependency[];
  exposes?: {
    tables?: AppTable[];
    procedures?: AppProcedure[];
    routes?: AppRoute[];
    migrations?: AppMigration[];
  };
  pricing: AppPricing;   // Zero = free
}

// src/lib/trpc/router.ts
import { z } from "zod";
import { initTRPC } from "@trpc/server";
import superjson from "superjson";

const t = initTRPC.context<Context>().create({
  transformer: superjson,
});

export const appRouter = t.router({
  health: publicProcedure.query(() => {
    return { status: "ok", timestamp: new Date().toISOString() };
  }),

  listTenants: publicProcedure.query(async ({ ctx }) => {
    const rows = await ctx.db.select().from(tenants);
    return rows;
  }),

  getTenantById: publicProcedure
    .input(z.object({ id: z.string().uuid() }))
    .query(async ({ ctx, input }) => {
      const [row] = await ctx.db
        .select()
        .from(tenants)
        .where(eq(tenants.id, input.id))
        .limit(1);
      return row ?? null;
    }),
});

export type AppRouter = typeof appRouter;