IoTGateway/DataProcess - Revision history

Eric.liang: /* Example */

2016-09-06T04:39:42Z

‎Example

Eric.liang: /* Example */

2016-09-06T03:46:06Z

‎Example

Eric.liang: /* Example */

2016-09-06T03:19:35Z

‎Example

Eric.liang: /* SenHub's Info Spec */

2016-09-06T03:14:37Z

‎SenHub's Info Spec

Eric.liang at 03:09, 6 September 2016

2016-09-06T03:09:16Z

Eric.liang: /* SQL Field */

2016-09-06T03:02:36Z

‎SQL Field

Eric.liang: /* Data Extend Information and SQL Structure for Handler to Manager */

2016-09-06T02:55:45Z

‎Data Extend Information and SQL Structure for Handler to Manager

Eric.liang: /* Data Extend Information and SQL Structure for Handler to Manager */

2016-09-06T02:54:42Z

‎Data Extend Information and SQL Structure for Handler to Manager

Eric.liang: /* SQL Field */

2016-09-06T02:52:20Z

‎SQL Field

Eric.liang: /* SQL Structure and Define for Handler */

2016-09-06T02:47:28Z

‎SQL Structure and Define for Handler

@@ Line 248: / Line 248: @@
 :'''<big>SqlParams:</big>'''
   nAction:        0
   pszPrimaryKey:  /cagent/admin/<devID>/agentactionreq
-  pszData:        NULL
+  pszOutData:     NULL
   pszGeneralInfo: NULL
   pExtend1:       NULL

@@ Line 243: / Line 243: @@
+    }
+  }
 SQL Table  IoTGWHandler_UniqueKey

@@ Line 216: / Line 216: @@
 =Example=
-==SenHub's Info Spec==
+'''<big>SenHub's Info Spec</big>'''<br />
- Topic: /cagent/admin/<devID>/agentactionreq
+Topic: /cagent/admin/<devID>/agentactionreq<br />
   Msg:
   { "susiCommData": {
@@ Line 242: / Line 243: @@
+    }
+  }

