[DB] SQLAlchemy SQLite Decimal Warnings
SQLAlchemy complains about SQLite's compatibility with the Decimal(n, p) type. It does not support Decimal floating point values, and Integers or Strings are recommended.
However, this creates a bit of an issue, because we can not uniformly deal with all database types we support.
Of course, SQLite is mostly used for testing in this project, while producting uses MySQLd, but SQLite can be used in any case, so we should fix this in some way.
Example warning:
test/test_account_type.py::test_user_account_type_relationship
/home/kevr/dev/aurweb/aurweb/db.py:77: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.
session.commit()