summaryrefslogtreecommitdiff
path: root/doc/includes/sqlite3/progress.py
diff options
context:
space:
mode:
authorKali Kaneko <kali@leap.se>2013-05-30 04:35:35 +0900
committerKali Kaneko <kali@leap.se>2013-05-30 04:35:35 +0900
commit51032d827b297e4ea0cd529d57d73cd44e0c3905 (patch)
treecc69775b399af33479bcf1e3a7dbaa68b932b8b0 /doc/includes/sqlite3/progress.py
parent06d9e5e7714562b10c48a0482dec2acd4abee55a (diff)
cleanup docs
Diffstat (limited to 'doc/includes/sqlite3/progress.py')
-rw-r--r--doc/includes/sqlite3/progress.py29
1 files changed, 0 insertions, 29 deletions
diff --git a/doc/includes/sqlite3/progress.py b/doc/includes/sqlite3/progress.py
deleted file mode 100644
index b30941d..0000000
--- a/doc/includes/sqlite3/progress.py
+++ /dev/null
@@ -1,29 +0,0 @@
-from pysqlite2 import dbapi2 as sqlite3
-
-def progress():
- print "Query still executing. Please wait ..."
-
-con = sqlite3.connect(":memory:")
-con.execute("create table test(x)")
-
-# Let's create some data
-con.executemany("insert into test(x) values (?)", [(x,) for x in xrange(300)])
-
-# A progress handler, executed every 10 million opcodes
-con.set_progress_handler(progress, 10000000)
-
-# A particularly long-running query
-killer_stament = """
- select count(*) from (
- select t1.x from test t1, test t2, test t3
- )
- """
-
-con.execute(killer_stament)
-print "-" * 50
-
-# Clear the progress handler
-con.set_progress_handler(None, 0)
-
-con.execute(killer_stament)
-