Testdaten aktualisieren

Für mehrere neu eingeführte Entitäten fehlen Testdaten in der Datenbank. Aktuell müssen bspw. für DashboardDiagrams, FilterHistories manuell Daten erstellt werden. Analog zu Transekten, News,... sollen beispielhafte Daten zur Verfügung gestellt werden.

Bei Implementierung des Tickets sind zusätzliche Bugs aufgetreten:

• DashboardDiagram Strategies modifizieren FilterService.dbQueryBuilder mit zusätzlichen Aliases => Kollisionen (bspw. Left Join SectionEvent se, se Alias existiert bereits)
• DashboardDiagram missing OwnerVisibilityInterface
• DB Schema Fehler via docker-compose exec php-fpm bash -c "php bin/console doctrine:schema:validate"

 [FAIL] The entity-class App\Entity\Section mapping is invalid:
 * The field App\Entity\Section#transectSectionHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TransectSectionHistory#section does not contain the required 'inversedBy="transectSectionHistories"' attribute.


 [FAIL] The entity-class App\Entity\SpeciesSpecialist mapping is invalid:
 * The association App\Entity\SpeciesSpecialist#user refers to the inverse side field App\Entity\User#speciesSpecialist which does not exist.


 [FAIL] The entity-class App\Entity\Transect mapping is invalid:
 * The field App\Entity\Transect#inspections is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Inspection#transect does not contain the required 'inversedBy="inspections"' attribute.


 [FAIL] The entity-class App\Entity\User mapping is invalid:
 * The mappings App\Entity\User#speciesSpecialists and App\Entity\SpeciesSpecialist#user are inconsistent with each other.

AC

• jede Entität hat Testdaten (bspw. FilterHistories, DashboardDiagrams, ...)
• DashboardDiagram implements OwnerVisibilityInterface
• Keine Schema Fehler

Queries um alle neu hinzugefügten Entitäten anzufragen

• DashboardDiagram

{
  seriesDashboardDiagrams(dateTimeFrom: "2021-02-17", dateTimeTo: "2021-02-18") {
    collection {
      _id
      seriesData
      displayType
      title
      xLabel
      yLabel
    }
  }
}

• FavoriteSpeciesItem

{
    favouriteSpeciesItems { 
        collection {
            id
        }
    }
}

• FilterHistory

{
  filterHistories {
    collection {
      id
      label
      isFavorite
      type
      filter
      user {
        id
      }
    }
  }
}

• ImageRef

{
  imageRefs {
    collection {
      id
      ref
      height
      width
      url
      thumbnailRefs {
        collection {
          id
        }
      }
    }
  }
}

• LandCoordinator

{
  landCoordinators {
    collection {
      id
      user {
        id
      }
      icc2
    }
  }
}

• QSObservation

{
  qSObservations {
    collection {
      id
      observation {
        id
      }
      qsProposal
      qsComment
      qsStatus
      qsSpecies
      abundance
      outOfMethod
      comment
      sex
      isDead
      species
      developmentalStage {
        id
      }
    }
  }
}

• SpeciesSpecialist

{
  speciesSpecialists {
    collection {
      id
      user {
        id
      }
      species
    }
  }
}

• ThumbnailRef

{
  thumbnailRefs {
    collection {
      id
      imageRef {
        id
      }
      ref
      label
      height
      width
      url
    }
  }
}

• TransectSectionHistory

{
  transectSectionHistories {
    collection {
      id
      allocatedStart
      allocatedEnd
      transect {
        id
      }
      section {
        id
      }
    }
  }
}

• TransectUserHistory

{
  transectUserHistories {
    collection {
      id
      allocatedStart
      allocatedEnd
      transect {
        id
      }
      icc2
      species
      user {
        id
      }
      relationType {
        id
      }
    }
  }
}