discoverSchema problems

[jmls]

Using the discoverSchema api on a postgres database has a couple of issues

1. relations: true does not work in the options object. You have to use associations: true instead
2. association discovery only seems to work with belongsTo relations. The associated hasMany is not generated.

if my db has

Artist has a pk of ArtistID
Album has a fk of ArtistID

then I get

"relations": { "artist": { "model": "Artist", "type": "belongsTo", "foreignKey": "artistid" }

in my Album model, but

``relations: {}` in my Artist model

[jmls]

fwiw, the discoverExportedForeignKeys function seems to return some data from my db :

[rmartins90]

+1

[jmls]

anyone ? Been over a year .. surely someone else has hit this problem ?

[superkhau]

Apparently not, @jmls would you like to submit a patch?

[ssh24]

@jmls Have you tried using the discoverSchemas function? It returns multiple schemas of which the models are related.

Here is a sample code snippet:

I want to discover the schemas of table Author and Book.

Here is what it looks like in the database:

testdb=# \d Book;
      Table "public.book"
  Column  |  Type   | Modifiers
----------+---------+-----------
 bid      | integer | not null
 name     | text    |
 isbn     | text    |
 authorid | integer | not null
Indexes:
    "book_pkey" PRIMARY KEY, btree (bid, authorid)
Foreign-key constraints:
    "book_author_author_id_fkey" FOREIGN KEY (authorid) REFERENCES author(aid)

testdb=# \d Author;
                                    Table "public.author"
 Column |            Type             |                      Modifiers
--------+-----------------------------+------------------------------------------------------
 aid    | integer                     | not null default nextval('author_aid_seq'::regclass)
 name   | text                        |
 dob    | timestamp without time zone |
Indexes:
    "author_pkey" PRIMARY KEY, btree (aid)
Referenced by:
    TABLE "book" CONSTRAINT "book_author_author_id_fkey" FOREIGN KEY (authorid) REFERENCES author(aid)

boot-script.js

'use strict';
var util = require('util');
var _ = require('lodash');

module.exports = function(app) {
    var db = app.datasources.postgresqlDs;

    db.discoverSchemas('book', {schema: 'public', relations: true}, function(err, result) {
        if (err) throw err;
        console.log('\nDiscovered schemas for `Author` and `Book` table: ' + util.inspect(result, {depth:4}));
    });
};

output

sakibs-mac:postgresql-65 ssh$ node .
Web server listening at: http://0.0.0.0:3000
Browse your REST API at http://0.0.0.0:3000/explorer

Discovered schemas for `Author` and `Book` table: { 'public.book': 
   { name: 'Book',
     options: 
      { idInjection: false,
        postgresql: { schema: 'public', table: 'book' },
        relations: { bookAuthorAuthorIdFkeyrel: { model: 'Author', type: 'belongsTo', foreignKey: 'authorid' } } },
     properties: 
      { bid: 
         { type: 'Number',
           required: true,
           length: null,
           precision: 32,
           scale: 0,
           id: 1,
           postgresql: 
            { columnName: 'bid',
              dataType: 'integer',
              dataLength: null,
              dataPrecision: 32,
              dataScale: 0,
              nullable: 'NO' } },
        name: 
         { type: 'String',
           required: false,
           length: null,
           precision: null,
           scale: null,
           postgresql: 
            { columnName: 'name',
              dataType: 'text',
              dataLength: null,
              dataPrecision: null,
              dataScale: null,
              nullable: 'YES' } },
        isbn: 
         { type: 'String',
           required: false,
           length: null,
           precision: null,
           scale: null,
           postgresql: 
            { columnName: 'isbn',
              dataType: 'text',
              dataLength: null,
              dataPrecision: null,
              dataScale: null,
              nullable: 'YES' } },
        authorid: 
         { type: 'Number',
           required: true,
           length: null,
           precision: 32,
           scale: 0,
           id: 2,
           postgresql: 
            { columnName: 'authorid',
              dataType: 'integer',
              dataLength: null,
              dataPrecision: 32,
              dataScale: 0,
              nullable: 'NO' } } } },
  'public.author': 
   { name: 'Author',
     options: 
      { idInjection: false,
        postgresql: { schema: 'public', table: 'author' },
        relations: {} },
     properties: 
      { aid: 
         { type: 'Number',
           required: true,
           length: null,
           precision: 32,
           scale: 0,
           id: 1,
           postgresql: 
            { columnName: 'aid',
              dataType: 'integer',
              dataLength: null,
              dataPrecision: 32,
              dataScale: 0,
              nullable: 'NO' } },
        name: 
         { type: 'String',
           required: false,
           length: null,
           precision: null,
           scale: null,
           postgresql: 
            { columnName: 'name',
              dataType: 'text',
              dataLength: null,
              dataPrecision: null,
              dataScale: null,
              nullable: 'YES' } },
        dob: 
         { type: 'String',
           required: false,
           length: null,
           precision: null,
           scale: null,
           postgresql: 
            { columnName: 'dob',
              dataType: 'timestamp without time zone',
              dataLength: null,
              dataPrecision: null,
              dataScale: null,
              nullable: 'YES' } } } } }

Hopefully this answered your question. Closing this issue as resolved. Feel free to reopen if needed.