SQL проти NoSQL · fullstack.org.ua

fullstack.org.ua

SQL проти NoSQL · fullstack.org.ua

sql

CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE orders (
  id INTEGER PRIMARY KEY,
  user_id INTEGER NOT NULL,
  total_cents INTEGER NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (name)
VALUES
  ('Олена'),
  ('Андрій');

INSERT INTO orders (user_id, total_cents)
VALUES
  (1, 120000),
  (2, 80000),
  (1, 45000);

SELECT
  users.name,
  SUM(orders.total_cents) AS total_spent
FROM users
JOIN orders ON orders.user_id = users.id
GROUP BY users.id, users.name
ORDER BY total_spent DESC;

json

{
  "id": 10,
  "user": {
    "id": 1,
    "name": "Олена"
  },
  "items": [
    {
      "productId": 101,
      "name": "Клавіатура",
      "quantity": 1,
      "priceCents": 120000
    }
  ],
  "totalCents": 120000
}