TDBC

Open Tickets
Login
Bounty program for improvements to Tcl and certain Tcl packages.
Tcl 2019 Conference, Houston/TX, US, Nov 4-8
Send your abstracts to [email protected]
or submit via the online form by Sep 9.
Key: Active Review Fixed Tested Deferred Closed
# mtime type status subsystem title
comments
 
a4d7f2a64f 2010-04-17 22:32:56 Documentation Open   documentation for statement getSql missing

The statement object has a method "getSql" which is not document:

set statement [$db_name prepare {select PATH_ID from PATHS where PATH=:path and parent_id is null}]

::oo::Obj943372::Stmt::10

(bin) 71 % $statement getSql

select PATH_ID from PATHS where PATH=:path and parent_id is null

(bin) 72 %

 
a2ad232bf6 2010-04-17 22:51:05 Feature_Request Open   feature request: add a getSql method to the resultset object

The statement object currently has an (undocumented) method yielding the underlying sql statement used for the construction of the specific statement object. (using bind variables notation). request: add a similar method for the resultset object, showing the substituted values.

Using the example from the man page:

package require tdbc::sqlite3

tdbc::sqlite3::connection create db phonebook.sqlite3

set statement [db prepare {

select phone_num from directory where first_name = :firstname and last_name = :lastname

}]

set firstname Fred

set lastname Flintstone

$statement getSql gives:

select phone_num from directory where first_name = :firstname and last_name = :lastname

set rs [$statement execute]

Request:

$rs getSql would give:

select phone_num from directory where first_name = 'Fred' and last_name = 'Flintstone'

Motivation: this feature would be very helpfull in debugging..

 
d1ad7f4948 2017-12-15 21:48:27 Code_Defect Open not_specified odbc::sqlite table subcommand has trailing space in type value
 
b6ac73ed3b 2012-11-29 16:25:04 Feature_Request Open   tdbc::sqlite3 does not return described error states
 
05d96953e1 2012-11-29 16:33:41 Feature_Request Open tdbc::sqlite3 tdbc::sqlite3 does not support schematas
 
fbcd8d40f1 2015-04-27 00:58:31 Code_Defect Open not_specified tdbc consults INFORMATION_SCHEMA without filtering for the target table's schema (foreignkeys, primarykeys methods affected)
 
6af4223559 2015-07-08 14:55:44 Code_Defect Open not_specified if [package require tdbc::*] fails to load a DLL, it should clean up
 
907989fb78 2015-11-19 04:01:26 Code_Defect Open   tdbcpostgres.tcl namespace eval
 
0302d63e13 2017-02-22 02:07:26 Documentation Open   documentation of tdbc::statement paramtype is incorrect
 
6827edbee9 2018-04-25 08:10:59 Code_Defect Open tdbc::odbc incorrect value returned from tdbc::odbc