schemats

import { Client } from 'pg'; import * as path from 'path'; import { execSync } from 'child_process'; // 1. Ensure schemats is installed globally or accessible via npx // npm install -g schemats const dbUrl = 'postgres://postgres:password@localhost:5432/mytestdb'; const outputFile = path.join(process.cwd(), 'db-types.ts'); async function setupAndGenerate() { // For demonstration, ensure a test database exists const client = new Client({ connectionString: 'postgres://postgres:password@localhost:5432/postgres' }); try { await client.connect(); await client.query(`DROP DATABASE IF EXISTS mytestdb;`); await client.query(`CREATE DATABASE mytestdb;`); await client.end(); const testClient = new Client({ connectionString: dbUrl }); await testClient.connect(); await testClient.query(` CREATE TABLE IF NOT EXISTS users ( id SERIAL PRIMARY KEY, username VARCHAR(255) NOT NULL UNIQUE, email VARCHAR(255) NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS products ( product_id UUID DEFAULT gen_random_uuid() PRIMARY KEY, name VARCHAR(255) NOT NULL, price NUMERIC(10, 2) NOT NULL ); `); await testClient.end(); console.log('Database and tables created. Generating types...'); // 2. Generate TypeScript interfaces from the schema // Using npx for local schemats binary or if not globally installed const command = `npx schemats generate -c "${dbUrl}" -s public -o "${outputFile}"`; execSync(command, { stdio: 'inherit' }); console.log(` Generated TypeScript types to ${outputFile}: `); // 3. Demonstrate usage of generated types // (In a real app, you'd import generated types from outputFile) // For this example, we'll simulate the types: interface Users { id: number; username: string; email: string; created_at: Date; } interface Products { product_id: string; // UUIDs often map to strings in TS name: string; price: string; // NUMERIC can be string or number, safer as string without specific parser } const exampleUser: Users = { id: 1, username: 'testuser', email: 'test@example.com', created_at: new Date() }; const exampleProduct: Products = { product_id: 'a1b2c3d4-e5f6-7890-1234-567890abcdef', name: 'Example Item', price: '99.99' }; console.log('Example user with generated type:', exampleUser); console.log('Example product with generated type:', exampleProduct); } catch (error) { console.error('Error during setup or generation:', error); process.exit(1); } } setupAndGenerate();