partyByOffice.ts

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

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

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

export const partyByOffice = schema.table('PartyByOffice', {
  uid: varchar('uid').primaryKey(),
  /**
   * @TODO Why wouldn't this be an FK to office?
   */
  officeCode: varchar('officeCode').notNull(),
  isNational: boolean('isNational').notNull(),
  incumbents: integer('incumbents').notNull(),
  holdovers: integer('holdovers').notNull(),
  uncontested: integer('uncontested').notNull(),

  state: integer('state').references(() => state.uid, { onDelete: 'cascade' }),
  party: varchar('party')
    .notNull()
    .references(() => party.uid, { onDelete: 'cascade' }),
  officeBody: varchar('officeBody').references(() => officeBody.uid, {
    onDelete: 'cascade',
  }),
});

export type NewPartyByOffice = typeof partyByOffice.$inferInsert;

export const partyByOfficeRelations = relations(partyByOffice, ({ one }) => ({
  state: one(state, {
    fields: [partyByOffice.state],
    references: [state.uid],
  }),
  party: one(party, {
    fields: [partyByOffice.party],
    references: [party.uid],
  }),
  officeBody: one(officeBody, {
    fields: [partyByOffice.officeBody],
    references: [officeBody.uid],
  }),
}));

[]

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

TypeScript coverage report