U
    Ƣf                     @   sL   d dl Zd dl mZ d dlZd dlZd dlZd dlmZ d dlZdd ZdS )    N)Error)datetimec              
   C   s  zt jjddddd}| }ttd}|d}t	| d}|
|| d	 f | }|st	d
| d}|
|t|  |  d}| |g t	|  |
|t|  |  W dS t	| d}	|
|	| d	 f |  d}
d}|
|t|  |  g }d}d}tt| D ]r}t	t|d | t| |  t|d | t| | krt	| |t|d | d t| |  d 7 }q| ||g t	|  |
|t|  |  W dS W n> tk
r } zt	dt|  td W 5 d }~X Y nX |  d S )Nz	127.0.0.1Zitransdb	itranswlcz1tr@nsb1rry)hostdatabaseuserpasswordzAsia/Taipeiz%Y-%m-%d %H:%M:%Su,   select * from drivers_info where 工號 = %s   1u   INSERT INTO drivers_info(姓名,所屬區域,聘用狀態,身分,工號,變動生效日期,資料修改人員) VALUES (%s,%s,%s,%s,%s,%s,%s)u   INSERT INTO drivers_info_hist(姓名,所屬區域,聘用狀態,身分,工號,變動生效日期,資料修改人員,資料修改時間) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)Tu*   DELETE FROM drivers_info where 工號 = %szselect * from drivers_info u   INSERT INTO drivers_info_hist(姓名,所屬區域,聘用狀態,身分,工號,變動生效日期,資料修改人員,資料修改時間,修改內容) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)r   z-->,z!Error connecting to the database:   )mysql	connectorconnectcursorr   nowpytztimezonestrftimeprintexecutefetchalltuplecommitextendrangelenstrr   sysexitclose)split
connectionr   datetodaysZaaZs3Zs4s2alistchanges1ie r.   '/home/mars/bis/apps/parsefile/update.pyupdatedb
   sd    

,
r0   )	Zmysql.connectorr   r   r   Zcsvtimer   r   r0   r.   r.   r.   r/   <module>   s   