// pages/api/graphql/index.ts
import { NextApiRequest, NextApiResponse } from 'next';
import { createSchema } from './services/graphql/schema';
import { createYoga } from 'graphql-yoga';

export default createYoga<{
    req: NextApiRequest;
    res: NextApiResponse;
}>({
    graphqlEndpoint: '/api/graphql/',
    graphiql: { title: 'My GraphQL Playground' },
    batching: true,
    schema: await createSchema(),
});

// services/graphql/schema.ts
import { generateDBSchema } from 'pgql';
import { makeSchema } from 'nexus';

export async function createSchema() {
    const credentials = {};

    const dbSchema = await generateDBSchema(credentials, {
        schemas: [
            {
                name: 'website',
                tables: [
                    {
                        name: 'user',
                        operations: ['READ'],
                        defaultWhere: `id IS NOT NULL`,
                        cols: ['id', 'name', 'email'],
                    },
                    { name: 'payment', operations: ['CREATE', 'READ', 'UPDATE', 'DELETE'] },
                ],
                views: [{ name: 'payments_per_user', operations: ['READ'] }],
            },
        ],
        generateForeignTables: true,
    });

    const types = await generateSchema(credentials, dbSchema);

    return makeSchema({
        types,
    });
}