Skip to Content

Changes for page 01 Lua Functions

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

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -V-BOX.V-Net.Manual.04 Lua Script.WebHome
1 +V-BOX.V-Net.1\.User Manual.04 Lua Script.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.Hunter
1 +XWiki.Stone
Content
... ... @@ -1,17 +1,5 @@
1 1  = **1 Interface description** =
2 2  
3 -(% style="width:749.222px" %)
4 -|=(% scope="row" style="width: 374px;" %)z|=(% style="width: 373px;" %)cxz
5 -|=(% style="width: 374px;" %) |(% style="width:373px" %)
6 -|=(% style="width: 374px;" %) |(% style="width:373px" %)
7 -
8 -|分类|宽|高
9 -|网页全屏|700-850|400
10 -|手机全屏|300|400
11 -|其他大图片|400左右|400左右
12 -|小图片|200左右|200左右
13 -
14 -
15 15  == **Data type definition** ==
16 16  
17 17  |=**Type**|=**Description**
... ... @@ -152,7 +152,7 @@
152 152  
153 153   Table 2-1
154 154  
155 -(% class="box infomessage" %)
143 +(% class="box errormessage" %)
156 156  (((
157 157  **✎Note: **If HLword enters any other value, it will be treated as invalid.
158 158  )))
... ... @@ -620,12 +620,11 @@
620 620  Attempting to use a script to open a serial port in an unsupported mode will result in an error directly, as below.
621 621  
622 622  |(((
623 -{{code language="LUA"}}
624 624  local setup = {
625 625  
626 626  name = "COM2",
627 627  
628 -mode = 422, -- COM2 does not support RS422
615 +mode = 422, ~-~- COM2 does not support RS422
629 629  
630 630  ...
631 631  
... ... @@ -632,7 +632,6 @@
632 632  }
633 633  
634 634  serial.open(setup)
635 -{{/code}}
636 636  )))
637 637  
638 638  **Data bit:**
... ... @@ -1077,9 +1077,8 @@
1077 1077  
1078 1078  If there is no custom configuration, return an empty table, otherwise, return with "field name/field content"
1079 1079  
1080 -**For example:**
1066 +E.g:
1081 1081  
1082 -{{code language="LUA"}}
1083 1083  {
1084 1084  
1085 1085  [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5', [5]={"fruit"="apple"}},
... ... @@ -1092,8 +1092,7 @@
1092 1092  
1093 1093  }
1094 1094  
1095 -Failed: table empty table
1096 -{{/code}}
1080 +Failed: //table// empty table
1097 1097  
1098 1098  (((
1099 1099  == **bns_get_config(string from)** ==
... ... @@ -1173,15 +1173,13 @@
1173 1173  
1174 1174  Type (1: switch, 2: number, 3: string)
1175 1175  
1176 -**For example:**
1160 +E.g:
1161 + {
1177 1177  
1178 -{{code language="LUA"}}
1179 -{
1163 +[1]={~-~-The first communication port
1180 1180  
1181 -[1]={--The first communication port
1165 +[1]={~-~-monitoring point array of the first communication port
1182 1182  
1183 -[1]={--monitoring point array of the first communication port
1184 -
1185 1185  [1]={[1]=11,[2]='data1',[3]=3,[4]=2},
1186 1186  
1187 1187  [2]={[1]=12,[2]='data2',[3]=3,[4]=2},
... ... @@ -1188,23 +1188,23 @@
1188 1188  
1189 1189  ...
1190 1190  
1191 -[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},--n monitoring points
1173 +[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},~-~-n monitoring points
1192 1192  
1193 1193  },
1194 1194  
1195 -[2]=14, --ID
1177 +[2]=14, ~-~-ID
1196 1196  
1197 -[3]='Modbus TCP' --n monitoring points
1179 +[3]='Modbus TCP' ~-~-n monitoring points
1198 1198  
1199 1199  },
1200 1200  
1201 -[2]={--The second communication port
1183 +[2]={~-~-The second communication port
1202 1202  
1203 -[1]={},--The monitoring point of the second communication port is not configured and is empty
1185 +[1]={},~-~-The monitoring point of the second communication port is not configured and is empty
1204 1204  
1205 -[2]=15, --ID
1187 +[2]=15, ~-~-ID
1206 1206  
1207 -[3]='WECON' --communication protocol name
1189 +[3]='WECON' ~-~-communication protocol name
1208 1208  
1209 1209  },
1210 1210  
... ... @@ -1211,7 +1211,6 @@
1211 1211  ...n communication ports and so on
1212 1212  
1213 1213  }
1214 -{{/code}}
1215 1215  
1216 1216  Failed~:// table// empty table
1217 1217  
... ... @@ -1291,9 +1291,8 @@
1291 1291  
1292 1292  Succeed: //table// one-dimensional array
1293 1293  
1294 -**For example:**
1275 +E.g:
1295 1295  
1296 -{{code language="LUA"}}
1297 1297  {
1298 1298  
1299 1299  [1]="This is the oldest message", - the first is the oldest message
... ... @@ -1305,7 +1305,6 @@
1305 1305  [n]="This is the latest message", - the last is the latest message
1306 1306  
1307 1307  }
1308 -{{/code}}
1309 1309  
1310 1310  Failede: nil
1311 1311  
... ... @@ -1323,7 +1323,7 @@
1323 1323  
1324 1324  == **https request** ==
1325 1325  
1326 -**For example:**
1305 +Example：
1327 1327  
1328 1328  {{code language="LUA"}}
1329 1329  local json = require("json")
... ... @@ -1379,7 +1379,7 @@
1379 1379  
1380 1380  **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.**
1381 1381  
1382 -**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.
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.
1383 1383  
1384 1384  (% class="box infomessage" %)
1385 1385  (((
... ... @@ -1401,7 +1401,7 @@
1401 1401  1. Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15".
1402 1402  
1403 1403  (((
1404 -== **Special data area (HSW/HSX)** ==
1383 +== **8.2 Special data area (HSW/HSX)** ==
1405 1405  
1406 1406  (% class="box infomessage" %)
1407 1407  (((
... ... @@ -1519,19 +1519,8 @@
1519 1519  ** addr_getstring("@W_HSW191",17)
1520 1520  * Obtaining ICCID (read only)
1521 1521  ** addr_getstring("@W_HSW225",15)
1522 -* (((
1523 -TSAP settings of Siemens LOGO PLC*
1524 1524  
1525 1525  (((
1526 -addr_setword("@W_0#HSW1200",8192) means set the Local TSAP as 20.00
1527 -)))
1528 -
1529 -* (((
1530 -addr_setword("@W_0#HSW1201",4096) means set the Remote TSAP as 10.00
1531 -)))
1532 -)))
1533 -
1534 -(((
1535 1535  == **Power-down storage area (HAW/HAX)** ==
1536 1536  
1537 1537  The system storage area (HAW) is used for the system power-down hold registers:
... ... @@ -1566,7 +1566,7 @@
1566 1566  Failed: multi
1567 1567  
1568 1568  (((
1569 -== **send_sms_ucs2(string number, string message)** ==
1537 +== **9.2 send_sms_ucs2(string number, string message)** ==
1570 1570  )))
1571 1571  
1572 1572  **Function:**
... ... @@ -1715,429 +1715,163 @@
1715 1715  * number [prarm.refin]: whether each byte of the data to be measured is inverted by bit, true or false.
1716 1716  * number [prarm.refout]: after the calculation or before the heterodyning output, whether the whole data is inverted by bit, true or false.
1717 1717  
1718 -**Return:**
1686 +Return:
1719 1719  
1720 1720  Success: crc object
1721 1721  
1722 1722  Failure: multi, error code
1723 1723  
1724 -(((
1725 -|=Parameter model name|=poly|=init|=xorout|=refin|=refout
1726 -|crc8|0x07|0x00|0x00|false|false
1727 -|crc8_cdma2000|0x9B|0xFF|0x00|false|false
1728 -|crc8_darc|0x39|0x00|0x00|true|true
1729 -|crc8_dvb_s2|0xD5|0x00|0x00|false|false
1730 -|crc8_ebu|0x1D|0xFF|0x00|true|true
1731 -|crc8_i_code|0x1D|0xFD|0x00|false|false
1732 -|crc8_itu|0x07|0x00|0x55|false|false
1733 -|crc8_maxim|0x31|0x00|0x00|true|true
1734 -|crc8_rohc|0x07|0xFF|0x00|true|true
1735 -|crc8_wcdma|0x9B|0x00|0x00|true|true
1736 -|crc8_sae_j1850|0x1D|0xFF|0xFF|false|false
1737 -|crc8_opensafety|0x2F|0x00|0x00|false|false
1738 -|crc16_tms37157|0x1021|0x3791|0x0000|true|true
1739 -|crc16_a|0x1021|0x6363|0x0000|true|true
1740 -|crc16_riello|0x1021|0x554D|0x0000|true|true
1741 -|crc16_ccitt_false|0x1021|0xFFFF|0x0000|false|false
1742 -|crc16_arc|0x8005|0x0000|0x0000|true|true
1743 -|crc16_arc_ccitt|0x1021|0x1D0F|0x0000|false|false
1744 -|crc16_buypass|0x8005|0x0000|0x0000|false|false
1745 -|crc16_cdma2000|0xC867|0xFFFF|0x0000|false|false
1746 -|crc16_dds110|0x8005|0x800D|0x0000|false|false
1747 -|crc16_dect_r|0x0589|0x0000|0x0001|false|false
1748 -|crc16_dect_x|0x0589|0x0000|0x0000|false|false
1749 -|crc16_dnp|0x3D65|0x0000|0xFFFF|true|true
1750 -|crc16_en_13757|0x3D65|0x0000|0xFFFF|false|false
1751 -|crc16_genibus|0x1021|0xFFFF|0xFFFF|false|false
1752 -|crc16_maxim|0x8005|0x0000|0xFFFF|true|true
1753 -|crc16_mcrf4xx|0x1021|0xFFFF|0x0000|true|true
1754 -|crc16_t10_dif|0x8BB7|0x0000|0x0000|false|false
1755 -|crc16_teledisk|0xA097|0x0000|0x0000|false|false
1756 -|crc16_usb|0x8005|0xFFFF|0xFFFF|true|true
1757 -|crc16_kermit|0x1021|0x0000|0x0000|true|true
1692 +|=Parameter model name|=poly|=init|=(% style="width: 184px;" %)xorout|=(% style="width: 69px;" %)refin|=refout
1693 +|crc8|0x07|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1694 +|crc8_cdma2000|0c9B|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1695 +|crc8_darc| |0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1696 +|crc8_dvb_s2| |0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1697 +|crc8_ebu| |0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1698 +|crc8_i_code| |0xFD|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1699 +|crc8_itu| |0x00|(% style="width:184px" %)0X55|(% style="width:69px" %)false|false
1700 +|crc8_maxim| |0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1701 +|crc8_rohc| |0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1702 +|crc8_wcdma| |0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
1703 +|crc8_sae_j1850| |0xFF|(% style="width:184px" %)0xFF|(% style="width:69px" %)false|false
1704 +|crc8_opensafaty| |0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
1705 +|crc16_tms37157| |0x3791|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1706 +|crc16_a| |0x6363|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1707 +|crc16_riello| |0x554D|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1708 +|crc16_ccitt_false| |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1709 +|crc16_arc| |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1710 +|crc16_arc_ccitt| |0X1D0F|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1711 +|crc16_cdma2000| |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1712 +|crc16_dds110| |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1713 +|crc16_dect_r| |0x800D|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1714 +|crc16_dect_x| |0x0000|(% style="width:184px" %)0x0001|(% style="width:69px" %)false|false
1715 +|crc16_dnp| |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1716 +|crc16_en_13757| |0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1717 +|crc16_genibus| |0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
1718 +|crc16_maxim| |0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
1719 +|crc16_mcrf4xx| |0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1720 +|crc16_r10_dif| |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1721 +|crc16_teldisk| |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1722 +|crc16_usb| |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1723 +|crc16_kermit| |0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1724 +| | |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1725 +| | |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
1726 +| | |0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
1727 +| | |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
1728 +| | |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1729 +| | |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
1730 +| | |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1731 +| | |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
1732 +| | |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1733 +| | |0x00000000|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
1734 +| | |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1735 +| | |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)true|true
1736 +| | |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
1737 +| | |0x0000000000000000|(% style="width:184px" %)0x0000000000000000|(% style="width:69px" %)false|false
1738 +| | |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
1739 +| | |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)false|false
1740 +| | |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
1741 +| | | |(% style="width:184px" %) |(% style="width:69px" %) |
1742 +| | | |(% style="width:184px" %) |(% style="width:69px" %) |
1743 +| | | |(% style="width:184px" %) |(% style="width:69px" %) |
1758 1758  
1759 -(% class="wikigeneratedid" %)
1760 -Table 9-1
1761 -
1762 -== **crc:calc(string crcValue)** ==
1763 -
1764 -**Function:** Calculate CRC result
1765 -
1766 -**Parameter:**
1767 -
1768 -crcValue: the value to be calculated
1769 -
1770 -**Return:**
1771 -
1772 -Succeed: calculated result
1773 -
1774 -Failed: multi, error code
1745 +(((
1746 +== **set_network(table config)** ==
1775 1775  )))
1776 1776  
1777 -**For example:**
1749 +**Function:** Set V-BOX network, take effect after restart
1778 1778  
1779 -{{code language="LUA"}}
1780 -function crcTest.main()
1751 +**parameter:**
1781 1781  
1782 -local param = {
1753 +//config~:// incoming network configuration table
1783 1783  
1784 -name = '',
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.
1785 1785  
1786 -width = 64,
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.
1787 1787  
1788 -poly = 0x42F0E1EBA9EA3693,
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.
1789 1789  
1790 -init = 0xFFFFFFFFFFFFFFFF,
1791 -
1792 -xorout = 0xFFFFFFFFFFFFFFFF,
1793 -
1794 -refin = 1,
1795 -
1796 -refout = 1
1797 -
1798 -}
1799 -
1800 -crc64,err = crc.init(param)
1801 -
1802 -if not crc64 then
1803 -
1804 -print("Crc init failed:", err)
1805 -else
1806 -
1807 -crcvalue = crc64:calc("123456789")
1808 -
1809 -print(string.format("crc64 calc :0X%16X", crcvalue))
1810 -
1811 -end
1812 -
1813 -end
1814 -{{/code}}
1815 -
1816 -= **10 Special function for V-NET** =
1817 -
1818 -== **normal_get_alldata()** ==
1819 -
1820 -**Function: **Obtain the data of all the monitoring points
1821 -
1822 -**Parameter: None**
1823 -
1824 1824  **Return:**
1825 1825  
1826 -Succeed: table two-dimensional arrays, as follows:
1786 +Succeed: true
1827 1827  
1828 -* Each item is a monitoring point and contains 4 attributes:
1829 -** 1: ID
1830 -** 2: status
1831 -** 3: tag name
1832 -** 4: value
1833 -* Status contains 3 enumerated values
1834 -** 0: offline
1835 -** 1: online
1836 -** 2: timeout
1837 -* Customization returns an empty table if there is no configuration, otherwise returns "field name/field content"
1788 +Faied: multi
1838 1838  
1839 -**For example:**
1790 +(((
1791 +== **9.7 remote_com_start(string config)** ==
1792 +)))
1840 1840  
1841 -{{code language="LUA"}}
1842 -{
1794 +**Function:**
1843 1843  
1844 -[1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'},
1796 +start serial port pass-through
1845 1845  
1846 -[2]= {[1]=1235, [2]=1, [3]='humi', [4]='67'},
1847 -
1848 -...
1849 -
1850 -[n]= {[1]=xxxx, [2]=x, [3]='xxxx', [4]='xx.x'},
1851 -
1852 -}
1853 -
1854 -Failed: table, empty table
1855 -{{/code}}
1856 -
1857 -== **normal_setdata_byname(string name, string data)** ==
1858 -
1859 -**Function:** Write data to the monitoring point name
1860 -
1861 1861  **Parameter:**
1862 1862  
1863 -name: the name of monitoring point
1800 +//config: //incoming serial port parameter configuration, JSON format
1864 1864  
1865 -data: the data to be written
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
1866 1866  
1867 1867  **Return:**
1868 1868  
1869 -Succeed: string: The value of the monitor point before it is written
1812 +Succeed: true
1870 1870  
1871 -Failed: nil
1814 +Failed: multi
1872 1872  
1873 -== **normal_getdata_byname(string name)** ==
1816 +(((
1817 +== **9.8 remote_com_stop()** ==
1818 +)))
1874 1874  
1875 -**Function:** Read the data of the monitoring point name
1820 +**Function:**
1876 1876  
1877 -**Parameter:**
1822 +close serial port pass-through
1878 1878  
1879 -name: the name of monitoring point
1880 -
1881 1881  **Return:**
1882 1882  
1883 -Succeed: string
1826 +Succeed: true
1884 1884  
1885 -Failed: nil
1886 -
1887 -= **11 MySQL database operation** =
1888 -
1889 -== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
1890 -
1891 -**Function:** Configure database connection parameters
1892 -
1893 -**Parameter:**
1894 -
1895 -sourcename: the name of database
1896 -
1897 -username: the username of the connection
1898 -
1899 -password: the password of the connection
1900 -
1901 -host: the host name of the connection
1902 -
1903 -port: the host port of the connection
1904 -
1905 -character: the character set of the connection
1906 -
1907 -**Return:**
1908 -
1909 -Succeed: string
1910 -
1911 1911  Failed: multi
1912 1912  
1913 -== **luaMySql.exec(string statement)** ==
1830 +(((
1831 +== **9.9 remote_com_state()** ==
1832 +)))
1914 1914  
1915 -**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
1834 +**Function:**
1916 1916  
1917 -**Parameter:**
1836 +query the serial port pass-through status and pass-through server domain name and port
1918 1918  
1919 -statement: the given SQL statement
1920 -
1921 1921  **Return:**
1922 1922  
1923 -Succeed: status: returns the number of rows affected by SQL statement execution.
1840 +Succeed:
1924 1924  
1925 -Failed: nil, errorString
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)
1926 1926  
1927 -== **luaMySql.execWithResult(string statement)** ==
1928 -
1929 -**Function:** Execute the given SQL statement returning the result set (check)
1930 -
1931 -**Parameter:**
1932 -
1933 -statement: the given SQL statement
1934 -
1935 -**Return:**
1936 -
1937 -Succeed: table: returns the result set
1938 -
1939 -Failed: nil, errorString
1940 -
1941 -**For example:**
1942 -
1943 -{{code language="LUA"}}
1944 -mysql = require"mysqlclient"
1945 -
1946 -function DataInitRight()
1947 -
1948 -local dbName = "db_lua1"
1949 -
1950 -local user = "root"
1951 -
1952 -local pwd = "123456"
1953 -
1954 -local host = "192.168.56.186"
1955 -
1956 -local port = 3306
1957 -local character = "UTF8"
1958 -
1959 -mysql.init(dbName, user, pwd, host, port, character)
1960 -
1961 -end
1962 -
1963 -function ExecFunc()
1964 -
1965 -status, errorString = mysql.exec("delete from tb_lua1 where mykey =
1966 -
1967 -10;")
1968 -
1969 -if nil == status then
1970 -
1971 -print("ExecFunc() error:", errorString)
1972 -
1973 -return -1
1974 -
1975 -else
1976 -
1977 -print("the number of rows affected by the command:", status)
1978 -
1979 -end
1980 -
1981 -return 0
1982 -
1983 -end
1984 -
1985 -function ExecWithResultFunc()
1986 -
1987 -status, errorString = mysql.execWithResult("select * from tb_lua1;")
1988 -
1989 -if nil == status then
1990 -
1991 -print("ExecWithResultFunc() error:", errorString)
1992 -
1993 -return -1
1994 -
1995 -else
1996 -
1997 -print("ExecWithResultFunc()
1998 -
1999 -success
2000 -
2001 -: status
2002 -
2003 -type
2004 -
2005 -=
2006 -
2007 -",
2008 -
2009 -type(status))
2010 -
2011 -print("ExecWithResultFunc() success : status len = ", #status)
2012 -
2013 -local num = #status
2014 -
2015 -local i = 1
2016 -
2017 -if num > 0 then
2018 -
2019 -for i = 1, num, 1 do
2020 -
2021 -local var = string.format("select result[%d] :mykey = %d,
2022 -
2023 -value = %s", i, status[i].mykey, status[i].value)
2024 -
2025 -print(var)
2026 -
2027 -end
2028 -
2029 -end
2030 -
2031 -print("---------------")
2032 -
2033 -end
2034 -
2035 -return 0
2036 -end
2037 -
2038 -function luaMysql_apiTest.main()
2039 -
2040 -print("script running ...")
2041 -
2042 -DataInitRight()
2043 -
2044 ---use exec demo
2045 -
2046 -if ExecFunc() < 0 then
2047 -
2048 -return
2049 -
2050 -end
2051 -
2052 ---use execWithResult demo
2053 -
2054 -if ExecWithResultFunc() < 0 then
2055 -
2056 -return
2057 -
2058 -end
2059 -
2060 -print("script running success")
2061 -
2062 -end
2063 -{{/code}}
2064 -
2065 -= **12 Message summary algorithm** =
2066 -
2067 -== **hmac(string hash_func, string key, string message)** ==
2068 -
2069 -**Function:** HMAC calculate
2070 -
2071 -**Function name**
2072 -
2073 -hash_func:
2074 -
2075 -* [md5, sha1, sha224, sha256, sha384, sha512]
2076 -* [sha512_224, sha512_256, sha3_224, sha3_256]
2077 -* [sha3_384, sha3_512]
2078 -
2079 -**Parameter:**
2080 -
2081 -key: the key
2082 -
2083 -message: message content
2084 -
2085 -**Return:**
2086 -
2087 -Succeed: string, calculation result
2088 -
2089 -Failed: nil
2090 -
2091 -**For example:**
2092 -
2093 -{{code language="LUA"}}
2094 -local sha = require"sha2"
2095 -
2096 -function hmac_test.main()
2097 -
2098 -local hmac = sha.hmac
2099 -
2100 -print(hmac(sha.sha1,
2101 -
2102 -"your key", "your message"))
2103 -
2104 -end
2105 -{{/code}}
2106 -
2107 -== **sha(string message** ==
2108 -
2109 -**Function:** SHA calculate
2110 -
2111 -**Function name:**
2112 -
2113 -sha:
2114 -
2115 -* sha1, sha224, sha256, sha384, sha512]
2116 -* [sha512_224, sha512_256, sha3_224, sha3_256]
2117 -* [sha3_384, sha3_512]
2118 -
2119 -**Parameter:**
2120 -
2121 -key: the key
2122 -
2123 -message: message content
2124 -
2125 -**Return:**
2126 -
2127 -Succeed: string, calculation result
2128 -
2129 -Failed: nil
2130 -
2131 -For example:
2132 -
2133 -{{code language="LUA"}}
2134 -local sha = require"sha2"
2135 -
2136 -function sha_test.main()
2137 -
2138 -local sha256 = sha.sha256
2139 -
2140 -print(sha256("your message"))
2141 -
2142 -end
2143 -{{/code}}
1845 +Failed: multi