[issue15460] SQLite cursor.description is not DB-API compatible

[Gerhard Häring]

Gerhard Häring  added the comment:

SQLite's columns aren't typed, only SQLite values are. So it's entirely 
possible for the same column to have different types, like the NULL type, the 
INTEGER type and the TEXT type.

It's thus impossible to give meaningful type information in a SQLite3 DB-API 
module. That's why it's set to None instead.

--
resolution:  -> wont fix
status: open -> closed

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue15460] SQLite cursor.description is not DB-API compatible

[Antoine Pitrou]

Changes by Antoine Pitrou :


--
nosy: +ghaering

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue15460] SQLite cursor.description is not DB-API compatible

[Tshepang Lekhonkhobe]

Changes by Tshepang Lekhonkhobe :


--
assignee:  -> docs@python
components: +Documentation -Library (Lib)
nosy: +docs@python, tshepang

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue15460] SQLite cursor.description is not DB-API compatible

[Charlie Clark]

New submission from Charlie Clark :

It says in the docs:
"""This read-only attribute provides the column names of the last query. To 
remain compatible with the Python DB API, it returns a 7-tuple for each column 
where the last six items of each tuple are None."""

According to the DB-API, however, the first two items, name and type, must be 
specified:
"""
The first two items (name and type_code) are mandatory, the other five are 
optional and are set to None if no meaningful values can be provided.
"""

Even with it's limited number of types SQLite is typed and should be able to 
return the type for column.

--
components: Library (Lib)
messages: 166498
nosy: CharlieX
priority: normal
severity: normal
status: open
title: SQLite cursor.description is not DB-API compatible
type: behavior

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com