1DBD::Firebird::TableInfUos:e:rBaCsoinct(r3i)buted Perl DDoBcDu:m:eFnitraetbiiornd::TableInfo::Basic(3)
2
3
4

NAME

6       DBD::Firebird::TableInfo::Basic - A base class for lowest-common
7       denominator Firebird table_info() querying.
8

SYNOPSIS

10           # Add support for a hypothetical IB derivative
11           package DBD::Firebird::TableInfo::HypotheticalIBDerivative
12
13           @ISA = qw(DBD::Firebird::TableInfo::Basic);
14
15           # What table types are supported?
16           sub supported_types {
17               ('SYSTEM TABLE', 'TABLE', 'VIEW', 'SPECIAL TABLE TYPE');
18           }
19
20           sub table_info {
21               my ($self, $dbh, $table, @types) = @_;
22           }
23

INTERFACE

25       list_catalogs
26               $ti->list_catalogs($dbh);  # $dbh->table_info('%', '', '')
27
28           Returns a statement handle with an empty result set, as IB does not
29           support the DBI concept of catalogs. (Rule 19a)
30
31       list_schema
32               $ti->list_schema($dbh);    # $dbh->table_info('', '%', '')
33
34           Returns a statement handle with an empty result set, as IB does not
35           support the DBI concept of schema. (Rule 19b)
36
37       list_tables
38               $ti->list_tables($dbh, $table, @types); # $dbh->table_info('', '',
39                                                       #                  'FOO%',
40                                                       #                  'TABLE,VIEW');
41
42           Called in response to $dbh->table_info($cat, $schem, $table,
43           $types).  $cat and $schem are presently ignored.
44
45           This is the workhorse method that must return an appropriate
46           statement handle of tables given the requested $table pattern and
47           @types.  A blank $table pattern means "any table," and an empty
48           @types list means "any type."
49
50           @types is a list of user-supplied, requested types.
51           "DBD::Firebird::db::table_info" will normalize the user-supplied
52           types, stripping quote marks, uppercasing, and removing duplicates.
53
54       list_types
55               $tbl_info->list_types($dbh);  # $dbh->table_info('', '', '', '%')
56
57           Called in response to $dbh->table_info('', '', '', '%'), returning
58           a statement handle with a TABLE_TYPE column populated with the
59           results of supported_types.  (Rule 19c)
60
61           Normally not overridden.  Override supported_types, instead.
62
63       supported_types
64               $tbl_info->supported_types($dbh);
65
66           Returns a list of supported DBI TABLE_TYPE entries.  The default
67           implementation supports 'TABLE', 'SYSTEM TABLE' and 'VIEW'.
68
69           This method is called by the default implementation of
70           "list_types".
71
72
73
74perl v5.34.1                      2022-07-07DBD::Firebird::TableInfo::Basic(3)
Impressum