<hibernate-configuration>
        <session-factory>
            <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
            <property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
            <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/animal-clinic</property>
            <property name="hibernate.connection.username">postgres</property>
            <property name="hibernate.connection.password">48iobrhqd5</property>

            <property name="hibernate.connection.provider_class">org.hibernate.c3p0.internal.C3P0ConnectionProvider</property>
            <property name="hibernate.c3p0.min_size">7</property>
            <property name="hibernate.c3p0.max_size">53</property>
            <property name="hibernate.c3p0.timeout">100</property>
            <property name="hibernate.c3p0.max_statements">50</property>
            <property name="hibernate.c3p0.idle_test_period">1000</property>
            <property name="hibernate.c3p0.validate">true</property>

            <!-- List of XML mapping files -->
            <mapping resource="ru/lesson/models/users/Role.hbm.xml"/>
            <mapping resource="ru/lesson/models/users/User.hbm.xml"/>
            <mapping resource="ru/lesson/models/users/Message.hbm.xml"/>
        </session-factory>
    </hibernate-configuration>

<hibernate-mapping>
<class name="ru.lesson.models.users.User" table="users">
    <meta attribute="class-description">
        This class contains the user detail.
    </meta>
    <id name="id" type="int" column="uid">
        <generator class="identity"/>
    </id>
    <property name="login" column="login" type="string"/>
    <property name="email" column="email" type="string"/>
    <property name="password" column="password" type="string"/>
    <property name="name" column="name" type="string"/>
    <property name="surname" column="surname" type="string"/>
    <property name="fullname" column="fullname" type="string"/>
    <property name="sex" column="sex" type="string"/>
    <property name="phone_number" column="phone_number" type="string"/>
    <property name="city" column="city" type="string"/>
    <many-to-one name="role" lazy="false" column="role_id" class="ru.lesson.models.users.Role" cascade="save-update"/>
    <bag name="messages" table="messages" lazy="false" inverse="true" cascade="all">
        <key column="user_id"/>
        <one-to-many class="ru.lesson.models.users.Message"/>
    </bag>
</class>
</hibernate-mapping>

<hibernate-mapping>
    <class name="ru.lesson.models.users.Message" table="messages">
        <meta attribute="class-description">
            This class contains the message of user.
        </meta>
        <id name="id" type="int" column="uid">
            <generator class="identity"/>
        </id>
        <many-to-one name="user" column="user_id" class="ru.lesson.models.users.User" cascade="all" insert="false" update="false"/>
        <many-to-one name="sender" column="sender_id" class="ru.lesson.models.users.User" cascade="all" insert="false" update="false"/>
        <property name="text" column="text" type="string"/>
    </class>
</hibernate-mapping>

<hibernate-mapping>
    <class name="ru.lesson.models.users.Role" table="roles">
        <meta attribute="class-description">
            This class contains the role detail.
        </meta>
        <id name="id" type="int" column="uid">
            <generator class="identity"/>
        </id>
        <property name="name" column="name" type="string"/>
    </class>
</hibernate-mapping>

package ru.lesson.models.users;

import java.util.*;

public class User extends Base{
    private String login;
    private String email;
    private String password;
    private String name;
    private String surname;
    private String fullname;
    private String sex;
    private String phone_number;
    private String city;
    private Role role;
    private List<Message> messages = new ArrayList<Message>();

    public User(){}

    public User(int id, String login, String email, String password, String name, String surname,
                String sex, String phone_number, String city){
        this.id = id;
        this.login = login;
        this.email = email;
        this.password = password;
        this.name = name;
        this.surname = surname;
        this.sex = sex;
        this.phone_number = phone_number;
        this.city = city;
        this.fullname = name + " " + surname;
    }

    public List<Message> getMessages() {
        return messages;
    }

    public void setMessages(List<Message> messages) {
        this.messages = messages;
    }

    public String getLogin() {
        return login;
    }

