* echonest_vector_counter.php to count feature vector * * PHP version 5 * * @category PHP * @package /p-schedule/ * @author Fukuball Lin <*****@*****.**> * @license No Licence * @version Release: <1.0> * @link http://sarasti.cs.nccu.edu.tw */ require_once dirname(dirname(__FILE__)) . "/p-config/application-setter.php"; $db_obj = LMDBAccess::getInstance(); $select_sql = "SELECT " . "id " . "FROM song " . "WHERE is_deleted = '0' " . "AND audio_path!='' " . "AND echonest_track_id!='' " . "AND retrieval_status='success' " . "ORDER BY id"; $query_result = $db_obj->selectCommand($select_sql); $music_feature_god = new LMMusicFeatureGod(); // get unprocess data foreach ($query_result as $query_result_data) { $song_obj = new LMSong($query_result_data['id']); $echonest_analysis_file = AUDIO_ROOT . '/' . $song_obj->getId() . '.json'; $echonest_analysis = file_get_contents($echonest_analysis_file); $echonest_data = json_decode($echonest_analysis); $second = $echonest_data->meta->seconds; $bar_count = count($echonest_data->bars); $beat_count = count($echonest_data->beats); $tatum_count = count($echonest_data->tatums); $section_count = count($echonest_data->sections); $segment_count = count($echonest_data->segments); $bar_duration_sum = 0; foreach ($echonest_data->bars as $bars_data) { $bar_duration_sum = $bar_duration_sum + $bars_data->duration;
* music_audio_word_matrix_generate.php * * PHP version 5 * * @category PHP * @package /p-schedule/ * @author Fukuball Lin <*****@*****.**> * @license No Licence * @version Release: <1.0> * @link http://sarasti.cs.nccu.edu.tw */ require_once dirname(dirname(__FILE__)) . "/p-config/application-setter.php"; $db_obj = LMDBAccess::getInstance(); $select_sql = "SELECT " . "id " . "FROM song " . "WHERE is_deleted = '0' " . "AND audio_path!='' " . "AND echonest_track_id!='' " . "AND retrieval_status='success' " . "ORDER BY id"; $query_result = $db_obj->selectCommand($select_sql); $music_feature_god = new LMMusicFeatureGod(); // get unprocess data foreach ($query_result as $query_result_data) { echo "song_id: " . $query_result_data['id'] . " \n"; $song_obj = new LMSong($query_result_data['id']); $echonest_analysis_file = AUDIO_ROOT . '/' . $song_obj->getId() . '.json'; $echonest_analysis = file_get_contents($echonest_analysis_file); $echonest_data = json_decode($echonest_analysis); $song_section_array = array(); foreach ($echonest_data->bars as $section_data) { array_push($song_section_array, $section_data->start); } array_push($song_section_array, 100000); $song_audio_word_array = array(); $song_audio_word_count_array = array(); $song_audio_word_timbre_array = array();