"""Fetch OA automation user id and VAPI token."""

from qa_testing_utils.lib import qa_mysql_db


def fetch_creds():
    """Fetch OA Vector API credentials."""
    query = """SELECT oauth_token, client_id, user_id
               FROM vectorapi_access_tokens t INNER JOIN orchadmin_users u
               ON t.user_id = u.id
               WHERE u.login='automation_qa'
               AND t.user_type='oa'"""
    return qa_mysql_db.execute_query(query)


def main():
    """Fetch OA Vector API credentials and print them."""
    vapi_token, client_id, user_id = fetch_creds()
    print(f'VAPI_TOKEN={vapi_token}')
    print(f'OA_USER_ID={user_id}')
    print(f'CLIENT_ID={client_id}')