<commit_before><?xml version='1.0' encoding='UTF-8'?>
<module version="1.0">

  <filter-mapping>
    <filter-name>service</filter-name>
    <url-pattern>/blogs/*.html</url-pattern>
  </filter-mapping>

  <filter-mapping>
    <filter-name>auth-filter</filter-name>
    <url-pattern>/blogs/*.html</url-pattern>
  </filter-mapping>

  <entity-permission>
    <name>blog-create</name>
    <entity-type>blog</entity-type>
    <sql>
       select ACL.ID from ACL
       where ACL.ENTITY_TYPE = :entity_type
       and ACL.USER_ID = :user_id   
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-delete</name>
    <entity-type>blog</entity-type>
    <sql>
       select ACL.ID from ACL
       where ACL.ENTITY_TYPE = :entity_type
       and ACL.USER_ID = :user_id   
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-create-post</name>
    <entity-type>blog</entity-type>
    <sql>
       select ACL.ID from ACL
       where ACL.ENTITY_TYPE = :entity_type
       and ACL.USER_ID = :user_id
       and ACL.ENTITY_ID = :entity_id
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-update-post</name>
    <entity-type>blog</entity-type>
    <sql>
       select ACL.ID from BLOG_POST inner join ACL on ACL.ENTITY_ID = BLOG_POST.BLOG_ID
       where ACL.ENTITY_TYPE = :entity_type
       and ACL.USER_ID = :user_id
       and BLOG_POST.ID = :entity_id
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-delete-post</name>
    <entity-type>blog</entity-type>
    <sql>
       select ACL.ID from BLOG_POST inner join ACL on ACL.ENTITY_ID = BLOG_POST.BLOG_ID
       where ACL.ENTITY_TYPE = :entity_type
       and ACL.USER_ID = :user_id
       and BLOG_POST.ID = :entity_id
    </sql>
  </entity-permission>

</module><commit_msg>Use lower case for table and column names and upper case or SQL keywords<commit_after><?xml version='1.0' encoding='UTF-8'?>
<module version="1.0">

  <filter-mapping>
    <filter-name>service</filter-name>
    <url-pattern>/blogs/*.html</url-pattern>
  </filter-mapping>

  <filter-mapping>
    <filter-name>auth-filter</filter-name>
    <url-pattern>/blogs/*.html</url-pattern>
  </filter-mapping>

  <entity-permission>
    <name>blog-create</name>
    <entity-type>blog</entity-type>
    <sql>
       SELECT acl.id FROM acl
       WHERE acl.entity_type = :entity_type
       AND acl.user_id = :user_id   
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-delete</name>
    <entity-type>blog</entity-type>
    <sql>
       SELECT acl.id FROM acl
       WHERE acl.entity_type = :entity_type
       AND acl.user_id = :user_id   
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-create-post</name>
    <entity-type>blog</entity-type>
    <sql>
       SELECT acl.id FROM acl
       WHERE acl.entity_type = :entity_type
       AND acl.user_id = :user_id
       AND acl.entity_id = :entity_id
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-update-post</name>
    <entity-type>blog</entity-type>
    <sql>
       SELECT acl.id FROM blog_post INNER JOIN acl ON acl.entity_id = blog_post.blog_id
       WHERE acl.entity_type = :entity_type
       AND acl.user_id = :user_id
       AND blog_post.id = :entity_id
    </sql>
  </entity-permission>

  <entity-permission>
    <name>blog-delete-post</name>
    <entity-type>blog</entity-type>
    <sql>
       SELECT acl.id FROM blog_post INNER JOIN acl ON acl.entity_id = blog_post.blog_id
       WHERE acl.entity_type = :entity_type
       AND acl.user_id = :user_id
       AND blog_post.id = :entity_id
    </sql>
  </entity-permission>

</module>
{'fraction_non_alphanumeric': 0.13828915004099482, 'fraction_numerical': 0.002732987154960372, 'mean_word_length': 2.6673346693386772, 'pattern_counts': {'":': 0, '<': 113, '<?xml version=': 2, '>': 113, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, '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': '311028', 'n_tokens_mistral': 1340, 'n_tokens_neox': 1293, 'n_words': 242}