Skip Menu |
 

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 87435
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: DDICK [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

Attachments


Subject: PATCH: statistics_info perldoc
MIME-Version: 1.0
X-Mailer: MIME-tools 5.504 (Entity 5.504)
X-RT-Interface: Web
Message-ID: <rt-4.0.14-7914-1375183720-1328.0-0-0 [...] rt.cpan.org>
X-RT-Original-Encoding: utf-8
Content-Type: multipart/mixed; boundary="----------=_1375183720-7914-6"
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 0
Content-Disposition: inline
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: binary
Content-Length: 60
Sorry, forgot to include perldoc support for statistics_info
Subject: dbd_sqlite_statistics_perldoc.patch
MIME-Version: 1.0
Content-Type: text/x-patch; name="dbd_sqlite_statistics_perldoc.patch"
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline; filename="dbd_sqlite_statistics_perldoc.patch"
Content-Transfer-Encoding: binary
Content-Length: 1470
diff -Naur old/lib/DBD/SQLite.pm new/lib/DBD/SQLite.pm --- old/lib/DBD/SQLite.pm 2013-07-28 15:29:31.000000000 +1000 +++ new/lib/DBD/SQLite.pm 2013-07-30 21:22:51.960515968 +1000 @@ -1574,6 +1574,47 @@ B<Note>: foreign key support in SQLite must be explicitly turned on through a C<PRAGMA> command; see L</"Foreign keys"> earlier in this manual. +=head2 statistics_info + + $sth = $dbh->statistics_info(undef, $schema, $table, + $unique_only, $quick); + +Returns information about a table and it's indexes, as specified in +L<DBI/statistics_info>, but with some limitations : + +=over + +=item * + +information in rows returned by the C<$sth> is incomplete with +respect to the L<DBI/statistics_info> specification. All requested fields +are present, but the content is C<undef> for some of them. + +=back + +The following nonempty fields are returned : + +B<TABLE_SCHEM>: +The name of the schema (database) that the table is in. The default schema is 'main', temporary tables are in 'temp' and other databases will be in the name given when the database was attached. + +B<TABLE_NAME>: +The name of the table + +B<NON_UNIQUE>: +Contains 0 for unique indexes, 1 for non-unique indexes + +B<INDEX_NAME>: +The name of the index + +B<TYPE>: +SQLite uses 'btree' for all it's indexes + +B<ORDINAL_POSITION>: +Column sequence number (starting with 1). + +B<COLUMN_NAME>: +The name of the column + =head2 ping my $bool = $dbh->ping;
MIME-Version: 1.0
In-Reply-To: <rt-4.0.14-7914-1375183720-1328.0-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <rt-4.0.14-7914-1375183720-1328.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.14-24369-1375286944-1289.87435-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 227
Download (untitled) / with headers
text/plain 227b
Thanks. Applied to the trunk. https://github.com/DBD-SQLite/DBD-SQLite/commit/5df6d6b0532127f5c9e2d18f322fe0e1fc37683d On Tue Jul 30 20:28:40 2013, DDICK wrote: Show quoted text
> Sorry, forgot to include perldoc support for statistics_info
MIME-Version: 1.0
In-Reply-To: <rt-4.0.14-7914-1375183720-1328.0-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <rt-4.0.14-7914-1375183720-1328.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.16-23353-1377588611-279.87435-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 78
Closed this ticket as DBD::SQLite 1.41_01 with the patch was released. Thanks.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.