call.ts

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

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

import { candidate } from './candidate.js';
import { electionType } from './electionType.js';
import { jurisdiction } from './jurisdiction.js';
import { office } from './office.js';
import { officeBody } from './officeBody.js';
import { officeRace } from './officeRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';

export const call = schema.table('Call', {
  uid: varchar('uid').primaryKey(),
  status: varchar('status').notNull(),
  description: varchar('description').notNull(),
  winnerIsCalled: boolean('winnerIsCalled').notNull(),
  /**
   * @TODO - Jon, I fixed this to allow nulls as this field is either boolean or null.
   *
   * isEmbargoed: { [Op.or]: [false, null] }, // Runoff calls have isEmbargoed: null, so get any calls that are NOT emgargoed by getting both isEmbargoed:false & isEmbargoed:null.
   * */
  isEmbargoed: boolean('isEmbargoed'),
  percentStatus: varchar('percentStatus'),
  transmissionSource: varchar('transmissionSource').notNull(),
  timestamp: timestamp('timestamp').notNull(),
  specialElection: boolean('specialElection').notNull(),

  leadingCandidate: integer('leadingCandidate').references(() => candidate.uid),
  electionType: varchar('electionType')
    .notNull()
    .references(() => electionType.uid),
  jurisdiction: varchar('jurisdiction')
    .notNull()
    .references(() => jurisdiction.uid),
  office: varchar('office')
    .notNull()
    .references(() => office.uid),
  officeBody: varchar('officeBody').references(() => officeBody.uid),
  officeRace: varchar('officeRace')
    .notNull()
    .references(() => officeRace.uid),
  state: integer('state')
    .notNull()
    .references(() => state.uid),
});

export type NewCall = typeof call.$inferInsert;

export const callRelations = relations(call, ({ one }) => ({
  leadingCandidate: one(candidate, {
    fields: [call.leadingCandidate],
    references: [candidate.uid],
  }),
  electionType: one(electionType, {
    fields: [call.electionType],
    references: [electionType.uid],
  }),
  jurisdiction: one(jurisdiction, {
    fields: [call.jurisdiction],
    references: [jurisdiction.uid],
  }),
  office: one(office, {
    fields: [call.office],
    references: [office.uid],
  }),
  officeBody: one(officeBody, {
    fields: [call.officeBody],
    references: [officeBody.uid],
  }),
  officeRace: one(officeRace, {
    fields: [call.officeRace],
    references: [officeRace.uid],
  }),
  state: one(state, {
    fields: [call.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