import json
from bulkperformancerights.connectors import mysql
from bulkperformancerights.models import track


def tracks_line_json(user_type, user_id):
    """Tracks outputted as line delimited JSON

    Args:
        user_type (str): type of user
        user_id (int):   identifier of user

    Return:
        (tuple) ((str): line delimited json of user's track data,
                 (int): number of rows)
    """
    session = mysql.art_relations_session()
    sql_result = track.tracks_for_template(session, user_type, user_id)
    json_list = []
    for row in sql_result:
        json_line = json.dumps(dict(row), ensure_ascii=False)
        json_list.append(str(json_line))
    session.close()
    if not json_list:
        return None
    return ('\n'.join(json_list), len(json_list))