Changes for page 01 Lua Functions

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

From 5.19 to 5.20 From 5.37 to 5.38

From version 5.20

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

Change comment: (Autosaved)

To version 5.37

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

Change comment: (Autosaved)

Raw
Rendered

Summary

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

Details

Page properties

Content

@@ -1689,105 +1689,359 @@
  Failure: multi, error code
--
  (((
--== **set_network(table config)** ==
++|=Parameter model name|=poly|=init|=xorout|=refin|=refout
++|crc8|0x07|0x00|0x00|false|false
++|crc8_cdma2000|0x9B|0xFF|0x00|false|false
++|crc8_darc|0x39|0x00|0x00|true|true
++|crc8_dvb_s2|0xD5|0x00|0x00|false|false
++|crc8_ebu|0x1D|0xFF|0x00|true|true
++|crc8_i_code|0x1D|0xFD|0x00|false|false
++|crc8_itu|0x07|0x00|0x55|false|false
++|crc8_maxim|0x31|0x00|0x00|true|true
++|crc8_rohc|0x07|0xFF|0x00|true|true
++|crc8_wcdma|0x9B|0x00|0x00|true|true
++|crc8_sae_j1850|0x1D|0xFF|0xFF|false|false
++|crc8_opensafety|0x2F|0x00|0x00|false|false
++|crc16_tms37157|0x1021|0x3791|0x0000|true|true
++|crc16_a|0x1021|0x6363|0x0000|true|true
++|crc16_riello|0x1021|0x554D|0x0000|true|true
++|crc16_ccitt_false|0x1021|0xFFFF|0x0000|false|false
++|crc16_arc|0x8005|0x0000|0x0000|true|true
++|crc16_arc_ccitt|0x1021|0x1D0F|0x0000|false|false
++|crc16_buypass|0x8005|0x0000|0x0000|false|false
++|crc16_cdma2000|0xC867|0xFFFF|0x0000|false|false
++|crc16_dds110|0x8005|0x800D|0x0000|false|false
++|crc16_dect_r|0x0589|0x0000|0x0001|false|false
++|crc16_dect_x|0x0589|0x0000|0x0000|false|false
++|crc16_dnp|0x3D65|0x0000|0xFFFF|true|true
++|crc16_en_13757|0x3D65|0x0000|0xFFFF|false|false
++|crc16_genibus|0x1021|0xFFFF|0xFFFF|false|false
++|crc16_maxim|0x8005|0x0000|0xFFFF|true|true
++|crc16_mcrf4xx|0x1021|0xFFFF|0x0000|true|true
++|crc16_t10_dif|0x8BB7|0x0000|0x0000|false|false
++|crc16_teledisk|0xA097|0x0000|0x0000|false|false
++|crc16_usb|0x8005|0xFFFF|0xFFFF|true|true
++|crc16_kermit|0x1021|0x0000|0x0000|true|true
++
++(% class="wikigeneratedid" %)
++Table 9-1
++
++== **crc:calc(string crcValue)** ==
++
++**Function:** Calculate CRC result
++
++**Parameter:**
++
++crcValue: the value to be calculated
++
++**Return:**
++
++Succeed: calculated result
++
++Failed: multi, error code
  )))
