other_tools.cpython-311.pyc•5.43 kB
�
��[h� � � � d Z ddlmZmZmZ ddlmZmZ ddlm Z de
dee
ee
f fd�Z de
dee
ef fd �Z de
dee
ef fd
�Z
d S ) z*
Chess.com titled players and club tools.
� )�Dict�Any�List)�make_api_request�
get_cache_ttl)�db�title�returnc � �p K � g d�}| |vrddd� |� � � �iS d| � �}t d� � } t ||�� � � d{V ��}|� d g � � }t j d
| t
|� � |d �� � |S # t $ r }g t |� � d �cY d}~S d}~ww xY w)
z�
Get a list of titled players from Chess.com.
Args:
title: Chess title (GM, WGM, IM, WIM, FM, WFM, NM, WNM, CM, WCM)
Returns:
Dictionary with 'players' list containing usernames
)
�GM�WGM�IM�WIM�FM�WFM�NM�WNM�CM�WCM�errorz Invalid title. Must be one of: z, ztitled/�titled_players�� cache_ttlN�playersa-
INSERT INTO titled_players_snapshot
(title, player_count, players_list, snapshot_date)
VALUES ($title, $count, $players, CURRENT_DATE)
ON CONFLICT (title, snapshot_date) DO UPDATE
SET player_count = $count, players_list = $players
)r �countr )r r ) �joinr r �getr �execute�len� Exception�str)r � valid_titles�endpointr �datar �es �+/home/yori/chess-mxcp/python/other_tools.py�get_titled_playersr' s � � � � U�T�T�L� �L� � ��T�4�9�9�\�;R�;R�T�T�U�U� �� � �H� � .�/�/�I�0�%�h�)�D�D�D�D�D�D�D�D�D�� �(�(�9�b�)�)��
�
� � ���\�\� �
�
�
�
�
� � �� � 0� 0� 0� ��A���/�/�/�/�/�/�/�/�����0���s �AB �
B5�B0�*B5�0B5�url_idc � �: K � d| � �}t d� � } t ||�� � � d{V ��}t j d| |� dd� � |� dd � � d
�� � |S # t
$ r }d d t
|� � � �icY d}~S d}~ww xY w)
z�
Get information about a club on Chess.com.
Args:
url_id: The URL identifier of the club
Returns:
Club profile data including name, description, members count, etc.
�club/� club_infor Nz�
INSERT INTO club_statistics
(club_id, club_name, member_count, checked_at)
VALUES ($id, $name, $members, CURRENT_TIMESTAMP)
�name� �
members_countr )�idr, �membersr z Failed to fetch club profile: )r r r r r r r! )r( r# r r$ r% s r& �get_club_profiler1 0 s� � � � � �v� � �H� �k�*�*�I�D�%�h�)�D�D�D�D�D�D�D�D�D�� �
� �
��H�H�V�R�(�(��x�x���3�3�
�
� � � � � �� � D� D� D��B�#�a�&�&�B�B�C�C�C�C�C�C�C�����D���s �AA2 �2
B�<B�B�Bc � � K � d| � d�}t d� � } t ||�� � � d{V ��}t � � }dD ]7}|� |g � � }|� d� |D � � � � �8t j d| t |� � t |� � d �� � |S # t $ r }d
d t |� � � �icY d}~S d}~ww xY w) z�
Get members of a club on Chess.com.
Args:
url_id: The URL identifier of the club
Returns:
Dictionary with lists of members by type (weekly, monthly, all_time)
r* z/membersr+ r N)�weekly�monthly�all_timec 3 �P K � | ]!}t |t � � �|d V � �"dS )�usernameN)�
isinstance�dict)�.0�members r& � <genexpr>z#get_club_members.<locals>.<genexpr>d s8 � � � � d� d�f�:�V\�^b�Kc�Kc� d�v�j� 1� d� d� d� d� d� d� a,
INSERT INTO club_member_snapshots
(club_id, member_count, members_list, snapshot_date)
VALUES ($id, $count, $members, CURRENT_DATE)
ON CONFLICT (club_id, snapshot_date) DO UPDATE
SET member_count = $count, members_list = $members
)r/ r r0 r z Failed to fetch club members: ) r r �setr �updater r r �listr r! )r( r# r r$ � all_members� member_typer0 r% s r& �get_club_membersrC P s5 � � � � (�v�'�'�'�H� �k�*�*�I�D�%�h�)�D�D�D�D�D�D�D�D�D�� �e�e� �<� e� e�K��h�h�{�B�/�/�G� � � � d� d�� d� d� d� d� d� d� d�
�
� � ���%�%��K�(�(�
�
�
�
�
� � �� � D� D� D��B�#�a�&�&�B�B�C�C�C�C�C�C�C�����D���s �BB- �-
C�7C�
C�CN)�__doc__�typingr r r � chess_clientr r � mxcp.runtimer r! r' r1 rC � r= r& �<module>rI s� ��� � #� "� "� "� "� "� "� "� "� "� 8� 8� 8� 8� 8� 8� 8� 8� � � � � � �$0�C� $0�D��d�3�i� �,@� $0� $0� $0� $0�N D�3� D�4��S��>� D� D� D� D�@$D�3� $D�4��S��>� $D� $D� $D� $D� $D� $Dr=