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);
}
}
}
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);
}
}
}
