import { schema } from "@db/index.js";
import { sql } from "drizzle-orm";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
export class Test {
public db: ReturnType<typeof drizzle<typeof schema>>;
public preparedStatement
constructor(client: Pool) {
this.db = drizzle(client, { schema });
this.preparedStatement = this.db
.query
.guildSettings
.findFirst({
where: (fields, { eq }) => eq(fields.guildId, sql.placeholder("id"))
})
.prepare("guild_settings")
}
}
import { schema } from "@db/index.js";
import { sql } from "drizzle-orm";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
export class Test {
public db: ReturnType<typeof drizzle<typeof schema>>;
public preparedStatement
constructor(client: Pool) {
this.db = drizzle(client, { schema });
this.preparedStatement = this.db
.query
.guildSettings
.findFirst({
where: (fields, { eq }) => eq(fields.guildId, sql.placeholder("id"))
})
.prepare("guild_settings")
}
}