// Follow this setup guide to integrate the Deno language server with your editor:
// https://deno.land/manual/getting_started/setup_your_environment
// This enables autocomplete, go to definition, etc.
import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';
import { user } from '../_shared/schema';
import process from "node:process";
import express from 'express';
require('dotenv').config();
const app = express();
app.use(express.json());
// const connectionString = process.env.DATABASE_URL;
const connectionString = "[url to postgres pooling connection]";
// Disable prefetch as it is not supported for "Transaction" pool mode
const client = postgres(connectionString, { prepare: false })
const db = drizzle(client);
// show all users
app.get('/users', async (req, res) => {
try {
const allUsers = await db.select().from(user);
res.json(allUsers);
} catch (error) {
res.status(500).json({ error: error.message });
}
});
app.get('/', (req, res) => {
res.json({ message: 'Hello World!' });
} );
// Follow this setup guide to integrate the Deno language server with your editor:
// https://deno.land/manual/getting_started/setup_your_environment
// This enables autocomplete, go to definition, etc.
import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';
import { user } from '../_shared/schema';
import process from "node:process";
import express from 'express';
require('dotenv').config();
const app = express();
app.use(express.json());
// const connectionString = process.env.DATABASE_URL;
const connectionString = "[url to postgres pooling connection]";
// Disable prefetch as it is not supported for "Transaction" pool mode
const client = postgres(connectionString, { prepare: false })
const db = drizzle(client);
// show all users
app.get('/users', async (req, res) => {
try {
const allUsers = await db.select().from(user);
res.json(allUsers);
} catch (error) {
res.status(500).json({ error: error.message });
}
});
app.get('/', (req, res) => {
res.json({ message: 'Hello World!' });
} );
