DBIx::SystemCatalog Perl module for accessing system catalog in common databases (access through DBI(3))
Download

DBIx::SystemCatalog Ranking & Summary

DBIx::SystemCatalog Tags

Perl module perl catalog DBIx system catalog

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