Integrate the MySQL API with the Python API

MySQL is a powerful database management system used by some of the largest
organizations in the world, including Facebook, Google, and Amazon. MySQL is an
open-source relational database management system (RDBMS), as well as a popular
choice for web applications used by millions of websites.

Some applications that can be built using the MySQL API include:

A web application that stores and retrieves data from a MySQL database
A desktop application that uses a MySQL database for data storage
A mobile application that interacts with a MySQL database

Connect MySQL#

module.exports = defineComponent({
  props: {
    mysql: {
      type: "app",
      app: "mysql",
    }
  },
  async run({steps, $}) {
    const mysql = require('mysql2/promise');
    
    const { host, port, username, password, database } = this.mysql.$auth
    
    const connection = await mysql.createConnection({
      host,
      port,
      user: username,
      password,
      database,
    });
    
    const [rows, fields] = await connection.execute('SELECT NOW()');
    console.log(rows)
  },
})

Overview of Python#

Python API on Pipedream offers developers to build or automate a variety of
tasks from their web and cloud apps. With the Python API, users are able to
create comprehensive and flexible scripts, compose and manage environment
variables, and configure resources to perform a range of functions.

By using Pipedream, you can easily:

Create automated workflows that run on a specific schedule
Compose workflows across various apps and services
React to events in cloud services or form data
Automatically create content and notifications
Construct classifications and predictions
Analyze and react to sentiment, sentiment analysis and sentiment score
Connect backends to the frontend with serverless functions
Work with files and databases
Perform web requests and fetch data
Integrate third-party APIs into your apps
Orchestrate data processing tasks and pipelines
Create powerful application APIs with authentication and authorization
Design CI/CD pipelines and Continuous Delivery services
Connect databases like MongoDB and MySQL
Monitor connections and events
Generate alerts and notifications for corresponding events

Connect Python#

def handler(pd: "pipedream"):
  # Reference data from previous steps
  print(pd.steps["trigger"]["context"]["id"])
  # Return data for use in future steps
  return {"foo": {"test":True}}