Changes for page 01 Lua Functions

Summary

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

Details

Page properties

Content

...	...	@@ -1872,10 +1872,186 @@
1872	1872
1873	1873	Failed: nil
1874	1874
1875		-= (% style="font-size:14px" %) (%%) =
	1875	+= **11 MySQL database operation** =
1876	1876
1877		-= **11 Message summary algorithm** =
	1877	+== **luaMySql.init(string sourcename, string username, string password, string host, number port, string character)** ==
1878	1878
	1879	+**Function:** Configure database connection parameters
	1880	+
	1881	+**Parameter:**
	1882	+
	1883	+sourcename: the name of database
	1884	+
	1885	+username: the username of the connection
	1886	+
	1887	+password: the password of the connection
	1888	+
	1889	+host: the host name of the connection
	1890	+
	1891	+port: the host port of the connection
	1892	+
	1893	+character: the character set of the connection
	1894	+
	1895	+**Return:**
	1896	+
	1897	+Succeed: string
	1898	+
	1899	+Failed: multi
	1900	+
	1901	+== **luaMySql.exec(string statement)** ==
	1902	+
	1903	+**Function:** Execute the given SQL statement without returning the result set (add, delete, change)
	1904	+
	1905	+**Parameter:**
	1906	+
	1907	+statement: the given SQL statement
	1908	+
	1909	+**Return:**
	1910	+
	1911	+Succeed: status: returns the number of rows affected by SQL statement execution.
	1912	+
	1913	+Failed: nil, errorString
	1914	+
	1915	+== **luaMySql.execWithResult(string statement)** ==
	1916	+
	1917	+**Function:** Execute the given SQL statement returning the result set (check)
	1918	+
	1919	+**Parameter:**
	1920	+
	1921	+statement: the given SQL statement
	1922	+
	1923	+**Return:**
	1924	+
	1925	+Succeed: table: returns the result set
	1926	+
	1927	+Failed: nil, errorString
	1928	+
	1929	+**For example:**
	1930	+
	1931	+{{code language="LUA"}}
	1932	+mysql = require"mysqlclient"
	1933	+
	1934	+function DataInitRight()
	1935	+
	1936	+local dbName = "db_lua1"
	1937	+
	1938	+local user = "root"
	1939	+
	1940	+local pwd = "123456"
	1941	+
	1942	+local host = "192.168.56.186"
	1943	+
	1944	+local port = 3306
	1945	+local character = "UTF8"
	1946	+
	1947	+mysql.init(dbName, user, pwd, host, port, character)
	1948	+
	1949	+end
	1950	+
	1951	+function ExecFunc()
	1952	+
	1953	+status, errorString = mysql.exec("delete from tb_lua1 where mykey =
	1954	+
	1955	+10;")
	1956	+
	1957	+if nil == status then
	1958	+
	1959	+print("ExecFunc() error:", errorString)
	1960	+
	1961	+return -1
	1962	+
	1963	+else
	1964	+
	1965	+print("the number of rows affected by the command:", status)
	1966	+
	1967	+end
	1968	+
	1969	+return 0
	1970	+
	1971	+end
	1972	+
	1973	+function ExecWithResultFunc()
	1974	+
	1975	+status, errorString = mysql.execWithResult("select * from tb_lua1;")
	1976	+
	1977	+if nil == status then
	1978	+
	1979	+print("ExecWithResultFunc() error:", errorString)
	1980	+
	1981	+return -1
	1982	+
	1983	+else
	1984	+
	1985	+print("ExecWithResultFunc()
	1986	+
	1987	+success
	1988	+
	1989	+: status
	1990	+
	1991	+type
	1992	+
	1993	+=
	1994	+
	1995	+",
	1996	+
	1997	+type(status))
	1998	+
	1999	+print("ExecWithResultFunc() success : status len = ", #status)
	2000	+
	2001	+local num = #status
	2002	+
	2003	+local i = 1
	2004	+
	2005	+if num > 0 then
	2006	+
	2007	+for i = 1, num, 1 do
	2008	+
	2009	+local var = string.format("select result[%d] :mykey = %d,
	2010	+
	2011	+value = %s", i, status[i].mykey, status[i].value)
	2012	+
	2013	+print(var)
	2014	+
	2015	+end
	2016	+
	2017	+end
	2018	+
	2019	+print("---------------")
	2020	+
	2021	+end
	2022	+
	2023	+return 0
	2024	+end
	2025	+
	2026	+function luaMysql_apiTest.main()
	2027	+
	2028	+print("script running ...")
	2029	+
	2030	+DataInitRight()
	2031	+
	2032	+--use exec demo
	2033	+
	2034	+if ExecFunc() < 0 then
	2035	+
	2036	+return
	2037	+
	2038	+end
	2039	+
	2040	+--use execWithResult demo
	2041	+
	2042	+if ExecWithResultFunc() < 0 then
	2043	+
	2044	+return
	2045	+
	2046	+end
	2047	+
	2048	+print("script running success")
	2049	+
	2050	+end
	2051	+{{/code}}
	2052	+
	2053	+= **12 Message summary algorithm** =
	2054	+
1879	1879	== **hmac(string hash_func, string key, string message)** ==
1880	1880
1881	1881	**Function:** HMAC calculate