How do I turn this model into a materialized view in sequelize?

Viewed 24

I have a model which currently creates a table. I would like to turn this into a materialized view instead. How can I do this?

/* eslint import/no-cycle: "off" */
import {
  Model,
  PrimaryKey,
  Column,
  Table,
  Min,
  AllowNull,
  AutoIncrement,
  BelongsTo,
} from 'sequelize-typescript';
import { FeedItem } from 'data/models';
 
@Table({
  freezeTableName: true,
})
export default class FeedItemLikesDislikesAggregate extends Model {
  @PrimaryKey
  @AutoIncrement
  @Column
  feedItemLikesDislikesAggregateId: number;
 
  @AllowNull(false)
  @Min(0)
  @Column
  dislikes: number;
 
  @AllowNull(false)
  @Min(0)
  @Column
  likes: number;
 
  @BelongsTo(() => FeedItem, {
    foreignKey: { name: 'feedItemId', allowNull: false },
    as: 'feedItemId_',
  })
  feedItemId: FeedItem;
}
0 Answers
Related