exports.get = function (query, cb) {
var out_json = {},
data = [],
meta = {},
base_sql = 'SELECT * FROM ?';
try {
if (query.goals && !query.ids) {
base_sql += ' WHERE goal IN('+ utils.string_to_int(query.goals) +')';
data = alasql(base_sql, [ TARGETS ]);
}
if (query.ids) {
base_sql += ' WHERE id IN ('+ utils.sql_stringify(query.ids) +')';
data = alasql(base_sql, [ TARGETS ]);
} else if (!query.goals) {
data = alasql(base_sql, [ TARGETS ]);
}
out_json['data'] = data;
out_json['meta'] = {};
}
catch (e) {
console.log(e);
out_json.errors = [];
out_json.errors.push({
status: '',
detail: e,
source: ''
});
}
cb(null, out_json);
}
var adjustResult = function(resultData){
var self = this
var resourceConfig = self.getResourceConfig()
if ((resourceConfig['attributes']) && ((resourceConfig['order']) || (resourceConfig['group']))){
var sql = 'SELECT '
if(resourceConfig['attributes']){
resourceConfig['attributes'].some(function(attribute){
sql += attribute + ', '
})
sql += 'FROM ? '
}
if(resourceConfig['where']) sql += 'WHERE '+resourceConfig['where']+' '
if(resourceConfig['group']) sql += 'GROUP BY '+resourceConfig['group']+' '
if(resourceConfig['order']) sql += 'ORDER BY '+resourceConfig['order']+' ASC '
var sql = sql.replace(', FROM',' FROM')
var res = alasql(sql,[resultData]);
return res
} else {
return resultData
}
}
/* @flow */
const alasql = require('alasql');
alasql('value of select 5');
alasql('select 5 as a');
alasql('select ? as a',[5], function(x){});
// $ExpectError
alasql.parse(['select 3']);
alasql.parse('select 3');
alasql.promise('value of select 5');
alasql.promise(['value of select 5', ['select ? as y',7]]);
alasql(['value of select 5']);
alasql.options.errorlog = false; // Log or throw error
alasql.options.valueof = false; // Use valueof in orderfn
alasql.options.dropifnotexists = false; // DROP database in any case
alasql.options.datetimeformat = 'sql'; // How to handle DATE and DATETIME types
alasql.options.casesensitive = true; // Table and column names are case sensitive and converted to lower-case
alasql.options.logtarget = 'output'; // target for log. Values: 'console', 'output', 'id' of html tag
alasql.options.logprompt = true; // Print SQL at log
alasql.options.progress = false; // Callback for async queries progress
alasql.options.modifier = undefined;
alasql.options.columnlookup = 10;
p._memQueryGen = function*(sql, params) {
this._debug('_memQueryGen', sql, params);
const result = alasql(sql, params);
this._printDebug('running memQuery: ' + sql, 'params: ' + params, 'result is: ', result);
return result;
};
/**
* Created by timtian on 2016/5/11.
*/
var alasql = require('alasql');
var a = 123;
var id = 2;
var data = [
{
id:1,
name:'A'
},
{
id:2,
name:'B'
},
{
id:3,
name:'C'
}
]
var res = alasql('SELECT id, name, 1 as enable, "abc" as title, (id + 1) as ID2 FROM ? WHERE id=2 AND name != "A"', [data]);
console.log(res);
// Async select
var db = require('alasql');
db("CREATE TABLE test (language INT, hello STRING)");
db("INSERT INTO test VALUES (1,'Hello!')");
db("INSERT INTO test VALUES (2,'Aloha!')");
db("INSERT INTO test VALUES (3,'Bonjour!')");
db .promise("SELECT * FROM test WHERE language > 1")
.then(function(res){
console.log(res);
});
var alasql = require('alasql');
var data = [{a:0},{a:1},{a:2},{a:3},{a:4}];
var res = alasql('SELECT * FROM ? WHERE a >= ?', [data, 2]);
console.log(res);