Lines Matching refs:dbh
157 my $dbh;
161 $dbh = Rose::DB->new('pg_admin')->retain_dbh()
165 if(!$@ && $dbh)
172 local $dbh->{'RaiseError'} = 0;
173 local $dbh->{'PrintError'} = 0;
175 $dbh->do('DROP TABLE product_color_map CASCADE');
176 $dbh->do('DROP TABLE colors CASCADE');
177 $dbh->do('DROP TABLE prices CASCADE');
178 $dbh->do('DROP TABLE products CASCADE');
179 $dbh->do('DROP TABLE vendors CASCADE');
180 $dbh->do('DROP TABLE pk_test CASCADE');
182 $dbh->do('DROP TABLE Rose_db_object_private.product_color_map CASCADE');
183 $dbh->do('DROP TABLE Rose_db_object_private.colors CASCADE');
184 $dbh->do('DROP TABLE Rose_db_object_private.prices CASCADE');
185 $dbh->do('DROP TABLE Rose_db_object_private.products CASCADE');
186 $dbh->do('DROP TABLE Rose_db_object_private.vendors CASCADE');
188 $dbh->do('DROP SCHEMA Rose_db_object_private CASCADE');
189 $dbh->do('CREATE SCHEMA Rose_db_object_private');
192 $dbh->do(<<"EOF");
203 $dbh->do(<<"EOF");
213 $dbh->do(<<"EOF");
232 $dbh->do(<<"EOF");
244 $dbh->do(<<"EOF");
254 $dbh->do(<<"EOF");
264 $dbh->do(<<"EOF");
275 $dbh->do(<<"EOF");
285 $dbh->do(<<"EOF");
304 $dbh->do(<<"EOF");
316 $dbh->do(<<"EOF");
326 $dbh->do(<<"EOF");
336 $dbh->disconnect;
346 $dbh = $db->retain_dbh or die Rose::DB->error;
352 local $dbh->{'RaiseError'} = 0;
353 local $dbh->{'PrintError'} = 0;
355 $dbh->do('DROP TABLE product_color_map CASCADE');
356 $dbh->do('DROP TABLE colors CASCADE');
357 $dbh->do('DROP TABLE prices CASCADE');
358 $dbh->do('DROP TABLE products CASCADE');
359 $dbh->do('DROP TABLE vendors CASCADE');
360 $dbh->do('DROP TABLE pk_test CASCADE');
364 $dbh->do(<<"EOF");
379 my $sth = $dbh->prepare("SHOW TABLE STATUS FROM `$db_name` LIKE ?");
390 if(!$@ && $dbh)
394 $dbh->do(<<"EOF");
405 $dbh->do(<<"EOF");
428 $dbh->do(<<"EOF");
444 $dbh->do(<<"EOF");
455 $dbh->do(<<"EOF");
472 $dbh->disconnect;
481 $dbh = Rose::DB->new('informix_admin')->retain_dbh()
485 if(!$@ && $dbh)
491 local $dbh->{'RaiseError'} = 0;
492 local $dbh->{'PrintError'} = 0;
494 $dbh->do('DROP TABLE product_color_map CASCADE');
495 $dbh->do('DROP TABLE colors CASCADE');
496 $dbh->do('DROP TABLE prices CASCADE');
497 $dbh->do('DROP TABLE products CASCADE');
498 $dbh->do('DROP TABLE vendors CASCADE');
499 $dbh->do('DROP TABLE pk_test CASCADE');
502 $dbh->do(<<"EOF");
513 $dbh->do(<<"EOF");
523 $dbh->do(<<"EOF");
542 $dbh->do(<<"EOF");
554 $dbh->do(<<"EOF");
564 $dbh->do(<<"EOF");
574 $dbh->disconnect;
583 $dbh = Rose::DB->new('sqlite_admin')->retain_dbh()
587 if(!$@ && $dbh)
593 local $dbh->{'RaiseError'} = 0;
594 local $dbh->{'PrintError'} = 0;
596 $dbh->do('DROP TABLE product_color_map');
597 $dbh->do('DROP TABLE colors');
598 $dbh->do('DROP TABLE prices');
599 $dbh->do('DROP TABLE products');
600 $dbh->do('DROP TABLE vendors');
601 $dbh->do('DROP TABLE pk_test');
604 $dbh->do(<<"EOF");
615 $dbh->do(<<"EOF");
625 $dbh->do(<<"EOF");
644 $dbh->do(<<"EOF");
656 $dbh->do(<<"EOF");
666 $dbh->do(<<"EOF");
676 $dbh->disconnect;
687 my $dbh = Rose::DB->new('pg_admin')->retain_dbh()
690 $dbh->do('DROP TABLE product_color_map CASCADE');
691 $dbh->do('DROP TABLE colors CASCADE');
692 $dbh->do('DROP TABLE prices CASCADE');
693 $dbh->do('DROP TABLE products CASCADE');
694 $dbh->do('DROP TABLE vendors CASCADE');
695 $dbh->do('DROP TABLE pk_test CASCADE');
697 $dbh->do('DROP TABLE Rose_db_object_private.product_color_map CASCADE');
698 $dbh->do('DROP TABLE Rose_db_object_private.colors CASCADE');
699 $dbh->do('DROP TABLE Rose_db_object_private.prices CASCADE');
700 $dbh->do('DROP TABLE Rose_db_object_private.products CASCADE');
701 $dbh->do('DROP TABLE Rose_db_object_private.vendors CASCADE');
703 $dbh->do('DROP SCHEMA Rose_db_object_private CASCADE');
705 $dbh->disconnect;
711 my $dbh = Rose::DB->new('mysql_admin')->retain_dbh()
714 $dbh->do('DROP TABLE product_color_map CASCADE');
715 $dbh->do('DROP TABLE colors CASCADE');
716 $dbh->do('DROP TABLE prices CASCADE');
717 $dbh->do('DROP TABLE products CASCADE');
718 $dbh->do('DROP TABLE vendors CASCADE');
719 $dbh->do('DROP TABLE pk_test CASCADE');
721 $dbh->disconnect;
727 my $dbh = Rose::DB->new('informix_admin')->retain_dbh()
730 $dbh->do('DROP TABLE product_color_map CASCADE');
731 $dbh->do('DROP TABLE colors CASCADE');
732 $dbh->do('DROP TABLE prices CASCADE');
733 $dbh->do('DROP TABLE products CASCADE');
734 $dbh->do('DROP TABLE vendors CASCADE');
735 $dbh->do('DROP TABLE pk_test CASCADE');
737 $dbh->disconnect;
743 my $dbh = Rose::DB->new('sqlite_admin')->retain_dbh()
746 $dbh->do('DROP TABLE product_color_map');
747 $dbh->do('DROP TABLE colors');
748 $dbh->do('DROP TABLE prices');
749 $dbh->do('DROP TABLE products');
750 $dbh->do('DROP TABLE vendors');
751 $dbh->do('DROP TABLE pk_test');
753 $dbh->disconnect;