Store timestamp in milliseconds when using SQLite

1 files changed, 1 insertions, 2 deletions

diff --git a/src/test/java/com/juick/server/tests/ServerTests.java b/src/test/java/com/juick/server/tests/ServerTests.java
index 62f50b12..4cbc30b5 100644
--- a/src/test/java/com/juick/server/tests/ServerTests.java
+++ b/src/test/java/com/juick/server/tests/ServerTests.java
@@ -1779,7 +1779,6 @@ public class ServerTests {
 
     @Test
     @Order(20)
-    @Disabled("Failed on SQLite")
     public void discussionsShouldBePageableByTimestamp() throws Exception {
         String msgText = "Привет, я снова Угнич";
         int mid = messagesService.createMessage(ugnich.getUid(), msgText, null, Set.of());
@@ -2622,7 +2621,7 @@ public class ServerTests {
                 "SELECT COUNT(*) FROM auth WHERE user_id=?", Integer.class, ugnich.getUid());
         assertThat(count, is(1));
         var timestamp = Instant.now().minus(3, ChronoUnit.DAYS).atOffset(ZoneOffset.UTC);
-        jdbcTemplate.update("UPDATE auth SET ts=? WHERE user_id=?", timestamp, ugnich.getUid());
+        jdbcTemplate.update("UPDATE auth SET ts=? WHERE user_id=?", ((EmailServiceImpl)emailService).toDateTime(timestamp), ugnich.getUid());
         emailService.cleanupAuthCodes();
         count = jdbcTemplate.queryForObject(
                 "SELECT COUNT(*) FROM auth WHERE user_id=?", Integer.class, ugnich.getUid());