This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

classification
Title: Examples dropped from PDF version of SQLite docs
Type: Stage:
Components: Documentation Versions: Python 2.5
process
Status: closed Resolution: out of date
Dependencies: Superseder:
Assigned To: Nosy List: georg.brandl, tcarroll
Priority: normal Keywords:

Created on 2007-06-26 20:20 by tcarroll, last changed 2022-04-11 14:56 by admin. This issue is now closed.

Files
File name Uploaded Description Edit
Lib-13-13-3-PDF(US-Letter).pdf tcarroll, 2007-06-26 20:20 portion of PDF doc illustrating error
Lib-13-13-3-HTML.pdf tcarroll, 2007-06-26 20:21 portion of HTML doc illustrating non-error
Messages (4)
msg32406 - (view) Author: Terry Carroll (tcarroll) Date: 2007-06-26 20:20
In section 13.13 of the PDF version Python Library Reference (on SQLite), a number of examples are dropped and instead have what looks like a statement that should have had the examples imported.

The HTML pages look fine, however.

For example, in section 13.13.3, in the PDF file it reads:

"""
This example shows how to use parameters with qmark style:
 1.py
This example shows how to use the named style:
 2.py
"""

In the HTML, it reads, correctly:

"""
This example shows how to use parameters with qmark style:

  import sqlite3

  con = sqlite3.connect("mydb")

  cur = con.cursor()

  who = "Yeltsin"
  age = 72

  cur.execute("select name_last, age from people where name_last=? and age=?", (who, age))
  print cur.fetchone()

  Download as text (original file name: sqlite3/execute_1.py).

This example shows how to use the named style:

  import sqlite3

  con = sqlite3.connect("mydb")

  cur = con.cursor()

  who = "Yeltsin"
  age = 72

  cur.execute("select name_last, age from people where name_last=:who and age=:age",
    {"who": who, "age": age})
  print cur.fetchone()

  Download as text (original file name: sqlite3/execute_2.py). 

"""

I've only looked at Chapter 13.13 (because I'm starting to use SQLite) and have found this in the following sections:

 13.13.1 (under complete_statement)
 13.13.2 (under row_factory and text_factory)
 13.13.3 (4 instances)
 13.13.4 (5 instances)
 13.13.6 (1 instance)

I'm attaching PDFs of the start of section 13.13.3 for comparison purposes: one copy from the PDF from http://docs.python.org/ftp/python/doc/2.5/pdf-letter-2.5.zip and one copy from the HTML at http://docs.python.org/lib/sqlite3-Cursor-Objects.html

msg32407 - (view) Author: Terry Carroll (tcarroll) Date: 2007-06-26 20:21
Adding copy from HTML version,illustrating how it should look.
File Added: Lib-13-13-3-HTML.pdf
msg32408 - (view) Author: Terry Carroll (tcarroll) Date: 2007-06-26 20:31
Just a little bit more info: this also is present in the A4-version of the PDF (i.e., both PDF version), as well as both the US-Letter and A4 versions of the Postscript.  The HTML ZIP file appears okay.  I don't have LaTeX installed and have no way of checking that one.
msg55227 - (view) Author: Georg Brandl (georg.brandl) * (Python committer) Date: 2007-08-23 21:49
Obsolete now, the toolset that generated these PDFs is no longer used
for new versions.
History
Date User Action Args
2022-04-11 14:56:25adminsetgithub: 45132
2007-08-23 21:49:06georg.brandlsetstatus: open -> closed
resolution: out of date
messages: + msg55227
nosy: + georg.brandl
2007-06-26 20:20:10tcarrollcreate