Skip to content

bpo-44106: Improve sqlite3 example database contents #26027

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 9 commits into from
May 19, 2021
Merged

bpo-44106: Improve sqlite3 example database contents #26027

Changes from 1 commit
Commits
Show all changes
9 commits
Select commit Hold shift + click to select a range
d30184f
bpo-44106: Don't use politicians as example database
May 10, 2021
e0db380
Add NEWS
May 10, 2021
70da048
Update suspicious rules
May 10, 2021
8e79018
Address review: drop unneeded parens
May 11, 2021
64b9923
Address review: drop unneeded constants
May 11, 2021
1975601
Address review: drop NEWS entry
May 11, 2021
174fcef
Address review: complete incomplete fix
May 11, 2021
7429f7a
Address review: fix inconsistent naming
May 11, 2021
6455524
Update simple_tableprinter.py
berkerpeksag May 19, 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
Prev Previous commit
Next Next commit
Address review: drop unneeded constants
  • Loading branch information
Erlend E. Aasland committed May 11, 2021
commit 64b992333c1f72b029b7a7d6065630699dbe3764
5 changes: 1 addition & 4 deletions Doc/includes/sqlite3/simple_tableprinter.py
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -1,13 +1,10 @@
import sqlite3

FIELD_MAX_WIDTH = 20
TABLE_NAME = 'lang'
SELECT = f'select * from {TABLE_NAME} order by name, first_appeared'

con = sqlite3.connect("mydb")

cur = con.cursor()
cur.execute(SELECT)
cur.execute(f"select * from lang order by name, first_appeared")

# Print a header.
for fieldDesc in cur.description:
Expand Down