Test mysql & sqlite

First off: This commit set changes the default development database backend to mysql. sqlite, however, is still completely supported with the caveat that a user must now modify config.dev to use the sqlite backend.

While looking into this, it was discovered that our SQLAlchemy backend for mysql (mysql-connector) completely broke model attributes when we switched to utf8mb4_bin (binary) -- it does not correct the correct conversion to and from binary utf8mb4.

The new, replacement dependency mysqlclient does. mysqlclient is also recommended in SQLAlchemy documentation as the "best" one available.

The mysqlclient backend uses a different exception flow then sqlite, and so models now raise IntegrityError when it finds problematic nulls (to centralize the exception logic).

In addition, now mysql and sqlite are both tested in CI. Docker hasn't been modified yet due to incoming changes to its config.

added database python scopebug labels

changed the description

added 4 commits

• e2ea7948 - use mysql backend in config.dev
• 38e26084 - fix aurweb.auth test coverage
• c39f6ddc - fix test_accounts_routes test coverage
• 8c6874ec - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

added 4 commits

• 232774a9 - use mysql backend in config.dev
• 93b7adfa - fix aurweb.auth test coverage
• 807a2ec5 - fix test_accounts_routes test coverage
• b5a1d655 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

added 4 commits

• 04ba85c4 - use mysql backend in config.dev
• b39f9be8 - fix aurweb.auth test coverage
• 7100b25b - fix test_accounts_routes test coverage
• db016733 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

added 4 commits

• 7e53a807 - use mysql backend in config.dev
• 12bcf234 - fix aurweb.auth test coverage
• 25a8d628 - fix test_accounts_routes test coverage
• 9c4b6693 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

changed the description

added 4 commits

• d423e0c6 - use mysql backend in config.dev
• 6cdad5ea - fix aurweb.auth test coverage
• c9bbc72d - fix test_accounts_routes test coverage
• 8d7726f9 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

requested review from @lfleischer

added 1 commit

• d6a21f33 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

resolved all threads

added 1 commit

• 75af2ec9 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

requested review from @jocke-l

added 81 commits

• 75af2ec9...d7481b96 - 77 commits from branch archlinux:pu
• aecb6494 - use mysql backend in config.dev
• 228bc8fe - fix aurweb.auth test coverage
• 62e58b12 - fix test_accounts_routes test coverage
• 4d1faca4 - test both mysql and sqlite in .gitlab-ci.yml

Compare with previous version

Merge inc.

merged