Changes for page 01 Lua Functions

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

From 5.26 to 5.27 From 12.1 to 13.1

From version 5.27

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

Change comment: There is no comment for this version

To version 12.1

edited by Hunter
on 2023/02/18 15:29

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.Hunter

Content

@@ -1,5 +1,17 @@
  = **1 Interface description** =
++(% style="width:749.222px" %)
++|=(% scope="row" style="width: 374px;" %)z|=(% style="width: 373px;" %)cxz
++|=(% style="width: 374px;" %) |(% style="width:373px" %)
++|=(% style="width: 374px;" %) |(% style="width:373px" %)
++
++|分类|宽|高
++|网页全屏|700-850|400
++|手机全屏|300|400
++|其他大图片|400左右|400左右
++|小图片|200左右|200左右
++
++
  == **Data type definition** ==
  |=**Type**|=**Description**
@@ -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,163 +1683,429 @@
  * 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
  Failure: multi, error code
--|=(% style="width: 193px;" %)Parameter model name|=(% style="width: 65px;" %)poly|=init|=(% style="width: 184px;" %)xorout|=(% style="width: 69px;" %)refin|=refout
--|(% style="width:193px" %)crc8|(% style="width:65px" %)0x07|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc8_cdma2000|(% style="width:65px" %)0x9B|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc8_darc|(% style="width:65px" %)0x39|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc8_dvb_s2|(% style="width:65px" %)0xD5|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc8_ebu|(% style="width:65px" %)0x1D|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc8_i_code|(% style="width:65px" %)0x1D|0xFD|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc8_itu|(% style="width:65px" %)0x07|0x00|(% style="width:184px" %)0X55|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc8_maxim|(% style="width:65px" %)0x31|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc8_rohc|(% style="width:65px" %)0x07|0xFF|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc8_wcdma|(% style="width:65px" %)0x9B|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc8_sae_j1850|(% style="width:65px" %)0x1D|0xFF|(% style="width:184px" %)0xFF|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc8_opensafaty|(% style="width:65px" %)0x2F|0x00|(% style="width:184px" %)0x00|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_tms37157|(% style="width:65px" %)0x1021|0x3791|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_a|(% style="width:65px" %)0x1021|0x6363|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_riello|(% style="width:65px" %)0x1021|0x554D|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_ccitt_false|(% style="width:65px" %)0x1021|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_arc|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_arc_ccitt|(% style="width:65px" %)0x1021|0X1D0F|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_cdma2000|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_dds110|(% style="width:65px" %)0xC867|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_dect_r|(% style="width:65px" %)0x0589|0x800D|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_dect_x|(% style="width:65px" %)0x0589|0x0000|(% style="width:184px" %)0x0001|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_dnp|(% style="width:65px" %)0x3D65|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_en_13757|(% style="width:65px" %)0x3D65|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_genibus|(% style="width:65px" %)0x1021|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_maxim|(% style="width:65px" %)0x8005|0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_mcrf4xx|(% style="width:65px" %)0x1021|0x0000|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_r10_dif|(% style="width:65px" %)0x8BB7|0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %)crc16_teldisk|(% style="width:65px" %)0xA097|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_usb|(% style="width:65px" %)0x8005|0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %)crc16_kermit|(% style="width:65px" %)0x1021|0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFF|(% style="width:184px" %)0x0000|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFF|(% style="width:184px" %)0xFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0x0000|(% style="width:184px" %)0x0000|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0xFFFFFFFF|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFF|(% style="width:184px" %)0x00000000|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0x00000000|(% style="width:184px" %)0x00000000|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0x0000000000000000|(% style="width:184px" %)0x0000000000000000|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)false|false
--|(% style="width:193px" %) |(% style="width:65px" %) |0xFFFFFFFFFFFFFFFF|(% style="width:184px" %)0xFFFFFFFFFFFFFFFF|(% style="width:69px" %)true|true
--|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
--|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
--|(% style="width:193px" %) |(% style="width:65px" %) | |(% style="width:184px" %) |(% style="width:69px" %) |
--
  (((
--== **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
++**For 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:**
++{{code language="LUA"}}
++{
--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
++{{/code}}
++
++== **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: nil
--(((
--== **9.8 remote_com_stop()** ==
--)))
++== **normal_getdata_byname(string name)** ==
--**Function:**
++**Function:** Read the data of the monitoring point name
--close serial port pass-through
++**Parameter:**
++name: the name of monitoring point
++
  **Return:**
--Succeed: true
++Succeed: string
++Failed: nil
++
++= **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: nil, 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: nil, 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 summary algorithm** =
++
++== **hmac(string hash_func, string key, string message)** ==
++
++**Function:** HMAC calculate
++
++**Function name**
++
++hash_func:
++
++* [md5, sha1, sha224, sha256, sha384, sha512]
++* [sha512_224, sha512_256, sha3_224, sha3_256]
++* [sha3_384, sha3_512]
++
++**Parameter:**
++
++key: the key
++
++message: message content
++
++**Return:**
++
++Succeed: string, calculation result
++
++Failed: nil
++
++**For example:**
++
++{{code language="LUA"}}
++local sha = require"sha2"
++
++function hmac_test.main()
++
++local hmac = sha.hmac
++
++print(hmac(sha.sha1,
++
++"your key", "your message"))
++
++end
++{{/code}}
++
++== **sha(string message** ==
++
++**Function:** SHA calculate
++
++**Function name:**
++
++sha:
++
++*  sha1, sha224, sha256, sha384, sha512]
++* [sha512_224, sha512_256, sha3_224, sha3_256]
++* [sha3_384, sha3_512]
++
++**Parameter:**
++
++key: the key
++
++message: message content
++
++**Return:**
++
++Succeed: string, calculation result
++
++Failed: nil
++
++For example:
++
++{{code language="LUA"}}
++local sha = require"sha2"
++
++function sha_test.main()
++
++local sha256 = sha.sha256
++
++print(sha256("your message"))
++
++end
++{{/code}}

Changes for page 01 Lua Functions

Summary

Details

Navigation

Table of Contents