let data = await Category.findAll({ where: { list_category_id: body.category_id }, attributes: { include: [ [ sequelize.literal(`COALESCE ( CASE WHEN youtube_id_id IS NOT NULL THEN ROW_NUMBER() OVER (ORDER BY random(), youtube_id_id) END, CASE WHEN instagram_id_id IS NOT NULL THEN ROW_NUMBER() OVER…
I'm building a web app, and I noticed that one of my queries is returning a null where I expect a boolean. However the database is indicating it's actually returning a boolean. I can see in the documentation that Postgres…
I want to query items from Postgres database with knex. In the database, I have two separate columns first_name and last_name, but I need to compare them both to a single value which is formatted "last_name, first_name". How can I…
I'm trying to create a summary report of sales per year with a couple of tables like the following: products id (PK) [... ] Orders id (PK) date product_id (FK to products I've written a query where I select from…
I've been having some issues with a connection to a Postgresql instance on Google Cloud SQL, and wanted to ask for help. I'm not sure if a solution would be to initiate a connection engine or something of the sort,…
I need to remap the names of properties in the objects of an array in postgres when performing a SELECT query. The table user_phones has columns id and phones. Imagine phones column type is json and the array has the…
this is what my playlist and user's models looks like type Playlist struct { ID uuid.UUID `json:"id" gorm:"primaryKey;type:uuid;default:gen_random_uuid()"` CreatedAt time.Time `json:"created_at"` UpdatedAt time.Time `json:"updated_at"` DeletedAt gorm.DeletedAt `json:"deleted_at" gorm:"index"` Title string `json:"title" gorm:"not null"` // Many 2 many with Back Reference…
I have a table of data with multiple columns and containing a column named 'weight' set to VARCHAR character type. It contains a mix of characters such as '400', '203.12', and '602.35 grams', and NULL values. Task is to clean…
I have a table with tasks. And I want to add a task to repeat after a while. If the task exists in the table, update the task, but if there are more than 3 attempts, delete the task or…
I have a table in Postgres id title ..... 1 title1 ..... 2 title2 ..... 3 title1 ..... 4 title13 ..... 5 title4 ..... 6 title7 ..... 7 title1 ..... 8 title1 ..... 9 title53 ..... 10 title11 ..... 11…