officeVote.ts

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

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

import { county } from './county.js';
import { documentScope } from './documentScope.js';
import { electionType } from './electionType.js';
import { office } from './office.js';
import { officeRace } from './officeRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';

export const officeVote = schema.table('OfficeVote', {
  uid: varchar('uid').primaryKey(),
  isSummary: boolean('isSummary').notNull(),
  isNational: boolean('isNational').notNull(),
  absenteeVoteOutstanding: bigint('absenteeVoteOutstanding', {
    mode: 'number',
  }),
  pctVoteBasedOnTotalExpectedVoteEstimate: real(
    'pctVoteBasedOnTotalExpectedVoteEstimate'
  ),
  maxAbsenteeVoteExpected: bigint('maxAbsenteeVoteExpected', {
    mode: 'number',
  }),
  numCountiesWithAbsenteeVotes: integer('numCountiesWithAbsenteeVotes'),
  numCountyWithVotes: integer('numCountyWithVotes'),
  numCounties: integer('numCounties'),
  precinctId: integer('precinctId'),
  pctExpectedVoteOutOf100: integer('pctExpectedVoteOutOf100'),
  totalPrecinctsReportingSoFar: integer(
    'totalPrecinctsReportingSoFar'
  ).notNull(),
  provisionalVoteOutstanding: bigint('provisionalVoteOutstanding', {
    mode: 'number',
  }),
  scopeType: varchar('scopeType').notNull(),
  sequencing: bigint('sequencing', { mode: 'number' }),
  sourceOfVotes: varchar('sourceOfVotes'),
  totalBallots: bigint('totalBallots', { mode: 'number' }),
  totalAbsenteeVotes: bigint('totalAbsenteeVotes', { mode: 'number' }),
  totalEarlyByMailVote: bigint('totalEarlyByMailVote', { mode: 'number' }),
  totalEarlyInPersonVote: bigint('totalEarlyInPersonVote', { mode: 'number' }),
  totalElectionDayVote: bigint('totalElectionDayVote', { mode: 'number' }),
  totalExpectedVote: bigint('totalExpectedVote', { mode: 'number' }),
  totalPrecincts: integer('totalPrecincts').notNull(),
  totalProvisionalVote: bigint('totalProvisionalVote', { mode: 'number' }),
  totalVote: bigint('totalVote', { mode: 'number' }),
  transmissionSource: varchar('transmissionSource').notNull(),
  /**
   * @TODO This should be non-null, but isn't in 2020 docs
   */
  timestamp: timestamp('timestamp'),
  /**
   * @TODO Review: This looks like it should be a foreign key
   */
  districtId: integer('districtId'),
  districtType: varchar('districtType'),

  county: varchar('county').references(() => county.uid),
  documentScope: varchar('documentScope').references(() => documentScope.uid),
  electionType: varchar('electionType')
    .notNull()
    .references(() => electionType.uid),
  office: varchar('office')
    .notNull()
    .references(() => office.uid),
  officeRace: varchar('officeRace')
    .notNull()
    .references(() => officeRace.uid),
});

export type NewOfficeVote = typeof officeVote.$inferInsert;

export const officeVoteRelations = relations(officeVote, ({ one }) => ({
  county: one(county, {
    fields: [officeVote.county],
    references: [county.uid],
  }),
  documentScope: one(documentScope, {
    fields: [officeVote.documentScope],
    references: [documentScope.uid],
  }),
  electionType: one(electionType, {
    fields: [officeVote.electionType],
    references: [electionType.uid],
  }),
  office: one(office, {
    fields: [officeVote.office],
    references: [office.uid],
  }),
  officeRace: one(officeRace, {
    fields: [officeVote.officeRace],
    references: [officeRace.uid],
  }),
}));

[]

TypeScript coverage report