Design config options for mongo-knex

[kirrg001]

Problem

Projects want to use NQL and want to forward information about database tables, in particular database relations.

Goal

Design a config options which makes it possible to query the database based on this config object.
How do we pass the table information to mongo-knex?

Tasks

• look at how GQL did it (https://github.com/TryGhost/GQL/blob/master/lib/context.js)
• collect the information mongo-knex needs from the project
• post example design
• add code to receive the options
• change config keys to new format

[kirrg001]

NOTE: Expansions (previous aliases) are not forwarded to mongo-knex. Aliases are handled in nql-lang (see). They are handled in mongo-utils.

---

The design we need here is for passing the relations.

We currently use:

    relations: {
        [name-of-relation]: {
            tableName: String (e.g. tags)
            tableNameAs: String (e.g. t, optional)
            type: String (e.g. manyToMany)
            join_table: String (e.g.  posts_tags)
            join_from: String (e.g. post_id)
            join_to: String (e.g. tag_id)
        }

We should think about if this structure also works for other relation types.
We should think about if we like the variable names.

[naz]

The naming of variables should def be more consistent e.g.: tableNameAs an join_table. Preferable should stay camelCase as these are only used within JavaScript code :)