index.ts

import { db } from './_db';

// Import DB Models
import {
  UserModel,
  MessageModel,
  StudyModel,
  TagModel,
  TaskModel,
  StatusModel,
} from './models/index';

// Define relationships between models
UserModel.hasMany(TagModel);
UserModel.belongsToMany(StudyModel, {through: 'UserStudy'});
StudyModel.belongsToMany(UserModel, {through: 'UserStudy'});
UserModel.hasMany(MessageModel);
MessageModel.belongsTo(StudyModel);

StudyModel.hasMany(TagModel);
StudyModel.belongsTo(UserModel, {as: 'Creator'});

// tasks
StudyModel.hasMany(TaskModel, { onDelete: 'cascade'});
TaskModel.belongsTo(StudyModel);
TaskModel.hasMany(StatusModel, { as: 'SurveyStatus', onDelete: 'cascade'});
UserModel.hasMany(StatusModel, { as: 'SurveyStatus', onDelete: 'cascade' });
TaskModel.hasOne(TaskModel, { // reminders are associated with a Parent Survey
  as: 'ParentSurveyTask',
  onDelete: 'cascade'},
);
TaskModel.hasMany(TaskModel, { as: 'Reminders'}); // reminders are associated with a Parent Survey

export default db;