private void writeObject(ObjectOutputStream out) throws IOException {
   out.writeInt(version);
   out.writeObject(textRenderer);
   out.writeObject(chartRenderer);
   out.writeObject(pointLocator);
   out.writeDouble(discardLowLimit);
   out.writeDouble(discardHighLimit);
   SerializationHelper.writeSafeUTF(out, chartColour);
   out.writeInt(plotType);
 }
 public DataSourceVO<?> mapRow(ResultSet rs, int rowNum) throws SQLException {
   DataSourceVO<?> ds =
       (DataSourceVO<?>)
           SerializationHelper.readObjectInContext(rs.getBlob(5).getBinaryStream());
   ds.setId(rs.getInt(1));
   ds.setXid(rs.getString(2));
   ds.setName(rs.getString(3));
   ds.setDefinition(ModuleRegistry.getDataSourceDefinition(rs.getString(4)));
   return ds;
 }
Exemple #3
0
  private void updatePoints() {
    // Get the points
    List<DataPointVO> dps =
        query(
            "select dp.id, dp.xid, dp.dataSourceId, dp.data, ds.name, " //
                + "ds.xid, ds.dataSourceType " //
                + "from dataPoints dp join dataSources ds on ds.id = dp.dataSourceId ",
            new DataPointRowMapper());

    // Resave
    for (DataPointVO dp : dps)
      ejt.update(
          "update dataPoints set xid=?, name=?, deviceName=?, enabled=?, loggingType=?, " //
              + "intervalLoggingPeriodType=?, intervalLoggingPeriod=?, intervalLoggingType=?, " //
              + "tolerance=?, purgeType=?, purgePeriod=?, defaultCacheSize=?, discardExtremeValues=?, " //
              + "engineeringUnits=?, data=? where id=?", //
          new Object[] {
            dp.getXid(),
            dp.getName(),
            dp.getDeviceName(),
            boolToChar(dp.isEnabled()),
            dp.getLoggingType(),
            dp.getIntervalLoggingPeriodType(),
            dp.getIntervalLoggingPeriod(),
            dp.getIntervalLoggingType(),
            dp.getTolerance(),
            dp.getPurgeType(),
            dp.getPurgePeriod(),
            dp.getDefaultCacheSize(),
            boolToChar(dp.isDiscardExtremeValues()),
            dp.getEngineeringUnits(),
            SerializationHelper.writeObject(dp),
            dp.getId()
          }, //
          new int[] {
            Types.VARCHAR,
            Types.VARCHAR,
            Types.VARCHAR,
            Types.CHAR,
            Types.INTEGER,
            Types.INTEGER,
            Types.INTEGER,
            Types.INTEGER,
            Types.DOUBLE,
            Types.INTEGER,
            Types.INTEGER,
            Types.INTEGER,
            Types.CHAR,
            Types.INTEGER,
            Types.BLOB,
            Types.INTEGER
          });
  }
 public void _updateDataSource(DataSourceVO<?> vo) {
   ejt.update(
       "update dataSources set xid=?, name=?, dataSourceType=?, data=? where id=?",
       new Object[] {
         vo.getXid(),
         vo.getName(),
         vo.getDefinition().getDataSourceTypeName(),
         SerializationHelper.writeObject(vo),
         vo.getId()
       },
       new int[] {Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.BLOB, Types.INTEGER});
 }
  private void insertDataSource(final DataSourceVO<?> vo) {
    vo.setId(
        doInsert(
            "insert into dataSources (xid, name, dataSourceType, data) values (?,?,?,?)",
            new Object[] {
              vo.getXid(),
              vo.getName(),
              vo.getDefinition().getDataSourceTypeName(),
              SerializationHelper.writeObject(vo)
            },
            new int[] {Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.BLOB}));

    AuditEventType.raiseAddedEvent(AuditEventType.TYPE_DATA_SOURCE, vo);
  }
