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 | 11x 11x 11x 11x 11x 11x | import { Sequelize, DataTypes, Optional, Model, ModelStatic } from "sequelize";
import { DumpsterPositionAttributes, DumpsterPositionCreationAttributes } from "./DumpsterPositions";
import { UserAttributes, UserCreationAttributes } from "./Users";
export interface RatingAttributes {
userID: number;
dumpsterID: number;
rating: number;
date: Date;
}
export interface RatingCreationAttributes
extends Optional<RatingAttributes, "date"> {}
export class Ratings
extends Model<RatingAttributes, RatingCreationAttributes>
implements RatingAttributes {
userID!: number;
dumpsterID!: number;
rating!: number;
date!: Date;
}
// Inject Sequelize
export function init(sequelize: Sequelize) {
Ratings.init(
{
userID: {
type: DataTypes.NUMBER,
primaryKey: true,
},
dumpsterID: {
type: DataTypes.INTEGER.UNSIGNED,
primaryKey: true,
},
rating: {
type: DataTypes.TINYINT.UNSIGNED,
allowNull: false,
},
date: {
type: DataTypes.DATE,
allowNull: false,
defaultValue: Sequelize.fn('now'),
}
},
{
sequelize,
tableName: "Ratings",
},
);
return Ratings;
}
// The type is not defined yet, so use a substitute
export function associate({
DumpsterPositions,
}: {
DumpsterPositions: ModelStatic<Model<DumpsterPositionAttributes, DumpsterPositionCreationAttributes>>;
Users: ModelStatic<Model<UserAttributes, UserCreationAttributes>>;
}) {
// do associations like
// Thing.hasMany()
// using the supplied Models object
} |