How to create and invoke a custom function in a sqlite3 connection

#!/user/bin/env python#@Time: 2018/6/8 14:44#@Author:P gidysq#@File: createfuntest.py" "how to create and invoke a custom function in a sqlite3 connection" "ImportSqlite3,hashlib#Custom Functionsdefmd5sum (t):returnhashlib.md5 (t). Hexdigest ()#Create a staging database in memoryconn = Sqlite3.connect (": Memory:")#Create a function that can be called in an SQL statementConn.create_function ("MD5", 1, md5sum) cur=conn.cursor ()#calling a custom function in an SQL statementCur.execute ("SELECT MD5 (?)",["ad on the singles wild". Encode ()])Print(Cur.fetchone () [0])

How to create and invoke a custom function in a sqlite3 connection