NAME

DBIO::Informix::Introspect::Util - Shared helpers of the Informix catalog readers

VERSION

version 0.900007

DESCRIPTION

Helpers shared by the readers under DBIO::Informix::Introspect::.

The statements built from these helpers are written against the catalog (systables, syscolumns, sysconstraints, sysindexes, sysreferences, sysdefaults) and measured against Informix 15.0.1 (t/60-introspect-live.t).

METHODS

qualifier

my $q = DBIO::Informix::Introspect::Util::qualifier($schema);
# "mydb":informix

Returns the "database":informix prefix for catalog tables. $schema is interpolated into SQL text, so it must be a plain identifier (\w+); anything else dies.

part_columns

my @colnos = part_columns($row, 'part');

Collects part1 .. part16 of an sysindexes row (key prefix $prefix, e.g. part or rpart) in key order. A part of 0 (or undef) is unused; a negative part is a descending key column, its column number is the absolute value.

column_names

my %name_by_colno = %{ column_names($dbh, $q, $tabid) };

Column number to column name of one table (syscolumns).

names_for

my @names = names_for(\%name_by_colno, @colnos);

Resolves column numbers to names; an unknown number dies rather than yielding a silently shorter key.

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.