🤦‍♂️

JEST is too smart...

👀 what was it? 👀👀

Well, i thought that is
JEST starts proccess with env "test". Config.json had username: root .
So, it was me and JEST :)

if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable], config)
} else {
  sequelize = new Sequelize(config.database, config.username, config.password, config)
}

Oooooh so it was using another config for testing.

you define between-table manualy, sequelzie don't know about it while insert data

try to add id field in RestaurantsWorkingDay model

or look guide how to work with many-to-many relation

\node_modules\sequelize\lib\model.js:230
       throw new Error(A column called 'id' was added to the attributes of '${this.tableName}' but not marked with 'primaryKey: true');

is there any config that could i  add into ./models/index.js

try to add primaryKey: true

once I see in docs that sequelize will remove ID of joint table when two ID's comes into one table

I did it but nothing changed

try to do like in this guide: https://khalilstemmler.com/articles/sequelize-tags-junction-pattern/

thanks

I have models:
product  [id, ..., features]
category  [id, ..., featuresFilter]
features is json, that stores data about product (color, material etc)
featuresFilter is json, that aggregates all features from products of its category

i am going to use featuresFilter as list of dimanic filters on the category page.

home -> store -> category -> notepads
here, on category notepads page ill send to template featuresFilter and show only available filters.
When i add or remove product ill recalculate featuresFilter.

well, my thoughts:
1.i know that i can add hook "afterCreate" to product model and call something like Category.addFeaturesToFeaturesFilter(features, categoryID) {
// Category.findbyPK(categoryID).then(...) // then do some stuff
should i do it here?
}
2.  i can do the same during creating or deleting product in controllers
I know how to make the second option, but i dont know about the first.
Any advices?

Привет, есть модель в которой будет колонка coordibates типа POINT, не совсем понимаю как описать тип для этой колонки, в базе выглядит как POINT(24, 55)

приходит клиенту как

{
           "type": "Point",
           "coordinates": [
               42.3446304,
               -71.0310138
           ]
       }
В sequlize нашел тип для такоого типа данных

@Column({ type: DataType.GEOMETRY('POINT'), allowNull: true })

но в модели как описать, как приходит? типа такого?

 coordinates: {
   type: string,
   coordinates: [number, number],
 };

да, это я уже нашел, тут скорее оффтоп у меня немного тк скорее мой вопрос про то как описать эту колонку в несте + тайпскрипт

если не ошибаюсь можно просто указать так:

@Column({ type: DataType.GEOMETRY('POINT'))
 coordinates: {
   type: string,
   coordinates: [number, number],
 };

ну исходя из того что из базы оно отдается в таком виде:

{
           "type": "Point",
           "coordinates": [
               42.3446304,
               -71.0310138
           ]
       }