diff options
author | Ngô Ngọc Đức Huy <huyngo@disroot.org> | 2024-04-23 01:19:27 +0700 |
---|---|---|
committer | Ngô Ngọc Đức Huy <huyngo@disroot.org> | 2024-04-23 01:19:27 +0700 |
commit | 40f57ed72a601d8489a180f3bd9acd5e6c20d323 (patch) | |
tree | 6dd84fffd42e809f5123333deb8bb1a366a97cfc /content/posts/2024-01-05-mayim-sqlite.md | |
parent | 2cff39c15ffb512f87ed5f8a2f71603e9ff2d4c7 (diff) | |
download | blog-40f57ed72a601d8489a180f3bd9acd5e6c20d323.tar.gz |
Update theme
Diffstat (limited to 'content/posts/2024-01-05-mayim-sqlite.md')
-rw-r--r-- | content/posts/2024-01-05-mayim-sqlite.md | 5 |
1 files changed, 4 insertions, 1 deletions
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 |