diff options
| author |  Vitaly Takmazov | 2023-01-28 01:46:13 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-01-28 19:07:28 +0300 |
| commit | 556d10c400add4b69d8832a40fb704fda4333080 (patch) | |
| tree | 4b19255566ada761ddd23baa66c695906329f1a8 /src/test | |
| parent | 906bf8ef21463f99820764807b656cb617b0aaa2 (diff) | |
Improve SQL server compatibility
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/java/com/juick/server/tests/ServerTests.java | 2 | ||||
| -rw-r--r-- | src/test/resources/application-sqlserver.yml | 12 |
2 files changed, 13 insertions, 1 deletions
diff --git a/src/test/java/com/juick/server/tests/ServerTests.java b/src/test/java/com/juick/server/tests/ServerTests.java index d695ffb8..ea1e6100 100644 --- a/src/test/java/com/juick/server/tests/ServerTests.java +++ b/src/test/java/com/juick/server/tests/ServerTests.java @@ -1599,7 +1599,7 @@ public class ServerTests { assertThat(messagesService.recommendMessage(mid, pogo.getUid()), is(MessagesService.RecommendStatus.Added)); jdbcTemplate.update("INSERT INTO favorites(user_id, user_uri, message_id, like_id, ts) " - + "values (0, 'http://example.com/u/test', ?, 1, now())", mid); + + "values (0, 'http://example.com/u/test', ?, 1, ?)", mid, Date.from(Instant.now())); assertThat(messagesService.getMessage(mid).get().getRecommendations().size(), is(4)); assertThat(CollectionUtils.isEqualCollection( messagesService.getMessagesRecommendations(Collections.singletonList(mid)).stream() diff --git a/src/test/resources/application-sqlserver.yml b/src/test/resources/application-sqlserver.yml new file mode 100644 index 00000000..f195bcae --- /dev/null +++ b/src/test/resources/application-sqlserver.yml @@ -0,0 +1,12 @@ +spring: + datasource: + url: jdbc:sqlserver://localhost:1433;databaseName=tempdb;encrypt=false;SelectMethod=Cursor + username: sa + password: Passw00rd! + flyway: + baseline-on-migrate: true + sql: + init: + platform: sqlserver + mode: always + |