SmRequest_v0.9_draft.json

{
  "uuid": "test",
  "source": {same},
  "sink": {
    "jdbcUrl": "jdbc:postgresql://192.168.1.249:5433/mwm?stringtype=unspecified",
    "tableName": "sm_events_sink_test",
    "rowSchema": {
      "fromTime": ["fromTs", "first(toTs(datetime))"],
      "toTime": ["toTs", "last(toTs(datetime))"],
      "payload": {
        "sourceId": "21",
        "appIdField": "1.as[Int]",
        "context": {
          "loco_id": "last(loco_id)"
        }
      }
    },
    "driverName": "org.postgresql.Driver",
    "userName": "clover",
    "password": "clover",
    "batchInterval": 500
  },
  "patterns": [
    {
      "id": "4991",
      "sourceCode": "PosKM = 0 andThen SpeedEngine > 0 and  (PosKM > 4 for 11 min < 60 sec)",
      "payload": {
        "entity_id": "4991",
        "context": {
          "avgSpeedEngine": "avg(SpeedEngine)"
        }
      }
    }
  ]
}