@@ -13,7 +13,7 @@ SQLite for internal data storage. It's also possible to prototype an
13
13
application using SQLite and then port the code to a larger database such as
14
14
PostgreSQL or Oracle.
15
15
16
- pysqlite was written by Gerhard Häring and provides a SQL interface compliant
16
+ sqlite3 was written by Gerhard Häring and provides a SQL interface compliant
17
17
with the DB-API 2.0 specification described by :pep: `249 `.
18
18
19
19
To use the module, you must first create a :class: `Connection ` object that
@@ -50,8 +50,9 @@ is insecure; it makes your program vulnerable to an SQL injection attack.
50
50
51
51
Instead, use the DB-API's parameter substitution. Put ``? `` as a placeholder
52
52
wherever you want to use a value, and then provide a tuple of values as the
53
- second argument to the cursor's :meth: `~Cursor.execute ` method. (Other database modules
54
- may use a different placeholder, such as ``%s `` or ``:1 ``.) For example::
53
+ second argument to the cursor's :meth: `~Cursor.execute ` method. (Other database
54
+ modules may use a different placeholder, such as ``%s `` or ``:1 ``.) For
55
+ example::
55
56
56
57
# Never do this -- insecure!
57
58
symbol = 'IBM'
@@ -90,11 +91,12 @@ This example uses the iterator form::
90
91
.. seealso ::
91
92
92
93
http://www.pysqlite.org
93
- The pysqlite web page.
94
+ The pysqlite web page -- sqlite3 is developed externally under the name
95
+ "pysqlite".
94
96
95
97
http://www.sqlite.org
96
- The SQLite web page; the documentation describes the syntax and the available
97
- data types for the supported SQL dialect.
98
+ The SQLite web page; the documentation describes the syntax and the
99
+ available data types for the supported SQL dialect.
98
100
99
101
:pep: `249 ` - Database API Specification 2.0
100
102
PEP written by Marc-André Lemburg.
@@ -784,10 +786,10 @@ So if you are within a transaction and issue a command like ``CREATE TABLE
784
786
... ``, ``VACUUM ``, ``PRAGMA ``, the :mod: `sqlite3 ` module will commit implicitly
785
787
before executing that command. There are two reasons for doing that. The first
786
788
is that some of these commands don't work within transactions. The other reason
787
- is that pysqlite needs to keep track of the transaction state (if a transaction
789
+ is that sqlite3 needs to keep track of the transaction state (if a transaction
788
790
is active or not).
789
791
790
- You can control which kind of ``BEGIN `` statements pysqlite implicitly executes
792
+ You can control which kind of ``BEGIN `` statements sqlite3 implicitly executes
791
793
(or none at all) via the *isolation_level * parameter to the :func: `connect `
792
794
call, or via the :attr: `isolation_level ` property of connections.
793
795
@@ -799,8 +801,8 @@ statement, or set it to one of SQLite's supported isolation levels: "DEFERRED",
799
801
800
802
801
803
802
- Using pysqlite efficiently
803
- --------------------------
804
+ Using :mod: ` sqlite3 ` efficiently
805
+ --------------------------------
804
806
805
807
806
808
Using shortcut methods
0 commit comments