Skip to content

bpo-43396: normalise naming in sqlite3 doc examples #24746

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
berkerpeksag merged 3 commits into from
Mar 4, 2021
Merged

bpo-43396: normalise naming in sqlite3 doc examples #24746

Changes from 1 commit
Commits
Show all changes
3 commits
Select commit Hold shift + click to select a range
44e77fc
Normalise docs: conn => con
Mar 4, 2021
9ff5290
Normalise docs: c => cur
Mar 4, 2021
8724545
Fix continuation line indents
Mar 4, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
Normalise docs: conn => con
  • Loading branch information
Erlend E. Aasland committed Mar 4, 2021
commit 44e77fcbf05a26c23f6be51a6498a0828aaf9fc4
22 changes: 11 additions & 11 deletions Doc/library/sqlite3.rst
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -26,14 +26,14 @@ 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()
c = con.cursor()

# Create table
c.execute('''CREATE TABLE stocks
Expand All @@ -43,17 +43,17 @@ and call its :meth:`~Cursor.execute` method to perform SQL commands::
c.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')
c = 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
Expand Down Expand Up @@ -764,20 +764,20 @@ Row Objects

Let's assume we initialize a table as in the example given above::

conn = sqlite3.connect(":memory:")
c = conn.cursor()
con = sqlite3.connect(":memory:")
c = con.cursor()
c.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()
con.commit()
c.close()

Now we plug :class:`Row` in::

>>> conn.row_factory = sqlite3.Row
>>> c = conn.cursor()
>>> con.row_factory = sqlite3.Row
>>> c = con.cursor()
>>> c.execute('select * from stocks')
<sqlite3.Cursor object at 0x7f4e7dd8fa80>
>>> r = c.fetchone()
Expand Down