New Column - Pipedream

import common from "../common/table.mjs"; export default { ...common, key: "mysql-new-column", name: "New Column", description: "Emit new event when you add a new column to a table. [See the docs here](https://dev.mysql.com/doc/refman/8.0/en/show-columns.html)", type: "source", version: "0.0.2", dedupe: "unique", props: { ...common.props, db: "$.service.db", }, methods: { ...common.methods, _getPreviousColumns() { return this.db.get("previousColumns"); }, _setPreviousColumns(previousColumns) { this.db.set("previousColumns", previousColumns); }, async listResults() { let previousColumns = this._getPreviousColumns() || []; const columns = await this.mysql.listNewColumns( this.table, previousColumns, ); this.iterateAndEmitEvents(columns); const newColumnNames = columns .map((column) => column.Field) .filter((c) => !previousColumns.includes(c)); previousColumns = previousColumns.concat(newColumnNames); this._setPreviousColumns(previousColumns); }, generateMeta(column) { const columnName = column.Field; return { id: `${columnName}${this.table}`, summary: columnName, ts: Date.now(), }; }, }, };

Label	Prop	Type	Description
MySQL	`mysql`	`app`	This component uses the MySQL app.
	`timer`	`$.interface.timer`
Table	`table`	`string`	Select a value from the drop down menu.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between component invocations.

Label

Prop

Type

Description

MySQL

mysql

app

This component uses the MySQL app.

timer

$.interface.timer

Table

table

string

Select a value from the drop down menu.

N/A

db

$.service.db

This component uses $.service.db to maintain state between component invocations.

MySQL uses API keys for authentication. When you connect your MySQL account, Pipedream securely stores the keys so you can easily authenticate to MySQL APIs in both code and no-code steps.

These values correspond with your MySQL server:

host: IP address or domain to access your MySQL server
port: Default is 3306
username: The account username to log in
password: The account password to log in
database: The name of the database to open after logging in. Please note, MySQL must be connectable from Pipedream's IP address range. Otherwise, you'll receive a Connection Refused error.

New Column from MySQL API

Pipedream makes it easy to connect APIs for MySQL and 700+ other apps remarkably fast.

Developers ♥ Pipedream

Getting Started#

Integrations#

Details#

Code#

Configuration#

Authentication#

About MySQL#

More Ways to Use MySQL#

Triggers#

Actions#

Explore Other Apps#

1
-
12
of
700+
apps by most popular

New Column from MySQL API

Pipedream makes it easy to connect APIs for MySQL and 700+ other apps remarkably fast.

Developers ♥ Pipedream

1-12of700+apps by most popular

1
-
12
of
700+
apps by most popular