    public void setLogin(String login) {
        this.login = login;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSurname() {
        return surname;
    }

    public void setSurname(String surname) {
        this.surname = surname;
    }

    public String getFullname() {
        return fullname;
    }

    public void setFullname(String fullname) {
        this.fullname = fullname;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getPhone_number() {
        return phone_number;
    }

    public void setPhone_number(String phone_number) {
        this.phone_number = phone_number;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public Role getRole() {
        return role;
    }

    public void setRole(Role role) {
        this.role = role;
    }

    @Override
    public String toString() {
        return "User{" +
                "login='" + login + ''' +
                ", email='" + email + ''' +
                ", password='" + password + ''' +
                ", name='" + name + ''' +
                ", surname='" + surname + ''' +
                ", fullname='" + fullname + ''' +
                ", sex='" + sex + ''' +
                ", phone_number='" + phone_number + ''' +
                ", city='" + city + ''' +
                ", role=" + role +
                ", messages=" + messages +
                '}';
    }
}

package ru.lesson.models.users;

public class Message extends Base {
    private User user;
    private User sender;
    private String text;

    public Message(){}

    public Message(int id, User userToSend, User sender, String textMessage){
        this.user = userToSend;
        this.sender = sender;
        this.text = textMessage;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public User getSender() {
        return sender;
    }

    public void setSender(User sender) { this.sender = sender; }

    public String getText() {
        return text;
    }

    public void setText(String text) {
        this.text = text;
    }
}

package ru.lesson.models.users;

public class Role extends Base {
    private String name;

    public Role(){}

    public Role(int id, String name){
        this.id = id;
        this.name = name;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

package ru.lesson.models.users;

public abstract class Base {
    protected int id;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }
}

package ru.lesson.store;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNotNull;

import java.util.ArrayList;
import java.util.List;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.web.WebAppConfiguration;
import ru.lesson.models.users.Message;
import ru.lesson.models.users.Role;
import ru.lesson.models.users.User;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:spring-context.xml"})
@WebAppConfiguration
public class UserStorageTest {
    @Autowired
    private Storages storage;
    private int id;
    private int idSender;
    private int size;

    @Test
    public void testStorage(){
        try {
            Role role = new Role();
            role.setName("user");
            User user = new User(-1, "sanyaTest", "testYawik@mail.ru", "123456", "Sanya", "Testirovwik", "Man", "095434345", "Kharkov");
            user.setRole(role);
            User sender = new User(-1, "Sender911", "testSender@mail.ru", "123456", "Sanya", "Sender", "Man", "095434345", "Praga");
            sender.setRole(role);
            idSender = storage.userStorage.add(sender);
            id = storage.userStorage.add(user);
            user = storage.userStorage.get(id);
            assertEquals(id, user.getId());
            assertNotNull(user);
            assertEquals("sanyaTest", user.getLogin());
            assertEquals("testYawik@mail.ru", user.getEmail());
            assertEquals("123456", user.getPassword());
            assertEquals("Sanya", user.getName());
            assertEquals("Testirovwik", user.getSurname());
            assertEquals("Man", user.getSex());
            assertEquals("095434345", user.getPhone_number());
            assertEquals("Kharkov", user.getCity());
            size = storage.userStorage.values().size();

            user = new User(id, "sanyaTest1", "testYawik@mail.ru1", "1234561", "Sanya1", "Testirovwik1", "Man1", "0954343451", "Kharkov1");
            user.setRole(role);
            List<Message> messages = new ArrayList<Message>();
            Message message = new Message(-1,user,sender,"textTestJUNIt");
            messages.add(message);
            user.setReceivedMessage(messages);
            storage.userStorage.edit(user);
            user = storage.userStorage.get(id);
            assertEquals(1, storage.userStorage.get(id).getReceivedMessage().size());
            assertEquals(id, user.getId());
            assertNotNull(user);
            assertEquals("sanyaTest1", user.getLogin());
            assertEquals("testYawik@mail.ru1", user.getEmail());
            assertEquals("1234561", user.getPassword());
            assertEquals("Sanya1", user.getName());
            assertEquals("Testirovwik1", user.getSurname());
            assertEquals("Man1", user.getSex());
            assertEquals("0954343451", user.getPhone_number());
            assertEquals("Kharkov1", user.getCity());

            List<User> list = storage.userStorage.searchByID(id);
            assertNotNull(list.get(0));
            assertEquals(list.get(0).getId(), user.getId());

            user = storage.userStorage.findByAuth("sanyaTest1", "1234561");
            assertNotNull(user);

            list = storage.userStorage.searchByName("Sanya1 Testirovwik1");
            assertNotNull(list.get(0));

            //list = storage.searchByLogin(user.getLogin());
            //assertNotNull(list.get(0));
        }finally{
            /*storage.userStorage.delete(id);
            assertEquals(size-1, storage.userStorage.values().size());*/
        }
    }
}