jurisdictionRace.ts

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

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

import { candidateElectoralVote } from './candidateElectoralVote.js';
import { countyByJurisdiction } from './countyByJurisdiction.js';
import { countyExpectedVote } from './countyExpectedVote.js';
import { delegateAllocation } from './delegateAllocation.js';
import { editorialTurnout } from './editorialTurnout.js';
import { electionType } from './electionType.js';
import { electoralVote } from './electoralVote.js';
import { jurisdiction } from './jurisdiction.js';
import { jurisdictionPastRace } from './jurisdictionPastRace.js';
import { jurisdictionType } from './jurisdictionType.js';
import { message } from './message.js';
import { officeRace } from './officeRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';
import { totalExpectedVote } from './totalExpectedVote.js';
import { voteFlag } from './voteFlag.js';

export const jurisdictionRace = schema.table('JurisdictionRace', {
  uid: varchar('uid').primaryKey(),
  majorPollCloseTime: timestamp('majorPollCloseTime').notNull(),
  maxCountyTurnoutRatio: real('maxCountyTurnoutRatio'),
  minCountyTurnoutRatio: real('minCountyTurnoutRatio'),
  numElectoralVotes: integer('numElectoralVotes'),
  numNationalConventionDelegates: integer('numNationalConventionDelegates'),
  numRaces: integer('numRaces').notNull(),
  pollOpeningTime: timestamp('pollOpeningTime'),
  turnoutRatio: real('turnoutRatio'),
  absenteeRatio: real('absenteeRatio'),
  earlyByMailVoteBreakout: boolean('earlyByMailVoteBreakout'),
  earlyInPersonVoteBreakout: boolean('earlyInPersonVoteBreakout'),
  electionDayVoteBreakout: boolean('electionDayVoteBreakout'),
  provisionalVoteBreakout: boolean('provisionalVoteBreakout'),

  state: integer('state').references(() => state.uid),
  jurisdiction: varchar('jurisdiction')
    .notNull()
    .references(() => jurisdiction.uid),
  jurisdictionType: varchar('jurisdictionType')
    .notNull()
    .references(() => jurisdictionType.uid),
  electionType: varchar('electionType')
    .notNull()
    .references(() => electionType.uid),
});

export type NewJurisdictionRace = typeof jurisdictionRace.$inferInsert;

export const jurisdictionRaceRelations = relations(
  jurisdictionRace,
  ({ one, many }) => ({
    state: one(state, {
      fields: [jurisdictionRace.state],
      references: [state.uid],
    }),
    jurisdiction: one(jurisdiction, {
      fields: [jurisdictionRace.jurisdiction],
      references: [jurisdiction.uid],
    }),
    jurisdictionType: one(jurisdictionType, {
      fields: [jurisdictionRace.jurisdictionType],
      references: [jurisdictionType.uid],
    }),
    electionType: one(electionType, {
      fields: [jurisdictionRace.electionType],
      references: [electionType.uid],
    }),
    candidateElectoralVotes: many(candidateElectoralVote),
    countyByJurisdictions: many(countyByJurisdiction),
    countyExpectedVotes: many(countyExpectedVote),
    voteFlags: many(voteFlag),
    delegateAllocations: many(delegateAllocation),
    editorialTurnouts: many(editorialTurnout),
    electoralVotes: many(electoralVote),
    jurisdictionPastRaces: many(jurisdictionPastRace),
    messages: many(message),
    officeRaces: many(officeRace),
    totalExpectedVotes: many(totalExpectedVote),
  })
);

[]

TypeScript coverage report