/**
* 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());
}
}
}
