Difference between revisions of "IoTGateway/DataProcess"
From ESS-WIKI
Eric.liang (talk | contribs) |
Eric.liang (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | :: | + | ::Data Format and SQL Field is designed for Data e-motion, Mqtt Reliability Data Channel. |
=SQL Field= | =SQL Field= | ||
{| style="border-spacing:0;width:17.477cm;" | {| style="border-spacing:0;width:17.477cm;" | ||
| Line 177: | Line 177: | ||
| + | =SQL Structure and Define for Handler= | ||
| − | + | Protocol Params in JSON Format | |
| + | |||
| + | { | ||
| + | "Protocol":"MQTT", | ||
| + | "MQTT":{ | ||
| + | "QoS":2, | ||
| + | "Retain":0 | ||
| + | } | ||
| + | } | ||
| + | |||
| + | typedef struct DataExInfo | ||
| + | { | ||
| + | int nVer; // Struct version, ( 1 ) | ||
| + | void *pSqlParams; // address of SQL parameters structure | ||
| + | void *pExtend1; // Reserved | ||
| + | void *pExtend2; // Reserved | ||
| + | }DATAEX_INFO, DataEx_Info; | ||
Revision as of 03:28, 6 September 2016
- Data Format and SQL Field is designed for Data e-motion, Mqtt Reliability Data Channel.
SQL Field
| SQLite Table Fields ( Auto Index) | |||||
| Item | Field Name | Type | Need | Format | Example |
| 1 | Key | Unsigned Int | Must | 6886 (serial number) | |
| 2 | SecondKey | Text | Optional | Default: Hanle Name: SUSHandler | |
| 3 | Protocol_Param | Text | Optional | JSON | {"Type":"MQTT","TypeId":1, "QoS":0 } |
| 4 | Message | Text | Optional | {IoTGW { …. } ) | |
| 5 | Send | Flag | Optional | 0 or 1 | 1 or 0 |
| 6 | Time | Unsigned Int | Must | 33325 ( UTC in sec ) | |
| 7 | General | Text | Optional | any type format | |
| SQLite Table Fields ( User Assign Key ) | |||||
| Item | Field Name | Type | Need | Format | Example |
| 1 | Key | Text | Must | /cagent/admin/infoack | |
| 2 | SecondKey | Text | Optional | Default: Hanle Name: SUSHandler | |
| 3 | Protocol_Param | Text | Optional | JSON | {"Type":"MQTT","TypeId":1, "QoS":0 } |
| 4 | Message | Text | Optional | {IoTGW { …. } ) | |
| 5 | Send | Flag | Optional | 0 or 1 | 1 or 0 |
| 6 | Time | Unsigned Int | Must | 33325 ( UTC in sec ) | |
| 7 | General | Text | Optional | any type format | |
| SQLite Methods | |||||
| Item | Method | Note | |||
| 1 | Insert | *by Primary key
*by Second key ( ex: HandlerName ) ( primary key => auto index ) | |||
| 2 | Update | by Primary key | |||
| 3 | Query | * by Primary key
* by Search rules ( like or updatetime or latest item / order by ? (time ...) ) * All ( order by time ) | |||
| 4 | Clean | *by Primary Key
*by Search rules ( like or updatetime or latest item / order by ? (time ...) ) *All items of Table | |||
| 5 | Create Table | *AutoIndex
*UniqueKey | |||
SQL Structure and Define for Handler
Protocol Params in JSON Format
{
"Protocol":"MQTT",
"MQTT":{
"QoS":2,
"Retain":0
}
}
typedef struct DataExInfo
{ int nVer; // Struct version, ( 1 ) void *pSqlParams; // address of SQL parameters structure void *pExtend1; // Reserved void *pExtend2; // Reserved }DATAEX_INFO, DataEx_Info;