open-index/open-npm huggingface dataset:
npm package: @mayahq/editor-api
Description: @node-red/editor-api ====================
Latest version: 1.2.9-maya
Deprecated: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.

# Fork of @node-red/editor-api for use with Maya Virtual Assitant
@node-red/editor-api
====================

Node-RED editor api module.

This provides an Express application that can be used to serve the Node-RED
editor.


### Source

The main Node-RED modules are maintained as a monorepo on [GitHub](https://github.com/mayahq/node-red).
npm package: @mayahq/editor-client
Description: @node-red/editor-client ====================
Latest version: 1.2.9-maya
Deprecated: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.

# Fork of @node-red/editor-client for use with Maya Virtual Assitant
@node-red/editor-client
====================

Node-RED editor resources module.

This provides all of the client-side resources of the Node-RED editor application.

### Source

The main Node-RED modules are maintained as a monorepo on [GitHub](https://github.com/mayahq/node-red).
npm package: @mayahq/maya-red-node-mysql
Description: A fork of Node-RED mysql node to read and write to a MySQL database
Latest version: 1.0.10

@mayahq/maya-red-node-mysql
========================
A fork of <a href="http://nodered.org" target="_new">Node-RED</a>'s storage/mysql node to read and write to a MySQL database.

Install
-------

Either use the `Maya's Module Install - MySQL Node`, or run the following command in your Node-RED user directory - typically `~/.node-red`

    npm i @mayahq/maya-red-node-mysql


Usage
-----

Allows basic access to a MySQL database.

This node uses the **query** operation against the configured database. This does allow both INSERTS and DELETES.

By its very nature it allows SQL injection... so *be careful out there...*

The `msg.payload.query` must hold the *query* for the database, and the result is returned in `msg.payload.result`.

Typically the returned payload will be an array of the result rows.

If nothing is found for the key then *null* is returned.

The reconnect retry timeout in milliseconds can be changed by adding a line to **settings.js**
```javascript
mysqlReconnectTime: 30000,
```

The timezone can be set like GMT, EST5EDT, UTC, etc.

The charset defaults to the "old" Mysql 3 byte UTF. If you need support for emojis etc then use UTF8MB4.


Preparing Queries
-----
```javascript
msg.payload=[24, 'example-user'];
msg.payload.query="INSERT INTO users (`userid`, `username`) VALUES (?, ?);"
return msg;
```

with named parameters:

```javascript
msg.payload={}
msg.payload.values.userToChange=42;
msg.payload.values.newUsername="example-user";
msg.topic="INSERT INTO users (`userid`, `username`) VALUES (:userToChange, :newUsername) ON DUPLICATE KEY UPDATE `username`=:newUsername;"
return msg;
```

```javascript
msg.payload.renewSchema = true;
```
to update the schema infromation of the database provided the supplied user credentials has access to the schema information. This returns `msg.payload.schema` with the create schema information of all tables in the database.

Documentation
-----
 
<a href="https://www.npmjs.com/package/mysql" target="_new">Documentation</a> of the used Node.js package
npm package: @mayahq/maya-red-node-postgres
Description: A fork of Node-RED postgres node to read and write to a PostgreSQL database
Latest version: 1.0.1

@mayahq/maya-red-node-mysql
========================
A fork of <a href="http://nodered.org" target="_new">Node-RED</a>'s storage/mysql node to read and write to a MySQL database.

Install
-------

Either use the `Maya's Module Install - PostgreSQL Node`, or run the following command in your Node-RED user directory - typically `~/.node-red`

    npm i @mayahq/maya-red-node-postgres


Usage
-----

Allows basic access to a Postgres database.

This node uses the **query** operation against the configured database. This does allow both INSERTS and DELETES.

By its very nature it allows SQL injection... so *be careful out there...*

The `msg.payload.query` must hold the *query* for the database, and the result is returned in `msg.payload.result`.

Typically the returned payload will be an array of the result rows.

If nothing is found for the key then *null* is returned.

The reconnect retry timeout in milliseconds can be changed by adding a line to **settings.js**
```javascript
mysqlReconnectTime: 30000,
```

The timezone can be set like GMT, EST5EDT, UTC, etc.

The charset defaults to the "old" Mysql 3 byte UTF. If you need support for emojis etc then use UTF8MB4.


Preparing Queries
-----
```javascript
msg.payload=[24, 'example-user'];
msg.payload.query="INSERT INTO users (`userid`, `username`) VALUES (?, ?);"
return msg;
```

with named parameters:

```javascript
msg.payload={}
msg.payload.values.userToChange=42;
msg.payload.values.newUsername="example-user";
msg.topic="INSERT INTO users (`userid`, `username`) VALUES (:userToChange, :newUsername) ON DUPLICATE KEY UPDATE `username`=:newUsername;"
return msg;
```

```javascript
msg.payload.renewSchema = true;
```
to update the schema infromation of the database provided the supplied user credentials has access to the schema information. This returns `msg.payload.schema` with the create schema information of all tables in the database.

Documentation
-----
 
<a href="https://www.npmjs.com/package/mysql" target="_new">Documentation</a> of the used Node.js package