Mercurial > cpython-lru_cache-weakref

annotate Doc/includes/sqlite3/load_extension.py @ 78069:a8aa77458e12 3.2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add c_size_t and c_ssize_t to the ctypes summary table.
author Antoine Pitrou <solipsis@pitrou.net>
date Thu, 12 Jul 2012 20:31:50 +0200
parents 74d81a3a0d56
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
59372
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
1 import sqlite3
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
2
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
3 con = sqlite3.connect(":memory:")
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
4
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
5 # enable extension loading
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
6 con.enable_load_extension(True)
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
7
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
8 # Load the fulltext search extension
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
9 con.execute("select load_extension('./fts3.so')")
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
10
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
11 # alternatively you can load the extension using an API call:
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
12 # con.load_extension("./fts3.so")
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
13
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
14 # disable extension laoding again
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
15 con.enable_load_extension(False)
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
16
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
17 # example from SQLite wiki
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
18 con.execute("create virtual table recipe using fts3(name, ingredients)")
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
19 con.executescript("""
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
20 insert into recipe (name, ingredients) values ('broccoli stew', 'broccoli peppers cheese tomatoes');
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
21 insert into recipe (name, ingredients) values ('pumpkin stew', 'pumpkin onions garlic celery');
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
22 insert into recipe (name, ingredients) values ('broccoli pie', 'broccoli cheese onions flour');
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
23 insert into recipe (name, ingredients) values ('pumpkin pie', 'pumpkin sugar flour butter');
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
24 """)
3003c1656e2a Merged new pysqlite version 2.6.0 from trunk.
Gerhard Häring <gh@ghaering.de>
parents:
diff changeset
25 for row in con.execute("select rowid, name, ingredients from recipe where name match 'pie'"):
65473
74d81a3a0d56 Syntax fixes for examples in the Doc/includes
Senthil Kumaran <orsenthil@gmail.com>
parents: 59372
diff changeset
26 print(row)