mydatascraper/competitor_compare
0
1�
2 _/2j� � �. � S SK JrJrJr S SKJr S SKJrJr S SK J3r4 S SK J r S SK
Jr S SKJrJr S SKJrJr \" S S5/S 9r\R- S \\ S
9\" S5 \" S5 \" S5 \" \65 \" \ 5 4S\\ S\\ S\\ S\S\47S jj5 rg)� )� APIRouter�Depends�Query)� AsyncSession)�select�func)�get_db)�verify_api_key)�Store)�
StoreResponse�RetailerFilter)�Optional�Listz/stores�Stores)�prefix�tags�/)�response_modelN�retailer�city�zip_code�db�_api_keyc � �` # � [ [ 5 R [ R S:H 5 nU ( a, UR [ R U R8 :H 5 nU( a2 UR [ R R SU S35 5 nU( a" UR [ R U:H 5 nUR [ R [ R 5 nUR U5 I Sh v�N nUR 5 R 5 $ N"7f)zEList all tracked stores, optionally filtered by retailer or location.T�%N)
r r �where� is_activer �valuer �iliker �order_by�execute�scalars�all)r r r r r �stmt�results �NC:\Users\sundrani.raza\PycharmProjects\grocery-price-api\app\routers\stores.py� list_storesr'
s� � � � �%�=� � �u���$� 6� 7�D���z�z�%�.�.�H�N�N�:�;�� ��z�z�%�*�*�*�*�Q�t�f�A�;�7�8����z�z�%�.�.�H�4�5�� �=�=�� � ���� 4�D��:�:�d�#�
#�F� �>�>� � � � !�!� $�s �DD.� D,�9#D.)�fastapir r r �sqlalchemy.ext.asyncior �10sqlalchemyr r � app.databaser �app.authr11 �12app.modelsr � app.schemasr r
�typingr r �router�get�str�dictr' � � r& �<module>r6 s� �� -� -� /� #� � #� � 5� !� �)�8�*� 5�� ���C��]� 3��4�).�t�� ��+� #�D�k� �v�� �^�,� "��~�&�"�13�3�-�"� �s�m�"� � "�14 � "� 5�"r5