office.ts

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

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

import { call } from './call.js';
import { candidateAbsenteeEstimate } from './candidateAbsenteeEstimate.js';
import { candidateElectoralVote } from './candidateElectoralVote.js';
import { candidatePriorEstimate } from './candidatePriorEstimate.js';
import { candidateRace_office } from './candidateRace_office.js';
import { candidateVote } from './candidateVote.js';
import { delegateAllocation } from './delegateAllocation.js';
import { electoralVote } from './electoralVote.js';
import { jurisdiction } from './jurisdiction.js';
import { officeBody } from './officeBody.js';
import { officeRace } from './officeRace.js';
import { officeVote } from './officeVote.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';
import { voteFlag } from './voteFlag.js';

export const office = schema.table('Office', {
  uid: varchar('office').primaryKey(),
  code: varchar('code').notNull(),
  name: varchar('name').notNull(),

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

export type NewOffice = typeof office.$inferInsert;

export const officeRelations = relations(office, ({ one, many }) => ({
  jurisdiction: one(jurisdiction, {
    fields: [office.jurisdiction],
    references: [jurisdiction.uid],
  }),
  officeBody: one(officeBody, {
    fields: [office.officeBody],
    references: [officeBody.uid],
  }),
  state: one(state, {
    fields: [office.state],
    references: [state.uid],
  }),
  calls: many(call),
  candidateAsenteeEstimates: many(candidateAbsenteeEstimate),
  candidateElectoralVotes: many(candidateElectoralVote),
  candidatePriorEstimates: many(candidatePriorEstimate),
  candidateRaces: many(candidateRace_office),
  candidateVotes: many(candidateVote),
  voteFlags: many(voteFlag),
  delegateAllocations: many(delegateAllocation),
  electoralVotes: many(electoralVote),
  officeRaces: many(officeRace),
  officeVotes: many(officeVote),
}));

[]

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

TypeScript coverage report