DBIx::SystemCatalogPerl module for accessing system catalog in common databases (access through DBI(3)) | |
Download |
DBIx::SystemCatalog Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Milan Sorm
- Publisher web site:
- http://search.cpan.org/~milso/SchemaView-Plus-0.16/bin/svplus
DBIx::SystemCatalog Tags
DBIx::SystemCatalog Description
Perl module for accessing system catalog in common databases (access through DBI(3)) DBIx::SystemCatalog is a Perl module for accessing system catalog in common databases (access through DBI(3)).SYNOPSIS use DBI; use DBIx::SystemCatalog; # create DBIx::SystemCatalog object and bind DBI my $dbh = DBI->connect('dbi:Oracle:','login','password'); my $catalog = new DBIx::SystemCatalog $dbh; # fetch all database schemas my @schemas = $catalog->schemas; # select one schema (e.g. first schema) $catalog->schema($schemas); # fetch all tables and views with types of objects my @tables = $catalog->tables_with_types; # fetch columns of first fetched table my @columns = $catalog->table_columns($tables->{name}); # fetch all relationships between tables and views my @relationships = $catalog->relationships; # fetch all primary keys for table my @primary_keys = $catalog->primary_keys($tables->{name}); # fetch all unique indexes for table my @unique_indexes = $catalog->unique_indexes($tables->{name}); # fetch all indexes for table my @indexes = $catalog->indexes($table->{name}); # disconnect database $dbh->disconnect;This module can access to system catalog of database through DBI(3) interface. Basic methods access to objects through standard DBI(3) interface (call tables() for list of objects and selectall_arrayref() with basic SQL to get structure of objects).Constructor looks for specific module implemented database interface for used DBD driver (obtained from DBI(3)). These module can add faster and better functions such as relationships or types of objects. Requirements: · Perl
DBIx::SystemCatalog Related Software