@@ Line 219: / Line 219: @@
   Topic: /cagent/admin/<devID>/agentactionreq
   Msg:
   { "susiCommData": {
-	"susiCommData": {
+     "infoSpec": {
-		"infoSpec": {
+        "SenHub": {
-			"SenHub": {
+           "SenData": {
-				"SenData": {
+                "e": [{"n": "Temperature","u": "Cel","v": 0,"min": -100,"max": 200,"asm": "r","type": "d","rt": "ucum.Cel","st": "ipso","exten": ""},
-					"e": [
+                      {"n": "Humidity","u": "%","v": 0,"min": 0,"max": 100,"asm": "r","type": "d","rt": "ucum.%","st": "ipso","exten": ""}],
+            "bn": "SenData"
-							"n": "Temperature",
+         },
-							"u": "Cel",
+        "Info": {"e": [{"n": "Name","sv": "SenHub1","asm": "rw"},{"n": "sw","sv": "1.0.00","asm": "r"}],
-							"v": 0,
+           "bn": "Info"
-							"min": -100,
+        },
-							"max": 200,
+        "Net": {"e": [{"n": "sw","sv": "1.0.00","asm": "r"},{"n": "Neighbor","sv": "","asm": "r"},{"n": "Health","v": "100.000000","asm": "r"}],
-							"asm": "r",
+                "bn": "Net"
-							"type": "d",
-							"rt": "ucum.Cel",
-							"st": "ipso",
+   },
-							"exten": ""
+   "commCmd": 2052,
-						},
+   "requestID": 2001,
+   "agentID": "0017000E40000000",
-							"n": "Humidity",
+   "handlerName": "general",
-							"u": "%",
+   "sendTS": 160081024
-							"v": 0,
+  }

← Older revision		Revision as of 03:09, 6 September 2016
Line 214:		Line 214:
	void *pExtend2; // Reserved		void *pExtend2; // Reserved
	}DATAEX_INFO, DataEx_Info;		}DATAEX_INFO, DataEx_Info;
		+
		+	=Example=
		+	==SenHub's Info Spec==
		+	Topic: /cagent/admin/<devID>/agentactionreq
		+	Msg:
		+	{
		+	"susiCommData": {
		+	"infoSpec": {
		+	"SenHub": {
		+	"SenData": {
		+	"e": [
		+	{
		+	"n": "Temperature",
		+	"u": "Cel",
		+	"v": 0,
		+	"min": -100,
		+	"max": 200,
		+	"asm": "r",
		+	"type": "d",
		+	"rt": "ucum.Cel",
		+	"st": "ipso",
		+	"exten": ""
		+	},
		+	{
		+	"n": "Humidity",
		+	"u": "%",
		+	"v": 0,
		+	"min": 0,
		+	"max": 100,
		+	"asm": "r",
		+	"type": "d",
		+	"rt": "ucum.%",
		+	"st": "ipso",
		+	"exten": ""
		+	},
		+	{
		+	"n": "GPIO1",
		+	"u": "",
		+	"bv": 0,
		+	"min": 0,
		+	"max": 1,
		+	"asm": "r",
		+	"type": "b",
		+	"rt": "",
		+	"st": "ipso",
		+	"exten": ""
		+	},
		+	{
		+	"n": "GPIO2",
		+	"u": "",
		+	"bv": 0,
		+	"min": 0,
		+	"max": 1,
		+	"asm": "r",
		+	"type": "b",
		+	"rt": "",
		+	"st": "ipso",
		+	"exten": ""
		+	}
		+	],
		+	"bn": "SenData"
		+	},
		+	"Info": {
		+	"e": [
		+	{
		+	"n": "Name",
		+	"sv": "SenHub1",
		+	"asm": "rw"
		+	},
		+	{
		+	"n": "sw",
		+	"sv": "1.0.00",
		+	"asm": "r"
		+	}
		+	],
		+	"bn": "Info"
		+	},
		+	"Net": {
		+	"e": [
		+	{
		+	"n": "sw",
		+	"sv": "1.0.00",
		+	"asm": "r"
		+	},
		+	{
		+	"n": "Neighbor",
		+	"sv": "",
		+	"asm": "r"
		+	},
		+	{
		+	"n": "Health",
		+	"v": "100.000000",
		+	"asm": "r"
		+	}
		+	],
		+	"bn": "Net"
		+	}
		+	}
		+	},
		+	"commCmd": 2052,
		+	"requestID": 2001,
		+	"agentID": "0017000E40000000",
		+	"handlerName": "general",
		+	"sendTS": 160081024
		+	}
		+	}

@@ Line 177: / Line 177: @@
-'''<big>Protocol Params in JSON Format</big>'''
+==Protocol Params in JSON Format==
+  {
-   "Protocol":"MQTT",
+  "Protocol":"MQTT",
-    "MQTT":{
+  "MQTT":{
-        "QoS":2,
+    "Method":"Publish",
-        "Retain":0
+    "Topic":"/cagent/admin/<devID>/agentactionreq",
+    "QoS":2,
+  }

@@ Line 186: / Line 186: @@
+  }
-=Data Extend Information and SQL Structure for Handler to Manager=
+=Data Extend Information and SQL Structures for Handler pass to Manager=
 '''<big>SQL Params structure. This stuucture is designed for Hanlder pass its log behavior.</big>'''

@@ Line 190: / Line 190: @@
 '''<big>SQL Params structure. This stuucture is designed for Hanlder pass its log behavior.</big>'''
   typedef struct SQLParams
-−
+  {
     int   nAction;          // 0: Insert or Update, 1: Delete, 2: Query
     char *pszPrimaryKey;    // NULL => Auto Index
     char **pszOutDataPoint; // Pass this point to save result of query
     char *pszGeneralInfo;   //
-    int  *int;              // status code
+    int  *pnStatus;              // status code
     void *pExtend1;
     void *pExtend2;
@@ Line 204: / Line 205: @@
   typedef struct DataExInfo
+  {
-    int   nVer;            // Struct version,  ( 1 )
+    int   nVer;            // Data Ex Info version: 1
     void *pSqlParams;      // address of SQL parameters structure
     void *pExtend1;        // Reserved
     void *pExtend2;        // Reserved
   }DATAEX_INFO, DataEx_Info;

@@ Line 31: / Line 31: @@
 | align=center style="background-color:#ffffff;border-top:none;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">Optional</span>
 | align=center style="background-color:#ffffff;border-top:none;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">JSON</span>
-| style="background-color:#ffffff;border-top:0.5pt solid #00000a;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">{"Type":"MQTT","TypeId":1, "QoS":0 }</span>
+| style="background-color:#ffffff;border-top:0.5pt solid #00000a;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">Refer to "Protocol Params in JSON Format"</span>
 |-
 | align=center style="background-color:#ffffff;border-top:none;border-bottom:0.5pt solid #00000a;border-left:0.5pt solid #00000a;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">4</span>
@@ Line 95: / Line 95: @@
 | align=center style="background-color:#ffffff;border-top:none;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">Optional</span>
 | align=center style="background-color:#ffffff;border-top:none;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">JSON</span>
-| style="background-color:#ffffff;border-top:0.5pt solid #00000a;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">{"Type":"MQTT","TypeId":1, "QoS":0 }</span>
+| style="background-color:#ffffff;border-top:0.5pt solid #00000a;border-bottom:0.5pt solid #00000a;border-left:none;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">Refer to "Protocol Params in JSON Format"</span>
 |-
 | align=center style="background-color:#ffffff;border-top:none;border-bottom:0.5pt solid #00000a;border-left:0.5pt solid #00000a;border-right:0.5pt solid #00000a;padding-top:0cm;padding-bottom:0cm;padding-left:0.049cm;padding-right:0.049cm;" | <span style="color:#000000;">4</span>