Typeorm : want to get the same result of getRawMany() as getMany(). | NestJS | Page 1

fiery yacht Apr 4, 2023, 11:21 AM

#

Hello.
Currently, we are running a query using getRawMany() to use the function 'SUM in MYSQL'.

As I received it with raw data, json is not pretty, so I want to receive it as a pretty json like getMany.

Is this supported by typeorm?
Is there any other way if I don't apply?

getRawMany()

{
    "feed_id": 1,
    "feed_content": "Test",
    "community_id": 1,
    "community_name": "Name",
    "postedUser_id": 1,
    "postedUser_nickname": "Nickname",
    "postedUser_profileImage": null,
}

I want the format below.

{
    "feed": {
        "id": 1,
        "content": "Test"
    },
    "community": {
        ...
    },
    "postedUser": {
        ...
    }
}

ornate vortex Apr 4, 2023, 11:22 AM

#

https://www.npmjs.com/package/unflatten

npm

unflatten

The opposite of flatten. Latest version: 1.0.4, last published: 6 years ago. Start using unflatten in your project by running npm i unflatten. There are 10 other projects in the npm registry using unflatten.

#

it's not supported by typeorm, but if you pass the result through this utility (with the separator set to _), you'll get the format you want.

fiery yacht Apr 4, 2023, 11:25 AM

#

ornate vortex https://www.npmjs.com/package/unflatten

Thank you. I'll try using it!

fiery yacht Apr 4, 2023, 11:37 AM

#

ornate vortex https://www.npmjs.com/package/unflatten

I'm going to load the images joined from getRawMany.
There are several images.

When I did getMany, I could get it as array, but in getRawMany, I only get the first value of array.

Are there options for this?

ornate vortex Apr 4, 2023, 11:47 AM

#

uh, no idea about that, sorry :/

#Typeorm : want to get the same result of getRawMany() as getMany().