$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;
}
$bar_avg_second = $bar_duration_sum / $bar_count;
echo "second: {$second} \n";
echo "bar_count: {$bar_count} \n";
echo "beat_count: {$beat_count} \n";
echo "tatum_count: {$tatum_count} \n";
echo "section_count: {$section_count} \n";
echo "segment_count: {$segment_count} \n";
echo "bar_avg_second: {$bar_avg_second} \n";
$music_feature_id = $music_feature_god->findBySongId($song_obj->getId());
if ($music_feature_id) {
$music_feature_obj = new LMMusicFeature($music_feature_id);
$music_feature_obj->second = $second;
$music_feature_obj->bar_count = $bar_count;
$music_feature_obj->beat_count = $beat_count;
$music_feature_obj->tatum_count = $tatum_count;
$music_feature_obj->section_count = $section_count;
$music_feature_obj->segment_count = $segment_count;
$music_feature_obj->bar_avg_second = $bar_avg_second;
if ($music_feature_obj->save()) {
echo "update music feature success \n";
} else {
echo "update music feature fail \n";
}
} else {
$parameter_array = array();
$parameter_array['song_id'] = $song_obj->getId();
* 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 music_feature " . "WHERE is_deleted = '0' " . "ORDER BY id";
$query_result = $db_obj->selectCommand($select_sql);
// get unprocess data
foreach ($query_result as $query_result_data) {
$music_feature_obj = new LMMusicFeature($query_result_data['id']);
$song_id = $music_feature_obj->song_id;
$select_sql2 = "SELECT " . "macw.id code_word_id," . "maw.song_id," . "COUNT(maw.code_word_id) word_count " . "FROM muisc_audio_code_word macw " . "LEFT JOIN music_audio_word maw " . "ON (macw.id=maw.code_word_id AND maw.song_id=" . $song_id . ") " . "WHERE macw.code_book_id=1 " . "GROUP BY macw.id " . "ORDER BY macw.id";
$query_result2 = $db_obj->selectCommand($select_sql2);
$histogram_array = array();
foreach ($query_result2 as $query_result_data2) {
array_push($histogram_array, $query_result_data2['word_count']);
}
$histogram_array_string = implode(',', $histogram_array);
$music_feature_obj->pitch_audio_word_histogram = $histogram_array_string;
if ($music_feature_obj->save()) {
echo "update music feature " . $music_feature_obj->getId() . " success \n";
} else {
echo "update music feature " . $music_feature_obj->getId() . " fail \n";
}
unset($music_feature_obj);
