Changes for page 01 Lua Functions

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

From 6.1 to 5.40 From 18.1 to 17.1

From version 17.1

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

Change comment: There is no comment for this version

To version 6.1

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

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.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)** ==
@@ -1860,6 +1860,8 @@
  == **normal_getdata_byname(string name)** ==
++
++
  **Function:** Read the data of the monitoring point name
  **Parameter:**
@@ -1926,72 +1926,128 @@
  Failed: nil, errorString
--**For example:**
++For example:
  {{code language="LUA"}}
---- Assuming the "mysqlclient" library is properly installed and available
--mysql = require("mysqlclient")
++mysql = require"mysqlclient"
  function DataInitRight()
--    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)
++
++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)
++
  end
  function ExecFunc()
--    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
++
++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)
++
  end
++return 0
++end
++
  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
++
++status, errorString = mysql.execWithResult("select * from tb_lua1;")
++
++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] :mykey = %d,
++
++value = %s", i, status[i].mykey, status[i].value)
++
++print(var)
++
  end
--function MySQL.main()
--    print("script running ...")
--    DataInitRight()
++end
--    -- use exec demo
--    if ExecFunc() < 0 then
--        return
--    end
++print("---------------")
--    -- use execWithResult demo
--    if ExecWithResultFunc() < 0 then
--        return
--    end
++end
--    print("script running success")
++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** =
@@ -2020,7 +2020,7 @@
  Failed: nil
--**For example:**
++For example:
  {{code language="LUA"}}
  local sha = require"sha2"

Changes for page 01 Lua Functions

Summary

Details

Navigation

Table of Contents