candidateVote.ts

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

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

import { candidate } from './candidate.js';
import { candidateRace } from './candidateRace.js';
import { county } from './county.js';
import { electionType } from './electionType.js';
import { jurisdiction } from './jurisdiction.js';
import { office } from './office.js';
import { officeRace } from './officeRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';

export const candidateVote = schema.table('CandidateVote', {
  uid: varchar('uid').primaryKey(),
  isSummary: boolean('isSummary').notNull(),
  isNational: boolean('isNational').notNull(),
  totalVote: bigint('totalVote', { mode: 'number' }).notNull(),
  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' }),

  candidate: integer('candidate')
    .notNull()
    .references(() => candidate.uid),
  candidateRace: varchar('candidateRace')
    .notNull()
    .references(() => candidateRace.uid),
  county: varchar('county').references(() => county.uid),
  electionType: varchar('electionType')
    .notNull()
    .references(() => electionType.uid),
  jurisdiction: varchar('jurisdiction')
    .notNull()
    .references(() => jurisdiction.uid),
  office: varchar('office')
    .notNull()
    .references(() => office.uid),
  officeRace: varchar('officeRace')
    .notNull()
    .references(() => officeRace.uid),
  state: integer('state').references(() => state.uid),
});

export type NewCandidateVote = typeof candidateVote.$inferInsert;

export const candidateVoteRelations = relations(candidateVote, ({ one }) => ({
  candidate: one(candidate, {
    fields: [candidateVote.candidate],
    references: [candidate.uid],
  }),
  candidateRace: one(candidateRace, {
    fields: [candidateVote.candidateRace],
    references: [candidateRace.uid],
  }),
  county: one(county, {
    fields: [candidateVote.county],
    references: [county.uid],
  }),
  electionType: one(electionType, {
    fields: [candidateVote.electionType],
    references: [electionType.uid],
  }),
  jurisdiction: one(jurisdiction, {
    fields: [candidateVote.jurisdiction],
    references: [jurisdiction.uid],
  }),
  office: one(office, {
    fields: [candidateVote.office],
    references: [office.uid],
  }),
  officeRace: one(officeRace, {
    fields: [candidateVote.officeRace],
    references: [officeRace.uid],
  }),
  state: one(state, {
    fields: [candidateVote.state],
    references: [state.uid],
  }),
}));

[]

TypeScript Coverage Report generated by type-coverage and typescript-coverage-report at Thu, 04 Apr 2024 19:50:44 GMT

TypeScript coverage report