Changes for page 01 Lua Functions
Last modified by Theodore Xu on 2023/10/26 10:51
From version 7.1
edited by Stone Wu
on 2022/07/12 11:18
on 2022/07/12 11:18
Change comment:
There is no comment for this version
To version 21.1
edited by Theodore Xu
on 2023/10/26 10:51
on 2023/10/26 10:51
Change comment:
There is no comment for this version
Summary
-
Page properties (3 modified, 0 added, 0 removed)
Details
- Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 -V-BOX.V-Net. 1\.UserManual.04 Lua Script.WebHome1 +V-BOX.V-Net.Manual.04 Lua Script.WebHome - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. Stone1 +XWiki.AiXia - Content
-
... ... @@ -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 RS422616 +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 port1169 +[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 points1179 +[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},--n monitoring points 1174 1174 1175 1175 }, 1176 1176 1177 -[2]=14, ~-~-ID1183 +[2]=14, --ID 1178 1178 1179 -[3]='Modbus TCP' ~-~-n monitoring points1185 +[3]='Modbus TCP' --n monitoring points 1180 1180 1181 1181 }, 1182 1182 1183 -[2]={ ~-~-The second communication port1189 +[2]={--The second communication port 1184 1184 1185 -[1]={}, ~-~-The monitoring point of the second communication port is not configured and is empty1191 +[1]={},--The monitoring point of the second communication port is not configured and is empty 1186 1186 1187 -[2]=15, ~-~-ID1193 +[2]=15, --ID 1188 1188 1189 -[3]='WECON' ~-~-communication protocol name1195 +[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") ... ... @@ -1347,175 +1347,14 @@ 1347 1347 {{/code}} 1348 1348 1349 1349 ((( 1350 - =**8 Internal register** =1359 + 1351 1351 ))) 1352 1352 1353 -The internal registers of the box are divided into bit addresses and word addresses, which can be accessed in two ways (taking HDW as an example): 1354 - 1355 -**Access by word, prefix @W_HDW.** 1356 - 1357 -For example: @W_HDW0 represents the first word of the system data area, @W_HDW1 represents the second word of the system data area. 1358 - 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 - 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. 1362 - 1363 -(% class="box infomessage" %) 1364 1364 ((( 1365 -**✎Note: ** 1366 - 1367 -* The address in @B_HDX is taken from the word in @W_HDW, so pay special attention when using the address. 1368 -** For example, @B_HDX1020.12 is to access the 13th bit of the 1020th word. The value of this bit is the same as the word obtained by @W_HDW001020. The 13th bit of this word is actually the same bit as @B_HDX1020.12. 1369 -* The address of the bit address @B_HDX has a decimal point, while the word address is an integer. 1363 += **8 General Functions** = 1370 1370 ))) 1371 1371 1372 - 1373 1373 ((( 1374 -== **Data storage area（HDW/HDX）** == 1375 -))) 1376 - 1377 -The system storage area (HDW) of the V-BOX is used to store temporary data: 1378 - 1379 -1. Access by word, the number range is: "@W_HDW0"-"@W_HDW299999". 1380 -1. Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15". 1381 - 1382 -((( 1383 -== **8.2 Special data area (HSW/HSX)** == 1384 - 1385 -(% class="box infomessage" %) 1386 -((( 1387 -**✎Note: ** 1388 - 1389 -* //HSW// is a system special register, so please refer to the system special register table during use. Do not use addresses that are not mentioned in the table, and use the addresses stated in the table with caution (example: restart ("@W_HSW0") Writing a value of 1 will cause V-BOX to restart). 1390 -* //Without any conditions. Direct use ("@W_HSW0") will cause the V-BOX to restart continuously.// When using ("@W_HSW0") address, please add judgment conditions, such as: connection to MQTT fails, there is no network, the value of a PLC address meets the condition or counts to a certain value. 1391 -))) 1392 -))) 1393 - 1394 -The system data area (HSW) of the box is used for system special registers (system reserved). Use //addr_getword// to obtain the following register information: 1395 - 1396 -(% class="table-bordered" %) 1397 -|=(% style="width: 151px;" %)address|=(% style="width: 169px;" %)function|=(% style="width: 456px;" %)Read and write status: read only, write only, read and write 1398 -|(% style="width:151px" %)@W_HSW0|(% style="width:169px" %)restart|(% style="width:456px" %)read and write 1399 -|(% style="width:151px" %)@W_HSW1|(% style="width:169px" %)Box time: year|(% style="width:456px" %)read and write 1400 -|(% style="width:151px" %)@W_HSW2|(% style="width:169px" %)Box time: month|(% style="width:456px" %)read and write 1401 -|(% style="width:151px" %)@W_HSW3|(% style="width:169px" %)Box time: day|(% style="width:456px" %)read and write 1402 -|(% style="width:151px" %)@W_HSW4|(% style="width:169px" %)Box time: hour|(% style="width:456px" %)read and write 1403 -|(% style="width:151px" %)@W_HSW5|(% style="width:169px" %)Box time: minute|(% style="width:456px" %)read and write 1404 -|(% style="width:151px" %)@W_HSW6|(% style="width:169px" %)Box time: second|(% style="width:456px" %)read and write 1405 -|(% style="width:151px" %)@W_HSW7|(% style="width:169px" %)Box time: week|(% style="width:456px" %)read and write 1406 -|(% style="width:151px" %)@W_HSW8|(% style="width:169px" %)Ethernet IP1|(% style="width:456px" %)read only 1407 -|(% style="width:151px" %)@W_HSW9|(% style="width:169px" %)Ethernet IP2|(% style="width:456px" %)read only 1408 -|(% style="width:151px" %)@W_HSW10|(% style="width:169px" %)Ethernet IP3|(% style="width:456px" %)read only 1409 -|(% style="width:151px" %)@W_HSW11|(% style="width:169px" %)Ethernet IP4|(% style="width:456px" %)read only 1410 -|(% style="width:151px" %)@W_HSW12|(% style="width:169px" %)Ethernet Mask 1|(% style="width:456px" %)read only 1411 -|(% style="width:151px" %)@W_HSW13|(% style="width:169px" %)Ethernet Mask 2|(% style="width:456px" %)read only 1412 -|(% style="width:151px" %)@W_HSW14|(% style="width:169px" %)Ethernet Mask 3|(% style="width:456px" %)read only 1413 -|(% style="width:151px" %)@W_HSW15|(% style="width:169px" %)Ethernet Mask 4|(% style="width:456px" %)read only 1414 -|(% style="width:151px" %)@W_HSW16|(% style="width:169px" %)Ethernet Gateway 1|(% style="width:456px" %)read only 1415 -|(% style="width:151px" %)@W_HSW17|(% style="width:169px" %)Ethernet Gateway 2|(% style="width:456px" %)read only 1416 -|(% style="width:151px" %)@W_HSW18|(% style="width:169px" %)Ethernet Gateway 3|(% style="width:456px" %)read only 1417 -|(% style="width:151px" %)@W_HSW19|(% style="width:169px" %)Ethernet Gateway 4|(% style="width:456px" %)read only 1418 -|(% style="width:151px" %)@W_HSW21|(% style="width:169px" %)Ethernet MAC1|(% style="width:456px" %)read only 1419 -|(% style="width:151px" %)@W_HSW22|(% style="width:169px" %)Ethernet MAC2|(% style="width:456px" %)read only 1420 -|(% style="width:151px" %)@W_HSW23|(% style="width:169px" %)Ethernet MAC3|(% style="width:456px" %)read only 1421 -|(% style="width:151px" %)@W_HSW24|(% style="width:169px" %)Ethernet MAC4|(% style="width:456px" %)read only 1422 -|(% style="width:151px" %)@W_HSW25|(% style="width:169px" %)Ethernet MAC3|(% style="width:456px" %)read only 1423 -|(% style="width:151px" %)@W_HSW26|(% style="width:169px" %)Ethernet MAC4|(% style="width:456px" %)read only 1424 -|(% style="width:151px" %)@W_HSW128|(% style="width:169px" %)WIFI IP1|(% style="width:456px" %)read only 1425 -|(% style="width:151px" %)@W_HSW129|(% style="width:169px" %)WIFI IP2|(% style="width:456px" %)read only 1426 -|(% style="width:151px" %)@W_HSW130|(% style="width:169px" %)WIFI IP3|(% style="width:456px" %)read only 1427 -|(% style="width:151px" %)@W_HSW131|(% style="width:169px" %)WIFI IP4|(% style="width:456px" %)read only 1428 -|(% style="width:151px" %)@W_HSW132|(% style="width:169px" %)WIFI Mask 1|(% style="width:456px" %)read only 1429 -|(% style="width:151px" %)@W_HSW133|(% style="width:169px" %)WIFI Mask 2|(% style="width:456px" %)read only 1430 -|(% style="width:151px" %)@W_HSW134|(% style="width:169px" %)WIFI Mask 3|(% style="width:456px" %)read only 1431 -|(% style="width:151px" %)@W_HSW135|(% style="width:169px" %)WIFI Mask 4|(% style="width:456px" %)read only 1432 -|(% style="width:151px" %)@W_HSW136|(% style="width:169px" %)WIFI Gateway 1|(% style="width:456px" %)read only 1433 -|(% style="width:151px" %)@W_HSW137|(% style="width:169px" %)WIFI Gateway 2|(% style="width:456px" %)read only 1434 -|(% style="width:151px" %)@W_HSW138|(% style="width:169px" %)WIFI Gateway 3|(% style="width:456px" %)read only 1435 -|(% style="width:151px" %)@W_HSW139|(% style="width:169px" %)WIFI Gateway 4|(% style="width:456px" %)read only 1436 -|(% style="width:151px" %)@W_HSW140|(% style="width:169px" %)WIFI MAC1|(% style="width:456px" %)read only 1437 -|(% style="width:151px" %)@W_HSW141|(% style="width:169px" %)WIFI MAC2|(% style="width:456px" %)read only 1438 -|(% style="width:151px" %)@W_HSW142|(% style="width:169px" %)WIFI MAC3|(% style="width:456px" %)read only 1439 -|(% style="width:151px" %)@W_HSW143|(% style="width:169px" %)WIFI MAC4|(% style="width:456px" %)read only 1440 -|(% style="width:151px" %)@W_HSW144|(% style="width:169px" %)WIFI MAC5|(% style="width:456px" %)read only 1441 -|(% style="width:151px" %)@W_HSW145|(% style="width:169px" %)WIFI MAC6|(% style="width:456px" %)read only 1442 -|(% style="width:151px" %)@W_HSW146|(% style="width:169px" %)WIFI Signal value|(% style="width:456px" %)read only 1443 -|(% style="width:151px" %)@W_HSW148|(% style="width:169px" %)4G IP1|(% style="width:456px" %)read only 1444 -|(% style="width:151px" %)@W_HSW149|(% style="width:169px" %)4G IP2|(% style="width:456px" %)read only 1445 -|(% style="width:151px" %)@W_HSW150|(% style="width:169px" %)4G IP3|(% style="width:456px" %)read only 1446 -|(% style="width:151px" %)@W_HSW151|(% style="width:169px" %)4G IP4|(% style="width:456px" %)read only 1447 -|(% style="width:151px" %)@W_HSW152|(% style="width:169px" %)4G Mask 1|(% style="width:456px" %)read only 1448 -|(% style="width:151px" %)@W_HSW153|(% style="width:169px" %)4G Mask 2|(% style="width:456px" %)read only 1449 -|(% style="width:151px" %)@W_HSW154|(% style="width:169px" %)4G Mask 3|(% style="width:456px" %)read only 1450 -|(% style="width:151px" %)@W_HSW155|(% style="width:169px" %)4G Mask 4|(% style="width:456px" %)read only 1451 -|(% style="width:151px" %)@W_HSW156|(% style="width:169px" %)4G Gateway 1|(% style="width:456px" %)read only 1452 -|(% style="width:151px" %)@W_HSW157|(% style="width:169px" %)4G Gateway 2|(% style="width:456px" %)read only 1453 -|(% style="width:151px" %)@W_HSW158|(% style="width:169px" %)4G Gateway 3|(% style="width:456px" %)read only 1454 -|(% style="width:151px" %)@W_HSW159|(% style="width:169px" %)4G Gateway 4|(% style="width:456px" %)read only 1455 -|(% style="width:151px" %)@W_HSW160|(% style="width:169px" %)4G MAC1|(% style="width:456px" %)read only 1456 -|(% style="width:151px" %)@W_HSW161|(% style="width:169px" %)4G MAC2|(% style="width:456px" %)read only 1457 -|(% style="width:151px" %)@W_HSW162|(% style="width:169px" %)4G MAC3|(% style="width:456px" %)read only 1458 -|(% style="width:151px" %)@W_HSW163|(% style="width:169px" %)4G MAC4|(% style="width:456px" %)read only 1459 -|(% style="width:151px" %)@W_HSW164|(% style="width:169px" %)4G MAC5|(% style="width:456px" %)read only 1460 -|(% style="width:151px" %)@W_HSW165|(% style="width:169px" %)4G MAC6|(% style="width:456px" %)read only 1461 -|(% style="width:151px" %)@W_HSW166|(% style="width:169px" %)4G Signal value|(% style="width:456px" %)read only 1462 - 1463 -**Others** 1464 - 1465 -* Access password: addr_getstring("@W_HSW27", 16) 1466 -* Machine code: addr_getstring("@W_HSW60", 64) 1467 -* Positioning method (@W_HSW167): (read only) 1468 -** Latitude and longitude 1469 -*** Longitude: addr_getdouble("@W_HSW168") (read only) 1470 -*** Latitude: addr_getdouble("@W_HSW172") (read only) 1471 -** Base station positioning 1472 -*** LAC: addr_getdword("@W_HSW168") (read only) 1473 -*** CI: addr_getdword("@W_HSW172") (read only) 1474 -* Convert base station to latitude and longitude via API 1475 -** Longitude: addr_getdouble("@W_HSW187") (read only) 1476 -** Latitude: addr_getdouble("@W_HSW183") (read only) 1477 -* Operator information: addr_getdword("@W_HSW181") (read only) 1478 -* Networking mode: addr_getword("@W_HSW177") (read only) 1479 -** 0: Ethernet 1480 -** 1: WIFI 1481 -** 2: 4G 1482 -** 3: 2G 1483 -* Map fence flag: addr_getword("@W_HSW178") (read only) 1484 -** 0: No map fence is drawn 1485 -** 1: Draw a map fence and the box is in the fence 1486 -** 2: Draw a map fence and the box is not in the fence 1487 -* SIM card status addr_getword("@W_HSW179") (read only) 1488 -** 1: No card detected 1489 -** 2: Card insertion detected 1490 -** 3: The card status is abnormal 1491 -* MQTT status addr_getword("@W_HSW180") (read only) 1492 -** 1: online, 2: offline 1493 -* IO interface, X is read only, Y is read and write (H series) 1494 -** addr_getbit(addr1), addr_setbit(addr2) 1495 -** addr1:"@B_Y0" "@B_Y1" "@B_X0" "@B_X1" 1496 -** addr2:"@B_Y0" "@B_Y1" 1497 -* Obtaining IMEI (read only) 1498 -** addr_getstring("@W_HSW191",17) 1499 -* Obtaining ICCID (read only) 1500 -** addr_getstring("@W_HSW225",15) 1501 - 1502 -((( 1503 -== **Power-down storage area (HAW/HAX)** == 1504 - 1505 -The system storage area (HAW) is used for the system power-down hold registers: 1506 - 1507 -1. Accessed as a word, numbered in the range: "@W_HAW0"-"@W_HAW199999". 1508 -1. Accessed by bit, the numbering range is: "@B_HAX0.0"-"@B_HAX199999.15". 1509 - 1510 -(% class="box infomessage" %) 1511 -((( 1512 -**✎Note:** HAW/HAX is a power-down hold, that is, the registers of this type can retain the data before power-down in case of power-down. 1513 -))) 1514 - 1515 -= **9 General Functions** = 1516 -))) 1517 - 1518 -((( 1519 1519 == **send_sms_ira(string number, string message)** == 1520 1520 ))) 1521 1521 ... ... @@ -1534,7 +1534,7 @@ 1534 1534 Failed: multi 1535 1535 1536 1536 ((( 1537 -== ** 9.2send_sms_ucs2(string number, string message)** ==1385 +== **send_sms_ucs2(string number, string message)** == 1538 1538 ))) 1539 1539 1540 1540 **Function:** ... ... @@ -1683,7 +1683,7 @@ 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: 1534 +**Return:** 1687 1687 1688 1688 Success: crc object 1689 1689 ... ... @@ -1742,7 +1742,7 @@ 1742 1742 Failed: multi, error code 1743 1743 ))) 1744 1744 1745 - Example:1593 +**For example:** 1746 1746 1747 1747 {{code language="LUA"}} 1748 1748 function crcTest.main() ... ... @@ -1781,7 +1781,7 @@ 1781 1781 end 1782 1782 {{/code}} 1783 1783 1784 -= ** 10Special function for V-NET** =1632 += **9 Special function for V-NET** = 1785 1785 1786 1786 == **normal_get_alldata()** == 1787 1787 ... ... @@ -1804,8 +1804,9 @@ 1804 1804 ** 2: timeout 1805 1805 * Customization returns an empty table if there is no configuration, otherwise returns "field name/field content" 1806 1806 1807 -For example: 1655 +**For example:** 1808 1808 1657 +{{code language="LUA"}} 1809 1809 { 1810 1810 1811 1811 [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'}, ... ... @@ -1819,6 +1819,7 @@ 1819 1819 } 1820 1820 1821 1821 Failed: table, empty table 1671 +{{/code}} 1822 1822 1823 1823 == **normal_setdata_byname(string name, string data)** == 1824 1824 ... ... @@ -1838,8 +1838,6 @@ 1838 1838 1839 1839 == **normal_getdata_byname(string name)** == 1840 1840 1841 - 1842 - 1843 1843 **Function:** Read the data of the monitoring point name 1844 1844 1845 1845 **Parameter:** ... ... @@ -1852,186 +1852,8 @@ 1852 1852 1853 1853 Failed: nil 1854 1854 1855 -= **1 1MySQL databaseoperation** =1703 += **10 Message summary algorithm** = 1856 1856 1857 -== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** == 1858 - 1859 -**Function:** Configure database connection parameters 1860 - 1861 -**Parameter:** 1862 - 1863 -sourcename: the name of database 1864 - 1865 -username: the username of the connection 1866 - 1867 -password: the password of the connection 1868 - 1869 -host: the host name of the connection 1870 - 1871 -port: the host port of the connection 1872 - 1873 -character: the character set of the connection 1874 - 1875 -**Return:** 1876 - 1877 -Succeed: string 1878 - 1879 -Failed: multi 1880 - 1881 -== **luaMySql.exec(string statement)** == 1882 - 1883 -**Function:** Execute the given SQL statement without returning the result set (add, delete, change) 1884 - 1885 -**Parameter:** 1886 - 1887 -statement: the given SQL statement 1888 - 1889 -**Return:** 1890 - 1891 -Succeed: status: returns the number of rows affected by SQL statement execution. 1892 - 1893 -Failed: nil, errorString 1894 - 1895 -== **luaMySql.execWithResult(string statement)** == 1896 - 1897 -**Function:** Execute the given SQL statement returning the result set (check) 1898 - 1899 -**Parameter:** 1900 - 1901 -statement: the given SQL statement 1902 - 1903 -**Return:** 1904 - 1905 -Succeed: table: returns the result set 1906 - 1907 -Failed: nil, errorString 1908 - 1909 -For example: 1910 - 1911 -{{code language="LUA"}} 1912 -mysql = require"mysqlclient" 1913 - 1914 -function DataInitRight() 1915 - 1916 -local dbName = "db_lua1" 1917 - 1918 -local user = "root" 1919 - 1920 -local pwd = "123456" 1921 - 1922 -local host = "192.168.56.186" 1923 - 1924 -local port = 3306 1925 -local character = "UTF8" 1926 - 1927 -mysql.init(dbName, user, pwd, host, port, character) 1928 - 1929 -end 1930 - 1931 -function ExecFunc() 1932 - 1933 -status, errorString = mysql.exec("delete from tb_lua1 where mykey = 1934 - 1935 -10;") 1936 - 1937 -if nil == status then 1938 - 1939 -print("ExecFunc() error:", errorString) 1940 - 1941 -return -1 1942 - 1943 -else 1944 - 1945 -print("the number of rows affected by the command:", status) 1946 - 1947 -end 1948 - 1949 -return 0 1950 - 1951 -end 1952 - 1953 -function ExecWithResultFunc() 1954 - 1955 -status, errorString = mysql.execWithResult("select * from tb_lua1;") 1956 - 1957 -if nil == status then 1958 - 1959 -print("ExecWithResultFunc() error:", errorString) 1960 - 1961 -return -1 1962 - 1963 -else 1964 - 1965 -print("ExecWithResultFunc() 1966 - 1967 -success 1968 - 1969 -: status 1970 - 1971 -type 1972 - 1973 -= 1974 - 1975 -", 1976 - 1977 -type(status)) 1978 - 1979 -print("ExecWithResultFunc() success : status len = ", #status) 1980 - 1981 -local num = #status 1982 - 1983 -local i = 1 1984 - 1985 -if num > 0 then 1986 - 1987 -for i = 1, num, 1 do 1988 - 1989 -local var = string.format("select result[%d] :mykey = %d, 1990 - 1991 -value = %s", i, status[i].mykey, status[i].value) 1992 - 1993 -print(var) 1994 - 1995 -end 1996 - 1997 -end 1998 - 1999 -print("---------------") 2000 - 2001 -end 2002 - 2003 -return 0 2004 -end 2005 - 2006 -function luaMysql_apiTest.main() 2007 - 2008 -print("script running ...") 2009 - 2010 -DataInitRight() 2011 - 2012 ---use exec demo 2013 - 2014 -if ExecFunc() < 0 then 2015 - 2016 -return 2017 - 2018 -end 2019 - 2020 ---use execWithResult demo 2021 - 2022 -if ExecWithResultFunc() < 0 then 2023 - 2024 -return 2025 - 2026 -end 2027 - 2028 -print("script running success") 2029 - 2030 -end 2031 -{{/code}} 2032 - 2033 -= **12 Message summary algorithm** = 2034 - 2035 2035 == **hmac(string hash_func, string key, string message)** == 2036 2036 2037 2037 **Function:** HMAC calculate ... ... @@ -2056,7 +2056,7 @@ 2056 2056 2057 2057 Failed: nil 2058 2058 2059 -For example: 1729 +**For example:** 2060 2060 2061 2061 {{code language="LUA"}} 2062 2062 local sha = require"sha2"