Integrate the Microsoft SQL Server API with the Amazon SES API

import sql from "mssql"
export default defineComponent({
  props: {
    microsoft_sql_server: {
      type: "app",
      app: "microsoft_sql_server",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database } = this.microsoft_sql_server.$auth
    const conn_str = `Server=${host},${port};Database=${database};User Id=${username};Password=${password};Encrypt=true`;
    await sql.connect(conn_str);
    return await sql.query`SELECT GETDATE()`
  },
})

module.exports = defineComponent({
  props: {
    amazon_ses: {
      type: "app",
      app: "amazon_ses",
    }
  },
  async run({steps, $}) {
    const AWS = require("aws-sdk")
    const { accessKeyId, secretAccessKey } = this.amazon_ses.$auth
    
    const ses = new AWS.SES({
      accessKeyId, 
      secretAccessKey,
      region: 'us-east-1',
    })
    
    const sesParams = {
      Destination: {
        ToAddresses: ["<your email here>"],
      }, 
      Message: {
        Body: {
          Html: {
            Charset: "UTF-8", 
            Data: "<h1>This is a test</h1>",
          }, 
            Text: {
            Charset: "UTF-8", 
            Data: "This is a test",
          }
        }, 
        Subject: {
          Charset: "UTF-8", 
          Data: "Test email",
        }
      },
      Source: "<your from address here", 
    };
    
    this.resp = await ses.sendEmail(sesParams).promise()
  },
})