from connector_neo4j import get_session

pending_social_query = """
    MATCH (p:Participant {chartmetricId: $account_id})-[r:HAS_SOCIAL_ACCOUNT]->(psa:PendingSocialAccount {identityId: $identity_id})
    RETURN
        psa
"""


def get_pending_social_accounts(account_id, identity_id):
    """Get any pending social media account info for provided account_id and identity.

    Args:
        account_id (str): account id
        identity_id (str): identity id

    Returns:
        iterable of dicts containing "platform" and "url" fields, if found.
    """

    session = get_session()
    result = session.run(pending_social_query, account_id=int(account_id), identity_id=identity_id)
    return [{
        'url': x['psa']['url'],
        'platform': x['psa']['platform']
    } for x in result]