example quickcharts : app:Exception on /countrygroupbychartview/chart/

[LeiYangGH]

Environment

windows 11, also reproduced in ubuntu 20

Flask-Appbuilder version:

4.5.0

pip freeze output:

aliyun-python-sdk-core==2.13.36
aliyun-python-sdk-kms==2.16.1
apispec==6.6.1
appdirs==1.4.4
async-timeout==4.0.3
atomicwrites==1.4.0
attrs==21.2.0
azure-core==1.24.2
azure-identity==1.10.0
Babel==2.15.0
bcrypt==4.0.1
blinker==1.6.2
Brotli==1.1.0
cachelib==0.9.0
cachetools==4.2.4
cattrs==1.9.0
cerence @ file:///C:/GL/ncs/tts/mobility-ncs-tts-tools/cerence-tts-oc2-proto-python
certifi==2021.10.8
cffi==1.15.1
charset-normalizer==2.0.7
click==8.1.4
colorama==0.4.6
ConfigArgParse==1.7
crcmod==1.7
cryptography==37.0.4
dataclasses-json==0.6.7
deepmerge==1.1.0
Deprecated==1.2.14
dnspython==2.6.1
dohq-artifactory==0.7.742
email_validator==2.2.0
et-xmlfile==1.1.0
exceptiongroup==1.1.3
Faker==18.7.0
filelock==3.0.4
Flask==2.3.2
Flask-AppBuilder==4.5.0
Flask-Babel==2.0.0
Flask-BasicAuth==0.2.0
Flask-Caching==2.3.0
Flask-Cors==4.0.0
Flask-JSON==0.4.0
Flask-JWT-Extended==4.6.0
Flask-Limiter==3.7.0
Flask-Login==0.6.3
Flask-SQLAlchemy==2.5.1
Flask-WTF==1.2.1
future==0.18.3
gevent==24.2.1
geventhttpclient==2.0.11
gitdb==4.0.9
GitPython==3.1.24
google-api-core==2.8.2
google-api-python-client==2.51.0
google-auth==2.3.2
google-auth-httplib2==0.1.0
googleapis-common-protos==1.56.2
greenlet==3.0.3
grpcio==1.46.3
grpcio-tools==1.46.3
httplib2==0.20.1
idna==3.3
importlib-metadata==4.12.0
importlib-resources==5.10.0
iniconfig==1.1.1
itsdangerous==2.1.2
Jinja2==3.1.2
jmespath==0.10.0
jsonschema==4.16.0
kubernetes==19.15.0
limits==3.13.0
locust==2.18.4
lxml==4.6.3
markdown-it-py==3.0.0
MarkupSafe==2.1.1
marshmallow==3.21.3
marshmallow-sqlalchemy==0.28.2
mdurl==0.1.2
msal==1.18.0
msal-extensions==1.0.0
msgpack==1.0.8
mypy-extensions==1.0.0
natsort==8.3.1
netmiko==4.2.0
nlu-spec-extract @ file:///C:/GL/ncs/tts/onecloud2.0/qa/nlu-spec-extract
ntc_templates==4.0.1
numpy==1.21.4
oauthlib==3.1.1
openpyxl==3.1.2
ordered-set==4.1.0
orjson==3.10.5
oss2==2.18.0
packaging==21.3
pandas==1.3.4
paramiko==3.3.1
pkgutil_resolve_name==1.3.10
pluggy==1.0.0
portalocker==2.5.1
prison==0.2.1
protobuf==3.20.1
psutil==5.9.8
py==1.11.0
pyasn1==0.4.8
pyasn1-modules==0.2.8
PyAudio @ file:///C:/NuanTools/py_tts/PyAudio-0.2.11-cp38-cp38-win32.whl
pycparser==2.21
pycryptodome==3.18.0
pygame==2.1.2
Pygments==2.18.0
PyJWT==2.8.0
PyMuPDF==1.23.3
PyMuPDFb==1.23.3
PyMySQL==1.1.0
PyNaCl==1.5.0
PyOgg @ file:///C:/G/PyOgg
pyparsing==2.4.7
pyproj==3.5.0
pyrsistent==0.18.1
pyserial==3.5
pytest==7.4.0
pytest-datadir==1.4.1
pytest-html==3.2.0
pytest-metadata==2.0.4
python-dateutil==2.8.2
python-gitlab==3.15.0
python-Levenshtein==0.12.2
pytz==2021.3
pywin32==304
PyYAML==6.0
pyzmq==25.1.2
qa @ file:///C:/GL/ncs/tts/onecloud2.0/qa/qa
redis==5.0.1
redlock-py==1.0.8
requests==2.26.0
requests-cache==0.8.1
requests-oauthlib==1.3.0
requests-toolbelt==1.0.0
rich==13.7.1
roundrobin==0.0.4
rsa==4.7.2
rsqa @ file:///C:/GL/ncs/tts/onecloud2.0/qa/rsqa
scp==0.14.5
six==1.16.0
smmap==5.0.0
sounddevice==0.4.6
soundfile==0.12.1
SQLAlchemy==1.4.52
SQLAlchemy-Utils==0.41.2
teamcity-messages==1.21
textfsm==1.1.3
thefuzz==0.19.0
tinydb==4.6.1
tomli==2.0.1
tts-grpc-python-client @ file:///C:/GL/ncs/tts/mobility-ncs-tts-tools/tts-grpc-python-client
typing-inspect==0.9.0
typing_extensions==4.3.0
uritemplate==4.1.1
url-normalize==1.4.3
urllib3==1.26.7
websocket-client==1.2.1
Werkzeug==2.3.6
wrapt==1.16.0
WTForms==3.1.2
xhlib @ file:///C:/G/xhlib
xmltodict==0.12.0
yamale==4.0.2
zhconv==1.4.3
zipp==3.8.1
zope.event==5.0
zope.interface==6.2

