message.ts

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

import { integer, text, 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';

export const message = schema.table('Message', {
  uid: varchar('uid').primaryKey(),
  content: text('content').notNull(),
  type: varchar('type').notNull(),
  priority: integer('priority').notNull(),
  securityLevel: integer('securityLevel').notNull(),
  transmissionSource: varchar('transmissionSource').notNull(),
  timestamp: timestamp('timestamp').notNull(),

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

export type NewMessage = typeof message.$inferInsert;

export const messageRelations = relations(message, ({ one }) => ({
  jurisdiction: one(jurisdiction, {
    fields: [message.jurisdiction],
    references: [jurisdiction.uid],
  }),
  jurisdictionRace: one(jurisdictionRace, {
    fields: [message.jurisdictionRace],
    references: [jurisdictionRace.uid],
  }),
  state: one(state, {
    fields: [message.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