function insertCompositionsOnDB()
{
$composers = getListComposers();
foreach ($composers as $index => $composer) {
$slug = getSlugComposer($composer);
$relevance = $index + 1;
$db = new MysqliDb(HOST, USER, PASSWORD, DBNAME);
$query = "INSERT INTO `composers`(`slug`,`name`,`relevance`)";
$query .= " VALUES ('" . $slug . "','" . $composer . "','" . $relevance . "');";
echo $query . PHP_EOL;
$db->rawQuery($query);
}
}
function getCompositions()
{
$composers = getListComposers();
$composers = array_slice($composers, 0, 2);
foreach ($composers as $composer) {
// We first save the HTMLs of the search "[composer] + compositions"
saveHtmlSearchComposerCompositions($composer);
// Once saved, we extract the compositions
$compositions = extractCompositionsFromSearchHtmls($composer);
$compositions = array_slice($compositions, 0, 1);
// For each composition, let's try to retrieve the info from Wikipedia
foreach ($compositions as $composition) {
// TODO: THIS IS NOT DONE!
getWikipediaPageForComposition($composition);
}
}
}
