sequelize include model return array with Strings instead of Objects

2022-05-04 10:42 OĞUZHAN CEYHAN imported from Stackoverflow

sequelize include model return array with Strings instead of Objects i want result array but i dont know do this sorry my english bad

code

user.findOne({
    where:{ id: 1 },
    include: {
        model:role,
        attributes: ["name"],
        include: {
            model:permission,
            attributes:["name"]
        }
    }
})

result

{
    id: 1,
    username: "asdf",
    roleId: 1,
    role: {
        name:"admin",
        permissions: [
            { name: "create" },
            { name: "read" },
            { name: "update" },
            { name: "delete" },
        ]
    }
}

wanted

{
    id: 1,
    username: "asdf",
    roleId: 1,
    role: {
        name:"admin",
        permissions: [
            "create",
            "read",
            "update",
            "delete",
        ]
    }
}

i learn sequelize thank you for answer

See also questions close to this topic

Sequelize how to return result as a 2D array instead of array of objects?
I am using Sequelize query() method as follows:
```
const sequelize = new Sequelize(...);
...
// IMPORTANT: No changed allowed on this query
const queryFromUser = "SELECT table1.colname, table2.colname FROM table1 JOIN table2 ON/*...*/";
const result = await sequelize.query(queryFromUser);
```
Because I am selecting two columns with identical names (colname), in the result, I am getting something like:

[{ "colname": "val1" }, { "colname": "val2" }...], and this array contains values only from the column table2.colname, as it is overwriting the table1.colname values.

I know that there is an option to use aliases in the SQL query with AS, but I don't have control over this query.

I think it would solve the issue, if there was a way to return the result as a 2D array, instead of the array of objects? Are there any ways to configure the Sequelize query that way?

sequelize migration throws ERROR: function uuid_generate_v4() does not exist

I enabled uuid extension with CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

Then ran same query generated by sequelize for migration and it worked,

create table if not exists "MY_SCHEMA"."Users" ("id" UUID not null default uuid_generate_v4() ,
"phone" VARCHAR(10) not null,
"password" VARCHAR(50) not null,
"isDeleted" BOOLEAN default false,
"role" "MY_SCHEMA"."enum_Users_role" default 'Student',
"createdAt" TIMESTAMP with TIME zone not null,
"updatedAt" TIMESTAMP with TIME zone not null,
primary key ("id"));

But, sequelize throws below error,

ERROR: function uuid_generate_v4() does not exist

Here is the migration file,

const SCHEMA = 'MY_SCHEMA';
const TABLE_WITH_SCHEMA = { tableName: 'Users', schema: SCHEMA };

module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable(TABLE_WITH_SCHEMA, {
      id: {
        allowNull: false,
        primaryKey: true,
        defaultValue: Sequelize.literal('uuid_generate_v4()'),
        type: Sequelize.UUID
      },
      phone: {
        type: Sequelize.STRING(10),
        allowNull: false
      },
      password: {
        type: Sequelize.STRING(50),
        allowNull: false
      },
      isDeleted: {
        type: Sequelize.BOOLEAN,
        defaultValue: false
      },
      role: {
        type: Sequelize.ENUM('Admin', 'Teacher', 'Student'),
        defaultValue: 'Student'
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
    await queryInterface.addIndex(TABLE_WITH_SCHEMA, ['phone'], {
      indicesType: 'UNIQUE'
    });
  },
  async down(queryInterface) {
    await queryInterface.dropTable(TABLE_WITH_SCHEMA);
  }
};

Sequelize transaction with optimistic locking is locking the whole db
I have an API coded with Node.js and I use a SQLite database with Sequelize.

When I make updates, I use a transaction to rollback if something failed during the process.

The code look like this:
```
return sequelize.transaction(transaction => {
    return tableA.update(DataToUpdateA, {transaction})
        .then(() => {
            return UpdateValueInTableB(DataToUpdateB, {transaction});
        })
        .then(() => {
             // Do some complexe process that can take a while...
            return SomeComplexeProcess();
        })
        .catch(error => {
            // Log the error
        }); 
});
```
Sometimes the request take times because in SomeComplexeProcess I'm applying NTFS rights on the File System. And I need to roll back value in the database if something went wrong.

The problem is as long as the transaction is not completed the whole database is locked.

So I wanted to implement Optimistic Locking to avoid locking the whole database.

When I update something, the version field is well increment but my whole database still locked during the process.

Here is the configuration of Sequelize:
```
new Sequelize(username, password, dbName {
    define: {
        freezeTableName: true,
        version: true // Optimistic locking
    },
    host: ...,
    ....
}
```
Did I do something wrong with my configuration ?

Related questions

sequelize include model return array with Strings instead of Objects

See also questions close to this topic