Mercurial > cpython-lru_cache-weakref

annotate Doc/includes/sqlite3/execute_1.py @ 87690:66c1c9f32567 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add use_weakref option to functools.lru_cache The use_weakref option makes lru_cache create weak references to the function arguments when creating the cache key, which prevents them from staying in the memory forever even after all other references to them are gone. This is a proof of concept for http://bugs.python.org/issue19859
author Radomir Dopieralski <devel@sheep.art.pl>
date Tue, 03 Dec 2013 16:02:48 +0100
parents 9eb77d455be1
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
42604
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
1 import sqlite3
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
2
74959
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
3 con = sqlite3.connect(":memory:")
42604
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
4 cur = con.cursor()
74959
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
5 cur.execute("create table people (name_last, age)")
42604
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
6
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
7 who = "Yeltsin"
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
8 age = 72
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
9
74959
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
10 # This is the qmark style:
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
11 cur.execute("insert into people values (?, ?)", (who, age))
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
12
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
13 # And this is the named style:
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
14 cur.execute("select * from people where name_last=:who and age=:age", {"who": who, "age": age})
9eb77d455be1 Issue #13491: Fix many errors in sqlite3 documentation
Petri Lehtinen <petri@digip.org>
parents: 42604
diff changeset
15
42604
9e1529bf0442 Move the 3k reST doc tree in place.
Georg Brandl <georg@python.org>
parents:
diff changeset
16 print(cur.fetchone())