Changes for page 01 Lua Functions

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

From 5.36 to 5.37 From 17.1 to 18.1

From version 5.37

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

Change comment: (Autosaved)

To version 17.1

edited by Theodore Xu
on 2023/08/24 16:45

Change comment: There is no comment for this version

Raw
Rendered

Summary

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

Details

Page properties

Parent

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

Author

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

Content

@@ -140,7 +140,7 @@
   Table 2-1
--(% class="box errormessage" %)
++(% class="box infomessage" %)
  (((
  **✎Note: **If HLword enters any other value, it will be treated as invalid.
  )))
@@ -608,11 +608,12 @@
  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
  ...
@@ -619,6 +619,7 @@
  }
  serial.open(setup)
++{{/code}}
  )))
  **Data bit:**
@@ -1063,8 +1063,9 @@
  If there is no custom configuration, return an empty table, otherwise, return with "field name/field content"
--E.g:
++**For example:**
++{{code language="LUA"}}
  {
  [1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5', [5]={"fruit"="apple"}},
@@ -1077,7 +1077,8 @@
  }
--Failed: //table// empty table
++Failed: table empty table
++{{/code}}
  (((
  == **bns_get_config(string from)** ==
@@ -1157,13 +1157,15 @@
  Type (1: switch, 2: number, 3: string)
--E.g:
-- {
++**For example:**
--[1]={~-~-The first communication port
++{{code language="LUA"}}
++{
--[1]={~-~-monitoring point array of the first communication port
++[1]={--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},
@@ -1170,23 +1170,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
  },
@@ -1193,6 +1193,7 @@
  ...n communication ports and so on
  }
++{{/code}}
  Failed~:// table// empty table
@@ -1272,8 +1272,9 @@
  Succeed: //table// one-dimensional array
--E.g:
++**For example:**
++{{code language="LUA"}}
  {
  [1]="This is the oldest message", - the first is the oldest message
@@ -1285,6 +1285,7 @@
  [n]="This is the latest message", - the last is the latest message
  }
++{{/code}}
  Failede: nil
@@ -1302,7 +1302,7 @@
  == **https request** ==
--Example：
++**For example:**
  {{code language="LUA"}}
  local json = require("json")
@@ -1358,7 +1358,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" %)
  (((
@@ -1380,7 +1380,7 @@
 . Access in bit mode, the number range is: "@B_HDX0.0"-"@B_HDX299999.15".
  (((
--== **8.2 Special data area (HSW/HSX)** ==
++== **Special data area (HSW/HSX)** ==
  (% class="box infomessage" %)
  (((
@@ -1498,8 +1498,19 @@
  ** 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:
@@ -1534,7 +1534,7 @@
  Failed: multi
  (((
--== **9.2 send_sms_ucs2(string number, string message)** ==
++== **send_sms_ucs2(string number, string message)** ==
  )))
  **Function:**
@@ -1683,7 +1683,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
@@ -1742,7 +1742,7 @@
  Failed: multi, error code
  )))
--Example:
++**For example:**
  {{code language="LUA"}}
  function crcTest.main()
@@ -1804,8 +1804,9 @@
  ** 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'},
@@ -1819,6 +1819,7 @@
  }
  Failed: table, empty table
++{{/code}}
  == **normal_setdata_byname(string name, string data)** ==
@@ -1834,12 +1834,10 @@
  Succeed: string: The value of the monitor point before it is written
--Failed: mil
++Failed: nil
  == **normal_getdata_byname(string name)** ==
--
--
  **Function:** Read the data of the monitoring point name
  **Parameter:**
@@ -1850,7 +1850,7 @@
  Succeed: string
--Failed: mil
++Failed: nil
  = **11 MySQL database operation** =
@@ -1890,7 +1890,7 @@
  Succeed: status: returns the number of rows affected by SQL statement execution.
--Failed: mil, errorString
++Failed: nil, errorString
  == **luaMySql.execWithResult(string statement)** ==
@@ -1904,144 +1904,152 @@
  Succeed: table: returns the result set
--Failed: mil, errorString
++Failed: nil, errorString
--For example:
++**For example:**
  {{code language="LUA"}}
--mysql = require"mysqlclient"
++-- Assuming the "mysqlclient" library is properly installed and available
++mysql = require("mysqlclient")
  function DataInitRight()
--
--local dbName = "db_lua1"
--
--local user = "root"
--
--local pwd = "123456"
--
--local host = "192.168.56.186"
--
--local port = 3306
--local character = "UTF8"
--
--mysql.init(dbName, user, pwd, host, port, character)
--
++    local dbName = "excel"
++    local user = "root"
++    local pwd = "XXXXX"
++    local host = "192.168.39.146"
++    local port = 3306
++    local character = "utf8mb3"
++
++    mysql.init(dbName, user, pwd, host, port, character)
  end
  function ExecFunc()
--
--status, errorString = mysql.exec("delete from tb_lua1 where mykey =
--
--10;")
--
--if nil == status then
--
--print("ExecFunc() error:", errorString)
--
--return -1
--
--else
--
--print("the number of rows affected by the command:", status)
--
++    status, errorString = mysql.exec("delete from student where Name = 'XXX';")  --Delete statement, column name = table element
++    if nil == status then
++        print("ExecFunc() error:", errorString)
++        return -1
++    else
++        print("the number of rows affected by the command:", status)
++    end
++        return 0
  end
--return 0
++function ExecWithResultFunc()
++    status, errorString = mysql.execWithResult("select * from student;")
++    if nil == status then
++        print("ExecWithResultFunc() error:", errorString)
++        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] :Num = %d，Name = %s，Age = %d", i, status[i].Num, status[i].Name,status[i].Age)   --Iterate through the data in the table, noting whether the elements are strings or numbers
++                print(var)
++            end
++        end
++        print("---------------")
++    end
++    return 0
  end
--function ExecWithResultFunc()
++function MySQL.main()
++    print("script running ...")
++    DataInitRight()
--status, errorString = mysql.execWithResult("select * from tb_lua1;")
++    -- use exec demo
++    if ExecFunc() < 0 then
++        return
++    end
--if nil == status then
++    -- use execWithResult demo
++    if ExecWithResultFunc() < 0 then
++        return
++    end
--print("ExecWithResultFunc() error:", errorString)
++    print("script running success")
++end
++{{/code}}
--return -1
++= **12 Message summary algorithm** =
--else
++== **hmac(string hash_func, string key, string message)** ==
--print("ExecWithResultFunc()
++**Function:** HMAC calculate
--success
++**Function name**
--: status
++hash_func:
--type
++* [md5, sha1, sha224, sha256, sha384, sha512]
++* [sha512_224, sha512_256, sha3_224, sha3_256]
++* [sha3_384, sha3_512]
--=
++**Parameter:**
--",
++key: the key
--type(status))
++message: message content
--print("ExecWithResultFunc() success : status len = ", #status)
++**Return:**
--local num = #status
++Succeed: string, calculation result
--local i = 1
++Failed: nil
--if num > 0 then
++**For example:**
--for i = 1, num, 1 do
++{{code language="LUA"}}
++local sha = require"sha2"
--local var = string.format("select result[%d] :mykey = %d,
++function hmac_test.main()
--value = %s", i, status[i].mykey, status[i].value)
++local hmac = sha.hmac
--print(var)
++print(hmac(sha.sha1,
--end
++"your key", "your message"))
  end
++{{/code}}
--print("---------------")
++== **sha(string message** ==
--end
++**Function:** SHA calculate
--return 0
--end
++**Function name:**
--function luaMysql_apiTest.main()
++sha:
--print("script running ...")
++*  sha1, sha224, sha256, sha384, sha512]
++* [sha512_224, sha512_256, sha3_224, sha3_256]
++* [sha3_384, sha3_512]
--DataInitRight()
++**Parameter:**
----use exec demo
++key: the key
--if ExecFunc() < 0 then
++message: message content
--return
++**Return:**
--end
++Succeed: string, calculation result
----use execWithResult demo
++Failed: nil
--if ExecWithResultFunc() < 0 then
++For example:
--return
++{{code language="LUA"}}
++local sha = require"sha2"
--end
++function sha_test.main()
--print("script running success")
++local sha256 = sha.sha256
++print(sha256("your message"))
++
  end
  {{/code}}
--
--= **12 Message ssummary 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