import { Pool } from 'https://deno.land/x/pg@v0.6.1/mod.ts'import { serve } from 'https://deno.land/std@0.114.0/http/server.ts'import { Kysely, PostgresDialect, Generated, ColumnType, Selectable, Insertable, Updateable,} from 'https://esm.sh/kysely@0.23.4'console.log(`Function "kysely-postgres" up and running!`)interface AnimalTable { id: Generated<number> animal: string created_at: Date}// Keys of this interface are table names.interface Database { animal: AnimalTable}// You'd create one of these when you start your app.const db = new Kysely<Database>({ // Use MysqlDialect for MySQL and SqliteDialect for SQLite. dialect: new PostgresDialect({ // @ts-ignore pool: new Pool({ user: 'postgres', hostname: 'db.bljghubhkofddfrezkhn.supabase.co', database: 'postgres', password: Deno.env.get('DB_PASSWORD')!, port: 5432, }), }),})
import { Pool } from 'https://deno.land/x/pg@v0.6.1/mod.ts'import { serve } from 'https://deno.land/std@0.114.0/http/server.ts'import { Kysely, PostgresDialect, Generated, ColumnType, Selectable, Insertable, Updateable,} from 'https://esm.sh/kysely@0.23.4'console.log(`Function "kysely-postgres" up and running!`)interface AnimalTable { id: Generated<number> animal: string created_at: Date}// Keys of this interface are table names.interface Database { animal: AnimalTable}// You'd create one of these when you start your app.const db = new Kysely<Database>({ // Use MysqlDialect for MySQL and SqliteDialect for SQLite. dialect: new PostgresDialect({ // @ts-ignore pool: new Pool({ user: 'postgres', hostname: 'db.bljghubhkofddfrezkhn.supabase.co', database: 'postgres', password: Deno.env.get('DB_PASSWORD')!, port: 5432, }), }),})