in reply to Re^3: DBI:to sort tables according to their dependencies
in thread DBI:to sort tables according to their dependencies

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'

Replies are listed 'Best First'.
Re^5: DBI:to sort tables according to their dependencies
by marto (Cardinal) on Dec 21, 2011 at 11:02 UTC

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

      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

        As far as I can tell you've not asked a question since asking for help installing the module.