Got error with mysql and mariadb about join-monster HOT 3 CLOSED

I added a MySQL/MariaDB dialect.

To use it you must pass joinMonster an options Object with a 'dialect' property set to 'mysql'. See the API docs for details.

I don't know which library you are using to connect to your database. If you are using knex, there is one thing you should watch out for. knex.raw returns different objects based on the knex dialect being used. It may not work with the exact code from the docs. Just double check the shape of that object before returning it from the callback. You may have to change this...

return joinMonster(resolveInfo, {}, sql => {
    return knex.raw(sql)
})

... to something like this...

return joinMonster(resolveInfo, {}, sql => {
    return knex.raw(sql).then(result => result[0])
}, { dialect: 'mysql' })

Please let me know if this works. If so, the issue can be closed.

from join-monster.

I see. The problem is the different meaning of double quotes in MySQL/MariaDB.

In SQLite3 and Postgres, which is what Join Monster is tested on, double quotes are used around an identifier to escape certain characters, like whitespace and capital letters. However, MySQL uses double quotes for a string literal. For MySQL, backticks should be used instead.

This means a new dialect will need to be introduced for MySQL/MariaDB. It's a simple fix and I can get around to it in a few days.

from join-monster.

Works perfectly!

from join-monster.