test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from mido import MidiFile\n",
    "import sys\n",
    "import json\n",
    "import mido\n",
    "import numpy as np\n",
    "import random\n",
    "\n",
    "def midifile_to_dict(mid):\n",
    "    tracks = []\n",
    "    for track in mid.tracks:\n",
    "        tracks.append([vars(msg).copy() for msg in track])\n",
    "\n",
    "    return {\n",
    "        'ticks_per_beat': mid.ticks_per_beat,\n",
    "        'tracks': tracks,\n",
    "    }\n",
    "\n",
    "\n",
    "def midi_to_txt(data_dir, file_name):\n",
    "    song_name = file_name.replace('.mid','')\n",
    "    json_path = data_dir + '/' + song_name\n",
    "    txt_path = data_dir + '/' + song_name + '.txt'\n",
    "    mid = mido.MidiFile(data_dir + '/' + file_name)\n",
    "\n",
    "    #print(json.dumps(midifile_to_dict(mid), indent=2))\n",
    "    with open(json_path, 'w') as outfile:\n",
    "        json.dump(midifile_to_dict(mid), outfile)\n",
    "\n",
    "    #The tempo is microseconds per beat, that is bpm = 60/(temp*10^(-6))\n",
    "    #C4 is 60\n",
    "\n",
    "    with open(json_path, 'r') as f:\n",
    "         data = json.load(f)\n",
    "    tpb = data['ticks_per_beat']\n",
    "    note_events_number = len(data['tracks'][0]) #計算note event的數量，後面的index可能是0或是1，cubase輸出的midi是1\n",
    "    note_events = data['tracks'][0] #取出note evnet的軌，後面的index可能是0或是1，cubase輸出的midi是1\n",
    "    ticks_per_beat = data['ticks_per_beat']\n",
    "    time_shift = 0\n",
    "    ###Time shift start###\n",
    "    for i in range(0,100):\n",
    "        if note_events[i]['type'] == 'note_on':\n",
    "            time_shift = note_events[i]['time']//ticks_per_beat*ticks_per_beat\n",
    "            note_events[i]['time'] = note_events[i]['time'] - time_shift#刪除midi前面空白部分\n",
    "            break\n",
    "    ###Time shift end###\n",
    "\n",
    "    ###將所有event的時間算成絕對時間 start###\n",
    "    note_events_abs_time = []\n",
    "    for i in range(0, note_events_number):\n",
    "        note_events_abs_time.append(note_events[i]['time'])\n",
    "    for i in range(0, note_events_number):\n",
    "        if i != 0:\n",
    "            note_events_abs_time[i] = note_events_abs_time[i-1] + note_events_abs_time[i]\n",
    "    ###將所有event的時間算成絕對時間 end###\n",
    "\n",
    "\n",
    "    ###note event to 2d-array start###\n",
    "    #將note event存成note on 和note off的兩個2d-list，[[timestamp 1, pitch 1],....]\n",
    "    note_on = []\n",
    "    note_off = []\n",
    "    note_check = []\n",
    "    for i in range(0, note_events_number):\n",
    "        if note_events[i]['type'] == 'note_on':\n",
    "            note_on.append([note_events[i]['time'],note_events[i]['note']])\n",
    "            note_check.append([note_events_abs_time[i],note_events[i]['note']])\n",
    "        elif note_events[i]['type'] == 'note_off':\n",
    "            note_off.append([note_events[i]['time'],note_events[i]['note']])\n",
    "            note_check.append([note_events_abs_time[i],note_events[i]['note']])\n",
    "    ###note event to 2d-array end### \n",
    "\n",
    "    ###檢查音有沒有重疊 start###\n",
    "    note_check.sort(key=lambda x: x[0])\n",
    "    note_check_pitch = np.array(note_check)[:,1]\n",
    "    checktime = 0\n",
    "    first = 0\n",
    "    for idx in range(0,len(note_check_pitch)):\n",
    "        checktime += 1\n",
    "        if checktime == 1:\n",
    "            first = note_check_pitch[idx]\n",
    "        elif checktime == 2:\n",
    "            if first != note_check_pitch[idx]:\n",
    "                print('有重疊音')\n",
    "                break\n",
    "            checktime = 0\n",
    "        if idx == len(note_check_pitch)-1:\n",
    "            print('通過')\n",
    "    ###檢查音有沒有重疊 end###\n",
    "\n",
    "    midi_array = []\n",
    "    condense_raio = 48\n",
    "    condense_raio = (tpb//192)*condense_raio #normalize然後縮小ticks_per_beat，減少兩個note間的間隔，沒有縮小=1；設定為12時，最小note長度為1/64拍\n",
    "    for note_idx in range(0, len(note_on)):\n",
    "        for time_idx in range(0, note_on[note_idx][0]//condense_raio): #填入note on前的空白部分\n",
    "            midi_array.append(90)\n",
    "        midi_array.append(note_on[note_idx][1])\n",
    "        for time_idx in range(0, note_off[note_idx][0]//condense_raio): #填入接續上一個音高，index為note pitch +128\n",
    "            midi_array.append(89)\n",
    "    \n",
    "\n",
    "    with open(txt_path, 'w') as text_file:\n",
    "        for idx in range(0, len(midi_array)):\n",
    "            if idx != len(midi_array)-1:\n",
    "                text_file.write(str(midi_array[idx]) + ' ')\n",
    "            else:\n",
    "                text_file.write(str(midi_array[idx]))\n",
    "                \n",
    "def concatenate_data(data_dir, txtname, input_string):\n",
    "    output_data = ''\n",
    "    txt_path = data_dir + '/' + txtname\n",
    "    with open(txt_path, 'r') as text_file:\n",
    "        output_data = input_string + ' ' + text_file.read()\n",
    "    return output_data\n",
    "\n",
    "def concatenate_txt(data_dir, files):\n",
    "    pre_output_data = ''\n",
    "    is_first_file = True\n",
    "    for file in files:\n",
    "        if file.find('.txt') != -1:\n",
    "            if is_first_file == True:\n",
    "                with open(data_dir + '/' + file, 'r') as text_file:\n",
    "                    pre_output_data = text_file.read()\n",
    "                is_first_file = False\n",
    "            else:\n",
    "                pre_output_data = concatenate_data(data_dir, file, pre_output_data)\n",
    "    return pre_output_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "通過\n",
      "有重疊音\n",
      "有重疊音\n",
      "有重疊音\n"
     ]
    }
   ],
   "source": [
    "from os import listdir\n",
    "from os.path import isfile, join\n",
    "data_dir = 'midi_data'\n",
    "all_files = [f for f in listdir(data_dir) if isfile(join(data_dir, f))]\n",
    "for file in all_files:\n",
    "    if file.find('.mid') != -1:\n",
    "        midi_to_txt(data_dir, file)\n",
    "\n",
    "#現在重疊音的處理方式為將該音的note off和重疊下一個音的note on的time stamp對調\n",
    "#未來可改成將該音的note off縮到和下個音的note on一樣的time stamp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "456\n",
      "38\n",
      "38\n",
      "380\n",
      "131507\n",
      "179273\n",
      "1393577\n"
     ]
    }
   ],
   "source": [
    "data_dir = 'midi_data'\n",
    "all_files = [f for f in listdir(data_dir) if isfile(join(data_dir, f))]\n",
    "random.shuffle(all_files)\n",
    "all_txt = []\n",
    "for file in all_files:\n",
    "    if file.find('.txt') != -1:\n",
    "        all_txt.append(file)\n",
    "    \n",
    "test_files = all_txt[0:len(all_txt)//12]\n",
    "valid_files = all_txt[len(all_txt)//12 : 2*(len(all_txt)//12)]\n",
    "train_files = all_txt[2*(len(all_txt)//12):len(all_txt)]\n",
    "\n",
    "test_data = concatenate_txt(data_dir, test_files)\n",
    "valid_data = concatenate_txt(data_dir, valid_files)\n",
    "train_data = concatenate_txt(data_dir, train_files)\n",
    "print(len(all_txt))\n",
    "print(len(test_files))\n",
    "print(len(valid_files))\n",
    "print(len(train_files))\n",
    "print(len(test_data))\n",
    "print(len(valid_data))\n",
    "print(len(train_data))\n",
    "\n",
    "with open('midi_data/melodygen.test.txt', 'w') as text_file:\n",
    "    text_file.write(test_data)\n",
    "with open('midi_data/melodygen.valid.txt', 'w') as text_file:\n",
    "    text_file.write(valid_data)\n",
    "with open('midi_data/melodygen.train.txt', 'w') as text_file:\n",
    "    text_file.write(train_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "##去除多餘的空白，thre = 1/4拍\n",
    "\n",
    "import sys\n",
    "\n",
    "def despace(data_dir, txtname):\n",
    "    with open(data_dir + \"/\" + txtname + \".txt\", \"r\") as text_file:\n",
    "        data = list(map(int, text_file.read().split(' ')))\n",
    "\n",
    "    num_of_space = 0\n",
    "    data_new = []\n",
    "    for i in data:\n",
    "        if i != 90:\n",
    "            if num_of_space <= 4:\n",
    "                for sp_n in range(0, num_of_space):\n",
    "                    data_new.append(90)\n",
    "                num_of_space = 0\n",
    "            else:\n",
    "                for sp_n in range(0, 4):\n",
    "                    data_new.append(90)\n",
    "                num_of_space = 0\n",
    "            data_new.append(i)\n",
    "        else:\n",
    "            num_of_space += 1\n",
    "    with open(data_dir + \"/\" + txtname + \"_despace.txt\", 'w') as text_file:\n",
    "        for idx in range(0, len(data_new)):\n",
    "            if idx != len(data_new)-1:\n",
    "                text_file.write(str(data_new[idx]) + ' ')\n",
    "            else:\n",
    "                text_file.write(str(data_new[idx]))\n",
    "data_dir = \"data\"\n",
    "despace(data_dir, \"melodygen.train\")\n",
    "despace(data_dir, \"melodygen.valid\")\n",
    "despace(data_dir, \"melodygen.test\")\n",
    "    \n",
    "\n",
    "            \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10\n",
      "[1, 2]\n",
      "[3, 4]\n",
      "[5, 6, 7, 8, 9, 10]\n"
     ]
    }
   ],
   "source": [
    "import random\n",
    "a = [1,2,3,4,5,6,7,8,9,10]\n",
    "print(len(a))\n",
    "print(a[0:2])\n",
    "print(a[2:4])\n",
    "print(a[2*2:len(a)])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#建立midi_idx\n",
    "midi_onehot = []\n",
    "for i in range(0, 91):\n",
    "    midi_onehot.append(i)\n",
    "with open('midi_data/melodygen.midi_idx.txt', 'w') as text_file:\n",
    "        for idx in range(0, len(midi_onehot)):\n",
    "            if idx != len(midi_onehot)-1:\n",
    "                text_file.write(str(midi_onehot[idx]) + ' ')\n",
    "            else:\n",
    "                text_file.write(str(midi_onehot[idx]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "1\n",
      "2\n"
     ]
    }
   ],
   "source": [
    "a = [1,2,3]\n",
    "for i in range(0, len(a)):\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "有重疊音\n"
     ]
    },
    {
     "ename": "IndexError",
     "evalue": "list index out of range",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mIndexError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-6133ef096a89>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0mdata_dir\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m'data/'\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      2\u001b[0m \u001b[0mfile\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m'c0130.mid'\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 3\u001b[1;33m \u001b[0mmidi_to_txt\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_dir\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfile\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32m<ipython-input-1-d11d6782e042>\u001b[0m in \u001b[0;36mmidi_to_txt\u001b[1;34m(data_dir, file_name)\u001b[0m\n\u001b[0;32m     94\u001b[0m             \u001b[0mmidi_array\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m90\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     95\u001b[0m         \u001b[0mmidi_array\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnote_on\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mnote_idx\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m1\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 96\u001b[1;33m         \u001b[1;32mfor\u001b[0m \u001b[0mtime_idx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mrange\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnote_off\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mnote_idx\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m//\u001b[0m\u001b[0mcondense_raio\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;31m#填入接續上一個音高，index為note pitch +128\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     97\u001b[0m             \u001b[0mmidi_array\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnote_on\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mnote_idx\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m1\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     98\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mIndexError\u001b[0m: list index out of range"
     ]
    }
   ],
   "source": [
	"#讀取database\n",
    "\n",
    "import sqlite3\n",
    "conn = sqlite3.connect('wjazzd.db')\n",
    "melody = c.execute('SELECT eventid, onset, duration, pitch FROM melody where melid = 1').fetchall()\n",
    "chord = c.execute('SELECT * FROM sections where type = \"PHRASE\" and melid = 1').fetchall()\n",
    "chords = c.execute('SELECT chord_changes FROM solo_info where melid = 1').fetchall()\n",
    "form = c.execute('SELECT * FROM sections where type = \"FORM\" and melid = 1').fetchall()\n",
    "beats = c.execute('SELECT * FROM beats where melid = 3').fetchall()\n",
    "# print(chord)\n",
    "# print(form)\n",
    "for b in beats:\n",
    "    print(b)\n",
    "\n",
    "\n",
    "#CHORD的欄位編碼 (歌曲編號, TYPE, event id開始, event id結束,和弦)，這邊只有「有note的地方才有對應的chord」\n",
    "#FORM裡面是分段的資訊\n",
    "#CHORUS是單位，一整遍歌曲叫做一個CHORUS\n",
    "#beats裡面的資訊是(編號, 歌曲編號, 時間, 小節, beat, signature, 和弦,段落,,第n個CHORUS)\n",
    "#chord_changes FROM solo_info 有一次CHORUS的分段和弦資訊"

   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.0"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import math\n",
    "np.log(math.exp( 1 ))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-44.0"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "decay_rate = 0.9\n",
    "4.60517//np.log(decay_rate)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}