
    RfC                     H    d dl Z d dlmZ d dlZd dlZd dlZd Zd Zd Zd Zy)    N)datetimec                 @   t        j                  t        |             }t        |      j                  d      d   }t        t        |      j                  d      d         dd  }t        t        |      j                  d      d   j                  d      d         }t        j                  |||      }t        t        |      j                  dd            }t        j                  dd	d
dd      }|j                         }d}| |||||dz   t        j                  t        j                  d            |	f}|j                  ||       |j                         d   }|
d   dk(  s|
d   dk(  rd}|j                  |||f       d|
v rd}|j                  |||f       d|
v r5d|
d   v r.|,d}|j                  |||f       d}|j                  |||f       d|
v rd}|j                  |||f       |j!                          |j#                          |j#                          y )Nz%20   Ar   D' cs2snipepostgresBerufsorientierung1!23.88.122.575432databaseuserpasswordhostportz INSERT INTO sniper_cs2snipe_found (skin, price, inspect_link, market_url, steamid, page, pub_date, foundskins_id_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) RETURNING idzEurope/Viennafilter_optionsexact_floatfloat_restrictionsz9UPDATE sniper_cs2snipe_found SET float = %s WHERE id = %spatternz;UPDATE sniper_cs2snipe_found SET pattern = %s WHERE id = %smore_filtersrankz8UPDATE sniper_cs2snipe_found SET rank = %s WHERE id = %sstickerpanelz<UPDATE sniper_cs2snipe_found SET stickers = %s WHERE id = %s)HelperFunctionsencodeItemNamestrsplitgenerateMarketLinkintreplacepsycopg2connectcursorr   nowpytztimezoneexecutefetchonecommitclose)full_item_name
floatvalue	paintseedinspect_linkpricepagestickertextr   steamidqueryidresult_jsonitem_encodedall_market_paramsm_parama_param
market_urlint_steamidconnr%   queryvalues
current_pks                         0/var/www/cs2snipeproduction/MarketBot/DBStuff.pyhandleDBInsertrB      s'    #11#n2EFLL)//6q9#'(..s3A67;G#'(..s3A6<<SA!DEG 33L'7SJc'l**334K'D [[]F }Ee\:wqRZR^R^_c_l_lm|_}R~  AH  IF
NN5&!"1%J 	$%6'(,@@Ouz:67KQuy*56$[00T5ERENN54"45SENN5:z":;$Ru{J78KKM
LLNJJL    c                 >   	 t        j                  ddddd      }|j                         }d}|j                  ||||| f       |j	                          |j                          |j                          y # t        $ r}t        t        |             Y d }~y d }~ww xY w)Nr
   r   r   r   r   r   zcUPDATE sniper_cs2snipe_queries SET query_failed = %s, message = %s, query_status = %s WHERE id = %s	r#   r$   r%   r)   r+   r,   	Exceptionprintr   )r5   query_failedquery_statusquery_messager=   r%   r>   es           rA   updateQueryrL   C   s    +
 yu|]L'RS

 c!fs   A2A5 5	B>BBc                 F   	 t        j                  ddddd      }|j                         }|dk(  rd}nd	}|j                  ||        |j	                          |j                          |j                          y # t        $ r}t        t        |             Y d }~y d }~ww xY w)
Nr
   r   r   r   r   r   pluszLUPDATE sniper_cs2snipe_users SET free_snipes = free_snipes + 1 WHERE id = %szLUPDATE sniper_cs2snipe_users SET free_snipes = free_snipes - 1 WHERE id = %srE   )r4   plus_or_minusr=   r%   r>   rK   s         rA   updateFreeSnipesrP   V   s    +
 F"fEfEuw(

 c!fs   A6A9 9	B BB c                 b   	 t        j                  ddddd      }|j                         }d}|j                  || |f       |j	                         d   }|j                          |j                          |j                          |S # t        $ r}t        t        |             Y d }~y d }~ww xY w)	Nr
   r   r   r   r   r   zWSELECT count(*) FROM sniper_cs2snipe_found WHERE foundskins_id_id = %s AND steamid = %sr   )
r#   r$   r%   r)   r*   r+   r,   rF   rG   r   )r5   r4   r=   r%   r>   countrK   s          rA   getResultCountrS   k   s    +
 muw01!!$

 c!fs   BB 	B.B))B.)	r#   r   r'   r   jsonrB   rL   rP   rS    rC   rA   <module>rV      s)        9x&*rC   