From 40f57ed72a601d8489a180f3bd9acd5e6c20d323 Mon Sep 17 00:00:00 2001 From: Ngô Ngọc Đức Huy Date: Tue, 23 Apr 2024 01:19:27 +0700 Subject: Update theme --- content/posts/2024-01-05-mayim-sqlite.md | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'content/posts/2024-01-05-mayim-sqlite.md') diff --git a/content/posts/2024-01-05-mayim-sqlite.md b/content/posts/2024-01-05-mayim-sqlite.md index 3ce666a..a151bfe 100644 --- a/content/posts/2024-01-05-mayim-sqlite.md +++ b/content/posts/2024-01-05-mayim-sqlite.md @@ -182,7 +182,10 @@ GROUP BY product.id; Running that would result in rows with duplicated categories like: ```python -Product(id=1, name='energy drink', prices=[Price(id=1, unit='bottle', price=12000), Price(id=2, unit='packets', price=70000)], categories=['drink', 'drink']), +Product(id=1, name='energy drink', + prices=[Price(id=1, unit='bottle', price=12000), + Price(id=2, unit='packets', price=70000)], + categories=['drink', 'drink']), ``` This is because I joined three tables at once, and the categories are repeated -- cgit 1.4.1