test_basic.py

async def test_log_action(service_client, pgsql, mockserver):
    @mockserver.handler('/v1/action')
    def _mock(request):
        assert request.get_data() == b'test_1', f'Actual data is {request.get_data()}'
        return mockserver.make_response()
 
    response = await service_client.post('/log?action=test_1')
    assert response.status == 200
 
    # '0_db_schema.sql' is created by `db_dump_schema_path` fixture, so the database is '0_db_schema'
    cursor = pgsql['0_db_schema'].cursor()
    cursor.execute('SELECT action FROM events_table WHERE id=1')
    result = cursor.fetchall()
    assert len(result) == 1
    assert result[0][0] == 'test_1'