delegateDistrict.ts

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

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

import { delegateDistrictCounty } from './delegateDistrictCounty.js';
import { delegateDistrictType } from './delegateDistrictType.js';
import { electionType } from './electionType.js';
import { jurisdiction } from './jurisdiction.js';
import { presidentialPrimaryDistrictVoteByCounty } from './presidentialPrimaryDistrictVoteByCounty.js';
import { presidentialPrimaryVoteByDistrict } from './presidentialPrimaryVoteByDistrict.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';

export const delegateDistrict = schema.table('DelegateDistrict', {
  uid: varchar('uid').primaryKey(),
  id: integer('id').notNull(),
  name: varchar('name').notNull(),
  /**
   * @TODO - Check if we can add .notNull() in 2024 data. Probably wrong key name in 2020. */
  abbr: varchar('abbr'),
  isStatewide: boolean('isStatewide').notNull(),
  totalDelegates: integer('totalDelegates').notNull(),
  totalPrecincts: integer('totalPrecincts').notNull(),

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

export type NewDelegateDistrict = typeof delegateDistrict.$inferInsert;

export const delegateDistrictRelations = relations(
  delegateDistrict,
  ({ one, many }) => ({
    delegateDistrictCounties: many(delegateDistrictCounty),
    delegateDistrictType: one(delegateDistrictType, {
      fields: [delegateDistrict.delegateDistrictType],
      references: [delegateDistrictType.uid],
    }),
    electionType: one(electionType, {
      fields: [delegateDistrict.electionType],
      references: [electionType.uid],
    }),
    jurisdiction: one(jurisdiction, {
      fields: [delegateDistrict.jurisdiction],
      references: [jurisdiction.uid],
    }),
    presidentialPrimaryDistrictVoteByCounties: many(
      presidentialPrimaryDistrictVoteByCounty
    ),
    presidentialPrimaryVoteByDistricts: many(presidentialPrimaryVoteByDistrict),
    state: one(state, {
      fields: [delegateDistrict.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