orchid-graphql

import { ApolloServer } from '@apollo/server'; import { startStandaloneServer } from '@apollo/server/standalone'; import gql from 'graphql-tag'; import * as r from 'orchid-graphql'; import { createBaseTable, orchidORM } from 'orchid-orm'; const BaseTable = createBaseTable(); class PostTable extends BaseTable { readonly table = 'post'; columns = this.setColumns(t => ({ id: t.identity().primaryKey(), text: t.text(0, 5000), })); } const db = orchidORM({ databaseURL: process.env.DATABASE_URL ?? '', log: true, }, { post: PostTable }); await db.$query` create table post ( id serial primary key, text text not null ); `; const typeDefs = gql` type Post { id: Int! text: String! } type Mutation { create_post(text: String!): Post! } type Query { posts: [Post!]! } `; const graph = r.graph({ Post: r.table(db.post) }); const resolvers = { Mutation: { async create_post(_parent: any, args: { text: string }, context: any, info: any) { const post = await db.post.create(args); return await graph.resolve(db.post.find(post.id), { context, info }); }, }, Query: { async posts(_parent: any, _args: any, context: any, info: any) { return await graph.resolve(db.post, { context, info }); }, }, }; const server = new ApolloServer({ typeDefs, resolvers }); const { url } = await startStandaloneServer(server, { listen: { port: 4000 } }); console.log(`Listening on ${url}`);