hddlZddlmZddlZddlZddlmZiZded<ded<ded <d ed <d ed <GddZdS)N)Error)datetime localhostdb_hostsitedb_nameroot db_username db_passwordi db_portcleZdZdZdZdZdZdZdZdZ dd Z dd Z d Z ddZ dZddZddZd S)EasySQLcd|_d|_d|_d|_|j|_d|_tj|jtj dS)NTzlog/EasySQL.logzEasySQL Error -> )filenamelevel) db_conn db_cursor enable_loglog_filedefault_error_functionerror_function e_msg_startlogging basicConfigERRORselfs 4C:\xampp\htdocs\dev\Site\Backend\api\core\EasySQL.py__init__zEasySQL.__init__sQ ) "9.T]'-HHHHHHc|j|z}|jr?tjd}t j|d|||dS)Nz%d/%m/%Y %H:%M:%Sz -> )rrrnowstrftimererrorr)rmsgfull_msg timestamps r throw_errorzEasySQL.throw_errorsk#c) ? 8 //0CDDI MY66H66 7 7 7 H%%%%%r!c*td|dS)NzDEFAULTS :) => )print)rr&s rrzEasySQL.default_error_function%s %%%&&&&&r!ctd|_td|_td|_td|_td|_dS)Nrrr r r T)paramsrrr r r rs rdb_initzEasySQL.db_init(sEi( i( !-0!-0i( tr!cF tj|j|j|j|j|j|_|j d|_ dS#t$r0}| dt|Yd}~dSd}~wwxYw)N)hostuserpassworddatabaseportT) dictionaryzDB Connection Error : F)mysql connectorconnectrr r rr rcursorrrr)str)res r db_connectzEasySQL.db_connect0s  ?22\%)\ 3DL"\00D0AADN4      >c!ff>> ? ? ?55555 sA"A&& B 0%BB ct|trdSt|trdSt|trdSdS)Nidsb) isinstanceintfloatr:)rvalues r get_bind_typezEasySQL.get_bind_type?sL eS ! ! 3 u % % 3 s # # 33r!c4tjd|r|ndS)Nz^[a-zA-Z0-9_]+$F)rematch)rstrings rsanitise_stringzEasySQL.sanitise_stringIs"4f==Hvv5Hr!r c|sdSt|tr||Sdd|DS)N*, cg|]}d|d S)`).0cols r z)EasySQL.build_columns..Rs <<3  % % >''00 099<.asGGGcS\GGGr!c3 K|]}|vV dS)NrQ)rRrSvalids r z+EasySQL.validate_columns..fs'55se|555555r!zvalidate_columns error: F) rexecutefetchallrBdictlistkeysall Exceptionr)r:)r table_namerVcheckr;ris @rvalidate_columnszEasySQL.validate_columns^s  N " "#F#F#F#F G G GGGT^-D-D-F-FGGGE'4(( W\\^^,,5555u55555 5      @A@@ A A A55555 sBB C"%C  CNcx||}|s|ddS|r |dks|dgkrg}d}nZt|tr|g}|||s|ddS||}d|d|}g}|r!|||\}}|d|z } |j|||j S#t$r0} |d t| Yd} ~ dSd} ~ wwxYw) NInvalid table nameFr rMzColumn Name ErrorzSELECT z FROM  WHERE zStatement Execution Failure: ) rKr)rBr:rtrWrcrrkrlrq) rrrrVr^r_col_strsqlr-cond_strr;s rselectzEasySQL.selectks))*55     1 2 2 25 2'R--7rd??GGG'3'' $")((W==   !4555u((11G333z33  (#44ZLL Hf 'X'' 'C  N " "3 / / />**,, ,      ESVVEE F F F55555 s 3C?? D9 %D44D9cf||}|r|||s|ddSd|}ddgt |z}t |}d|d|d|d} |j |||j d S#t$r0}|d t|Yd}~dSd}~wwxYw) NInvalid table or column nameFrNz%sz INSERT INTO z (z ) VALUES ()TzInsert Serious Error: )rKrtr)rUrolenrnrarrkrcommitrqr:)rrrdataro placeholdersraryr;s rinsertzEasySQL.inserts?))*55  !6!6z4!H!H    ; < < <5yy%%yy$#d))!344 dkkmm$$JZJJ4JJ<JJJ  N " "3 / / / L   ! ! !4      >c!ff>> ? ? ?55555 s4C66 D0%D++D0cT||}|r|||s|ddSdd|D}t |}|||\}}d|d|d|} |j| ||z|j |jj S#t$r0} |dt| Yd} ~ dSd} ~ wwxYw) Nr}FrNcg|]}|dS)rZrQ)rRks rrTz"EasySQL.update..s:::1 :::r!zUPDATE z SET rwzUpdate Serious Error: )rKrtr)rUrnrarcrrkrrrowcountrqr:) rrrrr^r_ set_clausera cond_clause cond_valuesryr;s rupdatezEasySQL.updatesJ))*55  !6!6z4!H!H    ; < < <5YY::T:::;; dkkmm$$#'#8#8Z#P#P [I IIIIKII  N " "3(< = = = L   ! ! !>* *      >c!ff>> ? ? ?55555 s*AC-- D'7%D""D'c||}|s|ddS|||s|ddS|||\}}d|d|} |j|||j|jjS#t$r0}|dt|Yd}~dSd}~wwxYw)NrvFz$Invalid column name(s) in conditionsz DELETE FROM rwzDelete Serious Error: ) rKr)rtrcrrkrrrrqr:)rrrr^r_rrryr;s rdeletezEasySQL.deletes#))*55     1 2 2 25$$Z<<    C D D D5#'#8#8Z#P#P [=Z== ==  N " "3 4 4 4 L   ! ! !>* *      >c!ff>> ? ? ?55555 s>?B>> C8%C33C8)r )rX)r NrX)__name__ __module__ __qualname__r r)rr.r<rFrKrWrcrtr{rrrrQr!rrrsIII&&&'''   III>>>>>>>>       D&(r!r)mysql.connectorr6rrHrrr-rrQr!rrs !!!!!!  yy}}yttttttttttr!