pastCountyVote.ts

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

import { bigint, integer, 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';

/**
 * @TODO Review for jurisdiction/jurisdictionRace relationship
 */
export const pastCountyVote = schema.table('PastCountyVote', {
  uid: varchar('uid').primaryKey(),
  jurisdiction: varchar('jurisdiction'),
  jurisdictionRace: varchar('jurisdictionRace'),
  office: varchar('office'),
  officeRace: varchar('officeRace'),
  totalVoteForAllCandidates: bigint('totalVoteForAllCandidates', {
    mode: 'number',
  }),
  pastElectionDate: varchar('pastElectionDate'),

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

export type NewPastCountyVote = typeof pastCountyVote.$inferInsert;

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