Re^3: DBI:to sort tables according to their dependencies

[marto]

moritz isn't marto ;) Perhaps you could show us what you did to install the module, the code you are running, and what doesn't work. See How do I post a question effectively? (again).

[ansh batra]

oops sorry moritz :)
i have this with me


 my $sth = $dbh->prepare("select tablename from pg_tables where schema
+name=?");
    $sth->execute($schema);
    my @tables;
    while (my @t = $sth->fetchrow_array) {
        push @tables, @t;
    }
    $sth->finish;

and from the example in Sort::Topological i have


 my %children = (
                  'a' => [ 'b', 'c' ],
                  'c' => [ 'x' ],
                  'b' => [ 'x' ],
                  'x' => [ 'y' ],
                  'y' => [ 'z' ],
                  'z' => [ ],
                  );
  sub children { @{$children{$_[0]} || []}; } 
  my @unsorted = ( 'z', 'a', 'x', 'c', 'b', 'y' );
  my @sorted = toposort(\&children, \@unsorted);

so i am planning something like foreach element in @tables i should call get_deps which will return the contents to be put inside a => 'here'

[marto]

Your previous post talks about problems installing Sort::Topological (and dependencies) you've not mentioned any of this here?

[ansh batra]

i was installing it from source may be thats why i was facing problems
but when i did it from cpan then it was ok