首页 > 解决方案 > 左连接只是使用连接怪物获取数据的一种方法吗?

问题描述

const QueryRoot = new GraphQLObjectType({
  name: 'Query',
  fields: () => ({
    getContentDetails: {
      type: new GraphQLList(Films),
      args: {
        id: {
          type: GraphQLInt
        },
        permalink: {
            type: GraphQLString
        },
        studio_id: {
            type: GraphQLString
        },
        content_types_id: {
            type: GraphQLString
        }
      },

      where: (filmTable, args, context) => {
            return ` ${filmTable}.permalink = "${args.permalink}" and ${filmTable}.content_types_id = "${args.content_types_id}"`
          },

      resolve: (parent, args, context, resolveInfo) => {
        return joinMonster.default(resolveInfo, {}, sql => {

            return FilmDb.query(sql).then(function(result) {

                return result[0];
              });

        },{dialect: 'mysql'});
      }
    }
  })
})

标签: graphql

解决方案


推荐阅读