countyExpectedVote.ts

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

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

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

export const countyExpectedVote = schema.table('CountyExpectedVote', {
  uid: varchar('uid').primaryKey(),
  pollingLocations: integer('pollingLocations'),
  totalExpectedAbsenteeVote: integer('totalExpectedAbsenteeVote'),
  totalExpectedEarlyByMailVote: integer('totalExpectedEarlyByMailVote'),
  totalExpectedEarlyInPersonVote: integer('totalExpectedEarlyInPersonVote'),
  totalExpectedElectionDayVote: integer('totalExpectedElectionDayVote'),
  totalExpectedVote: integer('totalExpectedVote'),

  county: varchar('county').references(() => county.uid),
  jurisdiction: varchar('jurisdiction')
    .notNull()
    .references(() => jurisdiction.uid),
  jurisdictionRace: varchar('jurisdictionRace')
    .notNull()
    .references(() => jurisdictionRace.uid),
});

export type NewCountyExpectedVote = typeof countyExpectedVote.$inferInsert;

export const countyExpectedVoteRelations = relations(
  countyExpectedVote,
  ({ one }) => ({
    county: one(county, {
      fields: [countyExpectedVote.county],
      references: [county.uid],
    }),
    jurisdiction: one(jurisdiction, {
      fields: [countyExpectedVote.jurisdiction],
      references: [jurisdiction.uid],
    }),
    jurisdictionRace: one(jurisdictionRace, {
      fields: [countyExpectedVote.jurisdictionRace],
      references: [jurisdictionRace.uid],
    }),
  })
);

[]

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

TypeScript coverage report