How to use the alasql.tables function in alasql
To help you get started, we’ve selected a few alasql examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
yoavfeld / sql-to-json / lib / SqlToJson.js View on Github 
p._loadDbTables = function*(tablesQueries) {
this._debug('_loadDbTables');
if (tablesQueries) {
this._logger.info('Loading pre load tables');
for (let tableName in tablesQueries) {
alasql.tables[tableName] = {};
let data = yield * this._queryGen(tablesQueries[tableName]);
alasql.tables[tableName].data = data;
}
}
};p._clearAlaSqlTables = function() {
this._debug('_clearAlaSqlTables');
for (let table in alasql.tables) {
delete alasql.tables[table];
}
};p._loadDbTables = function*(tablesQueries) {
this._debug('_loadDbTables');
if (tablesQueries) {
this._logger.info('Loading pre load tables');
for (let tableName in tablesQueries) {
alasql.tables[tableName] = {};
let data = yield * this._queryGen(tablesQueries[tableName]);
alasql.tables[tableName].data = data;
}
}
};alasql
Use SQL to select and filter javascript data - including relational joins and search in nested objects (JSON). Export to and import from Excel and CSV
