Module ImportFrom alias Import alias Import alias Import alias Import alias identifier Import alias ImportFrom alias Assign NameStore Call AttributeLoad NameLoad attr Str If CompareEq Call AttributeLoad AttributeLoad NameLoad attr attr Str body Import alias identifier orelse Import alias identifier Assign NameStore Str Assign NameStore Str FunctionDef arguments args defaults body Assign NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args defaults body Assign NameStore Call NameLoad Assign NameStore Call NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Print Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args defaults body Expr Str Print Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr BinOpAdd BinOpAdd Str Call NameLoad Call AttributeLoad AttributeLoad NameLoad attr attr Str With Call AttributeLoad NameLoad attr NameLoad Str Str NameStore body Expr Call AttributeLoad NameLoad attr Str For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Print Call AttributeLoad NameLoad attr BinOpMod AttributeLoad NameLoad attr NameLoad Str Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad NameLoad For NameStore NameLoad body If AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad NameLoad attr NameLoad If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad NameLoad Assign TupleStore NameStore NameStore TupleLoad ListLoad ListLoad For NameStore NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args defaults body Expr Str Assign NameStore Call NameLoad Assign NameStore Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list ClassDef bases NameLoad body FunctionDef arguments args NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr Assign NameStore BinOpAdd NameLoad Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore SubscriptLoad Call AttributeLoad NameLoad attr Index Num Expr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore ListComp Call AttributeLoad NameLoad attr NameLoad comprehension NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Assign NameStore Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad TupleLoad Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Str Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body If NameLoad body Assign NameStore Call NameLoad Assign TupleStore AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr AttributeStore NameLoad attr NameLoad Return NameLoad Return NameLoad decorator_list decorator_list
N/A obj History N/A log N/A config N/A datetime N/A sqlite3 sqlite N/A codecs os path N/A LOG N/A N/A log get_logger zxLogger N/A N/A N/A N/A N/A config LANG upper CN N/A N/A zhuaxia.i18n.msg_cn msg N/A N/A zhuaxia.i18n.msg_en msg N/A SELECT_PART Select id, song_id, song_name, hq, source, location, api_url, dl_time, times FROM History  N/A INSERT_STMT Insert into History (song_id, song_name, hq, source, location, api_url, dl_time )
    values(?,?,?,?,?,?,?) __getConnection N/A N/A N/A N/A N/A conn N/A N/A sqlite connect N/A config HIST_DB N/A conn N/A get_history_count N/A N/A N/A N/A N/A conn N/A __getConnection N/A dao N/A HistDao conn N/A count N/A N/A dao get_history_count N/A N/A N/A conn close N/A count N/A empty_hists N/A N/A N/A N/A N/A empty history table N/A conn N/A __getConnection N/A dao N/A HistDao conn N/A hists N/A N/A dao delete_all N/A N/A N/A log hl N/A msg history_cleared cyan N/A N/A N/A conn commit N/A N/A N/A conn close N/A export_hists N/A N/A N/A N/A N/A 
    export all history data
     N/A N/A N/A log hl N/A msg history_exporting cyan N/A conn N/A __getConnection N/A dao N/A HistDao conn N/A hists N/A N/A dao get_all_histories N/A filename N/A N/A path join N/A config DOWNLOAD_DIR N/A N/A zhuaxia_history_ N/A str N/A N/A N/A datetime datetime today .csv N/A N/A N/A codecs open filename w utf-8 f N/A N/A N/A N/A f write id;song_id;song_name;quality;source;location;api_url;download_time;download_times
 N/A h hists N/A N/A N/A N/A f write N/A N/A h to_csv N/A N/A N/A f write N/A N/A N/A log hl N/A N/A msg history_exported filename cyan N/A N/A N/A conn close N/A insert_hist N/A N/A songs N/A N/A N/A 
    insert histories entry if it is not yet exists (check unique constraint)
    otherwise skip insertion
     N/A conn N/A __getConnection N/A dao N/A HistDao conn N/A song songs N/A N/A N/A song success N/A N/A hist N/A N/A dao get_history song N/A hist N/A N/A N/A N/A dao update_history hist song N/A N/A N/A N/A dao insert_history song N/A N/A N/A conn commit N/A N/A N/A conn close N/A filter_songs N/A N/A songs N/A N/A N/A 
    the function do filtering on songs, if the song has a history entry 
    put the song in skipped list, also put the found history entry in hist_list
    finally return two lists
     N/A conn N/A __getConnection N/A dao N/A HistDao conn N/A N/A skipped hist_list N/A N/A N/A N/A song songs N/A N/A hist N/A N/A dao get_history song N/A hist N/A N/A N/A N/A skipped append song N/A N/A N/A hist_list append hist N/A N/A N/A conn close N/A N/A skipped hist_list N/A empty_history N/A N/A N/A N/A N/A 
    remove all history data
     N/A conn N/A __getConnection N/A dao N/A HistDao conn N/A N/A N/A dao delete_all conn N/A N/A N/A conn commit N/A N/A N/A conn close N/A HistDao N/A object N/A __init__ N/A N/A self conn N/A N/A N/A N/A self conn conn N/A get_history N/A N/A self song N/A N/A N/A N/A N/A LOG debug get history for song:%s N/A song song_name N/A sql N/A SELECT_PART  where song_id=? and source=? and hq=?  N/A cur N/A N/A N/A self conn cursor N/A N/A N/A cur execute sql N/A N/A song song_id N/A song song_type N/A N/A song handler is_hq N/A hist N/A N/A self __row2hist N/A N/A cur fetchone N/A N/A N/A cur close N/A hist N/A get_history_count N/A N/A self N/A N/A N/A sql select count(*) from History N/A cur N/A N/A N/A self conn cursor N/A N/A N/A cur execute sql N/A count N/A N/A N/A cur fetchone N/A 0 N/A N/A N/A cur close N/A count N/A get_all_histories N/A N/A self N/A N/A N/A sql SELECT_PART N/A cur N/A N/A N/A self conn cursor N/A N/A N/A cur execute sql N/A all_hists N/A N/A N/A self __row2hist row N/A row N/A N/A cur fetchall N/A N/A N/A cur close N/A all_hists N/A insert_history N/A N/A self song N/A N/A N/A sql INSERT_STMT N/A cur N/A N/A N/A self conn cursor N/A N/A N/A cur execute sql N/A N/A song song_id N/A song song_name N/A N/A song handler is_hq N/A song song_type N/A song abs_path N/A song dl_link N/A N/A N/A datetime datetime today N/A N/A N/A cur close N/A update_history N/A N/A self hist song N/A N/A N/A sql update History set 
            times=times+1, dl_time=?, location=?, api_url=?
            where id=? N/A cur N/A N/A N/A self conn cursor N/A N/A N/A cur execute sql N/A N/A N/A N/A datetime datetime today N/A song abs_path N/A song dl_link N/A hist id N/A N/A N/A cur close N/A delete_all N/A N/A self N/A N/A N/A sql delete from History N/A N/A N/A LOG debug empty history data N/A cur N/A N/A N/A self conn cursor N/A N/A N/A cur execute sql N/A N/A N/A cur close N/A __row2hist N/A N/A self row N/A N/A N/A row N/A N/A hist N/A History N/A N/A N/A hist id N/A hist song_id N/A hist song_name N/A hist hq N/A hist source N/A hist location N/A hist api_url N/A hist dl_time N/A hist times row N/A hist N/A None N/A N/A