NAME

DBIO::Sybase::Introspect::Views - Introspect Sybase ASE view definitions

VERSION

version 0.900007

DESCRIPTION

Fetches the definition of every view from syscomments and the views each one reads from from sysdepends. ASE keeps the whole CREATE VIEW statement as typed, split over rows of at most 255 characters -- colid numbers the rows, colid2 the groups of them -- so the rows are joined in that order and the CREATE VIEW ... AS head is stripped: what is compared and what CREATE VIEW is written from is the part after AS.

The views are also listed, with kind view, in the tables of the model (DBIO::Sybase::Introspect::Tables), their columns in columns; this class adds what the diff needs to create, drop and order them.

METHODS

fetch

my $views = DBIO::Sybase::Introspect::Views->fetch($dbh, $schema, $tables);

Returns a hashref keyed by view name, one entry for every view in $tables (kind view): view_name, definition (the text after AS, without a trailing ;), and depends_on, the sorted names of the other views of the list the view reads from (sysdepends; the tables it reads are not listed).

strip_head

my $select = DBIO::Sybase::Introspect::Views::strip_head($syscomments_text);

The text after the CREATE VIEW name [(columns)] AS head, trimmed, without a trailing ;. Used by "view_definition" in DBIO::Sybase::Introspect as well.

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.