@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
RequestDispatcher dispatcher;
Map<Integer, Integer> mapUserId = new TreeMap<>();
Map<Integer, Integer> mapMessageId = new TreeMap<>();
Map<Integer, String> mapMessageBody = new TreeMap<>();
switch (request.getServletPath()) {
case "/importar":
String url = request.getParameter("url");
Pacote pacote = importFromURL(url);
try {
// DELETA DADOS DO SERVIDOR
PreparedStatement stmt =
(new ActiveRecord())
.conn.prepareStatement(
"DELETE FROM \"user\" WHERE server_id = "
+ pacote.id_servidor
+ ";"
+ "DELETE FROM \"message\" WHERE server_id = "
+ pacote.id_servidor
+ ";"
+ "DELETE FROM \"comment\" WHERE server_id = "
+ pacote.id_servidor
+ ";"
+ "DELETE FROM \"like\" WHERE server_id = "
+ pacote.id_servidor
+ ";");
stmt.execute();
// IMPORTAR
// USER
User user;
for (UsuarioJSON usuario : pacote.usuarios) {
user = new User();
user.setLogin(usuario.login + "_" + pacote.id_servidor);
user.setName(usuario.nome);
user.setBirth(new Date(usuario.nascimento.getTime()));
user.setDescription(usuario.descricao);
user.setServer_id(pacote.id_servidor);
user.setPassword("senha");
user.save(true);
mapUserId.put(usuario.id, user.getId());
}
// MESSAGE
Message message;
for (PostJSON post : pacote.posts) {
message = new Message();
message.setBody(post.conteudo);
message.setMessage_date(new Timestamp(post.data.getTime()));
message.setUser_id(mapUserId.get(post.id_usuario));
message.setOriginal_user_id(mapUserId.get(post.id_usuario));
message.setServer_id(pacote.id_servidor);
message.save(true);
mapMessageId.put(post.id, message.getId());
mapMessageBody.put(post.id, post.conteudo);
}
// MESSAGE (REPOST)
for (RepostJSON post : pacote.reposts) {
message = new Message();
message.setBody(mapMessageBody.get(post.id_post));
message.setMessage_date(new Timestamp(post.data.getTime()));
message.setUser_id(mapUserId.get(post.id_usuario));
message.setOriginal_user_id(mapUserId.get(post.id_usuario));
message.setOriginal_message_id(mapMessageId.get(post.id_post));
message.setServer_id(pacote.id_servidor);
message.save(true);
mapMessageId.put(post.id, message.getId());
}
// COMMENT
Comment comment;
for (ComentarioJSON comentario : pacote.comentarios) {
comment = new Comment();
comment.setBody(comentario.conteudo);
comment.setUser_id(mapUserId.get(comentario.id_usuario));
comment.setMessage_id(mapMessageId.get(comentario.id_post));
comment.setServer_id(pacote.id_servidor);
comment.save();
}
// LIKE
Like like;
for (LikeJSON likejson : pacote.likes) {
like = new Like();
like.setMessage_id(mapMessageId.get(likejson.id_post));
like.setUser_id(mapUserId.get(likejson.id_usuario));
like.setValue(1);
like.setServer_id(pacote.id_servidor);
like.save();
}
// LIKE (DISLIKE)
for (DislikeJSON likejson : pacote.dislikes) {
like = new Like();
like.setMessage_id(mapMessageId.get(likejson.id_post));
like.setUser_id(mapUserId.get(likejson.id_usuario));
like.setValue(-1);
like.setServer_id(pacote.id_servidor);
like.save();
}
} catch (SQLException ex) {
Logger.getLogger(WebserviceController.class.getName()).log(Level.SEVERE, null, ex);
} catch (Exception ex) {
Logger.getLogger(WebserviceController.class.getName()).log(Level.SEVERE, null, ex);
}
try (PrintWriter out = response.getWriter()) {
gson.toJson(pacote, out);
}
// dispatcher = request.getRequestDispatcher("/views/import/index.jsp");
// dispatcher.forward(request, response);
break;
}
}
