countyByJurisdiction.ts

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

import { boolean, 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 countyByJurisdiction = schema.table('CountyByJurisdiction', {
  uid: varchar('uid').primaryKey(),
  registeredVotersForCountyElection: integer(
    'registeredVotersForCountyElection'
  ).notNull(),
  isEntireCounty: boolean('isEntireCounty').notNull(),
  totalPrecincts: integer('totalPrecincts').notNull(),

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

export type NewCountyByJurisdiction = typeof countyByJurisdiction.$inferInsert;

export const countyByJurisdictionRelations = relations(
  countyByJurisdiction,
  ({ one }) => ({
    county: one(county, {
      fields: [countyByJurisdiction.county],
      references: [county.uid],
    }),
    jurisdiction: one(jurisdiction, {
      fields: [countyByJurisdiction.jurisdiction],
      references: [jurisdiction.uid],
    }),
    jurisdictionRace: one(jurisdictionRace, {
      fields: [countyByJurisdiction.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