* 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();