Describe the expected results

when running examples/quickcharts, other views can display but countrygroupbychartview/chart/ throw exception,

the web page http://127.0.0.1:5000/countrygroupbychartview/chart/ shows:

Internal Server Error
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

The terminal says:

2024-06-27 09:30:16,662:INFO:werkzeug:127.0.0.1 - - [27/Jun/2024 09:30:16] "GET /static/appbuilder/js/ab.js HTTP/1.1" 304 -
2024-06-27 09:30:17,939:ERROR:app:Exception on /countrygroupbychartview/chart/ [GET]
Traceback (most recent call last):
File "C:\pv\tts\lib\site-packages\flask\app.py", line 2190, in wsgi_app
response = self.full_dispatch_request()
File "C:\pv\tts\lib\site-packages\flask\app.py", line 1486, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\pv\tts\lib\site-packages\flask\app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
File "C:\pv\tts\lib\site-packages\flask\app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "C:\pv\tts\lib\site-packages\flask_appbuilder\security\decorators.py", line 137, in wraps
return f(self, *args, **kwargs)
File "C:\pv\tts\lib\site-packages\flask_appbuilder\charts\views.py", line 200, in chart
widgets = self._get_chart_widget(
File "C:\pv\tts\lib\site-packages\flask_appbuilder\charts\views.py", line 179, in _get_chart_widget
group.apply(lst, sort=order_column == ""), self.label_columns
File "C:\pv\tts\lib\site-packages\flask_appbuilder\models\group.py", line 343, in apply
data = sorted(data, key=self.attrgetter(*self.group_bys_cols))
TypeError: '<' not supported between instances of 'Country' and 'Country'
2024-06-27 09:30:17,948:INFO:werkzeug:127.0.0.1 - - [27/Jun/2024 09:30:17] "GET /countrygroupbychartview/chart/ HTTP/1.1" 500 -

Tell us what should happen.

All example pages should open successfully.

[ThomasP0815]

related to #1674
change country to country.name