Lines Matching refs:dbh

193   my $dbh;
197     $dbh = Rose::DB->new('pg_admin')->retain_dbh()
201   if(!$@ && $dbh)
208       local $dbh->{'RaiseError'} = 0;
209       local $dbh->{'PrintError'} = 0;
211       $dbh->do('DROP TABLE product_color_map CASCADE');
212       $dbh->do('DROP TABLE color CASCADE');
213       $dbh->do('DROP TABLE price CASCADE');
214       $dbh->do('DROP TABLE product CASCADE');
215       $dbh->do('DROP TABLE vendor CASCADE');
217       $dbh->do('DROP TABLE Rose_db_object_private.product_color_map CASCADE');
218       $dbh->do('DROP TABLE Rose_db_object_private.color CASCADE');
219       $dbh->do('DROP TABLE Rose_db_object_private.price CASCADE');
220       $dbh->do('DROP TABLE Rose_db_object_private.product CASCADE');
221       $dbh->do('DROP TABLE Rose_db_object_private.vendor CASCADE');
223       $dbh->do('DROP SCHEMA Rose_db_object_private CASCADE');
224       $dbh->do('CREATE SCHEMA Rose_db_object_private');
227     $dbh->do(<<"EOF");
237     $dbh->do(<<"EOF");
262     $dbh->do(<<"EOF");
274     $dbh->do(<<"EOF");
284     $dbh->do(<<"EOF");
294     $dbh->do(<<"EOF");
304     $dbh->do(<<"EOF");
329     $dbh->do(<<"EOF");
341     $dbh->do(<<"EOF");
351     $dbh->do(<<"EOF");
361     $dbh->disconnect;
371     $dbh = $db->retain_dbh or die Rose::DB->error;
377       local $dbh->{'RaiseError'} = 0;
378       local $dbh->{'PrintError'} = 0;
380       $dbh->do('DROP TABLE product_color_map CASCADE');
381       $dbh->do('DROP TABLE color CASCADE');
382       $dbh->do('DROP TABLE price CASCADE');
383       $dbh->do('DROP TABLE product CASCADE');
384       $dbh->do('DROP TABLE vendor CASCADE');
388     $dbh->do(<<"EOF");
403     my $sth = $dbh->prepare("SHOW TABLE STATUS FROM `$db_name` LIKE ?");
414   if(!$@ && $dbh)
418     $dbh->do(<<"EOF");
444     $dbh->do(<<"EOF");
460     $dbh->do(<<"EOF");
471     $dbh->do(<<"EOF");
488     $dbh->disconnect;
497     $dbh = Rose::DB->new('informix_admin')->retain_dbh()
501   if(!$@ && $dbh)
507       local $dbh->{'RaiseError'} = 0;
508       local $dbh->{'PrintError'} = 0;
510       $dbh->do('DROP TABLE product_color_map CASCADE');
511       $dbh->do('DROP TABLE color CASCADE');
512       $dbh->do('DROP TABLE price CASCADE');
513       $dbh->do('DROP TABLE product CASCADE');
514       $dbh->do('DROP TABLE vendor CASCADE');
517     $dbh->do(<<"EOF");
527     $dbh->do(<<"EOF");
546     $dbh->do(<<"EOF");
558     $dbh->do(<<"EOF");
568     $dbh->do(<<"EOF");
578     $dbh->disconnect;
587     $dbh = Rose::DB->new('sqlite_admin')->retain_dbh()
591   if(!$@ && $dbh)
597       local $dbh->{'RaiseError'} = 0;
598       local $dbh->{'PrintError'} = 0;
600       $dbh->do('DROP TABLE product_color_map');
601       $dbh->do('DROP TABLE color');
602       $dbh->do('DROP TABLE price');
603       $dbh->do('DROP TABLE product');
604       $dbh->do('DROP TABLE vendor');
607     $dbh->do(<<"EOF");
617     $dbh->do(<<"EOF");
636     $dbh->do(<<"EOF");
648     $dbh->do(<<"EOF");
658     $dbh->do(<<"EOF");
668     $dbh->disconnect;
681     my $dbh = Rose::DB->new('pg_admin')->retain_dbh()
684     $dbh->do('DROP TABLE product_color_map CASCADE');
685     $dbh->do('DROP TABLE color CASCADE');
686     $dbh->do('DROP TABLE price CASCADE');
687     $dbh->do('DROP TABLE product CASCADE');
688     $dbh->do('DROP TABLE vendor CASCADE');
690     $dbh->do('DROP TABLE Rose_db_object_private.product_color_map CASCADE');
691     $dbh->do('DROP TABLE Rose_db_object_private.color CASCADE');
692     $dbh->do('DROP TABLE Rose_db_object_private.price CASCADE');
693     $dbh->do('DROP TABLE Rose_db_object_private.product CASCADE');
694     $dbh->do('DROP TABLE Rose_db_object_private.vendor CASCADE');
696     $dbh->do('DROP SCHEMA Rose_db_object_private CASCADE');
698     $dbh->disconnect;
704     my $dbh = Rose::DB->new('mysql_admin')->retain_dbh()
707     $dbh->do('DROP TABLE product_color_map CASCADE');
708     $dbh->do('DROP TABLE color CASCADE');
709     $dbh->do('DROP TABLE price CASCADE');
710     $dbh->do('DROP TABLE product CASCADE');
711     $dbh->do('DROP TABLE vendor CASCADE');
713     $dbh->disconnect;
719     my $dbh = Rose::DB->new('informix_admin')->retain_dbh()
722     $dbh->do('DROP TABLE product_color_map CASCADE');
723     $dbh->do('DROP TABLE color CASCADE');
724     $dbh->do('DROP TABLE price CASCADE');
725     $dbh->do('DROP TABLE product CASCADE');
726     $dbh->do('DROP TABLE vendor CASCADE');
728     $dbh->disconnect;
734     my $dbh = Rose::DB->new('sqlite_admin')->retain_dbh()
737     $dbh->do('DROP TABLE product_color_map');
738     $dbh->do('DROP TABLE color');
739     $dbh->do('DROP TABLE price');
740     $dbh->do('DROP TABLE product');
741     $dbh->do('DROP TABLE vendor');
743     $dbh->disconnect;