search

barsch / seishub.core

SeisHub - a seismological XML/SQL database hybrid
23 stars 9 forks source link

numeric values of 0.0 in db #9

Closed megies closed 3 years ago

megies commented 10 years ago

When indexing an xml resource, numeric values (e.g. magnitude) of 0.0 get stored as null/None/empty string in db.

megies commented 10 years ago

Ok, it seems to only happen with sqlite (in a test environment of mine):

2014-07-04 15:39:04+0200 [HTTPChannel,3,10.153.82.50] /home/megies/python_seishub/lib/python2.7/site-packages/sqlalchemy/types.py:215: sqlalchemy.exc.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.
barsch commented 3 years ago

wontfix