File: /var/dev/nowruzgan/rest/node_modules/machinepack-mysql/test/queryable/compile-statement.test.js
var assert = require('assert');
var Pack = require('../../');
describe('Queryable ::', function() {
describe('Compile Statement', function() {
it('should generate a SQL Statement from a WLQL query', function(done) {
Pack.compileStatement({
statement: {
select: ['title', 'author', 'year'],
from: 'books'
}
})
.exec(function(err, report) {
if (err) {
return done(err);
}
assert.equal(report.nativeQuery, 'select `title`, `author`, `year` from `books`');
return done();
});
});
// FUTURE: Add lots of checking to the statement compiler
it.skip('should return the malformed exit for bad WLQL', function(done) {
Pack.compileStatement({
statement: {
foo: 'bar',
from: 'books'
}
})
.exec(function(err) {
try {
assert(err);
assert.equal(err.exit, 'malformed', 'Instead got '+err.stack);
} catch (err2) { return done(err2); }
return done();
});
});
});
});