Skip to Content

Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51
From version 5.38
edited by Stone Wu
on 2022/07/12 11:10
Change comment: (Autosaved)
To version 21.1
edited by Theodore Xu
on 2023/10/26 10:51
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.AiXia
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")
... ... @@ -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.2 send_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 -= **10 Special 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  
... ... @@ -1834,12 +1834,10 @@
1834 1834  
1835 1835  Succeed: string: The value of the monitor point before it is written
1836 1836  
1837 -Failed: mil
1687 +Failed: nil
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:**
... ... @@ -1850,198 +1850,84 @@
1850 1850  
1851 1851  Succeed: string
1852 1852  
1853 -Failed: mil
1701 +Failed: nil
1854 1854  
1855 -= **11 MySQL database operation** =
1703 += **10 Message summary algorithm** =
1856 1856  
1857 -== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
1705 +== **hmac(string hash_func, string key, string message)** ==
1858 1858  
1859 -**Function:** Configure database connection parameters
1707 +**Function:** HMAC calculate
1860 1860  
1861 -**Parameter:**
1709 +**Function name**
1862 1862  
1863 -sourcename: the name of database
1711 +hash_func:
1864 1864  
1865 -username: the username of the connection
1713 +* [md5, sha1, sha224, sha256, sha384, sha512]
1714 +* [sha512_224, sha512_256, sha3_224, sha3_256]
1715 +* [sha3_384, sha3_512]
1866 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 1885  **Parameter:**
1886 1886  
1887 -statement: the given SQL statement
1719 +key: the key
1888 1888  
1889 -**Return:**
1721 +message: message content
1890 1890  
1891 -Succeed: status: returns the number of rows affected by SQL statement execution.
1892 -
1893 -Failed: mil, 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 1903  **Return:**
1904 1904  
1905 -Succeed: table: returns the result set
1725 +Succeed: string, calculation result
1906 1906  
1907 -Failed: mil, errorString
1727 +Failed: nil
1908 1908  
1909 -For example:
1729 +**For example:**
1910 1910  
1911 1911  {{code language="LUA"}}
1912 -mysql = require"mysqlclient"
1732 +local sha = require"sha2"
1913 1913  
1914 -function DataInitRight()
1734 +function hmac_test.main()
1915 1915  
1916 -local dbName = "db_lua1"
1736 +local hmac = sha.hmac
1917 1917  
1918 -local user = "root"
1738 +print(hmac(sha.sha1,
1919 1919  
1920 -local pwd = "123456"
1740 +"your key", "your message"))
1921 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 1929  end
1743 +{{/code}}
1930 1930  
1931 -function ExecFunc()
1745 +== **sha(string message** ==
1932 1932  
1933 -status, errorString = mysql.exec("delete from tb_lua1 where mykey =
1747 +**Function:** SHA calculate
1934 1934  
1935 -10;")
1749 +**Function name:**
1936 1936  
1937 -if nil == status then
1751 +sha:
1938 1938  
1939 -print("ExecFunc() error:", errorString)
1753 +* sha1, sha224, sha256, sha384, sha512]
1754 +* [sha512_224, sha512_256, sha3_224, sha3_256]
1755 +* [sha3_384, sha3_512]
1940 1940  
1941 -return -1
1757 +**Parameter:**
1942 1942  
1943 -else
1759 +key: the key
1944 1944  
1945 -print("the number of rows affected by the command:", status)
1761 +message: message content
1946 1946  
1947 -end
1763 +**Return:**
1948 1948  
1949 -return 0
1765 +Succeed: string, calculation result
1950 1950  
1951 -end
1767 +Failed: nil
1952 1952  
1953 -function ExecWithResultFunc()
1769 +For example:
1954 1954  
1955 -status, errorString = mysql.execWithResult("select * from tb_lua1;")
1771 +{{code language="LUA"}}
1772 +local sha = require"sha2"
1956 1956  
1957 -if nil == status then
1774 +function sha_test.main()
1958 1958  
1959 -print("ExecWithResultFunc() error:", errorString)
1776 +local sha256 = sha.sha256
1960 1960  
1961 -return -1
1778 +print(sha256("your message"))
1962 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 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 2031  {{/code}}
2032 -
2033 -= **12 Message summary algorithm** =
2034 -
2035 -== **hmac(string hash_func, string key, string message)** ==
2036 -
2037 -**Function:** Execute the given SQL statement returning the result set (check)
2038 -
2039 -**Parameter:**
2040 -
2041 -statement: the given SQL statement
2042 -
2043 -**Return:**
2044 -
2045 -Succeed: table: returns the result set
2046 -
2047 -Failed: mil, errorString