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.