function insertComposersOnDB()
{
$db = new MysqliDb(HOST, USER, PASSWORD, DBNAME);
$composers = getListComposersDb();
foreach ($composers as $index => $composer) {
$compositions = extractCompositionsFromSearchHtmls($composer['name']);
foreach ($compositions as $composition) {
echo "Inserting " . $composition . "..." . PHP_EOL;
$relevance = $index + 1;
$query = "INSERT INTO `compositions`(`composer_id`,`name`,`relevance`)";
$query .= " VALUES ('" . $composer['id'] . "','" . escapeSingleQuote($composition) . "','" . $relevance . "');";
$db->rawQuery($query);
}
}
}
foreach ($compositions as $numComposition => $composition) {
// There were some problems when retrieving the data from YouTube
// so, to avoid retrieving everything from scratch we set a start number
if ($numComposition < $startComposition) {
continue;
}
$maxResults = 25;
$youtube = new Google_Service_YouTube($client);
$searchResponse = $youtube->search->listSearch('id,snippet', array('q' => $composition['composition'] . " " . $composition['composer'], 'maxResults' => $maxResults, 'type' => 'video', 'order' => 'relevance', 'videoEmbeddable' => 'true'));
foreach ($searchResponse as $index => $result) {
$relevance = $index + 1;
$videoId = $result->getId()->getVideoId();
$videoTitle = $result->getSnippet()->getTitle();
$videoDescription = $result->getSnippet()->getDescription();
$query = "INSERT INTO `videos`(`composition_id`,`youtube_id`,`title`,`description`,`relevance` )";
$query .= " VALUES ('" . $composition['id'] . "','" . $videoId . "','" . escapeSingleQuote($videoTitle) . "','" . escapeSingleQuote($videoDescription) . "','" . $relevance . "');";
$db->rawQuery($query);
}
echo $numComposition + 1 . "/" . $countCompositions . ": Inserting videos for " . $composition['composition'] . PHP_EOL;
usleep(150);
// To avoid having problems with YouTube API quota limit
}
function test()
{
$client = new Google_Client();
$client->setApplicationName("Amadeus");
$client->setDeveloperKey(YOUTUBE_API_KEY);
$youtube = new Google_Service_YouTube($client);
$searchResponse = $youtube->search->listSearch('id,snippet', array('q' => 'test', 'maxResults' => 25, 'type' => 'video', 'order' => 'relevance', 'videoEmbeddable' => 'true'));
print_r($searchResponse);
}