Angelelz Angelelz

Solving problems

Angelelz / getSubPriorityStatus.ts

Created December 4, 2025 13:15

Sub priority

	export const getSubPriorityStatus = (
	line: Omit<DailyWorkOrderResult, "followUpType">,
	) => {
	if (line.ivrStatus === "IN PROGRESS:ON SITE") {
	return "01. IVR ONSITE";
	}
	if (
	line.Status_of_Call !== "COMPLETE" &&
	line.Type_of_Problem === "EMERGENCY"
	) {

Angelelz / pg.test.ts

Created November 11, 2023 15:46

Initial RLS test passing in pg and postgres.js

	test.serial('transaction with RLS', async (t) => {
	const { db } = t.context;

	const users = pgTable('users_transactions', {
	id: serial('id').primaryKey(),
	name: text('name').notNull(),
	lastName: text('lastname'),
	});

	await db.execute(sql`drop table if exists ${users}`);

Angelelz / repository.ts

Created November 2, 2023 03:11

Quick example on how some kind of repository pattern can be implemented for Drizzle

	import { MySqlTable } from "drizzle-orm/mysql-core";
	import { db as drizzleDb } from "./mysql/mysql2";
	import { eq } from "drizzle-orm";
	import { users } from "./mysql/schema";

	interface Reader<T extends MySqlTable & { id: any }> {
	findAll(): Promise<T["$inferSelect"][]>;
	findOne(id: number): Promise<T["$inferSelect"] \| undefined>;
	}