/[cvs]/nfo/perl/libs/libdb.pm
ViewVC logotype

Diff of /nfo/perl/libs/libdb.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by cvsjoko, Fri Jul 19 18:14:03 2002 UTC revision 1.3 by cvsjoko, Sat Jul 27 00:28:20 2002 UTC
# Line 2  Line 2 
2  ##    $Id$  ##    $Id$
3  ##    --------------------------------------------------------------------------------  ##    --------------------------------------------------------------------------------
4  ##    $Log$  ##    $Log$
5    ##    Revision 1.3  2002/07/27 00:28:20  cvsjoko
6    ##    bugfixes
7    ##
8    ##    Revision 1.2  2002/07/20 11:09:58  cvsjoko
9    ##    + bugfixes
10    ##    + dont' print sql-errors
11    ##
12  ##    Revision 1.1  2002/07/19 18:14:03  cvsjoko  ##    Revision 1.1  2002/07/19 18:14:03  cvsjoko
13  ##    no message  ##    no message
14  ##  ##
# Line 105  sub connectTarget { Line 112  sub connectTarget {
112    croak "please supply a dsn or a \"dbmeta\"-hash" if (!$dbmeta);    croak "please supply a dsn or a \"dbmeta\"-hash" if (!$dbmeta);
113    $dbmeta = patch_dbmeta($dbmeta);    $dbmeta = patch_dbmeta($dbmeta);
114    if (!$dbmeta->{connected}) {    if (!$dbmeta->{connected}) {
115      if ($dbmeta->{dbh} = DBI->connect($dbmeta->{dsn})) {      if ($dbmeta->{dbh} = DBI->connect($dbmeta->{dsn}, '', '', { PrintError => 0 } )) {
116        $dbmeta->{dbh}->trace($dbmeta->{trace_level}, $dbmeta->{trace_file});        $dbmeta->{dbh}->trace($dbmeta->{trace_level}, $dbmeta->{trace_file});
117        $dbmeta->{dbh}->{PrintError} = 0;        $dbmeta->{dbh}->{PrintError} = 0;
118        $dbmeta->{connected} = 1;        $dbmeta->{connected} = 1;
119        $dbmeta_ref_cache = $dbmeta;        $dbmeta_ref_cache = $dbmeta;
120          return 1;
121      }      }
122    }    }
123  }  }
# Line 165  sub sqlDbAction { Line 173  sub sqlDbAction {
173      trace_level => 1,      trace_level => 1,
174      trace_file => 'dbitrace',      trace_file => 'dbitrace',
175    };    };
176    connectTarget($dbmeta);    my $bool_ok;
177    sendSql($sql);    if (connectTarget($dbmeta)) {
178    disconnectTarget($dbmeta);      sendSql($sql);
179        #print "state: ", $dbmeta->{dbh}->state, "\n";
180        #print "err    ", $dbmeta->{dbh}->err, "\n";
181        #$bool_ok = ($dbmeta->{dbh} && $dbmeta->{dbh}->state && !$dbmeta->{dbh}->err);
182        $bool_ok = ($dbmeta->{dbh} && !$dbmeta->{dbh}->err);
183        disconnectTarget($dbmeta);
184      }
185      return $bool_ok;
186  }  }
187    
188  sub createSqlDb {  sub createSqlDb {
189    my $dsn = shift;    my $dsn = shift;
190    my $dbname = getDbNameByDsn($dsn);    my $dbname = getDbNameByDsn($dsn);
191    print "  - creating database $dbname", "\n";    print "  - creating rdbms-database $dbname ($dsn) ...";
192    my $sql;    my $sql;
193    $sql = "CREATE DATABASE $dbname;";    $sql = "CREATE DATABASE $dbname;";
194    sqlDbAction($dsn, $sql);    if ( sqlDbAction($dsn, $sql) ) {
195        print "ok", "\n";
196        return 1;
197      } else {
198        print "failed", "\n";
199        return 0;
200      }
201  }  }
202    
203  sub dropSqlDb {  sub dropSqlDb {
204    my $dsn = shift;    my $dsn = shift;
205    my $dbname = getDbNameByDsn($dsn);    my $dbname = getDbNameByDsn($dsn);
# Line 203  sub testDsnForTables { Line 225  sub testDsnForTables {
225    return 1 if ($bool_tablesHere);    return 1 if ($bool_tablesHere);
226  }  }
227    
 1;  
228    1;
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.3
MailToCvsAdmin">MailToCvsAdmin
 ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed