Skip to content

Automate the process of creating Hasura metadata, making it easier to manage complex database schemas and permissions when using Hasura with TypeORM

License

Notifications You must be signed in to change notification settings

utyfua/typeorm-hasura

Repository files navigation

typeorm-hasura

typeorm-hasura is a JavaScript library that generates Hasura metadata from TypeORM entities.

This library is designed to automate the process of creating Hasura metadata, making it easier to manage complex database schemas and permissions when using Hasura with TypeORM.

Features

  • Generate Hasura metadata from TypeORM entities
  • Define permissions for each entity and column
  • Add custom actions and inherited roles
  • Automatic handling of relationships between entities

Warning

The library does not support ManyToMany relationships.

Note

The library was tested with Hasura v2 and TypeORM v0.3 with PostgreSQL only.

Installation

npm install typeorm-hasura

or

yarn add typeorm-hasura

Usage

See the our developer playground for a complete example.

Here's a step-by-step guide on how to use typeorm-hasura:

  1. Create a script file (e.g., hasura.ts) and import the required modules:

    // hasura.ts
    import { MetadataBuilder } from "typeorm-hasura";
    import { currencyConverterAction } from "./action/currencyConverter";
    import { AppDataSource } from "./data-source"
    import { writeFile, mkdir } from "fs/promises"
  2. Define an asynchronous function (e.g., convert) to generate metadata using the MetadataBuilder:

    async function convert() {
        const generator = new MetadataBuilder()
            .addSource({
                name: "public",
                dataSource: AppDataSource,
                databaseUrl: process.env.HASURA_DATABASE_URL,
            })
            .addActions([
                currencyConverterAction,
            ])
            .addInheritedRoles({
                testUser: ["admin","editor"]
            })
    
        // make an action with the result of the generator(see below)
    }

    [!IMPORTANT]
    ⚠️ databaseUrl should refer to the database that Hasura will use to connect to the database from inside the container of Hasura.

    You can omit databaseUrl if you are using the same database for Hasura and TypeORM.

  3. Save metadata:

    a. Save metadata to a file:

    // generate metadata
    const metadata = await generator.getMetadata()
    // save metadata to a file
    await mkdir("metadata", { recursive: true });
    await writeFile("metadata/metadata.json", JSON.stringify(metadata, null, 2));

    b. Save metadata to Hasura:

    // generate metadata and apply it to Hasura using the Hasura API
    const result = await generator.applyMetadata({ 
        // example: https://example.com
        // please do not put /v1/graphql at the end of the url
        hasuraUrl: process.env.HASURA_URL,
        adminSecret : process.env.HASURA_GRAPHQL_ADMIN_SECRET
    })
    console.log(result)
  4. Call the convert function after initializing the AppDataSource:

    Make sure to call the initialize method of the AppDataSource before calling the convert function:

    AppDataSource.initialize()
        .then(convert)
        .catch(error => console.log(error))
  5. Define your TypeORM entities and use the @HasuraEntity and @HasuraColumn decorators to add Hasura metadata:

    // entity/Org.ts
    import {
        Entity,
        PrimaryGeneratedColumn,
        Column,
        OneToMany,
        BaseEntity
    } from 'typeorm';
    import { HasuraEntity, HasuraColumn } from 'typeorm-hasura';
    import { Product } from './Product';
    import { User } from './User';
    import { UserRole } from '../UserRole';
    
    @Entity({ schema: 'public', name: 'Org' })
    @HasuraEntity<Org>({
        customName: 'Org',
        permissions: {
            [UserRole.user]: {
                where: {
                    users: {
                        id: 'X-Hasura-User-Id'
                    }
                },
                select: true,
                update: true,
            }
        },
    })
    export class Org extends BaseEntity {
        @PrimaryGeneratedColumn('uuid')
        @HasuraColumn({
            permissions: {
                [UserRole.user]: ['select']
            }
        })
        id!: string;
    
        // ...
    }
  6. Now, you can use typeorm-hasura to automatically generate Hasura metadata for your TypeORM entities.

Contributing

We appreciate your help in improving the "typeorm-hasura" library.

License

typeorm-hasura is released under the MIT License.

About

Automate the process of creating Hasura metadata, making it easier to manage complex database schemas and permissions when using Hasura with TypeORM

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published