[Python-checkins] bpo-43396: Normalise naming in sqlite3 doc examples (GH-24746)
berkerpeksag
webhook-mailer at python.org
Thu Mar 4 12:11:50 EST 2021
https://github.com/python/cpython/commit/374ee449331bc95d18c37f5032aaea1448462e58
commit: 374ee449331bc95d18c37f5032aaea1448462e58
branch: 3.9
author: Miss Islington (bot) <31488909+miss-islington at users.noreply.github.com>
committer: berkerpeksag <berker.peksag at gmail.com>
date: 2021-03-04T19:11:40+02:00
summary:
bpo-43396: Normalise naming in sqlite3 doc examples (GH-24746)
(cherry picked from commit 40d1b831ecd1b5b6a4fce9a908a6e61b50b360a0)
Co-authored-by: Erlend Egeberg Aasland <erlend.aasland at innova.no>
files:
M Doc/library/sqlite3.rst
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
index 2e2e5e9cdae37..600e85944f3a0 100644
--- a/Doc/library/sqlite3.rst
+++ b/Doc/library/sqlite3.rst
@@ -25,34 +25,34 @@ represents the database. Here the data will be stored in the
:file:`example.db` file::
import sqlite3
- conn = sqlite3.connect('example.db')
+ con = sqlite3.connect('example.db')
You can also supply the special name ``:memory:`` to create a database in RAM.
Once you have a :class:`Connection`, you can create a :class:`Cursor` object
and call its :meth:`~Cursor.execute` method to perform SQL commands::
- c = conn.cursor()
+ cur = con.cursor()
# Create table
- c.execute('''CREATE TABLE stocks
- (date text, trans text, symbol text, qty real, price real)''')
+ cur.execute('''CREATE TABLE stocks
+ (date text, trans text, symbol text, qty real, price real)''')
# Insert a row of data
- c.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
+ cur.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
# Save (commit) the changes
- conn.commit()
+ con.commit()
# We can also close the connection if we are done with it.
# Just be sure any changes have been committed or they will be lost.
- conn.close()
+ con.close()
The data you've saved is persistent and is available in subsequent sessions::
import sqlite3
- conn = sqlite3.connect('example.db')
- c = conn.cursor()
+ con = sqlite3.connect('example.db')
+ cur = con.cursor()
Usually your SQL operations will need to use values from Python variables. You
shouldn't assemble your query using Python's string operations because doing so
@@ -67,19 +67,19 @@ example::
# Never do this -- insecure!
symbol = 'RHAT'
- c.execute("SELECT * FROM stocks WHERE symbol = '%s'" % symbol)
+ cur.execute("SELECT * FROM stocks WHERE symbol = '%s'" % symbol)
# Do this instead
t = ('RHAT',)
- c.execute('SELECT * FROM stocks WHERE symbol=?', t)
- print(c.fetchone())
+ cur.execute('SELECT * FROM stocks WHERE symbol=?', t)
+ print(cur.fetchone())
# Larger example that inserts many records at a time
purchases = [('2006-03-28', 'BUY', 'IBM', 1000, 45.00),
('2006-04-05', 'BUY', 'MSFT', 1000, 72.00),
('2006-04-06', 'SELL', 'IBM', 500, 53.00),
]
- c.executemany('INSERT INTO stocks VALUES (?,?,?,?,?)', purchases)
+ cur.executemany('INSERT INTO stocks VALUES (?,?,?,?,?)', purchases)
To retrieve data after executing a SELECT statement, you can either treat the
cursor as an :term:`iterator`, call the cursor's :meth:`~Cursor.fetchone` method to
@@ -88,7 +88,7 @@ matching rows.
This example uses the iterator form::
- >>> for row in c.execute('SELECT * FROM stocks ORDER BY price'):
+ >>> for row in cur.execute('SELECT * FROM stocks ORDER BY price'):
print(row)
('2006-01-05', 'BUY', 'RHAT', 100, 35.14)
@@ -768,23 +768,23 @@ Row Objects
Let's assume we initialize a table as in the example given above::
- conn = sqlite3.connect(":memory:")
- c = conn.cursor()
- c.execute('''create table stocks
+ con = sqlite3.connect(":memory:")
+ cur = con.cursor()
+ cur.execute('''create table stocks
(date text, trans text, symbol text,
qty real, price real)''')
- c.execute("""insert into stocks
- values ('2006-01-05','BUY','RHAT',100,35.14)""")
- conn.commit()
- c.close()
+ cur.execute("""insert into stocks
+ values ('2006-01-05','BUY','RHAT',100,35.14)""")
+ con.commit()
+ cur.close()
Now we plug :class:`Row` in::
- >>> conn.row_factory = sqlite3.Row
- >>> c = conn.cursor()
- >>> c.execute('select * from stocks')
+ >>> con.row_factory = sqlite3.Row
+ >>> cur = con.cursor()
+ >>> cur.execute('select * from stocks')
<sqlite3.Cursor object at 0x7f4e7dd8fa80>
- >>> r = c.fetchone()
+ >>> r = cur.fetchone()
>>> type(r)
<class 'sqlite3.Row'>
>>> tuple(r)
More information about the Python-checkins
mailing list