Conditions | 35 |
Paths | 1 |
Total Lines | 273 |
Code Lines | 195 |
Lines | 0 |
Ratio | 0 % |
Changes | 0 |
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
1 | <?php |
||
344 | protected function tearDown() : void |
||
345 | { |
||
346 | $conn = static::$sharedConn; |
||
347 | |||
348 | // In case test is skipped, tearDown is called, but no setup may have run |
||
349 | if (! $conn) { |
||
350 | return; |
||
351 | } |
||
352 | |||
353 | $platform = $conn->getDatabasePlatform(); |
||
354 | |||
355 | $this->sqlLoggerStack->enabled = false; |
||
356 | |||
357 | if (isset($this->usedModelSets['cms'])) { |
||
358 | $conn->executeUpdate('DELETE FROM cms_users_groups'); |
||
359 | $conn->executeUpdate('DELETE FROM cms_groups'); |
||
360 | $conn->executeUpdate('DELETE FROM cms_users_tags'); |
||
361 | $conn->executeUpdate('DELETE FROM cms_tags'); |
||
362 | $conn->executeUpdate('DELETE FROM cms_addresses'); |
||
363 | $conn->executeUpdate('DELETE FROM cms_phonenumbers'); |
||
364 | $conn->executeUpdate('DELETE FROM cms_comments'); |
||
365 | $conn->executeUpdate('DELETE FROM cms_articles'); |
||
366 | $conn->executeUpdate('DELETE FROM cms_users'); |
||
367 | $conn->executeUpdate('DELETE FROM cms_emails'); |
||
368 | } |
||
369 | |||
370 | if (isset($this->usedModelSets['ecommerce'])) { |
||
371 | $conn->executeUpdate('DELETE FROM ecommerce_carts_products'); |
||
372 | $conn->executeUpdate('DELETE FROM ecommerce_products_categories'); |
||
373 | $conn->executeUpdate('DELETE FROM ecommerce_products_related'); |
||
374 | $conn->executeUpdate('DELETE FROM ecommerce_carts'); |
||
375 | $conn->executeUpdate('DELETE FROM ecommerce_customers'); |
||
376 | $conn->executeUpdate('DELETE FROM ecommerce_features'); |
||
377 | $conn->executeUpdate('DELETE FROM ecommerce_products'); |
||
378 | $conn->executeUpdate('DELETE FROM ecommerce_shippings'); |
||
379 | $conn->executeUpdate('UPDATE ecommerce_categories SET parent_id = NULL'); |
||
380 | $conn->executeUpdate('DELETE FROM ecommerce_categories'); |
||
381 | } |
||
382 | |||
383 | if (isset($this->usedModelSets['company'])) { |
||
384 | $conn->executeUpdate('DELETE FROM company_contract_employees'); |
||
385 | $conn->executeUpdate('DELETE FROM company_contract_managers'); |
||
386 | $conn->executeUpdate('DELETE FROM company_contracts'); |
||
387 | $conn->executeUpdate('DELETE FROM company_persons_friends'); |
||
388 | $conn->executeUpdate('DELETE FROM company_managers'); |
||
389 | $conn->executeUpdate('DELETE FROM company_employees'); |
||
390 | $conn->executeUpdate('UPDATE company_persons SET spouse_id = NULL'); |
||
391 | $conn->executeUpdate('DELETE FROM company_persons'); |
||
392 | $conn->executeUpdate('DELETE FROM company_raffles'); |
||
393 | $conn->executeUpdate('DELETE FROM company_auctions'); |
||
394 | $conn->executeUpdate('UPDATE company_organizations SET main_event_id = NULL'); |
||
395 | $conn->executeUpdate('DELETE FROM company_events'); |
||
396 | $conn->executeUpdate('DELETE FROM company_organizations'); |
||
397 | } |
||
398 | |||
399 | if (isset($this->usedModelSets['generic'])) { |
||
400 | $conn->executeUpdate('DELETE FROM boolean_model'); |
||
401 | $conn->executeUpdate('DELETE FROM date_time_model'); |
||
402 | $conn->executeUpdate('DELETE FROM decimal_model'); |
||
403 | $conn->executeUpdate('DELETE FROM serialize_model'); |
||
404 | } |
||
405 | |||
406 | if (isset($this->usedModelSets['routing'])) { |
||
407 | $conn->executeUpdate('DELETE FROM RoutingRouteLegs'); |
||
408 | $conn->executeUpdate('DELETE FROM RoutingRouteBooking'); |
||
409 | $conn->executeUpdate('DELETE FROM RoutingRoute'); |
||
410 | $conn->executeUpdate('DELETE FROM RoutingLeg'); |
||
411 | $conn->executeUpdate('DELETE FROM RoutingLocation'); |
||
412 | } |
||
413 | |||
414 | if (isset($this->usedModelSets['navigation'])) { |
||
415 | $conn->executeUpdate('DELETE FROM navigation_tour_pois'); |
||
416 | $conn->executeUpdate('DELETE FROM navigation_photos'); |
||
417 | $conn->executeUpdate('DELETE FROM navigation_pois'); |
||
418 | $conn->executeUpdate('DELETE FROM navigation_tours'); |
||
419 | $conn->executeUpdate('DELETE FROM navigation_countries'); |
||
420 | } |
||
421 | |||
422 | if (isset($this->usedModelSets['directorytree'])) { |
||
423 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('file')); |
||
424 | // MySQL doesn't know deferred deletions therefore only executing the second query gives errors. |
||
425 | $conn->executeUpdate('DELETE FROM Directory WHERE parentDirectory_id IS NOT NULL'); |
||
426 | $conn->executeUpdate('DELETE FROM Directory'); |
||
427 | } |
||
428 | |||
429 | if (isset($this->usedModelSets['ddc117'])) { |
||
430 | $conn->executeUpdate('DELETE FROM ddc117editor_ddc117translation'); |
||
431 | $conn->executeUpdate('DELETE FROM DDC117Editor'); |
||
432 | $conn->executeUpdate('DELETE FROM DDC117ApproveChanges'); |
||
433 | $conn->executeUpdate('DELETE FROM DDC117Link'); |
||
434 | $conn->executeUpdate('DELETE FROM DDC117Reference'); |
||
435 | $conn->executeUpdate('DELETE FROM DDC117ArticleDetails'); |
||
436 | $conn->executeUpdate('DELETE FROM DDC117Translation'); |
||
437 | $conn->executeUpdate('DELETE FROM DDC117Article'); |
||
438 | } |
||
439 | |||
440 | if (isset($this->usedModelSets['stockexchange'])) { |
||
441 | $conn->executeUpdate('DELETE FROM exchange_bonds_stocks'); |
||
442 | $conn->executeUpdate('DELETE FROM exchange_bonds'); |
||
443 | $conn->executeUpdate('DELETE FROM exchange_stocks'); |
||
444 | $conn->executeUpdate('DELETE FROM exchange_markets'); |
||
445 | } |
||
446 | |||
447 | if (isset($this->usedModelSets['legacy'])) { |
||
448 | $conn->executeUpdate('DELETE FROM legacy_users_cars'); |
||
449 | $conn->executeUpdate('DELETE FROM legacy_users_reference'); |
||
450 | $conn->executeUpdate('DELETE FROM legacy_articles'); |
||
451 | $conn->executeUpdate('DELETE FROM legacy_cars'); |
||
452 | $conn->executeUpdate('DELETE FROM legacy_users'); |
||
453 | } |
||
454 | |||
455 | if (isset($this->usedModelSets['customtype'])) { |
||
456 | $conn->executeUpdate('DELETE FROM customtype_parent_friends'); |
||
457 | $conn->executeUpdate('DELETE FROM customtype_parents'); |
||
458 | $conn->executeUpdate('DELETE FROM customtype_children'); |
||
459 | $conn->executeUpdate('DELETE FROM customtype_uppercases'); |
||
460 | } |
||
461 | |||
462 | if (isset($this->usedModelSets['compositekeyinheritance'])) { |
||
463 | $conn->executeUpdate('DELETE FROM JoinedChildClass'); |
||
464 | $conn->executeUpdate('DELETE FROM JoinedRootClass'); |
||
465 | $conn->executeUpdate('DELETE FROM SingleRootClass'); |
||
466 | } |
||
467 | |||
468 | if (isset($this->usedModelSets['taxi'])) { |
||
469 | $conn->executeUpdate('DELETE FROM taxi_paid_ride'); |
||
470 | $conn->executeUpdate('DELETE FROM taxi_ride'); |
||
471 | $conn->executeUpdate('DELETE FROM taxi_car'); |
||
472 | $conn->executeUpdate('DELETE FROM taxi_driver'); |
||
473 | } |
||
474 | |||
475 | if (isset($this->usedModelSets['tweet'])) { |
||
476 | $conn->executeUpdate('DELETE FROM tweet_tweet'); |
||
477 | $conn->executeUpdate('DELETE FROM tweet_user_list'); |
||
478 | $conn->executeUpdate('DELETE FROM tweet_user'); |
||
479 | } |
||
480 | |||
481 | if (isset($this->usedModelSets['cache'])) { |
||
482 | $conn->executeUpdate('DELETE FROM cache_attraction_location_info'); |
||
483 | $conn->executeUpdate('DELETE FROM cache_attraction_contact_info'); |
||
484 | $conn->executeUpdate('DELETE FROM cache_attraction_info'); |
||
485 | $conn->executeUpdate('DELETE FROM cache_visited_cities'); |
||
486 | $conn->executeUpdate('DELETE FROM cache_flight'); |
||
487 | $conn->executeUpdate('DELETE FROM cache_attraction'); |
||
488 | $conn->executeUpdate('DELETE FROM cache_travel'); |
||
489 | $conn->executeUpdate('DELETE FROM cache_traveler'); |
||
490 | $conn->executeUpdate('DELETE FROM cache_traveler_profile_info'); |
||
491 | $conn->executeUpdate('DELETE FROM cache_traveler_profile'); |
||
492 | $conn->executeUpdate('DELETE FROM cache_city'); |
||
493 | $conn->executeUpdate('DELETE FROM cache_state'); |
||
494 | $conn->executeUpdate('DELETE FROM cache_country'); |
||
495 | $conn->executeUpdate('DELETE FROM cache_login'); |
||
496 | $conn->executeUpdate('DELETE FROM cache_token'); |
||
497 | $conn->executeUpdate('DELETE FROM cache_complex_action'); |
||
498 | $conn->executeUpdate('DELETE FROM cache_action'); |
||
499 | $conn->executeUpdate('DELETE FROM cache_client'); |
||
500 | } |
||
501 | |||
502 | if (isset($this->usedModelSets['ddc3346'])) { |
||
503 | $conn->executeUpdate('DELETE FROM ddc3346_articles'); |
||
504 | $conn->executeUpdate('DELETE FROM ddc3346_users'); |
||
505 | } |
||
506 | |||
507 | if (isset($this->usedModelSets['quote'])) { |
||
508 | $conn->executeUpdate( |
||
509 | sprintf( |
||
510 | 'UPDATE %s SET %s = NULL', |
||
511 | $platform->quoteIdentifier('quote-address'), |
||
512 | $platform->quoteIdentifier('user-id') |
||
513 | ) |
||
514 | ); |
||
515 | |||
516 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('quote-users-groups')); |
||
517 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('quote-group')); |
||
518 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('quote-phone')); |
||
519 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('quote-user')); |
||
520 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('quote-address')); |
||
521 | $conn->executeUpdate('DELETE FROM ' . $platform->quoteIdentifier('quote-city')); |
||
522 | } |
||
523 | |||
524 | if (isset($this->usedModelSets['vct_onetoone'])) { |
||
525 | $conn->executeUpdate('DELETE FROM vct_owning_onetoone'); |
||
526 | $conn->executeUpdate('DELETE FROM vct_inversed_onetoone'); |
||
527 | } |
||
528 | |||
529 | if (isset($this->usedModelSets['vct_onetoone_compositeid'])) { |
||
530 | $conn->executeUpdate('DELETE FROM vct_owning_onetoone_compositeid'); |
||
531 | $conn->executeUpdate('DELETE FROM vct_inversed_onetoone_compositeid'); |
||
532 | } |
||
533 | |||
534 | if (isset($this->usedModelSets['vct_onetoone_compositeid_foreignkey'])) { |
||
535 | $conn->executeUpdate('DELETE FROM vct_owning_onetoone_compositeid_foreignkey'); |
||
536 | $conn->executeUpdate('DELETE FROM vct_inversed_onetoone_compositeid_foreignkey'); |
||
537 | $conn->executeUpdate('DELETE FROM vct_auxiliary'); |
||
538 | } |
||
539 | |||
540 | if (isset($this->usedModelSets['vct_onetomany'])) { |
||
541 | $conn->executeUpdate('DELETE FROM vct_owning_manytoone'); |
||
542 | $conn->executeUpdate('DELETE FROM vct_inversed_onetomany'); |
||
543 | } |
||
544 | |||
545 | if (isset($this->usedModelSets['vct_onetomany_compositeid'])) { |
||
546 | $conn->executeUpdate('DELETE FROM vct_owning_manytoone_compositeid'); |
||
547 | $conn->executeUpdate('DELETE FROM vct_inversed_onetomany_compositeid'); |
||
548 | } |
||
549 | |||
550 | if (isset($this->usedModelSets['vct_onetomany_compositeid_foreignkey'])) { |
||
551 | $conn->executeUpdate('DELETE FROM vct_owning_manytoone_compositeid_foreignkey'); |
||
552 | $conn->executeUpdate('DELETE FROM vct_inversed_onetomany_compositeid_foreignkey'); |
||
553 | $conn->executeUpdate('DELETE FROM vct_auxiliary'); |
||
554 | } |
||
555 | |||
556 | if (isset($this->usedModelSets['vct_onetomany_extralazy'])) { |
||
557 | $conn->executeUpdate('DELETE FROM vct_owning_manytoone_extralazy'); |
||
558 | $conn->executeUpdate('DELETE FROM vct_inversed_onetomany_extralazy'); |
||
559 | } |
||
560 | |||
561 | if (isset($this->usedModelSets['vct_manytomany'])) { |
||
562 | $conn->executeUpdate('DELETE FROM vct_xref_manytomany'); |
||
563 | $conn->executeUpdate('DELETE FROM vct_owning_manytomany'); |
||
564 | $conn->executeUpdate('DELETE FROM vct_inversed_manytomany'); |
||
565 | } |
||
566 | |||
567 | if (isset($this->usedModelSets['vct_manytomany_compositeid'])) { |
||
568 | $conn->executeUpdate('DELETE FROM vct_xref_manytomany_compositeid'); |
||
569 | $conn->executeUpdate('DELETE FROM vct_owning_manytomany_compositeid'); |
||
570 | $conn->executeUpdate('DELETE FROM vct_inversed_manytomany_compositeid'); |
||
571 | } |
||
572 | |||
573 | if (isset($this->usedModelSets['vct_manytomany_compositeid_foreignkey'])) { |
||
574 | $conn->executeUpdate('DELETE FROM vct_xref_manytomany_compositeid_foreignkey'); |
||
575 | $conn->executeUpdate('DELETE FROM vct_owning_manytomany_compositeid_foreignkey'); |
||
576 | $conn->executeUpdate('DELETE FROM vct_inversed_manytomany_compositeid_foreignkey'); |
||
577 | $conn->executeUpdate('DELETE FROM vct_auxiliary'); |
||
578 | } |
||
579 | |||
580 | if (isset($this->usedModelSets['vct_manytomany_extralazy'])) { |
||
581 | $conn->executeUpdate('DELETE FROM vct_xref_manytomany_extralazy'); |
||
582 | $conn->executeUpdate('DELETE FROM vct_owning_manytomany_extralazy'); |
||
583 | $conn->executeUpdate('DELETE FROM vct_inversed_manytomany_extralazy'); |
||
584 | } |
||
585 | |||
586 | if (isset($this->usedModelSets['geonames'])) { |
||
587 | $conn->executeUpdate('DELETE FROM geonames_admin1_alternate_name'); |
||
588 | $conn->executeUpdate('DELETE FROM geonames_admin1'); |
||
589 | $conn->executeUpdate('DELETE FROM geonames_city'); |
||
590 | $conn->executeUpdate('DELETE FROM geonames_country'); |
||
591 | } |
||
592 | |||
593 | if (isset($this->usedModelSets['custom_id_object_type'])) { |
||
594 | $conn->executeUpdate('DELETE FROM custom_id_type_child'); |
||
595 | $conn->executeUpdate('DELETE FROM custom_id_type_parent'); |
||
596 | } |
||
597 | |||
598 | if (isset($this->usedModelSets['pagination'])) { |
||
599 | $conn->executeUpdate('DELETE FROM pagination_logo'); |
||
600 | $conn->executeUpdate('DELETE FROM pagination_department'); |
||
601 | $conn->executeUpdate('DELETE FROM pagination_company'); |
||
602 | $conn->executeUpdate('DELETE FROM pagination_user'); |
||
603 | } |
||
604 | |||
605 | if (isset($this->usedModelSets['versioned_many_to_one'])) { |
||
606 | $conn->executeUpdate('DELETE FROM versioned_many_to_one_article'); |
||
607 | $conn->executeUpdate('DELETE FROM versioned_many_to_one_category'); |
||
608 | } |
||
609 | |||
610 | if (isset($this->usedModelSets['issue5989'])) { |
||
611 | $conn->executeUpdate('DELETE FROM issue5989_persons'); |
||
612 | $conn->executeUpdate('DELETE FROM issue5989_employees'); |
||
613 | $conn->executeUpdate('DELETE FROM issue5989_managers'); |
||
614 | } |
||
615 | |||
616 | $this->em->clear(); |
||
617 | } |
||
856 |