Build NodeJS Object from SQL

Question

I'm currently building a NodeJS express API to run with a ReactJS front end. Coming from mongodb where everything is a document I'm a little bit lost about how to gather data from SQL. Let me explain.

To build a ReactJS application working with an API Rest I need proper Objects structure in front end.

Taking the example of a basic application where a user can place bets on a match, I would have

TABLE users (
  _id SERIAL PRIMARY KEY,

  username varchar(255) UNIQUE,
  password varchar(255)
);

TABLE matches (
    _id SERIAL PRIMARY KEY,

    EQA varchar(255), // These should be ids to teams but
    EQB varchar(255), // we try to keep it simple

    EQA_score INTEGER,
    EQB_score INTEGER,
);

TABLE bets (
    _id SERIAL PRIMARY KEY,
    user_id INTEGER REFERENCES users(_id),
    match_id INTEGER REFERENCES matches(_id),

    EQA_bet INTEGER,
    EQB_bet INTEGER,
);

Then to display the history of the pronostics in ReactJS it would be very simple with datas structured this way:

{
    username: 'Random name',
    bets: [
        {
            EQA_bet: 1,
            EQB_bet: 0,
            match: {
                EQA: 'Paris',
                EQB: 'London',
                EQA_score: 1,
                EQB_score: 0,

            }
        },
        {
            ...
        }
    ]
}

To build this object I don't know what would be the best:

One query for user, bets and matches and build my object in JS
One query with joins then some long code to build my object
Some other tools / strategies I don't know yet

Thanks for understanding my issue. This is all about not having a flat object to interpret in front end

You are looking for a SQL ORM. I have worked with Objection.js and I love it. The feature you need is called eager loading — Rashomon
– Rashomon, Commented Apr 4, 2019 at 21:01

S.Mishra · Accepted Answer · 2019-04-04 21:10:29Z

1

@Yooomi, you can use sequelize NPM Package to create your object models and can define relationships between different models. You can do all C.R.U.D. operations through this. The response you get through this package will be in JSON format. You can change it as per your need.

You can go through different blogs and find the usage of the sequelize. I search on google and found this article which seems a good start.

Let me know if that is useful.

answered Apr 4, 2019 at 21:10

S.Mishra

3,69431 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yoooomi Over a year ago

I'm taking a look at this and this seems to fill the job, but I'm quite sad I won't write my SQL queries on my own

S.Mishra Over a year ago

Yeah, That is the whole purpose of changing the SQL table to an object model to avoid SQL statements and let the framework handle all CRUD operations. If you seems I gave you the answer then, please like my original answer.

Collectives™ on Stack Overflow

Build NodeJS Object from SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related