Under the Hood

// Raw labels from the Sheet's row-2 col-B "signature label".
// Kept distinct from `site_type` because the Sheet's wording is its own source of truth.
export const SIGNATURE_LABELS = [
  'Anomaly',
  'Relic Signature',
  'Data Signature',
  'Gas Signature',
  'Ore Signature',
] as const;

export const sites = pgTable('sites', {
  id: serial('id').primaryKey(),
  sourceTab: text('source_tab').notNull(),
  name: text('name').notNull(),
  siteType: siteTypeEnum('site_type').notNull(),
  signatureLabel: text('signature_label').notNull(),
  wormholeClass: wormholeClassEnum('wormhole_class'),
  blueLootIsk: bigint('blue_loot_isk', { mode: 'number' }),
  resourceValueIsk: bigint('resource_value_isk', { mode: 'number' }),
});

// Per-NPC combat stats are computed live from raw EVE SDE attributes via
// src/data/npc-stats as of 2.7.1. The columns that used to cache them are
// dropped in drizzle/0009. `type_id` is the new join key.
export const npcs = pgTable('npcs', {
  sleeperName: text('sleeper_name').notNull(),
  sleeperClassCode: text('sleeper_class_code').notNull(),
  typeId: integer('type_id').notNull(),
});

// Pure formulas for per-NPC combat stats. No DB imports — takes a flat
// `{ attrId: value }` map and returns typed shapes. Spec is the
// historical snapshot fixtures + spot-checks recorded in math.test.ts.
//
// SDE attribute IDs that show up here are real CCP IDs from dgmAttributeTypes.

const ATTR = {
  rateOfFire: 51,
  turretDamageMult: 64,
  damageEm: 114,
  damageTherm: 116,
  damageKin: 117,
  damageExp: 118,
  structureHp: 9,
  shieldHp: 263,
  armorHp: 265,
  webSpeedFactor: 20,
  warpScramCount: 105,
  neutAmount: 97,
  rrepAmount: 1455,
} as const;

function computeTurretDps(attrs: AttrMap) {
  const mult = val(attrs, ATTR.turretDamageMult);
  const rofMs = val(attrs, ATTR.rateOfFire);
  if (mult <= 0 || rofMs <= 0) return { dps: ZERO_DAMAGE, alpha: ZERO_DAMAGE };
  const alpha = scaleDamage(damageQuad(attrs), mult);
  const dps = divideDamage(alpha, rofMs / 1000);
  return { dps, alpha };
}

// ESI source dispatcher. Above BULK_THRESHOLD types stale at once, the
// region-dump path streams every order in The Forge and filters in memory.
// Below the threshold, per-type calls are cheaper. Either way, a Fuzzwork
// fallback covers ESI degradation — preserving the per-row staleness
// contract so the next cron tick gets a fresh attempt.

// ESI's /markets/{region}/orders/ response item shape — only the fields
// we actually use. Boundary schema: ESI sends more keys; z.object ignores
// the unknown ones, so an upstream addition can't break parsing.

export type PriceSource = 'esi' | 'fuzzwork-fallback' | 'fuzzwork';

// Fuzzwork fallback path. Retained as a circuit-breaker target for the ESI
// source in source.ts: if ESI bulk returns 5xx or the per-type calls fail,
// the dispatcher reaches into this file for one batch round-trip and rewrites
// the source attribution to 'fuzzwork-fallback' on the way out.
//
// This file is intentionally self-contained — the dispatcher in source.ts is
// the only consumer. When Fuzzwork is eventually retired, the entire file
// deletes cleanly.

const FUZZWORK_AGGREGATES = 'https://market.fuzzwork.co.uk/aggregates/';

const fuzzworkSideSchema = z.object({
  weightedAverage: z.string(),
  max: z.string(),
  min: z.string(),
  percentile: z.string(),
});

// Source attribution is 'fuzzwork' here. The dispatcher in source.ts
// rewrites to 'fuzzwork-fallback' when calling this as a circuit-breaker
// target.

// Eve Static Data Export (SDE) tables. Sourced from CCP's first-party SDE,
// published straight from the Tranquility build pipeline as one zip of `.jsonl`
// files. The tables are shaped to CCP's native records rather than a flat
// per-table remap.

// typeDogma — every type's dogma attributes, one JSONB row per type, mirroring
// CCP's `typeDogma.jsonl` record (`{ _key: typeID, dogmaAttributes: [...] }`).
export const typeDogma = pgTable('type_dogma', {
  typeId: integer('type_id').primaryKey(),
  attributes: jsonb('attributes').notNull(),
});

// Industry blueprints — one JSONB document per blueprint, mirroring CCP's
// `blueprints.jsonl` record. `activities` holds CCP's whole nested object verbatim.
export const industryBlueprints = pgTable('industry_blueprints', {
  blueprintTypeId: integer('blueprint_type_id').primaryKey(),
  maxProductionLimit: integer('max_production_limit').notNull(),
  activities: jsonb('activities').notNull(),
});