Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51

From 5.38 to 5.37 From 19.1 to 18.1

From version 18.1

edited by Theodore Xu
on 2023/08/25 09:48

Change comment: There is no comment for this version

To version 5.38

edited by Stone Wu
on 2022/07/12 11:10

Change comment: (Autosaved)

Raw
Rendered

Summary

Page properties (3 modified, 0 added, 0 removed)

Details

Page properties

Parent

@@ -1,1 +1,1 @@
--V-BOX.V-Net.Manual.04 Lua Script.WebHome
++V-BOX.V-Net.1\.User Manual.04 Lua Script.WebHome

Author

@@ -1,1 +1,1 @@
--XWiki.AiXia
++XWiki.Stone

Content

@@ -140,7 +140,7 @@
   Table 2-1
--(% class="box infomessage" %)
++(% class="box errormessage" %)
  (((
  **✎Note: **If HLword enters any other value, it will be treated as invalid.
  )))
@@ -608,12 +608,11 @@
  Attempting to use a script to open a serial port in an unsupported mode will result in an error directly, as below.
  |(((
--{{code language="LUA"}}
  local setup = {
  name = "COM2",
--mode = 422, -- COM2 does not support RS422
++mode = 422, ~-~- COM2 does not support RS422
  ...
@@ -620,7 +620,6 @@
  }
  serial.open(setup)
--{{/code}}
  )))
  **Data bit:**
@@ -1065,9 +1065,8 @@
  If there is no custom configuration, return an empty table, otherwise, return with "field name/field content"
