state.ts

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

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

import { call } from './call.js';
import { candidateElectoralVote } from './candidateElectoralVote.js';
import { candidateVote } from './candidateVote.js';
import { county } from './county.js';
import { countyDemographic } from './countyDemographic.js';
import { countyExpectedVoteStratum } from './countyExpectedVoteStratum.js';
import { countyGeoStratum } from './countyGeoStratum.js';
import { countyPartyStratum } from './countyPartyStratum.js';
import { countyRegisteredVotersByParty } from './countyRegisteredVotersByParty.js';
import { delegateAllocation } from './delegateAllocation.js';
import { delegateDistrict } from './delegateDistrict.js';
import { delegateDistrictType } from './delegateDistrictType.js';
import { editorialTurnout } from './editorialTurnout.js';
import { electoralVote } from './electoralVote.js';
import { jurisdiction } from './jurisdiction.js';
import { jurisdictionRace } from './jurisdictionRace.js';
import { message } from './message.js';
import { office } from './office.js';
import { officeRace } from './officeRace.js';
import { partyByOffice } from './partyByOffice.js';
import { pastCandidateVote } from './pastCandidateVote.js';
import { pastCandidateVoteByCounty } from './pastCandidateVoteByCounty.js';
import { pastCountyVote } from './pastCountyVote.js';
import { presidentialPrimaryDistrictVoteByCounty } from './presidentialPrimaryDistrictVoteByCounty.js';
import { presidentialPrimaryVoteByDistrict } from './presidentialPrimaryVoteByDistrict.js';
import { relations } from 'drizzle-orm';
import { schema } from './schema.js';
import { stateExpectedVote } from './stateExpectedVote.js';
import { state_electionType } from './state_electionType.js';
import { totalExpectedVote } from './totalExpectedVote.js';
import { voteFlag } from './voteFlag.js';

export const state = schema.table('State', {
  uid: integer('uid').primaryKey(),
  code: integer('code').notNull(),
  fips: varchar('fips').notNull(),
  name: varchar('name').notNull(),
  apAbbr: varchar('apAbbr'),
  postalAbbr: varchar('postalAbbr'),
  numCounties: integer('numCounties'),
  numPseudoCounties: integer('numPseudoCounties'),
  pseudoState: boolean('pseudoState').notNull(),
});

export type NewState = typeof state.$inferInsert;

export const stateRelations = relations(state, ({ many }) => ({
  calls: many(call),
  candidateElectoralVotes: many(candidateElectoralVote),
  candidateVotes: many(candidateVote),
  counties: many(county),
  countyDemographics: many(countyDemographic),
  countyExpectedVoteStrata: many(countyExpectedVoteStratum),
  countyGeoStrata: many(countyGeoStratum),
  countyPartyStrata: many(countyPartyStratum),
  countyRegisteredVotersByParties: many(countyRegisteredVotersByParty),
  voteFlags: many(voteFlag),
  delegateAllocations: many(delegateAllocation),
  delegateDistricts: many(delegateDistrict),
  delegateDistrictTypes: many(delegateDistrictType),
  editorialTurnouts: many(editorialTurnout),
  electoralVotes: many(electoralVote),
  jurisdictions: many(jurisdiction),
  jurisdictionRaces: many(jurisdictionRace),
  messages: many(message),
  offices: many(office),
  officeRaces: many(officeRace),
  partyByOffices: many(partyByOffice),
  pastCandidateVotes: many(pastCandidateVote),
  pastCandidateVoteByCounties: many(pastCandidateVoteByCounty),
  pastCountyVotes: many(pastCountyVote),
  presidentialPrimaryDistrictVoteByCounties: many(
    presidentialPrimaryDistrictVoteByCounty
  ),
  presidentialPrimaryVoteByDistricts: many(presidentialPrimaryVoteByDistrict),
  state_electionTypes: many(state_electionType),
  stateExpectedVotes: many(stateExpectedVote),
  totalExpectedVotes: many(totalExpectedVote),
}));

[]

TypeScript coverage report