Skip to Content

Changes for page 01 Lua Functions

Last modified by Theodore Xu on 2023/10/26 10:51
From version 5.35
edited by Stone Wu
on 2022/07/12 11:00
Change comment: (Autosaved)
To version 5.40
edited by Stone Wu
on 2022/07/12 11:17
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1834,13 +1834,12 @@
1834 1834  
1835 1835  Succeed: string: The value of the monitor point before it is written
1836 1836  
1837 -Failed: mil
1837 +Failed: nil
1838 1838  
1839 1839  == **normal_getdata_byname(string name)** ==
1840 1840  
1841 1841  
1842 1842  
1843 -
1844 1844  **Function:** Read the data of the monitoring point name
1845 1845  
1846 1846  **Parameter:**
... ... @@ -1851,7 +1851,7 @@
1851 1851  
1852 1852  Succeed: string
1853 1853  
1854 -Failed: mil
1853 +Failed: nil
1855 1855  
1856 1856  = **11 MySQL database operation** =
1857 1857  
... ... @@ -1891,13 +1891,12 @@
1891 1891  
1892 1892  Succeed: status: returns the number of rows affected by SQL statement execution.
1893 1893  
1894 -Failed: mil, errorString
1893 +Failed: nil, errorString
1895 1895  
1896 1896  == **luaMySql.execWithResult(string statement)** ==
1897 1897  
1897 +**Function:** Execute the given SQL statement returning the result set (check)
1898 1898  
1899 -**Function:** Execute the given SQL statement returning the result set (che)
1900 -
1901 1901  **Parameter:**
1902 1902  
1903 1903  statement: the given SQL statement
... ... @@ -1904,6 +1904,210 @@
1904 1904  
1905 1905  **Return:**
1906 1906  
1907 -Succeed: status: returns the number of rows affected by SQL statement execution.
1905 +Succeed: table: returns the result set
1908 1908  
1909 -Failed: mil, errorString
1907 +Failed: nil, errorString
1908 +
1909 +For example:
1910 +
1911 +{{code language="LUA"}}
1912 +mysql = require"mysqlclient"
1913 +
1914 +function DataInitRight()
1915 +
1916 +local dbName = "db_lua1"
1917 +
1918 +local user = "root"
1919 +
1920 +local pwd = "123456"
1921 +
1922 +local host = "192.168.56.186"
1923 +
1924 +local port = 3306
1925 +local character = "UTF8"
1926 +
1927 +mysql.init(dbName, user, pwd, host, port, character)
1928 +
1929 +end
1930 +
1931 +function ExecFunc()
1932 +
1933 +status, errorString = mysql.exec("delete from tb_lua1 where mykey =
1934 +
1935 +10;")
1936 +
1937 +if nil == status then
1938 +
1939 +print("ExecFunc() error:", errorString)
1940 +
1941 +return -1
1942 +
1943 +else
1944 +
1945 +print("the number of rows affected by the command:", status)
1946 +
1947 +end
1948 +
1949 +return 0
1950 +
1951 +end
1952 +
1953 +function ExecWithResultFunc()
1954 +
1955 +status, errorString = mysql.execWithResult("select * from tb_lua1;")
1956 +
1957 +if nil == status then
1958 +
1959 +print("ExecWithResultFunc() error:", errorString)
1960 +
1961 +return -1
1962 +
1963 +else
1964 +
1965 +print("ExecWithResultFunc()
1966 +
1967 +success
1968 +
1969 +: status
1970 +
1971 +type
1972 +
1973 +=
1974 +
1975 +",
1976 +
1977 +type(status))
1978 +
1979 +print("ExecWithResultFunc() success : status len = ", #status)
1980 +
1981 +local num = #status
1982 +
1983 +local i = 1
1984 +
1985 +if num > 0 then
1986 +
1987 +for i = 1, num, 1 do
1988 +
1989 +local var = string.format("select result[%d] :mykey = %d,
1990 +
1991 +value = %s", i, status[i].mykey, status[i].value)
1992 +
1993 +print(var)
1994 +
1995 +end
1996 +
1997 +end
1998 +
1999 +print("---------------")
2000 +
2001 +end
2002 +
2003 +return 0
2004 +end
2005 +
2006 +function luaMysql_apiTest.main()
2007 +
2008 +print("script running ...")
2009 +
2010 +DataInitRight()
2011 +
2012 +--use exec demo
2013 +
2014 +if ExecFunc() < 0 then
2015 +
2016 +return
2017 +
2018 +end
2019 +
2020 +--use execWithResult demo
2021 +
2022 +if ExecWithResultFunc() < 0 then
2023 +
2024 +return
2025 +
2026 +end
2027 +
2028 +print("script running success")
2029 +
2030 +end
2031 +{{/code}}
2032 +
2033 += **12 Message summary algorithm** =
2034 +
2035 +== **hmac(string hash_func, string key, string message)** ==
2036 +
2037 +**Function:** HMAC calculate
2038 +
2039 +**Function name**
2040 +
2041 +hash_func:
2042 +
2043 +* [md5, sha1, sha224, sha256, sha384, sha512]
2044 +* [sha512_224, sha512_256, sha3_224, sha3_256]
2045 +* [sha3_384, sha3_512]
2046 +
2047 +**Parameter:**
2048 +
2049 +key: the key
2050 +
2051 +message: message content
2052 +
2053 +**Return:**
2054 +
2055 +Succeed: string, calculation result
2056 +
2057 +Failed: nil
2058 +
2059 +For example:
2060 +
2061 +{{code language="LUA"}}
2062 +local sha = require"sha2"
2063 +
2064 +function hmac_test.main()
2065 +
2066 +local hmac = sha.hmac
2067 +
2068 +print(hmac(sha.sha1,
2069 +
2070 +"your key", "your message"))
2071 +
2072 +end
2073 +{{/code}}
2074 +
2075 +== **sha(string message** ==
2076 +
2077 +**Function:** SHA calculate
2078 +
2079 +**Function name:**
2080 +
2081 +sha:
2082 +
2083 +* sha1, sha224, sha256, sha384, sha512]
2084 +* [sha512_224, sha512_256, sha3_224, sha3_256]
2085 +* [sha3_384, sha3_512]
2086 +
2087 +**Parameter:**
2088 +
2089 +key: the key
2090 +
2091 +message: message content
2092 +
2093 +**Return:**
2094 +
2095 +Succeed: string, calculation result
2096 +
2097 +Failed: nil
2098 +
2099 +For example:
2100 +
2101 +{{code language="LUA"}}
2102 +local sha = require"sha2"
2103 +
2104 +function sha_test.main()
2105 +
2106 +local sha256 = sha.sha256
2107 +
2108 +print(sha256("your message"))
2109 +
2110 +end
2111 +{{/code}}