From d97bfe93f5f886ec4e85e0ac71889942d76511f8 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Thu, 1 Sep 2016 16:51:24 +0300
Subject: juick-demo: fill some data for test purposes

---
 juick-demo/src/main/java/com/juick/demo/Demo.java | 39 +++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 juick-demo/src/main/java/com/juick/demo/Demo.java

(limited to 'juick-demo/src')

diff --git a/juick-demo/src/main/java/com/juick/demo/Demo.java b/juick-demo/src/main/java/com/juick/demo/Demo.java
new file mode 100644
index 00000000..6940bfd0
--- /dev/null
+++ b/juick-demo/src/main/java/com/juick/demo/Demo.java
@@ -0,0 +1,39 @@
+package com.juick.demo;
+
+import com.juick.Tag;
+import com.juick.server.MessagesQueries;
+import com.juick.server.PMQueries;
+import com.juick.server.TagQueries;
+import com.juick.server.UserQueries;
+import org.springframework.jdbc.core.JdbcTemplate;
+import org.springframework.jdbc.datasource.DriverManagerDataSource;
+
+import java.util.ArrayList;
+import java.util.logging.Logger;
+
+/**
+ * Created by vitalyster on 30.08.2016.
+ */
+public class Demo {
+    private static final Logger logger = Logger.getLogger(Demo.class.getName());
+    public static void main(String ...args) {
+        DriverManagerDataSource dataSource = new DriverManagerDataSource("jdbc:mysql://localhost/juick?user=root");
+        JdbcTemplate jdbc = new JdbcTemplate(dataSource);
+        logger.info("initializing demo database");
+
+        Integer ugnich_id = UserQueries.createUser(jdbc, "ugnich", "secret");
+        Integer ugn_mid = MessagesQueries.createMessage(jdbc, ugnich_id, "Hi, I am ugnich", null,
+                new ArrayList<Tag>() {{add(TagQueries.getTag(jdbc, "yo", true)); add(TagQueries.getTag(jdbc, "people", true));}});
+
+        Integer juick_id = UserQueries.createUser(jdbc, "juick", "secret");
+        MessagesQueries.createMessage(jdbc, juick_id, "New demo juick was created", null,
+                new ArrayList<Tag>() {{add(TagQueries.getTag(jdbc, "yo", true)); add(TagQueries.getTag(jdbc, "readonly", true));}});
+        Integer freefd_id = UserQueries.createUser(jdbc, "freefd", "secret");
+        MessagesQueries.createReply(jdbc, ugn_mid, 0, freefd_id, "I am freefd and this is my reply", null);
+        MessagesQueries.recommendMessage(jdbc, ugn_mid, freefd_id);
+        MessagesQueries.recommendMessage(jdbc, ugn_mid, juick_id);
+        MessagesQueries.setMessagePopular(jdbc, ugn_mid, 1);
+        PMQueries.createPM(jdbc, freefd_id, ugnich_id, "Hi ugnich!");
+        jdbc.execute("UPDATE tags SET top=1");
+    }
+}
-- 
cgit v1.2.3