Security News
tea.xyz Spam Plagues npm and RubyGems Package Registries
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
node-red-contrib-alasql
Advanced tools
Readme
(c) 2017 Mathias Rangel Wulff, Andrey Gershun & Kim McKinley
The Node-red alasql
node lets you access javascript objects as if they were a SQL database. The alafile in/out
nodes lets you transform the AlaSQL results into .xlsx, .xls, .csv, .json, .tab, .tsv, or .txt files stored on the node-red server.
The package is a Node-red wrapping of AlaSQL providing fast SQL based in-memory data processing for BI and ERP applications and import-export files into XLSX, XLS, and other data formats. Especially useful when you have (many) different sources coming with data you want to join, filter and format.
Go to your Node-RED user directory and install node-red-contrib-alasql
from npm:
cd ~/.node-red
npm install node-red-contrib-alasql
Write a valid SQL query in the SQL query
parameter. It can hold several SQL queries separated by ;
.
Refer to input data in msg.payload
with $0
in your SQL. If msg.payload
is an array the first value will be $0
, the second $1
and so forth.
The result will be returned in msg.payload
Default return format is an array of objects:
[{name:'foo', age: 86}, {name:'bar', age:64}]
To manipulate output format please consult the use of VALUE OF
, MATRIX OF
, COLUMN OF
, ROW OF
, and RECORDSET OF
.
If several queries are executed (separated by ;
) the returned value will be an array with the result from each.
Execute SQL on your data and output the result.
This includes INSERT
, UPDATE
, DELETE
, VIEW
indexes and multiple levels of JOIN
, GROUP BY
, UNION
, ROLLUP()
, CUBE()
, GROUPING SETS()
, CROSS APPLY
, OUTER APPLY
, WITH SELECT
, and subqueries. See the wiki to compare supported features with SQL standards.
Please consult the AlaSQL wiki to understand the flexible nature of the library.
You also can use alafile
component to perform import and export operations with files. The parameters include:
Name
- the name of the nodeFile name
- path to import or export fileFormat
- select file formatColums
- specify *
(star) for all columns or list them with comma like one, two, three
. You also can use AlaSQL functions or even rename columns with AS
operator (see the AlaSQL SELECT
statement documentation)Headers
- include first line headersThe node-red-contrib-alasql test suite for AlaSQL flows is provided to ensure AlaSQL nodes are operating properly.
node-red-contrib-alasql contains a set of test flows to ensure the nodes are handling exceptions properly and running as expected. Existing flows can be exported/imported into the test suite for verification.
The test suite is kindly contributed by
Kim McKinley (PotOfCoffee2Go). Requests and comments are appreciated. Create an
issue and please mention @PotOfCoffee2Go
somewhere in the issue.
To run the Test Suite from an existing node-red installation that uses node-red-contrib-alasql
please do:
cd ~/.node-red/node_modules/node-red-contrib-alasql
npm run test-setup
npm test
This will
Next time you want to run your test you can skip step 2.
To change the port do a export PORT=8081
on Mac or set PORT=8081
on Win prior to running npm test
.
If you wish to test the current release of AlaSQL prior to going into production. In any directory:
git clone https://github.com/AlaSQL/node-red-contrib-alasql.git
cd node-red-contrib-alasql
npm install
npm run test-setup
npm test
The test suite uses the npm link
command which allows node-red to
automatically add AlaSQL nodes to node-red by default. To remove this behaviour,
issue a npm unlink
from the node-red-contrib-alasql directory cloned above.
As default the library works in-memory - so all unsaved data are reset when Node-RED closes. Please consult the wiki to read more about how to let data be persistent.
If you are not sure why this is funny - please find out more about "SQL injections":
FAQs
Node-RED wrapper for AlaSQL database and XLSX import/export
The npm package node-red-contrib-alasql receives a total of 48 weekly downloads. As such, node-red-contrib-alasql popularity was classified as not popular.
We found that node-red-contrib-alasql demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
Security News
As cyber threats become more autonomous, AI-powered defenses are crucial for businesses to stay ahead of attackers who can exploit software vulnerabilities at scale.
Security News
UnitedHealth Group disclosed that the ransomware attack on Change Healthcare compromised protected health information for millions in the U.S., with estimated costs to the company expected to reach $1 billion.