wamblee.org Git - utils/blob - security/impl/src/main/resources/hbm/User.hbm.xml

   1 <?xml version="1.0"?>
   2 <!DOCTYPE hibernate-mapping PUBLIC
   3     "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
   4     "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
   5
   6 <hibernate-mapping>
   7
   8
   9     <class name="org.wamblee.usermgt.User" table="USERS" select-before-update="true">
  10         <id name="primaryKey" column="ID" type="long">
  11             <generator class="native"/>
  12         </id>
  13         <version name="persistedVersion" column="VERSION"/>
  14         <property name="name" column="NAME" unique="true"/>
  15         <property name="passwordString" column="PASSWORD"/>
  16         <set name="groupSet" table="USER_GROUPS" lazy="false">
  17             <key column="USER_ID"/>
  18             <many-to-many class="org.wamblee.usermgt.Group" column="GROUP_ID"/>
  19         </set>
  20     </class>
  21
  22     <query name="findUserByName">
  23         from org.wamblee.usermgt.User user where user.name = :name
  24     </query>
  25
  26     <query name="findUserByGroupName">
  27       select user
  28           from org.wamblee.usermgt.User user
  29             join user.groupSet grp
  30             where grp.name = :name
  31     </query>
  32
  33     <query name="countUsers">
  34         select count(*)
  35         from org.wamblee.usermgt.User user
  36     </query>
  37
  38
  39 </hibernate-mapping>