/** * Creates the needed JEVis structure * * @param buildingId building node id, where the structure has to be created * <p>TODO Enable mysql server TODO Add units */ public void createStructure(long buildingId) { ObjectAndBoolean dsd = createObjectCheckNameExistance( buildingId, "Data Source Directory", "Data Source Directory"); ObjectAndBoolean mysqlServer = createObjectCheckNameExistance( dsd.getJEVisObject().getID(), "MySQL Server", "MySQL Server"); if (mysqlServer.isNew) { long id = mysqlServer.getJEVisObject().getID(); writeToJEVis(id, "Schema", _schema); writeToJEVis(id, "User", _dbUser); writeToJEVis(id, "Port", _port); writeToJEVis(id, "Host", _host); writeToJEVis(id, "Password", _dbPW); writeToJEVis(id, "Enabled", true); } ObjectAndBoolean dataDirectory = createObjectCheckNameExistance(buildingId, "Data Directory", "Data Directory"); for (Sensor sensor : _result) { ObjectAndBoolean sqlChannelDir = createObjectCheckNameExistance( mysqlServer.getJEVisObject().getID(), "SQL Channel Directory", sensor.getName() + "_" + sensor.getSymbol()); ObjectAndBoolean channel = createObjectCheckNameExistance( sqlChannelDir.getJEVisObject().getID(), "SQL Channel", "SQL Channel"); if (channel.isNew) { long id = channel.getJEVisObject().getID(); writeToJEVis(id, "Column Timestamp", "time"); writeToJEVis(id, "Column Value", "value"); writeToJEVis(id, "Table", sensor.getTable()); writeToJEVis(id, "Timestamp Format", "yyyy-MM-dd HH:mm:ss.s"); } ObjectAndBoolean sqlDPD = createObjectCheckNameExistance( channel.getJEVisObject().getID(), "SQL Data Point Directory", "DPD"); ObjectAndBoolean sqlDP = createObjectCheckNameExistance(sqlDPD.getJEVisObject().getID(), "SQL Data Point", "DP"); ObjectAndBoolean device = createObjectCheckNameExistance( dataDirectory.getJEVisObject().getID(), "Device", sensor.getName()); if (device.isNew) { long id = device.getJEVisObject().getID(); writeToJEVis(id, "MAC", sensor.getName()); } ObjectAndBoolean data = createObjectCheckNameExistance( device.getJEVisObject().getID(), "Data", sensor.getSymbol()); try { JEVisAttribute attributeValue = data.getJEVisObject().getAttribute("Value"); attributeValue.setDisplayUnit( new JEVisUnitImp(Unit.valueOf(sensor.getUnit()), "", JEVisUnit.Prefix.NONE)); attributeValue.setInputUnit( new JEVisUnitImp(Unit.valueOf(sensor.getUnit()), "", JEVisUnit.Prefix.NONE)); attributeValue.commit(); } catch (JEVisException ex) { Logger.getLogger(WiotechStructureCreator.class.getName()).log(Level.SEVERE, null, ex); } if (data.isNew) { writeToJEVis( sqlDP.getJEVisObject().getID(), "Target", data.getJEVisObject().getID().toString()); } } }