YZ
but, about your question, yes, you can do like this by promise.all
SELECT the data(created), count(created) like total_count
FROM" Users " u
GROUP BY date (created)
ORDER BY date (created) DESC
Size: a a a
2021 July 28
2021 July 29
DT
Hello everyone. I immediately apologize if this is a stupid question. Who worked the sequel? I can't figure out how to make such an SQL query through it:
z
Users.findAll({
attributes: [‘created’, [sequelize.fn('COUNT', sequelize.col('created')), '
order: [‘created’, ‘DESC’]
group: [‘created’]
})
attributes: [‘created’, [sequelize.fn('COUNT', sequelize.col('created')), '
total_count']]order: [‘created’, ‘DESC’]
group: [‘created’]
})
z
попробуй, посмотри че сгенерит запрос, я так набросал за 2 минуты
z
и вот тут почитай
DT
Спасибо)
LC
myclass-task/app.js at main · kemphack/myclass-task · GitHub
https://github.com/kemphack/myclass-task/blob/main/app.js
https://github.com/kemphack/myclass-task/blob/main/app.js
LC
Можете покритиковать то, что я понаписал, мне кажется как-то сложно получилось.
YZ
хм, надо посмотреть
2021 July 30
M
Hello
Does ?sslmode=require work for Postgres URLs?
I tried it with no success. Is config object the only method?
Solved:
You can add these to options:
ssl: true,
dialect: "postgres",
dialectOptions: {
ssl: true
}
Does ?sslmode=require work for Postgres URLs?
I tried it with no success. Is config object the only method?
Solved:
You can add these to options:
ssl: true,
dialect: "postgres",
dialectOptions: {
ssl: true
}
K
hi....
how to set a dropTable at migration from a schema that is not the public???,
how to set a dropTable at migration from a schema that is not the public???,
K
im using postgresql
K
i have tested this
queryInterface.dropTable('tablename', {schema: 'schema_name'})K
but it does not works
YZ
need to investigate, but you can use just query:
const n = my_schema_name;
await queryInterface.sequelize.query(
DROP TABLE IF EXISTS "${my_schema_name}"."my_table_name"
);YZ
for research you case need to analyse error and debug result query
K
i found how to do...
queryInterface.dropTable({schema: "schema_name", tableName: "table_name"})YZ
K
the documentation is not good, and it doesn't have an example or shows how to do it in this case.