JSFiddle - React, Tailwind, and code Playground
SELECT * FROM user JOIN media USING user_id
by Kato Richardson
HTML
<script src="http://static.firebase.com/v0/firebase.js"></script>
<h3>SELECT * FROM user JOIN media USING user_id</h3>
<pre>Loading...</pre>
CSS
pre {
padding: 20px;
font-size: 20px;
border-radius: 15px;
background-color: #fafafa;
border: 1px solid #999;
font-family:'Courier New', 'Courier', monospaced;
}
JavaScript
var fb = new Firebase("https://examples-sql-queries.firebaseio.com/");
fb.child('user/123').once('value', function(userSnap) {
fb.child('media/123').once('value', function(mediaSnap) {
show( extend({}, userSnap.val(), mediaSnap.val()) );
});
});
function show(data) {
$('pre').text(JSON.stringify(data, null, 2));
}
function extend(base) {
var parts = Array.prototype.slice.call(arguments, 1);
parts.forEach(function (p) {
if (p && typeof (p) === 'object') {
for (var k in p) {
if (p.hasOwnProperty(k)) {
base[k] = p[k];
}
}
}
});
return base;
}