@Override int doWork() { try (DbConn cnx = Helpers.getNewDbSession()) { jqmlogger.info("Existing nodes: " + MetaService.getNodes(cnx).size()); return 0; } catch (Exception e) { jqmlogger.error("Could not fetch node count", e); return 111; } } }
private static void count() { DbConn cnx = null; try { cnx = Helpers.getNewDbSession(); jqmlogger.info("Existing nodes: " + MetaService.getNodes(cnx).size()); } catch (Exception e) { throw new JqmRuntimeException("Could not fetch node count", e); } finally { Helpers.closeQuietly(cnx); } } }
@Override int doWork() { if (!Helpers.isDbInitialized()) { jqmlogger.info("Database connector initialization"); Properties p = Db.loadProperties(); p.setProperty("com.enioka.jqm.jdbc.allowSchemaUpdate", "true"); Db db = new Db(p); Helpers.setDb(db); } try (DbConn cnx = Helpers.getNewDbSession()) { Helpers.updateConfiguration(cnx); cnx.commit(); jqmlogger.info("Upgrade done"); jqmlogger.info("Existing nodes: " + MetaService.getNodes(cnx).size()); return 0; } catch (Exception e) { jqmlogger.error("Could not upgrade", e); return 101; } } }
private static void upgrade() { DbConn cnx = null; try { if (!Helpers.isDbInitialized()) { Properties p = Db.loadProperties(); p.setProperty("com.enioka.jqm.jdbc.allowSchemaUpdate", "true"); Db db = new Db(p); Helpers.setDb(db); } cnx = Helpers.getNewDbSession(); Helpers.updateConfiguration(cnx); cnx.commit(); jqmlogger.info("Upgrade done"); jqmlogger.info("Existing nodes: " + MetaService.getNodes(cnx).size()); } catch (Exception e) { throw new JqmRuntimeException("Could not upgrade", e); } finally { Helpers.closeQuietly(cnx); } }
public static void syncNodes(DbConn cnx, List<NodeDto> dtos) { for (NodeDto existing : getNodes(cnx)) { boolean foundInNewSet = false; for (NodeDto newdto : dtos) { if (newdto.getId() != null && newdto.getId().equals(existing.getId())) { foundInNewSet = true; break; } } if (!foundInNewSet) { deleteQueue(cnx, existing.getId()); } } for (NodeDto dto : dtos) { upsertNode(cnx, dto); } }
public static void syncNodes(DbConn cnx, List<NodeDto> dtos) { for (NodeDto existing : getNodes(cnx)) { boolean foundInNewSet = false; for (NodeDto newdto : dtos) { if (newdto.getId() != null && newdto.getId().equals(existing.getId())) { foundInNewSet = true; break; } } if (!foundInNewSet) { deleteQueue(cnx, existing.getId()); } } for (NodeDto dto : dtos) { upsertNode(cnx, dto); } }