--**For example:**
++E.g:
--{{code language="LUA"}}
  {
  [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5', [5]={"fruit"="apple"}},
@@ -1080,8 +1080,7 @@
  }
--Failed: table empty table
--{{/code}}
++Failed: //table// empty table
  (((
  == **bns_get_config(string from)** ==
@@ -1161,15 +1161,13 @@
  Type (1: switch, 2: number, 3: string)
--**For example:**
++E.g:
++ {
--{{code language="LUA"}}
--{
++[1]={~-~-The first communication port
--[1]={--The first communication port
++[1]={~-~-monitoring point array of the first communication port
--[1]={--monitoring point array of the first communication port
--
  [1]={[1]=11,[2]='data1',[3]=3,[4]=2},
  [2]={[1]=12,[2]='data2',[3]=3,[4]=2},
@@ -1176,23 +1176,23 @@
  ...
--[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},--n monitoring points
++[n]={[1]=xx,[2]='datan',[3]=x,[4]=x},~-~-n monitoring points
  },
--[2]=14, --ID
++[2]=14, ~-~-ID
--[3]='Modbus TCP' --n monitoring points
++[3]='Modbus TCP' ~-~-n monitoring points
  },
--[2]={--The second communication port
++[2]={~-~-The second communication port
--[1]={},--The monitoring point of the second communication port is not configured and is empty
++[1]={},~-~-The monitoring point of the second communication port is not configured and is empty
--[2]=15, --ID
++[2]=15, ~-~-ID
--[3]='WECON' --communication protocol name
++[3]='WECON' ~-~-communication protocol name
  },
@@ -1199,7 +1199,6 @@
  ...n communication ports and so on
  }
--{{/code}}
  Failed~:// table// empty table
@@ -1279,9 +1279,8 @@
  Succeed: //table// one-dimensional array
--**For example:**
++E.g:
--{{code language="LUA"}}
  {
  [1]="This is the oldest message", - the first is the oldest message
@@ -1293,7 +1293,6 @@
  [n]="This is the latest message", - the last is the latest message
  }
--{{/code}}
  Failede: nil
@@ -1311,7 +1311,7 @@
  == **https request** ==
--**For example:**
++Example：
  {{code language="LUA"}}
  local json = require("json")
@@ -1367,7 +1367,7 @@
  **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.**
--**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.
++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.
  (% class="box infomessage" %)
  (((
@@ -1389,7 +1389,7 @@
 . Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15".
  (((
--== **Special data area (HSW/HSX)** ==
++== **8.2 Special data area (HSW/HSX)** ==
  (% class="box infomessage" %)
  (((
@@ -1507,19 +1507,8 @@
  ** addr_getstring("@W_HSW191",17)
  * Obtaining ICCID (read only)
  ** addr_getstring("@W_HSW225",15)
--* (((
--TSAP settings of Siemens LOGO PLC*
  (((
--addr_setword("@W_0#HSW1200",8192) means set the Local TSAP as 20.00
--)))
--
--* (((
--addr_setword("@W_0#HSW1201",4096) means set the Remote TSAP as 10.00
--)))
--)))
--
--(((
  == **Power-down storage area (HAW/HAX)** ==
  The system storage area (HAW) is used for the system power-down hold registers:
@@ -1554,7 +1554,7 @@
  Failed: multi
  (((
--== **send_sms_ucs2(string number, string message)** ==
++== **9.2 send_sms_ucs2(string number, string message)** ==
  )))
  **Function:**
@@ -1703,7 +1703,7 @@
  * number [prarm.refin]: whether each byte of the data to be measured is inverted by bit, true or false.
  * number [prarm.refout]: after the calculation or before the heterodyning output, whether the whole data is inverted by bit, true or false.
--**Return:**
++Return:
  Success: crc object
@@ -1762,7 +1762,7 @@
  Failed: multi, error code
  )))
--**For example:**
++Example:
  {{code language="LUA"}}
  function crcTest.main()
@@ -1824,9 +1824,8 @@
  ** 2: timeout
  * Customization returns an empty table if there is no configuration, otherwise returns "field name/field content"
--**For example:**
++For example:
--{{code language="LUA"}}
  {
  [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'},
@@ -1840,7 +1840,6 @@
  }
  Failed: table, empty table
--{{/code}}
  == **normal_setdata_byname(string name, string data)** ==
@@ -1856,10 +1856,12 @@
  Succeed: string: The value of the monitor point before it is written
--Failed: nil
++Failed: mil
  == **normal_getdata_byname(string name)** ==
++
++
  **Function:** Read the data of the monitoring point name
  **Parameter:**
@@ -1870,86 +1870,198 @@
  Succeed: string
--Failed: nil
++Failed: mil
--= (% style="font-size:14px" %) (%%) =
++= **11 MySQL database operation** =
--= **12 Message summary algorithm** =
++== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
--== **hmac(string hash_func, string key, string message)** ==
++**Function:** Configure database connection parameters
--**Function:** HMAC calculate
++**Parameter:**
--**Function name**
++sourcename: the name of database
--hash_func:
++username: the username of the connection
--* [md5, sha1, sha224, sha256, sha384, sha512]
--* [sha512_224, sha512_256, sha3_224, sha3_256]
--* [sha3_384, sha3_512]
++password: the password of the connection
++host: the host name of the connection
++
++port: the host port of the connection
++
++character: the character set of the connection
++
++**Return:**
++
++Succeed: string
++
++Failed: multi
++
++== **luaMySql.exec(string statement)** ==
++
++**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
++
  **Parameter:**
--key: the key
++statement: the given SQL statement
--message: message content
++**Return:**
++Succeed: status: returns the number of rows affected by SQL statement execution.
++
++Failed: mil, errorString
++
++== **luaMySql.execWithResult(string statement)** ==
++
++**Function:** Execute the given SQL statement returning the result set (check)
++
++**Parameter:**
++
++statement: the given SQL statement
++
  **Return:**
--Succeed: string, calculation result
++Succeed: table: returns the result set
--Failed: nil
++Failed: mil, errorString
--**For example:**
++For example:
  {{code language="LUA"}}
--local sha = require"sha2"
++mysql = require"mysqlclient"
--function hmac_test.main()
++function DataInitRight()
--local hmac = sha.hmac
++local dbName = "db_lua1"
--print(hmac(sha.sha1,
++local user = "root"
--"your key", "your message"))
++local pwd = "123456"
++local host = "192.168.56.186"
++
++local port = 3306
++local character = "UTF8"
++
++mysql.init(dbName, user, pwd, host, port, character)
++
  end
--{{/code}}
--== **sha(string message** ==
++function ExecFunc()
--**Function:** SHA calculate
++status, errorString = mysql.exec("delete from tb_lua1 where mykey =
--**Function name:**
++10;")
--sha:
++if nil == status then
--*  sha1, sha224, sha256, sha384, sha512]
--* [sha512_224, sha512_256, sha3_224, sha3_256]
--* [sha3_384, sha3_512]
++print("ExecFunc() error:", errorString)
--**Parameter:**
++return -1
--key: the key
++else
--message: message content
++print("the number of rows affected by the command:", status)
--**Return:**
++end
--Succeed: string, calculation result
++return 0
--Failed: nil
++end
--For example:
++function ExecWithResultFunc()
--{{code language="LUA"}}
--local sha = require"sha2"
++status, errorString = mysql.execWithResult("select * from tb_lua1;")
--function sha_test.main()
++if nil == status then
--local sha256 = sha.sha256
++print("ExecWithResultFunc() error:", errorString)
--print(sha256("your message"))
++return -1
++else
++
++print("ExecWithResultFunc()
++
++success
++
++: status
++
++type
++
++=
++
++",
++
++type(status))
++
++print("ExecWithResultFunc() success : status len = ", #status)
++
++local num = #status
++
++local i = 1
++
++if num > 0 then
++
++for i = 1, num, 1 do
++
++local var = string.format("select result[%d] :mykey = %d,
++
++value = %s", i, status[i].mykey, status[i].value)
++
++print(var)
++
  end
++
++end
++
++print("---------------")
++
++end
++
++return 0
++end
++
++function luaMysql_apiTest.main()
++
++print("script running ...")
++
++DataInitRight()
++
++--use exec demo
++
++if ExecFunc() < 0 then
++
++return
++
++end
++
++--use execWithResult demo
++
++if ExecWithResultFunc() < 0 then
++
++return
++
++end
++
++print("script running success")
++
++end
  {{/code}}
++
++= **12 Message summary algorithm** =
++
++== **hmac(string hash_func, string key, string message)** ==
++
++**Function:** Execute the given SQL statement returning the result set (check)
++
++**Parameter:**
++
++statement: the given SQL statement
++
++**Return:**
++
++Succeed: table: returns the result set
++
++Failed: mil, errorString

Changes for page 01 Lua Functions

Summary

Details

Navigation

Table of Contents