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,
}),
}),
})