a
     ld                     @   s   d dl mZ d dlmZ d dlmZ d dlmZ d dlm	Z	 d dl
mZ d dlmZ d dlmZ d d	lmZ d d
lmZ d dlmZ d dlmZ e dddZdS )    )Subquery)
celery_app)Company)AngiCrawler)
BBBCrawler)CheckatradeCrawler)GoogleMapCrawler)FacebookCrawler)HomeAdvisorCrawler)TrustpilotCrawler)YelpCrawler)ReviewSourceNFc                 C   s  t jj| d}|j}|j dkrBt|j t }||| n\|j dkrpt|j t	 }||| n.|j dkrt|j t
 }||| n |j dkrt|j t }||| n|j dkrt|j t }||| n|j dkr$t|j t }||| nz|j dkrVt|j t }||||| nH|j d	krt|j t }|| nt|j t jj|_|  |jj}tjj|djttjj|d d
d d ttjj|d dd d d d S )N)idZyelpztrustpilot.comZcheckatradeZhomeadvisorZangibbbfacebookZgooglecal_average_rating   cal_reviews_count)average_ratingreviews_count)r   objectsgetplatformnamelowerprintr   sync_reviewsr   r   r
   r   r   r	   r   
SyncStatusNOT_SYNCsync_statussavecompanyr   r   filterupdater   with_avg_ratingvalueswith_reviews_count)Zreview_source_idaccess_tokenpage_idis_addreview_sourcer   crawler
company_id r-   I/var/www/html/Ranjet/backend/verify_trusted/reviews/tasks/sync_reviews.pysync_reviews_task   s\    









r/   )NNF)django.db.modelsr   configr   verify_trusted.companies.modelsr   Z$verify_trusted.crawlers.angi.crawlerr   Z#verify_trusted.crawlers.bbb.crawlerr   Z+verify_trusted.crawlers.checkatrade.crawlerr   )verify_trusted.crawlers.googlemap.crawlerr   (verify_trusted.crawlers.facebook.crawlerr	   Z+verify_trusted.crawlers.homeadvisor.crawlerr
   Z*verify_trusted.crawlers.trustpilot.crawlerr   Z$verify_trusted.crawlers.yelp.crawlerr   verify_trusted.reviews.modelsr   taskr/   r-   r-   r-   r.   <module>   s   