--- trunk/lib/SQLSession/Dispatcher.pm	2006/12/09 01:15:02	33
+++ trunk/lib/SQLSession/Dispatcher.pm	2007/01/21 13:01:38	49
@@ -11,7 +11,26 @@
 	my $top = Jifty->web->navigation;
 	my $edit = Jifty->config->app('edit');
 	$top->child( 'New' => url => '/new' ) if ($edit);
-	$top->child( 'List' => url => '/list' );
+	my $l = $top->child( 'List' => url => '/list' );
+
+	my $databases = SQLSession::Model::DatabaseCollection->new();
+	$databases->unlimit;
+	while ( my $db = $databases->next ) {
+		my $label = $db->name;
+#		$label .= ' [' . $db->dsn . ']' if ($edit);
+		my $url = '/list/database/' . $db->id;
+		my $path = Jifty->web->request->path;
+		warn "url: $url path: $path\n";
+		$l->child( $label => url => $url => active => ( $url eq $path ) );
+	}
+
+	if ( Jifty->web->current_user->id ) {
+		$top->child( 'Logout' => url => '/logout' );
+	} else {
+		$top->child( 'Login' => url => '/login' );
+		$top->child( 'Signup' => url => '/signup' );
+	}
+
 };
 
 
@@ -31,6 +50,15 @@
 
 };
 
+under 'list' => [
+
+	on qr{database/(\d+)} => run {
+		set database_id => $1;
+	},
+
+	show '/list',
+];
+
 on 'new' => run {
 	show '/sql';
 };