sequelize-auto | Automatically generate bare sequelize models | Object-Relational Mapping library

I created a model of my database using the "sequelize-auto" package. It has worked great up until today. For some reason this morning it started giving me this error: ERROR: MCAIntranet.initModels is not a function which is accompanied by the warning (node:35036) Warning: Accessing non-existent property 'initModels' of module exports inside circular dependency

This same function call (dataqueries.getSitemap) worked fine yesterday with no changes being made to this code. The import (MCAIntranet) for the model returns an empty JSON array for some reason.

Here is all the relevant code involved. The controller, the sequelize query file, the initModel file and the table model in order:

What do you have to put in your migration files (and model files) to create a M:N association in sequelize? I suspect I specifically mean, what references need to be set, and what do the required keys in those objects mean, but I'm not 100% sure that's what I mean.

I'm trying to create a users<->rolls association, similar to what was asked here.

Initially, I added references to my user and roll migration files. Then I realised that the userrolls join table migration file probably needed references the other direction as well. I suspect I'm nearing every possible combination of settings, but somehow still haven't gotten this to work :)

The associations from my model files:

role.js

I have an app with postgres as db, sequelize, and express, and whenever it receives a db query, it just stays there forever, no logging or anything I run postgres in a container which I can connect to through GUI normally When I swapped it for sqlite, it worked perfectly the application

here is the relevant piece of code

I am attempting to create a 3 table join using Sequelize ORM. The code I have developed so far is

I am using generate sequelize tables from Django generated models with sequelize-auto in my project. so far so good. I wrote the code to update the rank if I see a url again.

I am getting an unusual error when trying to run a join in sequelize. The error message is

SequelizeEagerLoadingError: tblSMS is associated to tblSMSSent using an alias. You've included an alias (tblSMS), but it does not match the alias(es) defined in your association (tblSM).

The join I have created is this:

I am switching from using node-mssql to Sequelize in order to access my database in a simpler fashion. As a newbie to sequelize I am stumbling my way through pulling the correct data.

As I am converting a .net site with .net authentication to a node site I am using the existing authentication database. Currently I am trying to pull all roles for an existing user.

Here is the code I have so far. It returns both userID and roleID along with the username and role name that I desire. How can I remove these 2 ID columns from my query results?

I use sequelize for my models and create model like this

I'm not really good at English and coding something. My OS is Mac and here is my basic info dialect : mysql sequelize-ver: 6.3.3 folder structure

I wrote my problem in the below on my question. First, I imported .sql file to my database and i made models automatically from sequelize-auto, and also migrated automatically from sequelize-auto-migrate. ( I really appreciate about it. )

Here is my Mentors model ( I made signUp controller from this model. )