X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d1f932ad48cf69e11e55d10d65fb6c5e528ea55e..46e1506b7ccd09f451b1c33f9b42f450b96f55fd:/SL/DBUtils.pm diff --git a/SL/DBUtils.pm b/SL/DBUtils.pm index df4c5ac93..49e9aaeb5 100644 --- a/SL/DBUtils.pm +++ b/SL/DBUtils.pm @@ -9,7 +9,7 @@ require Exporter; selectall_hashref_query selectall_array_query selectall_as_map prepare_execute_query prepare_query - create_sort_spec); + create_sort_spec does_table_exist); sub conv_i { my ($value, $default) = @_; @@ -259,6 +259,28 @@ sub create_sort_spec { return %result; } +sub does_table_exist { + $main::lxdebug->enter_sub(2); + + my $dbh = shift; + my $table = shift; + + my $result = 0; + + if ($dbh) { + my $sth = $dbh->table_info('', '', $table, 'TABLE'); + if ($sth) { + $result = $sth->fetchrow_hashref(); + $sth->finish(); + } + } + + $main::lxdebug->leave_sub(2); + + return $result; +} + + 1;