| Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 1 | import sqlite3 |
| Collin Winter | 45d569b | 2007-08-07 01:20:21 +0000 | [diff] [blame^] | 2 | import hashlib |
| Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 3 | |
| 4 | def md5sum(t): |
| Collin Winter | 45d569b | 2007-08-07 01:20:21 +0000 | [diff] [blame^] | 5 | return hashlib.md5(t).hexdigest() |
| Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 6 | |
| 7 | con = sqlite3.connect(":memory:") |
| 8 | con.create_function("md5", 1, md5sum) |
| 9 | cur = con.cursor() |
| 10 | cur.execute("select md5(?)", ("foo",)) |
| Collin Winter | 45d569b | 2007-08-07 01:20:21 +0000 | [diff] [blame^] | 11 | print(cur.fetchone()[0]) |