function insertUserDataInDb($picture, $artist, $museum, $owner, $keywords, $category_ids)
{
$dbInserter = new DbInserter();
$idFetcher = new DbIdFetcher();
/********** ARTIST ****************/
$dbInserter->insertArtistIfDoesNotExists($this->db, $artist);
$picture->artist_fk = $idFetcher->fetchArtistId($this->db, $artist);
/********** OWNER ****************/
$dbInserter->insertOwnerIfDoesNotExists($this->db, $owner);
$picture->owner_fk = $idFetcher->fetchOwnerId($this->db, $owner);
/********** MUSEUM ****************/
if ($museum->isExhibitor) {
$dbInserter->insertMuseumExhibitsIfNotExists($this->db, $museum);
$picture->museum_exhibits_fk = $idFetcher->fetchMuseumId($this->db, $museum);
}
if ($museum->isOwner) {
$dbInserter->insertMuseumOwnsIfNotExists($this->db, $museum);
$picture->museum_owns_fk = $idFetcher->fetchMuseumId($this->db, $museum);
}
/********** KEYWORDS ****************/
$keyword_ids = array();
foreach ($keywords as $keyword_title) {
$dbInserter->insertKeyWordIfNotExists($this->db, $keyword_title);
$keyword_id = $idFetcher->fetchKeywordId($this->db, $keyword_title);
array_push($keyword_ids, $keyword_id);
}
/********** CATEGORIES ****************/
$dbInserter->insertCategoriesIfNeeded($this->db);
/********** PICTURE ****************/
$dbInserter->insertPictureIfNotExists($this->db, $picture);
$picture->id = $idFetcher->fetchPictureId($this->db, $picture);
/********** PICTURES_CATEGORIES ****************/
$dbInserter->insertPictureCategoriesIfNotExists($this->db, $picture->id, $category_ids);
/********** PICTURES_KEYWORDS ****************/
$dbInserter->insertPictureKeywordsIfNotExists($this->db, $picture->id, $keyword_ids);
}
function compare($db, $picture)
{
$inserter = new DbInserter();
$id = $inserter->insertComparisonPicture($db, $picture);
$pictures;
for ($threshold = 10; $threshold <= 90; $threshold = $threshold + 10) {
$pictures = $this->comparePicture($db, $picture, $id, $threshold);
if (count($pictures) > 0) {
break;
}
}
$this->deleteComparisonPictures($db);
return $pictures;
}