pastCandidateVoteByCounty.ts

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

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

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

export const pastCandidateVoteByCounty = schema.table(
  'PastCandidateVoteByCounty',
  {
    uid: varchar('uid').primaryKey(),
    candidate: integer('candidate'),
    candidateRace: varchar('candidateRace'),
    jurisdiction: varchar('jurisdiction'),
    jurisdictionRace: varchar('jurisdictionRace'),
    office: varchar('office'),
    officeRace: varchar('officeRace'),
    candidateVote: bigint('candidateVote', { mode: 'number' }),
    totalVoteForAllCandidates: bigint('totalVoteForAllCandidates', {
      mode: 'number',
    }),
    pastElectionDate: timestamp('pastElectionDate'),
    absenteeVote: bigint('absenteeVote', { mode: 'number' }),
    earlyByMailVote: bigint('earlyByMailVote', { mode: 'number' }),
    earlyInPersonVote: bigint('earlyInPersonVote', { mode: 'number' }),
    electionDayVote: bigint('electionDayVote', { mode: 'number' }),
    otherVote: bigint('otherVote', { mode: 'number' }),

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

export type NewPastCandidateVoteByCounty =
  typeof pastCandidateVoteByCounty.$inferInsert;

export const pastCandidateVoteByCountyRelations = relations(
  pastCandidateVoteByCounty,
  ({ one }) => ({
    county: one(county, {
      fields: [pastCandidateVoteByCounty.county],
      references: [county.uid],
    }),
    state: one(state, {
      fields: [pastCandidateVoteByCounty.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