U Ƣf @sDddlZddlmZddlZddlZddlmZddZddZdS)N)Error)datecCs|dr"|dr"||d|7}nd|drJ|dsJ|d|7}|dn<|drr|dsr|d|7}|dn|d|d||fS)NAND )pop)listsidnamer '/home/mars/bis/apps/parsefile/search.pyarrange s      rc Csztjjddddd}|}d}d}d}d }d }d }d } d } |d} |dd } d} |d |dkr|d r"|dr"d} | |d|7} t|| ||\}} t|dkrd|| } |d|| t|| } n>| |d7} |dt | |dd} || t|| } n|d s|dsd} t d| |d7} |drt|drt| |d|7} nh|dr|ds| |7} |dn@|dr|ds| |7} |dn|} |d|d| || d7} |d|d || t|| } n|d |dkr|d r|drd} t d| |d|d|7} t|| ||\}} | || d7} t || || t|| } | | | fWSt k r}zt dt |tdW5d}~XYnX|dS)Nz 127.0.0.1itransdb itranswlcz 1tr@nsb1rry)hostdatabaseuserpasswordz select * from drivers_info_hist u變動生效日期 >= %s u變動生效日期 <= %s u!姓名 like CONCAT('%', %s, '%') u!工號 like CONCAT('%', %s, '%') z ORDER BY rzwhere ru(select drivers_info_hist.* from drivers_info_hist, (select 姓名, max(變動生效日期) as 變動生效日期 from drivers_info_hist where 變動生效日期 <= %s group by 姓名)MAX where drivers_info_hist.姓名= MAX.姓名 and drivers_info_hist.變動生效日期 = MAX.變動生效日期 u變動生效日期 DESC2r rrz DESCaz!Error connecting to the database:)mysql connectorconnectcursorrrlenexecutetuplefetchallprintfetchonerstrsysexitclose)r connectionrheadsdZedr r orderr checksortvar1searcher r r searchdbs                   r1) mysql.connectorrrr%csvdatetimerrr1r r r r s