Changes for page 01 Lua Functions
Last modified by Theodore Xu on 2023/10/26 10:51
From 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.Manual.04 Lua Script.WebHome 1 +V-BOX.V-Net.1\.User Manual.04 Lua Script.WebHome - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. AiXia1 +XWiki.Stone - Content
-
... ... @@ -608,12 +608,11 @@ 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"}} 612 612 local setup = { 613 613 614 614 name = "COM2", 615 615 616 -mode = 422, -- COM2 does not support RS422 615 +mode = 422, ~-~- COM2 does not support RS422 617 617 618 618 ... 619 619 ... ... @@ -620,7 +620,6 @@ 620 620 } 621 621 622 622 serial.open(setup) 623 -{{/code}} 624 624 ))) 625 625 626 626 **Data bit:** ... ... @@ -1065,9 +1065,8 @@ 1065 1065 1066 1066 If there is no custom configuration, return an empty table, otherwise, return with "field name/field content" 1067 1067 1068 - **For example:**1066 +E.g: 1069 1069 1070 -{{code language="LUA"}} 1071 1071 { 1072 1072 1073 1073 [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5', [5]={"fruit"="apple"}}, ... ... @@ -1080,8 +1080,7 @@ 1080 1080 1081 1081 } 1082 1082 1083 -Failed: table empty table 1084 -{{/code}} 1080 +Failed: //table// empty table 1085 1085 1086 1086 ((( 1087 1087 == **bns_get_config(string from)** == ... ... @@ -1161,15 +1161,13 @@ 1161 1161 1162 1162 Type (1: switch, 2: number, 3: string) 1163 1163 1164 -**For example:** 1160 +E.g: 1161 + { 1165 1165 1166 -{{code language="LUA"}} 1167 -{ 1163 +[1]={~-~-The first communication port 1168 1168 1169 -[1]={-- The first communication port1165 +[1]={~-~-monitoring point array of the first communication port 1170 1170 1171 -[1]={--monitoring point array of the first communication port 1172 - 1173 1173 [1]={[1]=11,[2]='data1',[3]=3,[4]=2}, 1174 1174 1175 1175 [2]={[1]=12,[2]='data2',[3]=3,[4]=2}, ... ... @@ -1176,23 +1176,23 @@ 1176 1176 1177 1177 ... 1178 1178 1179 -[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 1180 1180 1181 1181 }, 1182 1182 1183 -[2]=14, --ID 1177 +[2]=14, ~-~-ID 1184 1184 1185 -[3]='Modbus TCP' --n monitoring points 1179 +[3]='Modbus TCP' ~-~-n monitoring points 1186 1186 1187 1187 }, 1188 1188 1189 -[2]={--The second communication port 1183 +[2]={~-~-The second communication port 1190 1190 1191 -[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 1192 1192 1193 -[2]=15, --ID 1187 +[2]=15, ~-~-ID 1194 1194 1195 -[3]='WECON' --communication protocol name 1189 +[3]='WECON' ~-~-communication protocol name 1196 1196 1197 1197 }, 1198 1198 ... ... @@ -1199,7 +1199,6 @@ 1199 1199 ...n communication ports and so on 1200 1200 1201 1201 } 1202 -{{/code}} 1203 1203 1204 1204 Failed~:// table// empty table 1205 1205 ... ... @@ -1279,9 +1279,8 @@ 1279 1279 1280 1280 Succeed: //table// one-dimensional array 1281 1281 1282 - **For example:**1275 +E.g: 1283 1283 1284 -{{code language="LUA"}} 1285 1285 { 1286 1286 1287 1287 [1]="This is the oldest message", - the first is the oldest message ... ... @@ -1293,7 +1293,6 @@ 1293 1293 [n]="This is the latest message", - the last is the latest message 1294 1294 1295 1295 } 1296 -{{/code}} 1297 1297 1298 1298 Failede: nil 1299 1299 ... ... @@ -1311,7 +1311,7 @@ 1311 1311 1312 1312 == **https request** == 1313 1313 1314 - **For example:**1305 +Example： 1315 1315 1316 1316 {{code language="LUA"}} 1317 1317 local json = require("json") ... ... @@ -1356,14 +1356,175 @@ 1356 1356 {{/code}} 1357 1357 1358 1358 ((( 1359 - 1350 += **8 Internal register** = 1360 1360 ))) 1361 1361 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" %) 1362 1362 ((( 1363 -= **8 General Functions** = 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. 1364 1364 ))) 1365 1365 1372 + 1366 1366 ((( 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 +((( 1367 1367 == **send_sms_ira(string number, string message)** == 1368 1368 ))) 1369 1369 ... ... @@ -1382,7 +1382,7 @@ 1382 1382 Failed: multi 1383 1383 1384 1384 ((( 1385 -== **send_sms_ucs2(string number, string message)** == 1537 +== **9.2 send_sms_ucs2(string number, string message)** == 1386 1386 ))) 1387 1387 1388 1388 **Function:** ... ... @@ -1531,7 +1531,7 @@ 1531 1531 * number [prarm.refin]: whether each byte of the data to be measured is inverted by bit, true or false. 1532 1532 * number [prarm.refout]: after the calculation or before the heterodyning output, whether the whole data is inverted by bit, true or false. 1533 1533 1534 - **Return:**1686 +Return: 1535 1535 1536 1536 Success: crc object 1537 1537 ... ... @@ -1590,7 +1590,7 @@ 1590 1590 Failed: multi, error code 1591 1591 ))) 1592 1592 1593 - **For example:**1745 +Example: 1594 1594 1595 1595 {{code language="LUA"}} 1596 1596 function crcTest.main() ... ... @@ -1629,7 +1629,7 @@ 1629 1629 end 1630 1630 {{/code}} 1631 1631 1632 -= ** 9Special function for V-NET** =1784 += **10 Special function for V-NET** = 1633 1633 1634 1634 == **normal_get_alldata()** == 1635 1635 ... ... @@ -1652,9 +1652,8 @@ 1652 1652 ** 2: timeout 1653 1653 * Customization returns an empty table if there is no configuration, otherwise returns "field name/field content" 1654 1654 1655 - **For example:**1807 +For example: 1656 1656 1657 -{{code language="LUA"}} 1658 1658 { 1659 1659 1660 1660 [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'}, ... ... @@ -1668,7 +1668,6 @@ 1668 1668 } 1669 1669 1670 1670 Failed: table, empty table 1671 -{{/code}} 1672 1672 1673 1673 == **normal_setdata_byname(string name, string data)** == 1674 1674 ... ... @@ -1688,6 +1688,8 @@ 1688 1688 1689 1689 == **normal_getdata_byname(string name)** == 1690 1690 1841 + 1842 + 1691 1691 **Function:** Read the data of the monitoring point name 1692 1692 1693 1693 **Parameter:** ... ... @@ -1700,8 +1700,186 @@ 1700 1700 1701 1701 Failed: nil 1702 1702 1703 -= **1 0Message summary algorithm** =1855 += **11 MySQL database operation** = 1704 1704 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 + 1705 1705 == **hmac(string hash_func, string key, string message)** == 1706 1706 1707 1707 **Function:** HMAC calculate ... ... @@ -1726,7 +1726,7 @@ 1726 1726 1727 1727 Failed: nil 1728 1728 1729 - **For example:**2059 +For example: 1730 1730 1731 1731 {{code language="LUA"}} 1732 1732 local sha = require"sha2"