Exemple #6
0
    @Override
    public DataPointVO mapRow(ResultSet rs, int rowNum) throws SQLException {
      DataPointVO dp =
          (DataPointVO) SerializationHelper.readObjectInContext(rs.getBlob(4).getBinaryStream());
      dp.setId(rs.getInt(1));
      dp.setXid(rs.getString(2));
      dp.setDataSourceId(rs.getInt(3));

      // Data source information.
      dp.setDataSourceName(rs.getString(5));
      dp.setDataSourceXid(rs.getString(6));
      dp.setDataSourceTypeName(rs.getString(7));

      return dp;
    }
  private void readObject(ObjectInputStream in) throws IOException, ClassNotFoundException {
    int ver = in.readInt();

    // Switch on the version of the class so that version changes can be elegantly handled.
    if (ver == 1) {
      name = SerializationHelper.readSafeUTF(in);
      deviceName = null;
      enabled = in.readBoolean();
      loggingType = in.readInt();
      intervalLoggingPeriodType = in.readInt();
      intervalLoggingPeriod = in.readInt();
      intervalLoggingType = in.readInt();
      tolerance = in.readDouble();
      purgeOverride = true;
      purgeType = in.readInt();
      purgePeriod = in.readInt();
      textRenderer = (TextRenderer) in.readObject();
      chartRenderer = (ChartRenderer) in.readObject();
      pointLocator = (PointLocatorVO) in.readObject();
      defaultCacheSize = in.readInt();
      discardExtremeValues = in.readBoolean();
      discardLowLimit = in.readDouble();
      discardHighLimit = in.readDouble();
      engineeringUnits = in.readInt();
      chartColour = null;
      plotType = PlotTypes.STEP;
    } else if (ver == 2) {
      name = SerializationHelper.readSafeUTF(in);
      deviceName = null;
      enabled = in.readBoolean();
      loggingType = in.readInt();
      intervalLoggingPeriodType = in.readInt();
      intervalLoggingPeriod = in.readInt();
      intervalLoggingType = in.readInt();
      tolerance = in.readDouble();
      purgeOverride = true;
      purgeType = in.readInt();
      purgePeriod = in.readInt();
      textRenderer = (TextRenderer) in.readObject();
      chartRenderer = (ChartRenderer) in.readObject();
      pointLocator = (PointLocatorVO) in.readObject();
      defaultCacheSize = in.readInt();
      discardExtremeValues = in.readBoolean();
      discardLowLimit = in.readDouble();
      discardHighLimit = in.readDouble();
      engineeringUnits = in.readInt();
      chartColour = SerializationHelper.readSafeUTF(in);
      plotType = PlotTypes.STEP;
    } else if (ver == 3) {
      name = SerializationHelper.readSafeUTF(in);
      deviceName = SerializationHelper.readSafeUTF(in);
      enabled = in.readBoolean();
      loggingType = in.readInt();
      intervalLoggingPeriodType = in.readInt();
      intervalLoggingPeriod = in.readInt();
      intervalLoggingType = in.readInt();
      tolerance = in.readDouble();
      purgeOverride = true;
      purgeType = in.readInt();
      purgePeriod = in.readInt();
      textRenderer = (TextRenderer) in.readObject();
      chartRenderer = (ChartRenderer) in.readObject();
      pointLocator = (PointLocatorVO) in.readObject();
      defaultCacheSize = in.readInt();
      discardExtremeValues = in.readBoolean();
      discardLowLimit = in.readDouble();
      discardHighLimit = in.readDouble();
      engineeringUnits = in.readInt();
      chartColour = SerializationHelper.readSafeUTF(in);
      plotType = PlotTypes.STEP;
    } else if (ver == 4) {
      name = SerializationHelper.readSafeUTF(in);
      deviceName = SerializationHelper.readSafeUTF(in);
      enabled = in.readBoolean();
      loggingType = in.readInt();
      intervalLoggingPeriodType = in.readInt();
      intervalLoggingPeriod = in.readInt();
      intervalLoggingType = in.readInt();
      tolerance = in.readDouble();
      purgeOverride = true;
      purgeType = in.readInt();
      purgePeriod = in.readInt();
      textRenderer = (TextRenderer) in.readObject();
      chartRenderer = (ChartRenderer) in.readObject();
      pointLocator = (PointLocatorVO) in.readObject();
      defaultCacheSize = in.readInt();
      discardExtremeValues = in.readBoolean();
      discardLowLimit = in.readDouble();
      discardHighLimit = in.readDouble();
      engineeringUnits = in.readInt();
      chartColour = SerializationHelper.readSafeUTF(in);
      plotType = in.readInt();
    } else if (ver == 5) {
      textRenderer = (TextRenderer) in.readObject();
      chartRenderer = (ChartRenderer) in.readObject();
      pointLocator = (PointLocatorVO) in.readObject();
      discardLowLimit = in.readDouble();
      discardHighLimit = in.readDouble();
      chartColour = SerializationHelper.readSafeUTF(in);
      plotType = in.readInt();
    }

    // Check the purge type. Weird how this could have been set to 0.
    if (purgeType == 0) purgeType = Common.TimePeriods.YEARS;
    // Ditto for purge period
    if (purgePeriod == 0) purgePeriod = 1;
  }
 public void savePersistentData(int id, Object data) {
   ejt.update(
       "update dataSources set rtdata=? where id=?",
       new Object[] {SerializationHelper.writeObject(data), id},
       new int[] {Types.BLOB, Types.INTEGER});
 }