<commit_before><query-mapping package='AWA.Questions.Models'>
    <description>
      Detailed information about a question.
    </description>

    <class name="AWA.Questions.Models.Question_Display_Info" bean="yes">
        <comment>The list of questions.</comment>
        <property type='Identifier' name="id">
            <comment>the question identifier.</comment>
        </property>
        <property type='String' name="title">
            <comment>the question title.</comment>
        </property>
        <property type='Date' name="create_date">
            <comment>the question creation date.</comment>
        </property>
        <property type='Date' name="edit_date">
            <comment>the question edit date.</comment>
        </property>
        <property type='String' name="description">
            <comment>the question description.</comment>
        </property>
        <property type='String' name="rating">
            <comment>the question rating.</comment>
        </property>
        <property type='Identifier' name="author_id">
            <comment>the author's identifier.</comment>
        </property>
        <property type='String' name="author_name">
            <comment>the author's name.</comment>
        </property>
        <property type='String' name="author_email">
            <comment>the author's email.</comment>
        </property>
    </class>

    <query name='question-info'>
       <comment>Get the detailed information for a question.</comment>
       <sql>
    SELECT
      q.id,
      q.title,
      q.create_date,
      q.edit_date,
      q.description,
      q.rating,
      q.author_id,
      user.name,
      email.email
    FROM awa_question AS q
    INNER JOIN awa_user AS user ON q.author_id = user.id
    INNER JOIN awa_email AS email ON q.author_id = email.user_id<commit_msg>Get the question rating from the rating table<commit_after><query-mapping package='AWA.Questions.Models'>
    <description>
      Detailed information about a question.
    </description>

    <class name="AWA.Questions.Models.Question_Display_Info" bean="yes">
        <comment>The list of questions.</comment>
        <property type='Identifier' name="id">
            <comment>the question identifier.</comment>
        </property>
        <property type='String' name="title">
            <comment>the question title.</comment>
        </property>
        <property type='Date' name="create_date">
            <comment>the question creation date.</comment>
        </property>
        <property type='Date' name="edit_date">
            <comment>the question edit date.</comment>
        </property>
        <property type='String' name="description">
            <comment>the question description.</comment>
        </property>
        <property type='Integer' name="rating">
            <comment>the question rating.</comment>
        </property>
        <property type='Identifier' name="author_id">
            <comment>the author's identifier.</comment>
        </property>
        <property type='String' name="author_name">
            <comment>the author's name.</comment>
        </property>
        <property type='String' name="author_email">
            <comment>the author's email.</comment>
        </property>
    </class>

    <query name='question-info'>
       <comment>Get the detailed information for a question.</comment>
       <sql>
    SELECT
      q.id,
      q.title,
      q.create_date,
      q.edit_date,
      q.description,
      r.rating,
      q.author_id,
      user.name,
      email.email
    FROM awa_question AS q
    INNER JOIN awa_user AS user ON q.author_id = user.id
    INNER JOIN awa_email AS email ON q.author_id = email.user_id
    LEFT JOIN awa_rating AS r ON r.for_entity_id = q.id AND r.for_entity_type = :entity_type
{'fraction_non_alphanumeric': 0.1221814368117462, 'fraction_numerical': 0.0, 'mean_word_length': 2.3880994671403197, 'pattern_counts': {'":': 0, '<': 97, '<?xml version=': 0, '>': 97, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4432476', 'n_tokens_mistral': 1047, 'n_tokens_neox': 1017, 'n_words': 261}