X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=bp_bin%2Fremove_mysql_tables;h=794ab0f9c36db3248f6da0414c68eefec04c2a41;hb=5de6112b70b59420b245ce636a8b2e3c90acbe00;hp=1419cbc5b0889fa33f7d1ee03f3bbf8757365c0e;hpb=9bf550c4335d8860c5f6f9c4db0f385f1b36c1dd;p=biopieces.git

diff --git a/bp_bin/remove_mysql_tables b/bp_bin/remove_mysql_tables
index 1419cbc..794ab0f 100755
--- a/bp_bin/remove_mysql_tables
+++ b/bp_bin/remove_mysql_tables
@@ -37,15 +37,18 @@ use Maasha::UCSC;
 # >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
 
 
-my ( $options, $in, $out, $record, %table_hash, $dbh, $table );
+my ( $options, $user, $password, $in, $out, $record, %table_hash, $dbh, $table );
+
+$user     = Maasha::Biopieces::biopiecesrc( "MYSQL_USER" );
+$password = Maasha::Biopieces::biopiecesrc( "MYSQL_PASSWORD" );
 
 $options = Maasha::Biopieces::parse_options(
     [
-        { long => 'database', short => 'd', type => 'string', mandatory => 'yes', default => undef, allowed => undef, disallowed => undef },
-        { long => 'tables',   short => 't', type => 'list',   mandatory => 'no',  default => undef, allowed => undef, disallowed => undef },
-        { long => 'keys',     short => 'k', type => 'list',   mandatory => 'no',  default => undef, allowed => undef, disallowed => undef },
-        { long => 'user',     short => 'u', type => 'string', mandatory => 'no',  default => undef, allowed => undef, disallowed => undef },
-        { long => 'password', short => 'p', type => 'string', mandatory => 'no',  default => undef, allowed => undef, disallowed => undef },
+        { long => 'database', short => 'd', type => 'string', mandatory => 'yes', default => undef,     allowed => undef, disallowed => undef },
+        { long => 'tables',   short => 't', type => 'list',   mandatory => 'no',  default => undef,     allowed => undef, disallowed => undef },
+        { long => 'keys',     short => 'k', type => 'list',   mandatory => 'no',  default => undef,     allowed => undef, disallowed => undef },
+        { long => 'user',     short => 'u', type => 'string', mandatory => 'no',  default => $user,     allowed => undef, disallowed => undef },
+        { long => 'password', short => 'p', type => 'string', mandatory => 'no',  default => $password, allowed => undef, disallowed => undef },
     ]   
 );