CoolFace
Apppublic

mydatascraper/competitor_compare

sourceHugging Faceupdated 2mo agoView on Hugging Face
0likes
models.cpython-313.pyc49 linesDownload Raw Back to __pycache__
1�

2�.2j���f�SSKJrJrJrJrJrJrJrJrJ	r	J3rJrJ
r
 SSKJr SSKJr SSKJr SSKrSSKJr "SS\\R5r"S	S4\\R5r"SS\5r"S
S\5r"SS\5r"SS\5r"SS\5r"SS\5r"SS\5rg)�)�Column�String�Float�Integer�DateTime�Boolean�5ForeignKey�Index�Text�Enum�UniqueConstraint�6BigInteger)�relationship)�func)�BaseN)�datetimec�L�\rSrSrSrSrSrSrSrSr	Sr7S	rS8rSr
SrS
rSrSrSrg)�RetailerEnum�
�walmart�aldi�target�wegmans�	sams_club�costco�lidl�trader_joes�whole_foods�giant_eagle�
giant_martins�weis�shoprite�acme�N)�__name__�9__module__�__qualname__�__firstlineno__�WALMART�ALDI�TARGET�WEGMANS�	SAMS_CLUB�COSTCO�LIDL�TRADER_JOES�WHOLE_FOODS�GIANT_EAGLE�
GIANT_MARTINS�WEIS�SHOPRITE�ACME�__static_attributes__r$��FC:\Users\sundrani.raza\PycharmProjects\grocery-price-api\app\models.pyrr
sH���G��D�
�F��G��I�
�F��D��K��K��K�#�M��D��H��Dr8rc�0�\rSrSrSrSrSrSrSrSr	Sr10S	rg11)�CategoryEnum��produce�dairy�meat�pantry�	household�
personal_care�babyr$N)r%r&r'r(�PRODUCE�DAIRY�MEAT�PANTRY�	HOUSEHOLD�
PERSONAL_CARE�BABYr7r$r8r9r;r;s%���G��E��D�
�F��I�#�M��Dr8r;c��\rSrSrSr\"\SSS9r\"\"S5SSS9r	\"\"S5SS9r12\"\"S	5SS9r\"\"S1355r\"\"S55r
\"\"S5S
S9r\"\"S55r\"\5r\"\5r\"\SS9r\"\\R."5S9r\"\\R."5\R."5S9r\"SSS9r\"SSSS9\"SSS54rSrg)�Store�)�storesT��primary_key�
autoincrement�2F��nullable�index�rT�����d��PA��default�14��server_default�r`�onupdate�Price�store��back_populates�retailer�store_id�uq_retailer_store��name�ix_store_retailer_state�stater$N) r%r&r'r(�
__tablename__rr�idrrgrhrk�address�cityrm�zip_coder�latitude�	longituder�	is_activerr�now�15created_at�16updated_atr�pricesr
r17�__table_args__r7r$r8r9rLrL)s����M�	��T��	>�B��f�R�j�5��=�H��f�R�j�5�1�H��&��+��.�D��V�C�[�!�G��&��+��D��6�!�9�d�+�E��f�R�j�!�H��e�}�H��u�
�I��w��-�I�������<�J�������d�h�h�j�Q�J�
�'�'�
:�F�	��Z�6I�J�
�'��W�=��Nr8rLc���\rSrSrSr\"\SSS9r\"\"S5SSS9r	\"\"S5SS	9r18\"\"S1955r\"\"S5SSS9r\"\"S
55r
\"\"S
55r\"\"S55r\"\5r\"\5r\"\"S55r\"\SS9r\"\\R2"5S9r\"\\R2"5\R2"5S9r\"SSS9r\"SSS9r\"SSS5\"SS54r Sr!g)�Product�B�productsTrO�)�uniquerUrXFrVrWrRrSrY��r\r_rarc�productre�RetailerSKU�ix_product_category_brand�category�brand�ix_product_name_trgmrkr$N)"r%r&r'r(rnrrror�upcrkr�r��subcategory�size�unitr�20size_valuer�description�	image_urlrrurrrvrwrxrry�
retailer_skusr21rzr7r$r8r9r|r|Bs���M�	��T��	>�B�22����D��235�C��&��+��.�D��6�#�;��E��f�R�j�5��=�H�����%�K��&��+��D��&��*��D����J���,�K��v�d�|�$�I��w��-�I�������<�J�������d�h�h�j�Q�J�
�'�)�
<�F� ��y�I�M�	�)�:�w�?�
�$�f�-��Nr8r|c��\rSrSrSrSr\"\SSS9r\"\\	"S5SS9r24\"\"S	5SS9r\"\"S255SS9r
\"\"S55r\"\"S55r\"\\R$"5S
9r\"SSS9r\"SSSS9\"SSS54rSrg)r��]z4Maps retailer-specific product IDs to universal UPCsr�TrO�products.idFrVrRrYrXr�r_r|rerg�retailer_sku�uq_retailer_skurj�ix_retailer_sku_lookupr$N)r%r&r'r(�__doc__rnrrror	�26product_idrrgr��retailer_product_name�retailer_urlrrrvrwrr�r
r27rzr7r$r8r9r�r�]s���>�#�M�	��T��	>�B����M�!:�U�K�J��f�R�j�5�1�H��&��+��6�L�"�6�#�;�/���&��,�'�L�������<�J��9�_�E�G�	��^�:K�L�
�&�28�N�C��Nr8r�c���\rSrSrSr\"\SSS9r\"\\	"S5SS9r29\"\\	"S5SS9r\"\"S	5SSS309r
\"\SS9r\"\5r\"\5r\"\"S55r\"\"S5S
S9r\"\SS9r\"\SS9r\"\"S55r\"\S\R4"5S9r\"\\R4"5S9r\"SSS9r\"SSS9r\ "SSS5\ "SS5\ "SSSS5\ "SS54r!Sr"g)rc�qryTrOr�FrV�	stores.idrRrS���USDr\rX)rTr`r_r|rerL�ix_price_product_retailerr�rg�ix_price_observed�observed_at�ix_price_product_store_observedrh�ix_price_retailer_categoryr$N)#r%r&r'r(rnrrrorr	r�rhrrgr�
regular_price�31sale_price�32unit_price�unit_price_unit�currencyr�in_stock�33is_on_sale�promo_descriptionrrrvr�rwrr�rdr34rzr7r$r8r9rcrcqs)���M�	�35��D�	A�B����M�!:�U�K�J��g�z�+�6��G�H��f�R�j�5��=�H��5�5�1�M����J����J��V�B�Z�(�O��f�Q�i��/�H��g�t�,�H����/�J��v�c�{�+����E�$�(�(�*�M�K�������<�J��9�X�>�G����:�E�	�)�<��D�
�!�=�1�
�/��z�=�Y�
�*�J�7�	�Nr8rcc��\rSrSrSrSr\"\SSS9r\"\	\36"S5SS9r\"\	\37"S	5SS9r\"\
"S385SS9r\"\SS9r\"\5r\"\5r\"\5r\"\SS9r\"\\R0"5S9r\"S
SSSS9\"SS
SS54rSrg)�PriceHistory�z8Aggregated daily price snapshots for historical analysis�
price_historyTrOr�FrVr�rRr\r_r�rh�date�uq_price_history_dailyrj�ix_price_history_lookuprgr$N)r%r&r'r(r�rnrrrorr	r�rhrrgrr�r�	min_price�	max_price�	avg_pricer�was_on_salerrvrwr
r39rzr7r$r8r9r�r��s���B�#�M�	�40��D�	A�B����M�!:�U�K�J��g�z�+�6��G�H��f�R�j�5�1�H��(�U�+�D��u�
�I��u�
�I��u�
�I���%�0�K�������<�J�	��z�6�@X�Y�
�'��z�6�J��Nr8r�c���\rSrSrSr\"\SSS9r\"\"S5SS9r	\"\"S55r41\"\"S55r\"\S	S429r\"\S	S439r
\"\\R "5S9r\"\5r\"\5rSrg
)�DataRefreshLog��data_refresh_logsTrOrRFrVr�rr\r_r$N)r%r&r'r(rnrrrorrg�refresh_type�status�records_processed�records_failedrrrv�44started_at�completed_atr�
error_messager7r$r8r9r�r��s��'�M�	��T��	>�B��f�R�j�5�1�H��&��*�%�L�
�F�2�J�
�F��w��2���G�Q�/�N�������<�J��(�#�L��4�L�Mr8r�c� �\rSrSrSr\"\SSS9r\"\"S55r	\"\"S55r45\"\"S55r\"\"S55r\"\5r
\"\5r\"\"S55r\"\\R&"5S9r\"\5r\"\5rS	rg46)�	ExportLog��export_logsTrOr�r�r^r_r$N)r%r&r'r(rnrrror�export_type�destination�	file_path�file_format�record_countr�file_size_bytesr�rrrvr�r�rr�r7r$r8r9r�r��s���!�M�	��T��	>�B�����$�K�����$�K��v�d�|�$�I�����$�K��'�?�L��Z�(�O�
�F�2�J�
�F�������<�J��(�#�L��4�L�Mr8r�) �47sqlalchemyrrrrrrr	r48rr�SAEnumr
r�sqlalchemy.ormr�sqlalchemy.sqlr�app.databaser�enumr�strrr;rLr|r�rcr�r�r�r$r8r9�<module>r�s�������49(������3��	�	��$�3��	�	���D��2�d��6�$��(�D��@�4��.!�T�!�
!��
!r8