Skip to content
This repository was archived by the owner on Aug 19, 2025. It is now read-only.

Implement order by #70

Merged
aminalaee merged 12 commits into from
Aug 24, 2021
Merged

Implement order by #70

Changes from 1 commit
Commits
Show all changes
12 commits
Select commit Hold shift + click to select a range
f55003f
Implement order by
Jul 31, 2020
4e0f960
Merge branch 'master' into implement-order-by
aminalaee Aug 19, 2021
559f023
format fix
aminalaee Aug 19, 2021
63637de
fix imports
aminalaee Aug 19, 2021
55a9dd6
minor cleanups
aminalaee Aug 19, 2021
97eefa1
try different `async_adapter`
aminalaee Aug 20, 2021
89657f8
revert async_adapter
aminalaee Aug 20, 2021
7ba7337
add python3.8
aminalaee Aug 20, 2021
9f0e8dc
Update README.md
aminalaee Aug 20, 2021
8a42004
Update models.py
aminalaee Aug 21, 2021
4251839
add tests
aminalaee Aug 21, 2021
5325aae
Merge branch 'master' into implement-order-by
aminalaee Aug 24, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
add tests
  • Loading branch information
@aminalaee
aminalaee committed Aug 21, 2021
commit 4251839ad351d4a56b4b7d453460e958d1e71270
40 changes: 18 additions & 22 deletions tests/test_models.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -177,41 +177,37 @@ async def test_model_filter():
@async_adapter
async def test_model_order_by():
async with database:
await User.objects.create(name="Tom")
await User.objects.create(name="Bob")
await User.objects.create(name="Allen")
await User.objects.create(name="Bob")

users = await User.objects.order_by("name").all()
assert len(users) == 3
assert users[0].name == "Allen"
assert users[1].name == "Bob"
assert users[2].name == "Tom"


@async_adapter
async def test_model_order_by_desc():
async with database:
await User.objects.create(name="Tom")
await User.objects.create(name="Allen")
await User.objects.create(name="Bob")
users = await User.objects.order_by("-name").all()
assert len(users) == 3
assert users[0].name == "Tom"
assert users[1].name == "Bob"
assert users[2].name == "Allen"


@async_adapter
async def test_model_order_by_multi():
async with database:
await User.objects.create(name="Tom")
await User.objects.create(name="Tom")
await User.objects.create(name="Allen")
users = await User.objects.order_by("name", "-id").all()
assert len(users) == 3
assert users[0].name == "Allen"
assert users[0].id == 2
assert users[1].name == "Bob"
assert users[1].id == 3

users = await User.objects.filter(name="Bob").order_by("-id").all()
assert users[0].name == "Bob"
assert users[0].id == 3
assert users[1].name == "Tom"
assert users[1].id == 2
assert users[1].name == "Bob"
assert users[1].id == 1

users = await User.objects.order_by("id").limit(1).all()
assert users[0].name == "Bob"
assert users[0].id == 1

users = await User.objects.order_by("id").limit(1).offset(1).all()
assert users[0].name == "Allen"
assert users[0].id == 2


@async_adapter
Expand Down