import { InferAttributes, InferCreationAttributes } from "sequelize"; import { DataType, BelongsTo, ForeignKey, Column, Table, } from "sequelize-typescript"; import Document from "./Document"; import User from "./User"; import IdModel from "./base/IdModel"; import Fix from "./decorators/Fix"; @Table({ tableName: "backlinks", modelName: "backlink" }) @Fix class Backlink extends IdModel< InferAttributes, Partial> > { @BelongsTo(() => User, "userId") user: User; @ForeignKey(() => User) @Column(DataType.UUID) userId: string; @BelongsTo(() => Document, "documentId") document: Document; @ForeignKey(() => Document) @Column(DataType.UUID) documentId: string; @BelongsTo(() => Document, "reverseDocumentId") reverseDocument: Document; @ForeignKey(() => Document) @Column(DataType.UUID) reverseDocumentId: string; /** * Find all backlinks for a document that the user has access to * * @param documentId The document ID to find backlinks for * @param user The user to check access for */ public static async findSourceDocumentIdsForUser( documentId: string, user: User ) { const backlinks = await this.findAll({ attributes: ["reverseDocumentId"], where: { documentId, }, }); const documents = await Document.findByIds( backlinks.map((backlink) => backlink.reverseDocumentId), { userId: user.id } ); return documents.map((doc) => doc.id); } } export default Backlink;