totalExpectedVote.ts

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

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

import { county } from './county.js';
import { electionType } from './electionType.js';
import { jurisdiction } from './jurisdiction.js';
import { jurisdictionRace } from './jurisdictionRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';
import { turnoutStage } from './turnoutStage.js';

export const totalExpectedVote = schema.table('TotalExpectedVote', {
  uid: varchar('uid').primaryKey(),
  countyOutstandingBallot: bigint('countyOutstandingBallot', {
    mode: 'number',
  }),
  outstandingVoteType: varchar('outstandingVoteType'),
  voteTabulationProgress: varchar('voteTabulationProgress'),
  precinctReportType: varchar('precinctReportType'),
  reportingSource: varchar('reportingSource'),
  absenteeVoteProgress: varchar('absenteeVoteProgress'),
  totalExpectedAbsenteeVote: bigint('totalExpectedAbsenteeVote', {
    mode: 'number',
  }),
  totalExpectedEarlyByMailVote: bigint('totalExpectedEarlyByMailVote', {
    mode: 'number',
  }),
  totalExpectedEarlyInPersonVote: bigint('totalExpectedEarlyInPersonVote', {
    mode: 'number',
  }),
  totalExpectedElectionDayVote: bigint('totalExpectedElectionDayVote', {
    mode: 'number',
  }),
  totalExpectedVote: bigint('totalExpectedVote', { mode: 'number' }),
  totalExpectedVoteMode: varchar('totalExpectedVoteMode'),
  /**
   * @TODO - Jon, this is sometimes null so got rid of notNull().
   * From Edison: The final flag will be set in the county and statewide levels only.
   */
  final: boolean('final'),
  /**
   * @TODO - Jon, this is sometimes null so got rid of notNull().
   * From Edison: The complete flag will be set in the county level only.
   */
  complete: boolean('complete'),
  /**
   * @TODO - Jon, this is sometimes null so got rid of notNull().
   * From Edison: The verified flag will be set in the county level only.
   */
  verified: boolean('verified'),
  /**
   * @TODO - Jon, this is sometimes null so got rid of notNull().
   */
  cancelled: boolean('cancelled'),
  timestamp: timestamp('timestamp'),
  county: varchar('county').references(() => county.uid),
  electionType: varchar('electionType')
    .notNull()
    .references(() => electionType.uid),
  jurisdiction: varchar('jurisdiction')
    .notNull()
    .references(() => jurisdiction.uid),
  jurisdictionRace: varchar('jurisdictionRace')
    .notNull()
    .references(() => jurisdictionRace.uid),
  state: integer('state').references(() => state.uid),
  turnoutStage: integer('turnoutStage').references(() => turnoutStage.uid),
});

export type NewTotalExpectedVote = typeof totalExpectedVote.$inferInsert;

export const totalExpectedVoteRelations = relations(
  totalExpectedVote,
  ({ one }) => ({
    county: one(county, {
      fields: [totalExpectedVote.county],
      references: [county.uid],
    }),
    electionType: one(electionType, {
      fields: [totalExpectedVote.electionType],
      references: [electionType.uid],
    }),
    jurisdiction: one(jurisdiction, {
      fields: [totalExpectedVote.jurisdiction],
      references: [jurisdiction.uid],
    }),
    jurisdictionRace: one(jurisdictionRace, {
      fields: [totalExpectedVote.jurisdictionRace],
      references: [jurisdictionRace.uid],
    }),
    state: one(state, {
      fields: [totalExpectedVote.state],
      references: [state.uid],
    }),
    turnoutStage: one(turnoutStage, {
      fields: [totalExpectedVote.turnoutStage],
      references: [turnoutStage.uid],
    }),
  })
);

[]

TypeScript coverage report