candidateRace.ts

Filename	Percent	Threshold	Total	Covered	Uncovered
src/db/schema/candidateRace.ts	100.00%	80%	167	167	0

import { boolean, integer, varchar } from 'drizzle-orm/pg-core';

import { candidate } from './candidate.js';
import { candidateAbsenteeEstimate } from './candidateAbsenteeEstimate.js';
import { candidateElectoralVote } from './candidateElectoralVote.js';
import { candidatePriorEstimate } from './candidatePriorEstimate.js';
import { candidateRace_office } from './candidateRace_office.js';
import { candidateVote } from './candidateVote.js';
import { candidateVoteByParty } from './candidateVoteByParty.js';
import { delegateAllocation } from './delegateAllocation.js';
import { electionType } from './electionType.js';
import { officeRace } from './officeRace.js';
import { party } from './party.js';
import { state } from './state.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { candidateRace_party } from './candidateRace_party.js';

export const candidateRace = schema.table('CandidateRace', {
  uid: varchar('uid').primaryKey(),
  isIncumbent: boolean('isIncumbent').notNull(),
  isInIncumbentParty: boolean('isInIncumbentParty').notNull(),
  estimatesAreReported: boolean('estimatesAreReported').notNull(),
  candidateOutputOrder: integer('candidateOutputOrder').notNull(),
  candidateExitPollOutputOrder: integer('candidateExitPollOutputOrder'),
  numPartyLines: integer('numPartyLines').notNull(),
  candidateStatus: varchar('candidateStatus'),
  advancesToRunoff: boolean('advancesToRunoff'),
  callDescription: varchar('callDescription'),
  callStatus: varchar('callStatus'),
  candidatePercentage: integer('candidatePercentage'),
  finishingOrder: integer('finishingOrder'),
  specialElection: boolean('specialElection').notNull(),
  tiedForFirstPlace: boolean('tiedForFirstPlace'),
  winner: boolean('winner'),

  candidate: integer('candidate')
    .notNull()
    .references(() => candidate.uid),
  electionType: varchar('electionType')
    .notNull()
    .references(() => electionType.uid),
  officeRace: varchar('officeRace')
    .notNull()
    .references(() => officeRace.uid),
  state: integer('state').references(() => state.uid),
  majorParty: varchar('majorParty')
    .notNull()
    .references(() => party.uid),
});

export type NewCandidateRace = typeof candidateRace.$inferInsert;

export const candidateRaceRelations = relations(
  candidateRace,
  ({ one, many }) => ({
    candidate: one(candidate, {
      fields: [candidateRace.candidate],
      references: [candidate.uid],
    }),
    electionType: one(electionType, {
      fields: [candidateRace.electionType],
      references: [electionType.uid],
    }),
    officeRace: one(officeRace, {
      fields: [candidateRace.officeRace],
      references: [officeRace.uid],
    }),
    state: one(state, {
      fields: [candidateRace.state],
      references: [state.uid],
    }),
    majorParty: one(party, {
      fields: [candidateRace.majorParty],
      references: [party.uid],
      relationName: 'majorParty',
    }),
    candidateRace_party: one(candidateRace_party),
    candidateAbsenteeEstimate: one(candidateAbsenteeEstimate),
    candidateElectoralVotes: many(candidateElectoralVote),
    candidatePriorEstimate: one(candidatePriorEstimate),
    candidateVotes: many(candidateVote),
    candidateVoteByParties: many(candidateVoteByParty),
    delegateAllocations: many(delegateAllocation),
    offices: many(candidateRace_office),
  })
);

[]

TypeScript coverage report