All files / models DumpsterCategories.ts

100% Statements 7/7
100% Branches 0/0
100% Functions 2/2
100% Lines 7/7

Press n or j to go to the next uncovered block, b, p or k for the previous block.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 7711x                           11x                         11x 11x                                                     11x       11x                       11x          
import { Sequelize, DataTypes, Optional, Model, ModelStatic } from "sequelize";
import { DumpsterAttributes, DumpsterCreationAttributes } from "./dumpsters";
import { CategoryAttributes, CategoryCreationAttributes } from "./Categories";
 
export interface DumpsterCategoryAttributes {
    dumpsterID: number;
    revisionID: number;
    categoryID: number;
    dateAdded: string;
}
 
export interface DumpsterCategoryCreationAttributes
    extends Optional<DumpsterCategoryAttributes, "dumpsterID" | "dateAdded"> {}
 
export class DumpsterCategories
    extends Model<
        DumpsterCategoryAttributes,
        DumpsterCategoryCreationAttributes
    >
    implements DumpsterCategoryAttributes {
    public dumpsterID!: number;
    public revisionID!: number;
    public categoryID!: number;
    public dateAdded!: string;
}
 
// Inject Sequelize
export function init(sequelize: Sequelize) {
    DumpsterCategories.init(
        {
            dumpsterID: {
                type: DataTypes.INTEGER.UNSIGNED,
                allowNull: false,
            },
            revisionID: {
                type: DataTypes.INTEGER.UNSIGNED,
                primaryKey: true,
                allowNull: false,
            },
            categoryID: {
                type: DataTypes.INTEGER.UNSIGNED,
                primaryKey: true,
                allowNull: false,
            },
            dateAdded: {
                type: DataTypes.DATE,
                allowNull: false,
                defaultValue: Sequelize.fn("now"),
            },
        },
        {
            sequelize,
            tableName: "DumpsterCategories",
        },
    );
    return DumpsterCategories;
}
 
// The type is not defined yet, so use a substitute
export function associate({
    Categories,
    Dumpsters,
}: {
    Dumpsters: ModelStatic<
        Model<DumpsterAttributes, DumpsterCreationAttributes>
    >;
    Categories: ModelStatic<
        Model<CategoryAttributes, CategoryCreationAttributes>
    >;
}) {
    // @ts-ignore
    DumpsterCategories.belongsTo(Categories, { foreignKey: "categoryID" });
    // do associations like
    // Thing.hasMany()
    // using the supplied Models object
}