Nodal Conditional Joins TL;DR

1. Command Line

nodal new conditional-joins
nodal g:model Tweet user_id:int body:string
nodal g:controller --for Tweets
nodal g:model --user
nodal g:controller --for Users
nodal db:create
nodal db:prepare
nodal db:migrate
nodal s

2. users_controller.js

// users_controller.js
    index() {

      User.query()
        .where({tweets__body__icontains: 'Minecraft'}) // add me
        .join('tweets', {body__icontains: 'Minecraft'}) // add me
        .end((err, models) => {
          this.respond(err || models, ['tweets']); // add me
        });

    }

3. user.js

  // models/user.js
  
  'use strict';

  const Nodal = require('nodal');
  const Tweet = Nodal.require('app/models/tweet.js'); // import me
  
  User.setDatabase(Nodal.require('db/main.js'));
  User.setSchema(Nodal.my.Schema.models.User);
  User.joinedBy(Tweet); // add me

4. tweet.js

  // models/tweet.js
  
  'use strict';

  const Nodal = require('nodal');
  const User = Nodal.require('app/models/user.js'); // import me

  class Tweet extends Nodal.Model {}

  Tweet.setDatabase(Nodal.require('db/main.js'));
  Tweet.setSchema(Nodal.my.Schema.models.Tweet);
  Tweet.joinsTo(User, {multiple: true}) // add me

  return Tweet;

5. Requests

POST /users username:nodalisawesome password:password email:nodal@isawesome.com

POST /tweets user_id:1 body:some other text
POST /tweets user_id:1 body:minecraft
POST /tweets user_id:1 body:Minecraft

GET /users

6. Response

/**
 * 
 * You should be receiving all the tweets that contain Minecraft
 * 
 * */

{
  "meta": {
    "total": 1,
    "count": 1,
    "offset": 0,
    "error": null
  },
  "data": [
    {
      "tweets": [
        {
          "id": 2,
          "user_id": 1,
          "body": "minecraft",
          "created_at": "2016-05-22T02:25:47.979Z",
          "updated_at": "2016-05-22T02:25:47.979Z"
        },
        {
          "id": 3,
          "user_id": 1,
          "body": "Minecraft",
          "created_at": "2016-05-22T02:25:52.454Z",
          "updated_at": "2016-05-22T02:25:52.454Z"
        }
      ]
    }
  ]
}