Skip to content

Instantly share code, notes, and snippets.

@gmiroshnykov
Created December 20, 2013 14:40
Show Gist options
  • Save gmiroshnykov/8055630 to your computer and use it in GitHub Desktop.
Save gmiroshnykov/8055630 to your computer and use it in GitHub Desktop.
r.tableCreate('senders');
r.tableCreate('receivers');
r.tableCreate('messages');
r.table('senders').insert({id: 1, sender: 'Sender One'});
r.table('receivers').insert({id: 1, receiver: 'Receiver One'});
r.table('messages').insert([{
senderId: 1,
receiverId: 1,
msg: 'Message One'
}, {
senderId: 1,
receiverId: 1,
msg: 'Message Two'
}, {
senderId: 1,
receiverId: 1,
msg: 'Message Three'
}]);
// returns tree rows, as expected
r.table('messages')
.eqJoin('senderId', r.table('senders'))
.without({right: {id: true}})
.zip()
// returns only one row
r.table('messages')
.eqJoin('senderId', r.table('senders'))
.without({right: {id: true}})
.zip()
.eqJoin('receiverId', r.table('receivers'))
.without({right: {id: true}})
.zip()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment