sqlite doesn't support Decimal objects natively

schireson / pytest-mock-resources

Pytest Fixtures that let you actually test against external resource (Postgres, Mongo, Redshift...) dependent code.

MIT License

183 stars 19 forks source link

Closed DanCardin closed 5 years ago

DanCardin commented 5 years ago

It emits this warning every time you try to persist a Decimal object. Options include:

silence the warning and live with the potential for rounding errors (which i think is fine honestly)
transparently swap Numeric column types that would accept decimals to string type columns, while making sure that it otherwise acts the same with filters, comparisons, inserts and whatnot.

langelgjm commented 5 years ago

I vote for 1. I feel like if you care about rounding errors you're either doing testing wrong or shouldn't be using SQLite...

oakhan3 commented 5 years ago