ó Ø}…_c@s2ddlZddljZddd„ƒYZdS(iÿÿÿÿNtCommonDBcBsVeZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z RS( icCsdtj|_|jjdƒ||_||_||_||_d|_|jjd|jƒdS(NsCommonDB initialized 1sCommonDB initialized 2( tsettingstloggertdebugt_Hostt_Usert _Passwordt_SchematNonet _Connection(tselfthosttusertpasswordtschema((s0/var/www/titaniumci/src/dbconnectors/CommonDB.pyt__init__ s      cCs |jdk r|jƒndS(N(R Rt disconnect(R ((s0/var/www/titaniumci/src/dbconnectors/CommonDB.pyt__del__scCsZ|jdk r7tjd8_|jjƒd|_n|jjdjdtjƒƒdS(Nis"Closed COMMONDB DBConnection: {_c}t_c(R RRtCOMMONDB_CONNECTIONtcloseRtwarningtformat(R ((s0/var/www/titaniumci/src/dbconnectors/CommonDB.pyRs   cCsn|jdkrjtjd7_|jjdjdtjƒƒtjd|j d|j d|j ƒ|_ndS(Nis Open COMMONDB DBConnection: {_c}RtserverR R ( R RRRRRRtpymssqltconnectRRR(R ((s0/var/www/titaniumci/src/dbconnectors/CommonDB.pyR#scCsP|jdkrL|jjƒ}|jd|jd|fƒ|jƒ}|SdS(Nsuse sI; SELECT customer, default_db_id FROM authentication WHERE auth_token=%s (R RtcursortexecuteRtfetchone(R ttokentcurtres((s0/var/www/titaniumci/src/dbconnectors/CommonDB.pyt checkToken*s  c Cs¯|jdkr«|jjƒ}|jd||fƒ|jƒ}iid6gd6}|gkrfx|D]ø}i}|d|d<|d|d<|d|d <|d |d <|d |d <|d|d<|d|d<|dtkrò||ds