Integrate the Microsoft Azure SQL Database API with the Amazon SES API

import sql from "mssql"
export default defineComponent({
  props: {
    azure_sql: {
      type: "app",
      app: "azure_sql",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database, encrypt } = this.azure_sql.$auth
    const config = {
      user: username, 
      password, 
      server: host, 
      port, 
      database, 
      authentication: {
          type: 'default'
      },
      options: {
          encrypt
      }
    }
    await sql.connect(config);
    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()
  },
})