Skip to Content

Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51
From version 5.26
edited by Stone Wu
on 2022/07/12 10:30
Change comment: (Autosaved)
To version 11.1
edited by Hunter
on 2023/02/18 15:17
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -V-BOX.V-Net.1\.User Manual.04 Lua Script.WebHome
1 +V-BOX.V-Net.Manual.04 Lua Script.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Stone
1 +XWiki.Hunter
Content
... ... @@ -140,7 +140,7 @@
140 140  
141 141   Table 2-1
142 142  
143 -(% class="box errormessage" %)
143 +(% class="box infomessage" %)
144 144  (((
145 145  **✎Note: **If HLword enters any other value, it will be treated as invalid.
146 146  )))
... ... @@ -608,11 +608,12 @@
608 608  Attempting to use a script to open a serial port in an unsupported mode will result in an error directly, as below.
609 609  
610 610  |(((
611 +{{code language="LUA"}}
611 611  local setup = {
612 612  
613 613  name = "COM2",
614 614  
615 -mode = 422, ~-~- COM2 does not support RS422
616 +mode = 422, -- COM2 does not support RS422
616 616  
617 617  ...
618 618  
... ... @@ -619,6 +619,7 @@
619 619  }
620 620  
621 621  serial.open(setup)
623 +{{/code}}
622 622  )))
623 623  
624 624  **Data bit:**
... ... @@ -1063,8 +1063,9 @@
1063 1063  
1064 1064  If there is no custom configuration, return an empty table, otherwise, return with "field name/field content"
1065 1065  
1066 -E.g:
1068 +**For example:**
1067 1067  
1070 +{{code language="LUA"}}
1068 1068  {
1069 1069  
1070 1070  [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5', [5]={"fruit"="apple"}},
... ... @@ -1077,7 +1077,8 @@
1077 1077  
1078 1078  }
1079 1079  
1080 -Failed: //table// empty table
1083 +Failed: table empty table
1084 +{{/code}}
1081 1081  
1082 1082  (((
1083 1083  == **bns_get_config(string from)** ==
... ... @@ -1157,13 +1157,15 @@
1157 1157  
1158 1158  Type (1: switch, 2: number, 3: string)
1159 1159  
1160 -E.g:
1161 - {
1164 +**For example:**
1162 1162  
1163 -[1]={~-~-The first communication port
1166 +{{code language="LUA"}}
1167 +{
1164 1164  
1165 -[1]={~-~-monitoring point array of the first communication port
1169 +[1]={--The first communication port
1166 1166  
1171 +[1]={--monitoring point array of the first communication port
1172 +
1167 1167  [1]={[1]=11,[2]='data1',[3]=3,[4]=2},
1168 1168  
1169 1169  [2]={[1]=12,[2]='data2',[3]=3,[4]=2},
... ... @@ -1170,23 +1170,23 @@
1170 1170  
1171 1171  ...
1172 1172  
1173 -[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},~-~-n monitoring points
1179 +[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},--n monitoring points
1174 1174  
1175 1175  },
1176 1176  
1177 -[2]=14, ~-~-ID
1183 +[2]=14, --ID
1178 1178  
1179 -[3]='Modbus TCP' ~-~-n monitoring points
1185 +[3]='Modbus TCP' --n monitoring points
1180 1180  
1181 1181  },
1182 1182  
1183 -[2]={~-~-The second communication port
1189 +[2]={--The second communication port
1184 1184  
1185 -[1]={},~-~-The monitoring point of the second communication port is not configured and is empty
1191 +[1]={},--The monitoring point of the second communication port is not configured and is empty
1186 1186  
1187 -[2]=15, ~-~-ID
1193 +[2]=15, --ID
1188 1188  
1189 -[3]='WECON' ~-~-communication protocol name
1195 +[3]='WECON' --communication protocol name
1190 1190  
1191 1191  },
1192 1192  
... ... @@ -1193,6 +1193,7 @@
1193 1193  ...n communication ports and so on
1194 1194  
1195 1195  }
1202 +{{/code}}
1196 1196  
1197 1197  Failed~:// table// empty table
1198 1198  
... ... @@ -1272,8 +1272,9 @@
1272 1272  
1273 1273  Succeed: //table// one-dimensional array
1274 1274  
1275 -E.g:
1282 +**For example:**
1276 1276  
1284 +{{code language="LUA"}}
1277 1277  {
1278 1278  
1279 1279  [1]="This is the oldest message", - the first is the oldest message
... ... @@ -1285,6 +1285,7 @@
1285 1285  [n]="This is the latest message", - the last is the latest message
1286 1286  
1287 1287  }
1296 +{{/code}}
1288 1288  
1289 1289  Failede: nil
1290 1290  
... ... @@ -1302,7 +1302,7 @@
1302 1302  
1303 1303  == **https request** ==
1304 1304  
1305 -Example：
1314 +**For example:**
1306 1306  
1307 1307  {{code language="LUA"}}
1308 1308  local json = require("json")
... ... @@ -1358,7 +1358,7 @@
1358 1358  
1359 1359  **Access in bit mode, the prefix is @B_HDX, the number in front of "." indicates the number of the word, and the number behind is the bit number of the word.**
1360 1360  
1361 -For example: @B_HDX1020.12, its meaning is to access the system data area in bit mode, the specific location is the 13th bit of the 1020th word.
1370 +**For example:** @B_HDX1020.12, its meaning is to access the system data area in bit mode, the specific location is the 13th bit of the 1020th word.
1362 1362  
1363 1363  (% class="box infomessage" %)
1364 1364  (((
... ... @@ -1380,7 +1380,7 @@
1380 1380  1. Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15".
1381 1381  
1382 1382  (((
1383 -== **8.2 Special data area (HSW/HSX)** ==
1392 +== **Special data area (HSW/HSX)** ==
1384 1384  
1385 1385  (% class="box infomessage" %)
1386 1386  (((
... ... @@ -1498,8 +1498,19 @@
1498 1498  ** addr_getstring("@W_HSW191",17)
1499 1499  * Obtaining ICCID (read only)
1500 1500  ** addr_getstring("@W_HSW225",15)
1510 +* (((
1511 +TSAP settings of Siemens LOGO PLC*
1501 1501  
1502 1502  (((
1514 +addr_setword("@W_0#HSW1200",8192) means set the Local TSAP as 20.00
1515 +)))
1516 +
1517 +* (((
1518 +addr_setword("@W_0#HSW1201",4096) means set the Remote TSAP as 10.00
1519 +)))
1520 +)))
1521 +
1522 +(((
1503 1503  == **Power-down storage area (HAW/HAX)** ==
1504 1504  
1505 1505  The system storage area (HAW) is used for the system power-down hold registers:
... ... @@ -1534,7 +1534,7 @@
1534 1534  Failed: multi
1535 1535  
1536 1536  (((
1537 -== **9.2 send_sms_ucs2(string number, string message)** ==
1557 +== **send_sms_ucs2(string number, string message)** ==
1538 1538  )))
1539 1539  
1540 1540  **Function:**
... ... @@ -1683,163 +1683,429 @@
1683 1683  * number [prarm.refin]: whether each byte of the data to be measured is inverted by bit, true or false.
1684 1684  * number [prarm.refout]: after the calculation or before the heterodyning output, whether the whole data is inverted by bit, true or false.
1685 1685  
1686 -Return:
1706 +**Return:**
1687 1687  
1688 1688  Success: crc object
1689 1689  
1690 1690  Failure: multi, error code
1691 1691  
1692 -|=(% style="width: 193px;" %)Parameter model name|=(% style="width: 65px;" %)poly|=init|=(% style="width: 184px;" %)xorout|=(% style="width: 69px;" %)refin|=refout
1693 -|(% style="width:193px" %)crc8|(% style="width:65px" %)0x07|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1694 -|(% style="width:193px" %)crc8_cdma2000|(% style="width:65px" %)0x9B|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1695 -|(% style="width:193px" %)crc8_darc|(% style="width:65px" %)0x39|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1696 -|(% style="width:193px" %)crc8_dvb_s2|(% style="width:65px" %)0xD5|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1697 -|(% style="width:193px" %)crc8_ebu|(% style="width:65px" %)0x1D|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1698 -|(% style="width:193px" %)crc8_i_code|(% style="width:65px" %)0x1D|0xFD|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1699 -|(% style="width:193px" %)crc8_itu|(% style="width:65px" %)0x07|0x00|(% style="width:184px" %)0X55|(% style="width:69px" %)false|false
1700 -|(% style="width:193px" %)crc8_maxim|(% style="width:65px" %)0x31|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1701 -|(% style="width:193px" %)crc8_rohc|(% style="width:65px" %)0x07|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1702 -|(% style="width:193px" %)crc8_wcdma|(% style="width:65px" %)0x9B|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1703 -|(% style="width:193px" %)crc8_sae_j1850|(% style="width:65px" %)0x1D|0xFF|(% style="width:184px" %)0xFF|(% style="width:69px" %)false|false
1704 -|(% style="width:193px" %)crc8_opensafaty|(% style="width:65px" %)0x2F|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1705 -|(% style="width:193px" %)crc16_tms37157|(% style="width:65px" %)0x1021|0x3791|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1706 -|(% style="width:193px" %)crc16_a|(% style="width:65px" %)0x1021|0x6363|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1707 -|(% style="width:193px" %)crc16_riello|(% style="width:65px" %)0x1021|0x554D|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1708 -|(% style="width:193px" %)crc16_ccitt_false|(% style="width:65px" %)0x1021|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1709 -|(% style="width:193px" %)crc16_arc|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1710 -|(% style="width:193px" %)crc16_arc_ccitt|(% style="width:65px" %)0x1021|0X1D0F|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1711 -|(% style="width:193px" %)crc16_cdma2000|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1712 -|(% style="width:193px" %)crc16_dds110|(% style="width:65px" %)0xC867|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1713 -|(% style="width:193px" %)crc16_dect_r|(% style="width:65px" %)0x0589|0x800D|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1714 -|(% style="width:193px" %)crc16_dect_x|(% style="width:65px" %)0x0589|0x0000|(% style="width:184px" %)0x0001|(% style="width:69px" %)false|false
1715 -|(% style="width:193px" %)crc16_dnp|(% style="width:65px" %)0x3D65|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1716 -|(% style="width:193px" %)crc16_en_13757|(% style="width:65px" %)0x3D65|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1717 -|(% style="width:193px" %)crc16_genibus|(% style="width:65px" %)0x1021|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
1718 -|(% style="width:193px" %)crc16_maxim|(% style="width:65px" %)0x8005|0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
1719 -|(% style="width:193px" %)crc16_mcrf4xx|(% style="width:65px" %)0x1021|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1720 -|(% style="width:193px" %)crc16_r10_dif|(% style="width:65px" %)0x8BB7|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1721 -|(% style="width:193px" %)crc16_teldisk|(% style="width:65px" %)0xA097|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1722 -|(% style="width:193px" %)crc16_usb|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1723 -|(% style="width:193px" %)crc16_kermit|(% style="width:65px" %)0x1021|0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1724 -|(% style="width:193px" %) |(% style="width:65px" %) |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1725 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1726 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1727 -|(% style="width:193px" %) |(% style="width:65px" %) |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1728 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1729 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
1730 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1731 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1732 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1733 -|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
1734 -|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1735 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)true|true
1736 -|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1737 -|(% style="width:193px" %) |(% style="width:65px" %) |0x0000000000000000|(% style="width:184px" %)0x0000000000000000|(% style="width:69px" %)false|false
1738 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
1739 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)false|false
1740 -|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
1741 -|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
1742 -|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
1743 -|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
1744 -
1745 1745  (((
1746 -== **set_network(table config)** ==
1713 +|=Parameter model name|=poly|=init|=xorout|=refin|=refout
1714 +|crc8|0x07|0x00|0x00|false|false
1715 +|crc8_cdma2000|0x9B|0xFF|0x00|false|false
1716 +|crc8_darc|0x39|0x00|0x00|true|true
1717 +|crc8_dvb_s2|0xD5|0x00|0x00|false|false
1718 +|crc8_ebu|0x1D|0xFF|0x00|true|true
1719 +|crc8_i_code|0x1D|0xFD|0x00|false|false
1720 +|crc8_itu|0x07|0x00|0x55|false|false
1721 +|crc8_maxim|0x31|0x00|0x00|true|true
1722 +|crc8_rohc|0x07|0xFF|0x00|true|true
1723 +|crc8_wcdma|0x9B|0x00|0x00|true|true
1724 +|crc8_sae_j1850|0x1D|0xFF|0xFF|false|false
1725 +|crc8_opensafety|0x2F|0x00|0x00|false|false
1726 +|crc16_tms37157|0x1021|0x3791|0x0000|true|true
1727 +|crc16_a|0x1021|0x6363|0x0000|true|true
1728 +|crc16_riello|0x1021|0x554D|0x0000|true|true
1729 +|crc16_ccitt_false|0x1021|0xFFFF|0x0000|false|false
1730 +|crc16_arc|0x8005|0x0000|0x0000|true|true
1731 +|crc16_arc_ccitt|0x1021|0x1D0F|0x0000|false|false
1732 +|crc16_buypass|0x8005|0x0000|0x0000|false|false
1733 +|crc16_cdma2000|0xC867|0xFFFF|0x0000|false|false
1734 +|crc16_dds110|0x8005|0x800D|0x0000|false|false
1735 +|crc16_dect_r|0x0589|0x0000|0x0001|false|false
1736 +|crc16_dect_x|0x0589|0x0000|0x0000|false|false
1737 +|crc16_dnp|0x3D65|0x0000|0xFFFF|true|true
1738 +|crc16_en_13757|0x3D65|0x0000|0xFFFF|false|false
1739 +|crc16_genibus|0x1021|0xFFFF|0xFFFF|false|false
1740 +|crc16_maxim|0x8005|0x0000|0xFFFF|true|true
1741 +|crc16_mcrf4xx|0x1021|0xFFFF|0x0000|true|true
1742 +|crc16_t10_dif|0x8BB7|0x0000|0x0000|false|false
1743 +|crc16_teledisk|0xA097|0x0000|0x0000|false|false
1744 +|crc16_usb|0x8005|0xFFFF|0xFFFF|true|true
1745 +|crc16_kermit|0x1021|0x0000|0x0000|true|true
1746 +
1747 +(% class="wikigeneratedid" %)
1748 +Table 9-1
1749 +
1750 +== **crc:calc(string crcValue)** ==
1751 +
1752 +**Function:** Calculate CRC result
1753 +
1754 +**Parameter:**
1755 +
1756 +crcValue: the value to be calculated
1757 +
1758 +**Return:**
1759 +
1760 +Succeed: calculated result
1761 +
1762 +Failed: multi, error code
1747 1747  )))
1748 1748  
1749 -**Function:** Set V-BOX network, take effect after restart
1765 +**For example:**
1750 1750  
1751 -**parameter:**
1767 +{{code language="LUA"}}
1768 +function crcTest.main()
1752 1752  
1753 -//config~:// incoming network configuration table
1770 +local param = {
1754 1754  
1755 -1. connectMode: the way V-BOX connects to the server, 0: Ethernet, 1: WIFI, 2: 4G, 3: 2G, it is not allowed to be empty.
1756 -1. ethernetEnable: Whether to enable Ethernet, 1: enable, 0: disable, and it is not allowed to be empty.
1757 -1. ethernetLanIp: Set the LAN IP address. Only V-BOX with three network ports support this configuration, and other models of V-BOX do not support setting LAN IP. This item is allowed to be empty.
1758 -1. ethernetIpMode: Whether to enable Ethernet static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
1759 -1. ethernetIp: The IP address needs to be configured when the Ethernet static IP is used, and it is not allowed to be empty.
1760 -1. ethernetNetmask: The subnet mask needs to be configured when Ethernet static IP is used, and it is not allowed to be empty.
1761 -1. ethernetGateway: The gateway can be configured when Ethernet static IP is used.
1772 +name = '',
1762 1762  
1763 -1. When using the Ethernet network, if the Gateway is empty, V-BOX will not connect to the server.
1764 -1. If you only use Ethernet to directly connect to the PLC for communication, you do not need to configure a gateway.
1774 +width = 64,
1765 1765  
1766 -1. ethernetFirstDns: You can configure the preferred DNS server when the Ethernet static IP is used, and it is allowed to be empty. If you use the Ethernet network and do not fill in the DNS server, V-BOX will not be connected to the server.
1767 -1. ethernetSpareDns: Alternate DNS server can be configured when the Ethernet static IP is used, and it is allowed to be empty.
1768 -1. wifiEnable: Whether to enable WIFI, 1: enable, 0: disable, it is not allowed to be empty. If it is a model that does not include WIFI, directly disable it.
1769 -1. wifiName: WIFI name, if WIFI is enabled, it is not allowed to be empty.
1770 -1. wifiPassword: WIFI password, it is allowed to be empty.
1771 -1. wifiIpMode: Whether to enable WIFI static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
1772 -1. wifiIp: IP address needs to be configured when WIFI static IP is used, it is not allowed to be empty.
1773 -1. wifiNetmask: The subnet mask needs to be configured when WIFI static IP is used, and it is not allowed to be empty.
1774 -1. wifiGateway: The gateway can be configured when WIFI static IP is used, and it is not allowed to be empty.
1775 -1. wifiFirstDns: You can configure the preferred DNS server when the WIFI static IP is used, and it is allowed to be empty. If you use the WIFI network and do not fill in the DNS server, V-BOX will not be connected to the server.
1776 -1. wifiSpareDns: Alternate DNS server can be configured when the WIFI static IP is used, and it is allowed to be empty.
1777 -1. mobileEnable: Whether to enable the mobile network, 1: enable, 0: disable, it is not allowed to be empty, if it does not include 4G models, directly disable it.
1778 -1. mobileApnMode: Whether to manually configure the APN, 0: Use the default APN, 1: Manually configure the APN, it is not allowed to be empty.
1779 -1. apnName: APN name, if you choose to manually configure APN, it is not allowed to be empty.
1780 -1. apnPassword: APN username, it is allowed to be empty.
1781 -1. apnUserName: APN number, it is allowed to be empty.
1782 -1. apnNumber: APN number, it is allowed to be empty.
1776 +poly = 0x42F0E1EBA9EA3693,
1783 1783  
1778 +init = 0xFFFFFFFFFFFFFFFF,
1779 +
1780 +xorout = 0xFFFFFFFFFFFFFFFF,
1781 +
1782 +refin = 1,
1783 +
1784 +refout = 1
1785 +
1786 +}
1787 +
1788 +crc64,err = crc.init(param)
1789 +
1790 +if not crc64 then
1791 +
1792 +print("Crc init failed:", err)
1793 +else
1794 +
1795 +crcvalue = crc64:calc("123456789")
1796 +
1797 +print(string.format("crc64 calc :0X%16X", crcvalue))
1798 +
1799 +end
1800 +
1801 +end
1802 +{{/code}}
1803 +
1804 += **10 Special function for V-NET** =
1805 +
1806 +== **normal_get_alldata()** ==
1807 +
1808 +**Function: **Obtain the data of all the monitoring points
1809 +
1810 +**Parameter: None**
1811 +
1784 1784  **Return:**
1785 1785  
1786 -Succeed: true
1814 +Succeed: table two-dimensional arrays, as follows:
1787 1787  
1788 -Faied: multi
1816 +* Each item is a monitoring point and contains 4 attributes:
1817 +** 1: ID
1818 +** 2: status
1819 +** 3: tag name
1820 +** 4: value
1821 +* Status contains 3 enumerated values
1822 +** 0: offline
1823 +** 1: online
1824 +** 2: timeout
1825 +* Customization returns an empty table if there is no configuration, otherwise returns "field name/field content"
1789 1789  
1790 -(((
1791 -== **9.7 remote_com_start(string config)** ==
1792 -)))
1827 +**For example:**
1793 1793  
1794 -**Function:**
1829 +{{code language="LUA"}}
1830 +{
1795 1795  
1796 -start serial port pass-through
1832 +[1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'},
1797 1797  
1834 +[2]= {[1]=1235, [2]=1, [3]='humi', [4]='67'},
1835 +
1836 +...
1837 +
1838 +[n]= {[1]=xxxx, [2]=x, [3]='xxxx', [4]='xx.x'},
1839 +
1840 +}
1841 +
1842 +Failed: table, empty table
1843 +{{/code}}
1844 +
1845 +== **normal_setdata_byname(string name, string data)** ==
1846 +
1847 +**Function:** Write data to the monitoring point name
1848 +
1798 1798  **Parameter:**
1799 1799  
1800 -//config: //incoming serial port parameter configuration, JSON format
1851 +name: the name of monitoring point
1801 1801  
1802 -1. type:0, serial port pass-through
1803 -1. port: serial port number marked on the V-BOX
1804 -1. comtype:0-RS232, 1-RS485, 2-RS422
1805 -1. baudrate: Baud Rate
1806 -1. data_length: Data Bits
1807 -1. stop_bit: Stop Bit
1808 -1. check_bit: Check Bit
1853 +data: the data to be written
1809 1809  
1810 1810  **Return:**
1811 1811  
1812 -Succeed: true
1857 +Succeed: string: The value of the monitor point before it is written
1813 1813  
1814 -Failed: multi
1859 +Failed: nil
1815 1815  
1816 -(((
1817 -== **9.8 remote_com_stop()** ==
1818 -)))
1861 +== **normal_getdata_byname(string name)** ==
1819 1819  
1820 -**Function:**
1863 +**Function:** Read the data of the monitoring point name
1821 1821  
1822 -close serial port pass-through
1865 +**Parameter:**
1823 1823  
1867 +name: the name of monitoring point
1868 +
1824 1824  **Return:**
1825 1825  
1826 -Succeed: true
1871 +Succeed: string
1827 1827  
1873 +Failed: nil
1874 +
1875 += **11 MySQL database operation** =
1876 +
1877 +== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
1878 +
1879 +**Function:** Configure database connection parameters
1880 +
1881 +**Parameter:**
1882 +
1883 +sourcename: the name of database
1884 +
1885 +username: the username of the connection
1886 +
1887 +password: the password of the connection
1888 +
1889 +host: the host name of the connection
1890 +
1891 +port: the host port of the connection
1892 +
1893 +character: the character set of the connection
1894 +
1895 +**Return:**
1896 +
1897 +Succeed: string
1898 +
1828 1828  Failed: multi
1829 1829  
1830 -(((
1831 -== **9.9 remote_com_state()** ==
1832 -)))
1901 +== **luaMySql.exec(string statement)** ==
1833 1833  
1834 -**Function:**
1903 +**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
1835 1835  
1836 -query the serial port pass-through status and pass-through server domain name and port
1905 +**Parameter:**
1837 1837  
1907 +statement: the given SQL statement
1908 +
1838 1838  **Return:**
1839 1839  
1840 -Succeed:
1911 +Succeed: status: returns the number of rows affected by SQL statement execution.
1841 1841  
1842 -1. number, current pass-through status: 0-none 1,2-starting pass-through 3-penetrating 4,5-finishing pass-through 6-pass-through error
1843 -1. string, pass-through server domain name and port number, xxxx (domain name): xxx (port number)
1913 +Failed: nil, errorString
1844 1844  
1845 -Failed: multi
1915 +== **luaMySql.execWithResult(string statement)** ==
1916 +
1917 +**Function:** Execute the given SQL statement returning the result set (check)
1918 +
1919 +**Parameter:**
1920 +
1921 +statement: the given SQL statement
1922 +
1923 +**Return:**
1924 +
1925 +Succeed: table: returns the result set
1926 +
1927 +Failed: nil, errorString
1928 +
1929 +**For example:**
1930 +
1931 +{{code language="LUA"}}
1932 +mysql = require"mysqlclient"
1933 +
1934 +function DataInitRight()
1935 +
1936 +local dbName = "db_lua1"
1937 +
1938 +local user = "root"
1939 +
1940 +local pwd = "123456"
1941 +
1942 +local host = "192.168.56.186"
1943 +
1944 +local port = 3306
1945 +local character = "UTF8"
1946 +
1947 +mysql.init(dbName, user, pwd, host, port, character)
1948 +
1949 +end
1950 +
1951 +function ExecFunc()
1952 +
1953 +status, errorString = mysql.exec("delete from tb_lua1 where mykey =
1954 +
1955 +10;")
1956 +
1957 +if nil == status then
1958 +
1959 +print("ExecFunc() error:", errorString)
1960 +
1961 +return -1
1962 +
1963 +else
1964 +
1965 +print("the number of rows affected by the command:", status)
1966 +
1967 +end
1968 +
1969 +return 0
1970 +
1971 +end
1972 +
1973 +function ExecWithResultFunc()
1974 +
1975 +status, errorString = mysql.execWithResult("select * from tb_lua1;")
1976 +
1977 +if nil == status then
1978 +
1979 +print("ExecWithResultFunc() error:", errorString)
1980 +
1981 +return -1
1982 +
1983 +else
1984 +
1985 +print("ExecWithResultFunc()
1986 +
1987 +success
1988 +
1989 +: status
1990 +
1991 +type
1992 +
1993 +=
1994 +
1995 +",
1996 +
1997 +type(status))
1998 +
1999 +print("ExecWithResultFunc() success : status len = ", #status)
2000 +
2001 +local num = #status
2002 +
2003 +local i = 1
2004 +
2005 +if num > 0 then
2006 +
2007 +for i = 1, num, 1 do
2008 +
2009 +local var = string.format("select result[%d] :mykey = %d,
2010 +
2011 +value = %s", i, status[i].mykey, status[i].value)
2012 +
2013 +print(var)
2014 +
2015 +end
2016 +
2017 +end
2018 +
2019 +print("---------------")
2020 +
2021 +end
2022 +
2023 +return 0
2024 +end
2025 +
2026 +function luaMysql_apiTest.main()
2027 +
2028 +print("script running ...")
2029 +
2030 +DataInitRight()
2031 +
2032 +--use exec demo
2033 +
2034 +if ExecFunc() < 0 then
2035 +
2036 +return
2037 +
2038 +end
2039 +
2040 +--use execWithResult demo
2041 +
2042 +if ExecWithResultFunc() < 0 then
2043 +
2044 +return
2045 +
2046 +end
2047 +
2048 +print("script running success")
2049 +
2050 +end
2051 +{{/code}}
2052 +
2053 += **12 Message summary algorithm** =
2054 +
2055 +== **hmac(string hash_func, string key, string message)** ==
2056 +
2057 +**Function:** HMAC calculate
2058 +
2059 +**Function name**
2060 +
2061 +hash_func:
2062 +
2063 +* [md5, sha1, sha224, sha256, sha384, sha512]
2064 +* [sha512_224, sha512_256, sha3_224, sha3_256]
2065 +* [sha3_384, sha3_512]
2066 +
2067 +**Parameter:**
2068 +
2069 +key: the key
2070 +
2071 +message: message content
2072 +
2073 +**Return:**
2074 +
2075 +Succeed: string, calculation result
2076 +
2077 +Failed: nil
2078 +
2079 +**For example:**
2080 +
2081 +{{code language="LUA"}}
2082 +local sha = require"sha2"
2083 +
2084 +function hmac_test.main()
2085 +
2086 +local hmac = sha.hmac
2087 +
2088 +print(hmac(sha.sha1,
2089 +
2090 +"your key", "your message"))
2091 +
2092 +end
2093 +{{/code}}
2094 +
2095 +== **sha(string message** ==
2096 +
2097 +**Function:** SHA calculate
2098 +
2099 +**Function name:**
2100 +
2101 +sha:
2102 +
2103 +* sha1, sha224, sha256, sha384, sha512]
2104 +* [sha512_224, sha512_256, sha3_224, sha3_256]
2105 +* [sha3_384, sha3_512]
2106 +
2107 +**Parameter:**
2108 +
2109 +key: the key
2110 +
2111 +message: message content
2112 +
2113 +**Return:**
2114 +
2115 +Succeed: string, calculation result
2116 +
2117 +Failed: nil
2118 +
2119 +For example:
2120 +
2121 +{{code language="LUA"}}
2122 +local sha = require"sha2"
2123 +
2124 +function sha_test.main()
2125 +
2126 +local sha256 = sha.sha256
2127 +
2128 +print(sha256("your message"))
2129 +
2130 +end
2131 +{{/code}}