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 | 11x 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 PhotoAttributes {
photoID: number;
dumpsterID: number;
url: string;
userID: number | null;
dateAdded: Date;
}
export interface PhotoCreationAttributes
extends Optional<PhotoAttributes, "photoID" | "dateAdded"> {}
export class Photos extends Model<PhotoAttributes, PhotoCreationAttributes>
implements PhotoAttributes {
photoID!: number;
dumpsterID!: number;
url!: string;
userID!: number | null;
dateAdded!: Date;
}
// Inject Sequelize
export function init(sequelize: Sequelize) {
Photos.init(
{
photoID: {
type: DataTypes.INTEGER.UNSIGNED,
autoIncrement: true,
primaryKey: true,
},
dumpsterID: {
type: DataTypes.INTEGER.UNSIGNED,
allowNull: false,
},
url: {
type: DataTypes.STRING,
allowNull: false,
},
userID: {
type: DataTypes.INTEGER.UNSIGNED,
},
dateAdded: {
type: DataTypes.DATE,
allowNull: false,
defaultValue: Sequelize.fn("now"),
},
},
{
sequelize,
tableName: "Photos",
},
);
return Photos;
}
// The type is not defined yet, so use a substitute
export function associate({
DumpsterPositions,
PhotoReports,
Users,
}: {
DumpsterPositions: ModelStatic<
Model<DumpsterPositionAttributes, DumpsterPositionCreationAttributes>
>;
Users: ModelStatic<Model<UserAttributes, UserCreationAttributes>>;
PhotoReports: ModelStatic<Model<any, any>>;
}) {
// do associations like
// Thing.hasMany()
// using the supplied Models object
Photos.hasMany(PhotoReports, { foreignKey: "photoID" });
}
|