Function test_concat_functions

tests/test_aggregation.py:174–184

(db)

@test.requireCapability(dialect=In("postgres", "mssql"))
@pytest.mark.asyncio
async def test_concat_functions(db):
    author = await Author.create(name="Some One")
    await Book.create(name="Physics Book", author=author, rating=4, subject="physics ")
    await Book.create(name="Mathematics Book", author=author, rating=3, subject=" mathematics")
    await Book.create(name="No-subject Book", author=author, rating=3)
    ret = (
        await Book.all()
        .annotate(long_info=Max(Concat("name", "(", Coalesce(Trim("subject"), "others"), ")")))
        .values("long_info")
    )
    assert ret == [{"long_info": "Physics Book(physics)"}]


@pytest.mark.asyncio