GraphQL Guru Sequelize

Sequelize database resolver modules for GraphQL Guru.

It supports the dialects PostgreSQL, MySQL, SQLite and MSSQL

Installation

1. In a terminal run npm install graphql-guru-sequelize

2. In environment.js add the path to the json storage file and optionally add defaults to seed the database on creation.

   server/environment.js

    database: {
      sequelize: {
        username: 'username',
        databases: 'database',
        port: '5432',
        dialect: 'sqlite', // one of 'mysql'|'sqlite'|'postgres'|'mssql',
        host: 'localhost',
        pool: {
          max: 5,
          min: 0,
          idle: 10000
        }
      },
      // SQLite only
      storage: 'path/to/sqlite/database'
    }

3. In index-database.js import graphql-guru-sequelize and add it to the database object.

   server/core/database/index-database.js

    import * as sequelize from 'graphql-guru-sequelize';

    export const databases = {
      sequelize
    };

4. extend resolverQuery and resolverMutation with SequelizeQuery and SequelizeMutation respectively.

   server/modules/resolverQuery.js

   import { SequelizeQuery } from 'graphql-guru-sequelize';
   
   export default class People extends SequelizeQuery {
   }

   server/modules/resolverMutation.js

   import { SequelizeMutation } from 'graphql-guru-sequelize';
   
   export default class People extends SequelizeMutation {
   }

5. Add the methods to your schema files

server/modules/schemaQuery.js

peopleResolve(id: String): People
peopleFindAll(id: String): [People]
peopleFindById(id: String): People
peopleFindManyById(id: [String]): [People]

server/modules/schemaMutation.js

# Add description
peopleCreate(
  firstName: String,
  lastName:  String
): People

# Add description
peopleRemove (
  id: String
): People

# Add description
peopleUpdate(
  id:        String,
  firstName: String,
  lastName:  String
): People

Usage

Once all the installation steps are complete you're go to go.

You can overwrite the methods with your own or add new methods inside the resolvers.

Database methods

For database usage see [sequelizejs.com]http://docs.sequelizejs.com/

License

MIT