From fbc5c1330679b12b09c6d970ee1750fa83f4cac4 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sun, 29 Jan 2023 00:45:31 +0300
Subject: Move postgres db initialization to tests

---
 src/test/resources/db/migration/V1.999__data.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 src/test/resources/db/migration/V1.999__data.sql

(limited to 'src/test/resources/db/migration/V1.999__data.sql')

diff --git a/src/test/resources/db/migration/V1.999__data.sql b/src/test/resources/db/migration/V1.999__data.sql
new file mode 100644
index 00000000..673b24d2
--- /dev/null
+++ b/src/test/resources/db/migration/V1.999__data.sql
@@ -0,0 +1,13 @@
+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 sequence tags_tag_id_seq restart with 10;
+alter sequence users_id_seq restart with 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