How can we handle Date in graphql and sequelize?

[jvbianchi]

No description provided.

[mickhansen]

However you like really.

[jvbianchi]

I end up using this solution graphql/graphql-js#497

Thanks

[jedwards1211]

@mickhansen seems to me this package should be using custom scalars for dates and timestamps. Would you accept a PR for that? It would be a breaking change...

[jedwards1211]

At the very least I'm surprised that graphql-sequelize doesn't return dates as ISO 8601 strings.

[jedwards1211]

@mickhansen also considering that this package provides its own JSON scalar type, it's kind of odd that it doesn't provide types for all sequelize DateTypes.

[intellix]

We have this:

import { GraphQLScalarType, Kind } from 'graphql';

export const DateType = new GraphQLScalarType({
  name: 'Date',
  parseLiteral(ast) {
    if (ast.kind === Kind.INT) {
      return parseInt(ast.value, 10);
    }
    return null;
  },
  parseValue(value: string): Date {
    return new Date(value);
  },
  serialize(value: string | Date): string {
    return typeof value === 'string' ? value : value.toISOString();
  },
});

// ISO Dates for all Sequelize.Date fields
typeMapper.mapType(type => (type instanceof Sequelize.DATE ? DateType : false));

Don't remember where we got it, but the output is basically:

"user": {
  "createdAt": "2018-04-16T22:04:31.000Z"
}

Might be worth shoving into this library as SequelizeDate and automatically handling it. Don't think I can think of any reason to serialise a Sequelize.DATE into anything but an ISO String as it's supported in all browsers with new Date(user.createdAt).

[mickhansen]

GraphQL is handling the serialization at the moment, that seems consistent to me.