graphQL with Sequelize and Mysql duplicate field in relation

Question

https://www.graphqlbin.com/v2/gLg9FP

I am stuck with this problem for a day now and need somebody help. I have 2 sequelize models

      module.exports = (sequelize, DataTypes) => {
            const Periodo = sequelize.define('periodo', {
...
                    cod_casa: {
                        type: DataTypes.INTEGER(11),
                        allowNull: false,
                        field: 'cod_casa'
                    },
                   ....
                },
     ...
            );

            Periodo.associate = (models) => {
                Periodo.belongsTo(models.casa);
            };

            return Periodo;
        }

and

  const Casa = sequelize.define('casa', {
                cod_casa: {
                    type: DataTypes.INTEGER(11),
                    allowNull: false,
                    primaryKey: true,
                    autoIncrement: true,
                    field: 'cod_casa'
                },

.....
    Casa.associate = (models) => {
        Casa.hasMany(models.periodo);
    };

    return Casa;
}

But graphQl always return an error :

"extensions": { "code": "INTERNAL_SERVER_ERROR", "exception": { "name": "SequelizeDatabaseError", "parent": { "code": "ER_BAD_FIELD_ERROR", "errno": 1054, "sqlState": "42S22", "sqlMessage": "Unknown column 'casaCodCasa' in 'field list'", "sql": "SELECT id, cod_casa, inicio, fim, preco_semana AS precoSemana, preco_dia AS precoDia, preco_fimsemana AS precoFimsemana, estadia_minima AS estadiaMinima, descricao, observacoes, createdAt, updatedAt, casaCodCasa FROM periodo AS periodo WHERE periodo.casaCodCasa = 23;" },

The problem seems to be in relation definition. I also have the resolvers and graphQL schema well defined. Anybody been trougth someting like this? Thanks in advance.

Vivek Doshi · Accepted Answer · 2018-11-14 17:14:39Z

1

You need to define foreign key custom as you are not using default primary key as id

Periodo.belongsTo(models.casa,{foreignKey: 'cod_casa'}); // <--- HERE

As per the DOC :

const User = this.sequelize.define('user', {/* attributes */})
const Company  = this.sequelize.define('company', {/* attributes */});

User.belongsTo(Company); // Will add companyId to user

const User = this.sequelize.define('user', {/* attributes */}, {underscored: true})
const Company  = this.sequelize.define('company', {
  uuid: {
    type: Sequelize.UUID,
    primaryKey: true
  }
});

User.belongsTo(Company); // <----- Will add company_uuid to user

NOTE : User.belongsTo(Company); // <----- Will add company_uuid to user , so in your case its casaCodCasa

answered Nov 14, 2018 at 17:14

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Leonel Matias Domingos Over a year ago

I am using primary key const Periodo = sequelize.define('periodo', { id: { type: DataTypes.INTEGER(11), allowNull: false, primaryKey: true, autoIncrement: true, field: 'id' }, cod_casa: { type: DataTypes.INTEGER(11), allowNull: false, field: 'cod_casa' },

Vivek Doshi Over a year ago

Yes but not in casa table, that's why just change the line as I have suggested and run your code.

Leonel Matias Domingos Over a year ago

i ve changed the line ... no effect at all. Maybe problem is because primary key of Casa have same name foreign key of Periodo?

Leonel Matias Domingos Over a year ago

cannot share localhost

Leonel Matias Domingos Over a year ago

if i use query { periodos { casaid } }

|

Leonel Matias Domingos · Accepted Answer · 2018-11-15 03:01:11Z

0

Fix consists of o custom foreign key option in both definition of the relation /association ex:

Periodo.associate = (models) => {
        Periodo.belongsTo(models.casa,**{foreignKey: 'cod_casa'}**);
    };

and

Casa.associate = (models) => {
        Casa.hasMany(models.periodo,**{ foreignKey: 'cod_casa' }**);
        Casa.hasMany(models.feedback,{ foreignKey: 'cod_casa' });
    };

as @Vivek Doshi saind but for both models.

answered Nov 15, 2018 at 3:01

Leonel Matias Domingos

2,1166 gold badges36 silver badges54 bronze badges

Collectives™ on Stack Overflow

graphQL with Sequelize and Mysql duplicate field in relation

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related