Fix MTIME handling accross multiple backends

Authored by dvratil on Sep 8 2016, 10:33 AM.

Description

Fix MTIME handling accross multiple backends

MySQL and PSQL don't support milliseconds in datetime columns, so
we need to strip milliseconds in STORE response before sending it
back, otherwise the MTIME send by STORE does not match MTIME of a
separately fetched from the database.

Secondly, MySQL and SQLite QtSql drivers assume that the datetime
stored in DB is local time (even though we stored as UTC), while
PSQL driver assumes it's UTC and converts to local time, so we
need to handle this separetly for each backend.

Details

Committed
dvratilSep 8 2016, 10:33 AM
Parents
R165:f918dafea123: AkAppend: don't do UPDATE when nothing changed
Branches
Unknown
Tags
Unknown