--- nfo/perl/libs/Data/Storage/Handler/DBI.pm	2002/12/05 07:58:20	1.9
+++ nfo/perl/libs/Data/Storage/Handler/DBI.pm	2003/01/30 22:28:21	1.12
@@ -1,8 +1,18 @@
 #################################
 #
-#  $Id: DBI.pm,v 1.9 2002/12/05 07:58:20 joko Exp $
+#  $Id: DBI.pm,v 1.12 2003/01/30 22:28:21 joko Exp $
 #
 #  $Log: DBI.pm,v $
+#  Revision 1.12  2003/01/30 22:28:21  joko
+#  + implemented new concrete methods
+#
+#  Revision 1.11  2002/12/19 16:31:05  joko
+#  + sub dropDb
+#  + sub rebuildDb
+#
+#  Revision 1.10  2002/12/15 02:02:22  joko
+#  + fixed logging-message
+#
 #  Revision 1.9  2002/12/05 07:58:20  joko
 #  + now using Tie::SecureHash as a base for the COREHANDLE
 #  + former public COREHANDLE becomes private _COREHANDLE now
@@ -183,6 +193,9 @@
 sub sendQuery {
   my $self = shift;
   my $query = shift;
+
+  $logger->debug( __PACKAGE__ . "->sendQuery" );
+
   #my $sql = "SELECT cs FROM $self->{metainfo}->{$descent}->{node} WHERE $self->{metainfo}->{$descent}->{IdentProvider}->{arg}='$self->{entry}->{source}->{ident}';";
   #my $result = $self->{metainfo}->{$descent}->{storage}->sendCommand($sql);
   my @crits;
@@ -202,6 +215,7 @@
 sub eraseAll {
   my $self = shift;
   my $classname = shift;
+  $logger->debug( __PACKAGE__ . "->eraseAll" );
   my $sql = "DELETE FROM $classname";
   $self->sendCommand($sql);
 }
@@ -255,4 +269,76 @@
   return $self->{_COREHANDLE};
 }
 
+sub dropDb {
+  my $self = shift;
+  my $dsn = $self->{locator}->{dbi}->{dsn};
+
+  $logger->debug( __PACKAGE__ .  "->dropDb( dsn $dsn )" );
+
+  $dsn =~ s/database=(.+?);//;
+  my $database_name = $1;
+
+  my $ok;
+  
+  if ( my $dbh = DBI->connect($dsn, '', '', {
+                                                      PrintError => 0,
+                                                      } ) ) {
+    if ($database_name) {
+      if ($dbh->do("DROP DATABASE $database_name;")) {
+        $ok = 1;
+      }
+    }
+
+    $dbh->disconnect();
+
+  }
+  
+  return $ok;
+}
+
+sub rebuildDb {
+  my $self = shift;
+  $logger->info( __PACKAGE__ . "->rebuildDb()" );
+  my @results;
+
+  # sum up results (bool (0/1)) in array
+  #push @results, $self->retreatSchema();
+  push @results, $self->dropDb();
+  push @results, $self->createDb();
+  #push @results, $self->deploySchema();
+
+  # scan array for "bad ones"
+  my $res = 1;
+  map {
+    $res = 0 if (!$_);
+  } @results;
+  
+  return $res;
+}
+
+sub testAvailability {
+  my $self = shift;
+  my $status = $self->testDsn();
+  $self->{locator}->{status}->{available} = $status;
+  return $status;
+}
+
+sub testDsn {
+  my $self = shift;
+  my $dsn = $self->{locator}->{dbi}->{dsn};
+  my $result;
+  if ( my $dbh = DBI->connect($dsn, '', '', {
+                                                      PrintError => 0,
+                                                      } ) ) {
+    
+    # TODO: REVIEW
+    $dbh->disconnect();
+    
+    return 1;
+  } else {
+    $logger->warning( __PACKAGE__ .  "[$self->{locator}->{type}]" . "->testDsn(): " . "DBI-error: " . $DBI::errstr );
+  }
+}
+
 1;
+__END__