sequelize mapToModel example

sequelize-mapToModel-example.js

/**
 * @param {UUID} sourceId An ID to find.
 * 
 * @returns {Object} an single object instance of Sequelize Model.
 */
async function getMyTableData(sourceId) {
  const sequelize = await this.hub.api('DbConnector', 'Sequelize');
  const mytable = await sequelize
    .query(`SELECT *
            FROM "my_table_name"
            WHERE metadata->>'source_id' = '${sourceId}'
            ORDER BY created_at DESC
            LIMIT 1;`,
      {
        plain: true, // true == return single record
        model: sequelize.model('MyTableName'),
        mapToModel: true
      });

  return mytable;
}