--**Function:** Set V-BOX network, take effect after restart
++Example:
--**parameter:**
++{{code language="LUA"}}
++function crcTest.main()
--//config~:// incoming network configuration table
++local param = {
--1. connectMode: the way V-BOX connects to the server, 0: Ethernet, 1: WIFI, 2: 4G, 3: 2G, it is not allowed to be empty.
--1. ethernetEnable: Whether to enable Ethernet, 1: enable, 0: disable, and it is not allowed to be empty.
--1. ethernetLanIp: Set the LAN IP address. Only V-BOX with three network ports support this configuration, and other models of V-BOX do not support setting LAN IP. This item is allowed to be empty.
--1. ethernetIpMode: Whether to enable Ethernet static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
--1. ethernetIp: The IP address needs to be configured when the Ethernet static IP is used, and it is not allowed to be empty.
--1. ethernetNetmask: The subnet mask needs to be configured when Ethernet static IP is used, and it is not allowed to be empty.
--1. ethernetGateway: The gateway can be configured when Ethernet static IP is used.
++name = '',
--1. When using the Ethernet network, if the Gateway is empty, V-BOX will not connect to the server.
--1. If you only use Ethernet to directly connect to the PLC for communication, you do not need to configure a gateway.
++width = 64,
--1. ethernetFirstDns: You can configure the preferred DNS server when the Ethernet static IP is used, and it is allowed to be empty. If you use the Ethernet network and do not fill in the DNS server, V-BOX will not be connected to the server.
--1. ethernetSpareDns: Alternate DNS server can be configured when the Ethernet static IP is used, and it is allowed to be empty.
--1. wifiEnable: Whether to enable WIFI, 1: enable, 0: disable, it is not allowed to be empty. If it is a model that does not include WIFI, directly disable it.
--1. wifiName: WIFI name, if WIFI is enabled, it is not allowed to be empty.
--1. wifiPassword: WIFI password, it is allowed to be empty.
--1. wifiIpMode: Whether to enable WIFI static IP, 1: Enable static IP, 0: DHCP, not allowed to be empty.
--1. wifiIp: IP address needs to be configured when WIFI static IP is used, it is not allowed to be empty.
--1. wifiNetmask: The subnet mask needs to be configured when WIFI static IP is used, and it is not allowed to be empty.
--1. wifiGateway: The gateway can be configured when WIFI static IP is used, and it is not allowed to be empty.
--1. wifiFirstDns: You can configure the preferred DNS server when the WIFI static IP is used, and it is allowed to be empty. If you use the WIFI network and do not fill in the DNS server, V-BOX will not be connected to the server.
--1. wifiSpareDns: Alternate DNS server can be configured when the WIFI static IP is used, and it is allowed to be empty.
--1. mobileEnable: Whether to enable the mobile network, 1: enable, 0: disable, it is not allowed to be empty, if it does not include 4G models, directly disable it.
--1. mobileApnMode: Whether to manually configure the APN, 0: Use the default APN, 1: Manually configure the APN, it is not allowed to be empty.
--1. apnName: APN name, if you choose to manually configure APN, it is not allowed to be empty.
--1. apnPassword: APN username, it is allowed to be empty.
--1. apnUserName: APN number, it is allowed to be empty.
--1. apnNumber: APN number, it is allowed to be empty.
++poly = 0x42F0E1EBA9EA3693,
++init = 0xFFFFFFFFFFFFFFFF,
++
++xorout = 0xFFFFFFFFFFFFFFFF,
++
++refin = 1,
++
++refout = 1
++
++}
++
++crc64,err = crc.init(param)
++
++if not crc64 then
++
++print("Crc init failed:", err)
++else
++
++crcvalue = crc64:calc("123456789")
++
++print(string.format("crc64 calc :0X%16X", crcvalue))
++
++end
++
++end
++{{/code}}
++
++= **10 Special function for V-NET** =
++
++== **normal_get_alldata()** ==
++
++**Function: **Obtain the data of all the monitoring points
++
++**Parameter: None**
++
  **Return:**
--Succeed: true
++Succeed: table two-dimensional arrays, as follows:
--Faied: multi
++* Each item is a monitoring point and contains 4 attributes:
++** 1: ID
++** 2: status
++** 3: tag name
++** 4: value
++* Status contains 3 enumerated values
++** 0: offline
++** 1: online
++** 2: timeout
++* Customization returns an empty table if there is no configuration, otherwise returns "field name/field content"
--(((
--== **9.7 remote_com_start(string config)** ==
--)))
++For example:
--**Function:**
++{
--start serial port pass-through
++[1]= {[1]=1234, [2]=1, [3]='temp', [4]='23.5'},
++[2]= {[1]=1235, [2]=1, [3]='humi', [4]='67'},
++
++...
++
++[n]= {[1]=xxxx, [2]=x, [3]='xxxx', [4]='xx.x'},
++
++}
++
++Failed: table, empty table
++
++== **normal_setdata_byname(string name, string data)** ==
++
++**Function:** Write data to the monitoring point name
++
  **Parameter:**
--//config: //incoming serial port parameter configuration, JSON format
++name: the name of monitoring point
--1. type:0, serial port pass-through
--1. port: serial port number marked on the V-BOX
--1. comtype:0-RS232, 1-RS485, 2-RS422
--1. baudrate: Baud Rate
--1. data_length: Data Bits
--1. stop_bit: Stop Bit
--1. check_bit: Check Bit
++data: the data to be written
  **Return:**
--Succeed: true
++Succeed: string: The value of the monitor point before it is written
--Failed: multi
++Failed: mil
--(((
--== **9.8 remote_com_stop()** ==
--)))
++== **normal_getdata_byname(string name)** ==
--**Function:**
--close serial port pass-through
++**Function:** Read the data of the monitoring point name
++
++**Parameter:**
++
++name: the name of monitoring point
++
  **Return:**
--Succeed: true
++Succeed: string
++Failed: mil
++
++= **11 MySQL database operation** =
++
++== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
++
++**Function:** Configure database connection parameters
++
++**Parameter:**
++
++sourcename: the name of database
++
++username: the username of the connection
++
++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
--(((
--== **9.9 remote_com_state()** ==
--)))
++== **luaMySql.exec(string statement)** ==
--**Function:**
++**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
--query the serial port pass-through status and pass-through server domain name and port
++**Parameter:**
++statement: the given SQL statement
++
  **Return:**
--Succeed:
++Succeed: status: returns the number of rows affected by SQL statement execution.
--1. number, current pass-through status: 0-none 1,2-starting pass-through 3-penetrating 4,5-finishing pass-through 6-pass-through error
--1. string, pass-through server domain name and port number, xxxx (domain name): xxx (port number)
++Failed: mil, errorString
--Failed: multi
++== **luaMySql.execWithResult(string statement)** ==
++
++**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
++
++For example:
++
++{{code language="LUA"}}
++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)
++
++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)
++
++end
++
++return 0
++
++end
++
++function ExecWithResultFunc()
++
++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
++
++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 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