editorialTurnout.ts

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

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

import { jurisdiction } from './jurisdiction.js';
import { jurisdictionRace } from './jurisdictionRace.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { state } from './state.js';
import { state_electionType } from './state_electionType.js';

export const editorialTurnout = schema.table('EditorialTurnout', {
  uid: varchar('uid').primaryKey(),
  transmissionSource: varchar('transmissionSource'),
  timestamp: timestamp('timestamp').notNull(),
  isEditorial: boolean('isEditorial'),
  percentAbsentee: real('percentAbsentee'),
  timeOfApproval: timestamp('timeOfApproval'),
  totalExpectedAbsenteeVote: bigint('totalExpectedAbsenteeVote', {
    mode: 'number',
  }),
  totalExpectedEarlyByMailVote: bigint('totalExpectedEarlyByMailVote', {
    mode: 'number',
  }),
  totalExpectedEarlyInPersonVote: bigint('totalExpectedEarlyInPersonVote', {
    mode: 'number',
  }),
  totalExpectedElectionDayVote: bigint('totalExpectedElectionDayVote', {
    mode: 'number',
  }),
  totalExpectedVote: bigint('totalExpectedVote', { mode: 'number' }),
  votingAgeTurnoutOutOf100: integer('votingAgeTurnoutOutOf100'),
  eligibleTurnoutOutOf100: integer('eligibleTurnoutOutOf100'),

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

export type NewEditorialTurnout = typeof editorialTurnout.$inferInsert;

export const editorialTurnoutRelations = relations(
  editorialTurnout,
  ({ one }) => ({
    jurisdiction: one(jurisdiction, {
      fields: [editorialTurnout.jurisdiction],
      references: [jurisdiction.uid],
    }),
    jurisdictionRace: one(jurisdictionRace, {
      fields: [editorialTurnout.jurisdictionRace],
      references: [jurisdictionRace.uid],
    }),
    state: one(state, {
      fields: [editorialTurnout.state],
      references: [state.uid],
    }),
    state_electionType: one(state_electionType, {
      fields: [editorialTurnout.state_electionType],
      references: [state_electionType.uid],
    }),
  })
);

[]

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

TypeScript coverage report