jurisdiction.ts

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

import { boolean, 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 { candidateVote } from './candidateVote.js';
import { countyByJurisdiction } from './countyByJurisdiction.js';
import { countyExpectedVote } from './countyExpectedVote.js';
import { delegateAllocation } from './delegateAllocation.js';
import { delegateDistrict } from './delegateDistrict.js';
import { editorialTurnout } from './editorialTurnout.js';
import { electoralVote } from './electoralVote.js';
import { jurisdictionPastRace } from './jurisdictionPastRace.js';
import { jurisdictionRace } from './jurisdictionRace.js';
import { jurisdictionType } from './jurisdictionType.js';
import { message } from './message.js';
import { office } from './office.js';
import { officeRace } from './officeRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';
import { totalExpectedVote } from './totalExpectedVote.js';
import { voteFlag } from './voteFlag.js';

export const jurisdiction = schema.table('Jurisdiction', {
  uid: varchar('uid').primaryKey(),
  code: integer('code').notNull(),
  name: varchar('name').notNull(),
  abbr: varchar('abbr').notNull(),
  isNational: boolean('isNational').notNull(),

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

export type NewJurisdiction = typeof jurisdiction.$inferInsert;

export const jurisdictionRelations = relations(
  jurisdiction,
  ({ one, many }) => ({
    jurisdictionType: one(jurisdictionType, {
      fields: [jurisdiction.jurisdictionType],
      references: [jurisdictionType.uid],
    }),
    state: one(state, {
      fields: [jurisdiction.state],
      references: [state.uid],
    }),
    calls: many(call),
    candidateAbsenteeEstimates: many(candidateAbsenteeEstimate),
    candidateElectoralVotes: many(candidateElectoralVote),
    candidatePriorEstimates: many(candidatePriorEstimate),
    candidateVotes: many(candidateVote),
    countyByJurisdictions: many(countyByJurisdiction),
    countyExpectedVotes: many(countyExpectedVote),
    voteFlags: many(voteFlag),
    delegateAllocations: many(delegateAllocation),
    delegateDistricts: many(delegateDistrict),
    editorialTurnouts: many(editorialTurnout),
    electoralVotes: many(electoralVote),
    jurisdictionPastRaces: many(jurisdictionPastRace),
    jurisdictionRaces: many(jurisdictionRace),
    messages: many(message),
    offices: many(office),
    officeRaces: many(officeRace),
    totalExpectedVotes: many(totalExpectedVote),
  })
);

[]

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

TypeScript coverage report