From f8a7d417cb916b81cfa685175f3e6afbe6063cee Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sun, 29 Jan 2023 05:44:21 +0300
Subject: SQLite support

---
 src/test/resources/application-sqlite.yml | 11 +++++++++++
 src/test/resources/data-mysql.sql         | 13 -------------
 2 files changed, 11 insertions(+), 13 deletions(-)
 create mode 100644 src/test/resources/application-sqlite.yml
 delete mode 100644 src/test/resources/data-mysql.sql

(limited to 'src/test/resources')

diff --git a/src/test/resources/application-sqlite.yml b/src/test/resources/application-sqlite.yml
new file mode 100644
index 00000000..6a838f13
--- /dev/null
+++ b/src/test/resources/application-sqlite.yml
@@ -0,0 +1,11 @@
+spring:
+  datasource:
+    maxActive: 1
+    type: org.springframework.jdbc.datasource.SimpleDriverDataSource
+    url: jdbc:sqlite:data.db
+  sql:
+    init:
+      separator: ;;
+      platform: sqlite
+      mode: always
+
diff --git a/src/test/resources/data-mysql.sql b/src/test/resources/data-mysql.sql
deleted file mode 100644
index a5db173a..00000000
--- a/src/test/resources/data-mysql.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-INSERT INTO users(id, nick, passw) VALUES(0, 'Anonymous', 'password');
-INSERT INTO users(id, nick, passw) VALUES(2, 'juick', 'password');
-INSERT INTO users(id, nick, passw) VALUES(5, 'archive', 'password');
-INSERT INTO tags(tag_id, name) VALUES(2, 'juick');
-ALTER TABLE tags AUTO_INCREMENT = 10;
-ALTER TABLE users AUTO_INCREMENT = 10;
-INSERT INTO reactions (like_id, description) VALUES (1, 'like');
-INSERT INTO reactions (like_id, description) VALUES (2, 'love');
-INSERT INTO reactions (like_id, description) VALUES (3, 'lol');
-INSERT INTO reactions (like_id, description) VALUES (4, 'hmm');
-INSERT INTO reactions (like_id, description) VALUES (5, 'angry');
-INSERT INTO reactions (like_id, description) VALUES (6, 'uhblya');
-INSERT INTO reactions (like_id, description) VALUES (7, 'ugh');
-- 
cgit v1.2.3