Skip to content

Instantly share code, notes, and snippets.

View Angelelz's full-sized avatar

Angelelz Angelelz

View GitHub Profile
@Angelelz
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
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>;
}