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 77 78 79 80 81 82 83 84 85 86 87 88 | 11x 11x 11x 11x 11x 11x | import { Sequelize, DataTypes, Optional, Model, ModelStatic } from "sequelize";
import {
DumpsterPositionAttributes,
DumpsterPositionCreationAttributes,
} from "./DumpsterPositions";
export interface CommentAttributes {
commentID: number;
dumpsterID: number;
nickname: string;
userID: number;
comment: string;
rating: number;
date: Date;
}
export interface CommentCreationAttributes
extends Optional<CommentAttributes, "commentID" | "rating" | "date"> {}
export class Comments
extends Model<CommentAttributes, CommentCreationAttributes>
implements CommentAttributes {
commentID!: number;
dumpsterID!: number;
nickname!: string;
userID!: number;
comment!: string;
rating!: number;
date!: Date;
}
// Inject Sequelize
export function init(sequelize: Sequelize) {
Comments.init(
{
commentID: {
type: DataTypes.INTEGER.UNSIGNED,
autoIncrement: true,
primaryKey: true,
},
dumpsterID: {
type: DataTypes.INTEGER.UNSIGNED,
allowNull: false,
},
nickname: {
type: DataTypes.STRING,
allowNull: false,
},
userID: {
type: DataTypes.INTEGER.UNSIGNED,
allowNull: false,
},
comment: {
type: DataTypes.STRING,
allowNull: false,
},
rating: {
type: DataTypes.TINYINT,
allowNull: false,
defaultValue: 0,
},
date: {
type: DataTypes.DATE,
allowNull: false,
defaultValue: Sequelize.fn("now"),
},
},
{
sequelize,
tableName: "Comments",
},
);
return Comments;
}
// The type is not defined yet, so use a substitute
export function associate({
DumpsterPositions,
}: {
DumpsterPositions: ModelStatic<
Model<DumpsterPositionAttributes, DumpsterPositionCreationAttributes>
>;
}) {
// do associations like
// Thing.hasMany()
// using the supplied Models object
}
|