candidateAbsenteeEstimate.ts

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

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

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

export const candidateAbsenteeEstimate = schema.table(
  'CandidateAbsenteeEstimate',
  {
    uid: varchar('uid').primaryKey(),
    value: real('value').notNull(),
    stdErrDiff: real('stdErrDiff').notNull(),
    stdErr: real('stdErr').notNull(),
    shift: real('shift').notNull(),

    candidate: integer('candidate')
      .notNull()
      .references(() => candidate.uid),
    candidateRace: varchar('candidateRace')
      .notNull()
      .references(() => candidateRace.uid),
    jurisdiction: varchar('jurisdiction')
      .notNull()
      .references(() => jurisdiction.uid),
    office: varchar('office')
      .notNull()
      .references(() => office.uid),
    officeRace: varchar('officeRace')
      .notNull()
      .references(() => officeRace.uid),
  }
);

export type NewCandidateAbsenteeEstimate =
  typeof candidateAbsenteeEstimate.$inferInsert;

export const candidateAbsenteeEstimateRelations = relations(
  candidateAbsenteeEstimate,
  ({ one }) => ({
    candidate: one(candidate, {
      fields: [candidateAbsenteeEstimate.candidate],
      references: [candidate.uid],
    }),
    candidateRace: one(candidateRace, {
      fields: [candidateAbsenteeEstimate.candidateRace],
      references: [candidateRace.uid],
    }),
    jurisdiction: one(jurisdiction, {
      fields: [candidateAbsenteeEstimate.jurisdiction],
      references: [jurisdiction.uid],
    }),
    office: one(office, {
      fields: [candidateAbsenteeEstimate.office],
      references: [office.uid],
    }),
    officeRace: one(officeRace, {
      fields: [candidateAbsenteeEstimate.officeRace],
      references: [officeRace.uid],
    }),
  })
);

[]

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

TypeScript coverage report