presidentialPrimaryDistrictVoteByCounty.ts

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

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

import { candidate } from './candidate.js';
import { county } from './county.js';
import { delegateDistrict } from './delegateDistrict.js';
import { electionType } from './electionType.js';
import { party } from './party.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';

export const presidentialPrimaryDistrictVoteByCounty = schema.table(
  'PresidentialPrimaryDistrictVoteByCounty',
  {
    uid: varchar('uid').primaryKey(),
    candidateVote: bigint('candidateVote', { mode: 'number' }),
    unfusedCandidateVote: bigint('unfusedCandidateVote', { mode: 'number' }),
    precinctId: integer('precinctId'),
    totalPrecincts: integer('totalPrecincts'),
    totalPrecinctsReportingSoFar: integer('totalPrecinctsReportingSoFar'),
    absenteeVoteOutstanding: bigint('absenteeVoteOutstanding', {
      mode: 'number',
    }),
    maxAbsenteeBallotsExpected: bigint('maxAbsenteeBallotsExpected', {
      mode: 'number',
    }),
    provisionalVoteOutstanding: bigint('provisionalVoteOutstanding', {
      mode: 'number',
    }),
    absenteeVote: bigint('absenteeVote', { mode: 'number' }),
    earlyByMailVote: bigint('earlyByMailVote', { mode: 'number' }),
    earlyInPersonVote: bigint('earlyInPersonVote', { mode: 'number' }),
    electionDayVote: bigint('electionDayVote', { mode: 'number' }),
    provisionalVote: bigint('provisionalVote', { mode: 'number' }),
    totalBallots: bigint('totalBallots', { mode: 'number' }),
    totalAbsenteeVote: bigint('totalAbsenteeVote', { mode: 'number' }),
    totalEarlyByMailVote: bigint('totalEarlyByMailVote', { mode: 'number' }),
    totalEarlyInPersonVote: bigint('totalEarlyInPersonVote', {
      mode: 'number',
    }),
    totalElectionDayVote: bigint('totalElectionDayVote', { mode: 'number' }),
    totalProvisionalVote: bigint('totalProvisionalVote', { mode: 'number' }),
    totalVote: bigint('totalVote', { mode: 'number' }),
    districtId: integer('districtId'),
    districtTypeCode: varchar('districtTypeCode'),
    absenteeVoteProgress: varchar('absenteeVoteProgress'),
    canceled: boolean('canceled'),
    complete: boolean('complete'),
    final: boolean('final'),
    voteTabulationProgress: varchar('voteTabulationProgress'),
    reportingSource: varchar('reportingSource'),
    verified: boolean('verified'),
    electionDate: timestamp('electionDate'),
    officeCode: varchar('officeCode'),
    scope: varchar('scope'),
    sequence: bigint('sequence', { mode: 'number' }),
    timestamp: timestamp('timestamp'),
    transmissionSource: varchar('transmissionSource'),

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

export type NewPresidentialPrimaryDistrictVoteByCounty =
  typeof presidentialPrimaryDistrictVoteByCounty.$inferInsert;

export const presidentialPrimaryDistrictVoteByCountyRelations = relations(
  presidentialPrimaryDistrictVoteByCounty,
  ({ one }) => ({
    candidate: one(candidate, {
      fields: [presidentialPrimaryDistrictVoteByCounty.candidate],
      references: [candidate.uid],
    }),
    county: one(county, {
      fields: [presidentialPrimaryDistrictVoteByCounty.county],
      references: [county.uid],
    }),
    delegateDistrict: one(delegateDistrict, {
      fields: [presidentialPrimaryDistrictVoteByCounty.delegateDistrict],
      references: [delegateDistrict.uid],
    }),
    electionType: one(electionType, {
      fields: [presidentialPrimaryDistrictVoteByCounty.electionType],
      references: [electionType.uid],
    }),
    party: one(party, {
      fields: [presidentialPrimaryDistrictVoteByCounty.party],
      references: [party.uid],
    }),
    state: one(state, {
      fields: [presidentialPrimaryDistrictVoteByCounty.state],
      references: [state.uid],
    }),
  })
);

[]

TypeScript coverage report