<?xml version=“1.0” encoding=“UTF-8”?> <!DOCTYPE hibernate-mapping PUBLIC “-//Hibernate/Hibernate Mapping DTD 3.0//EN”

"http://hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

{{# sheet_arr}}

    <query name="{{table_name}}">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = 0 ORDER BY e.utime DESC]]>
    </query>
    <query name="{{table_name}}-id">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = 0 and e.id = :id ORDER BY e.utime DESC]]>
    </query>
    <query name="{{table_name}}-cuser">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = 0 and e.cuser = :cuser ORDER BY e.utime DESC]]>
    </query>
    <query name="{{table_name}}-uuser">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = 0 and e.uuser = :uuser ORDER BY e.utime DESC]]>
    </query>
    <query name="{{table_name}}-deleted">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = :deleted ORDER BY e.utime DESC]]>
    </query>
{{# rows_model}}
    {{# is_column}}
            {{# is_string}}
<query name="{{table_name}}-{{name}}">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = 0 and e.{{name}} LIKE :{{name}} ORDER BY e.id]]>
    </query>
                    {{/is_string}}
                    {{^ is_string}}
<query name="{{table_name}}-{{name}}">
      <![CDATA[FROM {{model_name}} e WHERE e.deleted = 0 and e.{{name}} = :{{name}} ORDER BY e.utime DESC]]>
    </query>
                    {{/is_string}}
            {{/is_column}}
{{/ rows_model}}

{{/ sheet_arr}} </hibernate-mapping>