private void initDb() {
        usersRepository.deleteAll();
        offersRepository.deleteAll();

        User user1 = new User("admin@email.com", "Pedro", "Díaz", 100);
        user1.setPassword("admin");
        user1.setRole(rolesService.getRoles()[0]);
        User user2 = new User("lucas@wpop.com", "Lucas", "Núñez", 100);
        user2.setPassword("123456");
        user2.setRole(rolesService.getRoles()[1]);
        User user3 = new User("maria@wpop.com", "María", "Rodríguez", 100);
        user3.setPassword("123456");
        user3.setRole(rolesService.getRoles()[1]);
        User user4 = new User("marta@wpop.com", "Marta", "Almonte", 100);
        user4.setPassword("123456");
        user4.setRole(rolesService.getRoles()[1]);
        User user5 = new User("pelayo@wpop.com", "Pelayo", "Valdes", 100);
        user5.setPassword("123456");
        user5.setRole(rolesService.getRoles()[1]);
        User user6 = new User("edward@wpop.com", "Edward", "Núñez", 100);
        user6.setPassword("123456");
        user6.setRole(rolesService.getRoles()[1]);

        Set<Offer> user1Offers = new HashSet<Offer>() {
            private static final long serialVersionUID = 1L;

            {
                add(new Offer("Consola XBOX", "Dispositivo de juego", DateConverter.getDatefromString("01/02/2019"), 100.0, user1));
                add(new Offer("Seat Ibiza", "Coche", DateConverter.getDatefromString("11/03/2019"), 1000.0, user1));
                add(new Offer("Vespa", "Motocicleta", DateConverter.getDatefromString("14/10/2018"), 600.0, user1));
            }
        };
        user1.setOffers(user1Offers);

        Set<Offer> user2Offers = new HashSet<Offer>() {
            private static final long serialVersionUID = 1L;

            {
                add(new Offer("Consola PS4", "Dispositivo de juego", DateConverter.getDatefromString("25/10/2018"), 150.0, user2));
                add(new Offer("Batería 4000mAh", "Batería portátil", DateConverter.getDatefromString("09/09/2018"), 15.0, user2));
                add(new Offer("Teclado mecánico", "Para oficina", DateConverter.getDatefromString("10/12/2018"), 27.5, user2));
            }
        };
        user2.setOffers(user2Offers);

        Set<Offer> user3Offers = new HashSet<Offer>() {
            private static final long serialVersionUID = 1L;

            {
                add(new Offer("Funda gafas RayBan", "Con protección contra caídas", DateConverter.getDatefromString("07/01/2019"), 14.0, user3));
                add(new Offer("Zapatillas Vans", "Color negro, número 43", DateConverter.getDatefromString("12/03/2019"), 36.5, user3));
                add(new Offer("Koenigsegg Agera", "Coche económico", DateConverter.getDatefromString("31/01/2019"), 899999.99, user3));
            }
        };
        user3.setOffers(user3Offers);

        Set<Offer> user4Offers = new HashSet<Offer>() {
            private static final long serialVersionUID = 1L;

            {
                add(new Offer("Consola Nintendo DS", "Dispositivo de juego portátil", DateConverter.getDatefromString("07/05/2018"), 85.0, user4));
                add(new Offer("Ratón ASUS ROG", "Ratón gaming", DateConverter.getDatefromString("05/01/2019"), 99.99, user4));
                add(new Offer("Agua Fontvella 2L", "Agua de manantial", DateConverter.getDatefromString("28/02/2019"), 1.0, user4));
            }
        };
        user4.setOffers(user4Offers);

        Set<Offer> user5Offers = new HashSet<Offer>() {
            private static final long serialVersionUID = 1L;

            {
                add(new Offer("Micrófono JVC", "Dispositivo de grabación de estudio", DateConverter.getDatefromString("06/09/2018"), 249.99, user5));
                add(new Offer("Adaptador tipo C", "Cable", DateConverter.getDatefromString("15/01/2019"), 0.75, user5));
                add(new Offer("Cobertor de cama", "Para invierno y verano", DateConverter.getDatefromString("17/04/2018"), 27.95, user5));
            }
        };
        user5.setOffers(user5Offers);

        Set<Offer> user6Offers = new HashSet<Offer>() {
            private static final long serialVersionUID = 1L;

            {
                add(new Offer("Mecedora IKEA Poäng", "Muy cómoda", DateConverter.getDatefromString("01/02/2019"), 189.99, user6));
                add(new Offer("Destornillador Phillips", "Para dispositivos móviles", DateConverter.getDatefromString("11/03/2019"), 7.99, user6));
                add(new Offer("Gremlin", "No le mojes, por favor", DateConverter.getDatefromString("31/12/1945"), 0.05, user6));
            }
        };
        user6.setOffers(user6Offers);

        usersService.addUser(user1);
        usersService.addUser(user2);
        usersService.addUser(user3);
        usersService.addUser(user4);
        usersService.addUser(user5);
        usersService.addUser(user6);

        User u2 = usersRepository.findByEmail("lucas@wpop.com");
        Offer o1 = offersRepository.findAllSoldByUserNonPageable(u2).get(0);
        Offer o2 = offersRepository.findAllSoldByUserNonPageable(u2).get(1);

        User u3 = usersRepository.findByEmail("maria@wpop.com");
        Offer o3 = offersRepository.findAllSoldByUserNonPageable(u3).get(0);
        Offer o4 = offersRepository.findAllSoldByUserNonPageable(u3).get(1);

        User u4 = usersRepository.findByEmail("marta@wpop.com");
        Offer o5 = offersRepository.findAllSoldByUserNonPageable(u4).get(0);
        Offer o6 = offersRepository.findAllSoldByUserNonPageable(u4).get(1);

        User u5 = usersRepository.findByEmail("pelayo@wpop.com");
        Offer o7 = offersRepository.findAllSoldByUserNonPageable(u5).get(0);
        Offer o8 = offersRepository.findAllSoldByUserNonPageable(u5).get(1);

        User u6 = usersRepository.findByEmail("edward@wpop.com");
        Offer o9 = offersRepository.findAllSoldByUserNonPageable(u6).get(0);
        Offer o10 = offersRepository.findAllSoldByUserNonPageable(u6).get(1);

        setOffersBuyer(o1, u5);
        setOffersBuyer(o2, u6);
        setOffersBuyer(o3, u6);
        setOffersBuyer(o4, u5);
        setOffersBuyer(o5, u2);
        setOffersBuyer(o6, u4);
        setOffersBuyer(o7, u3);
        setOffersBuyer(o8, u2);
        setOffersBuyer(o9, u3);
        setOffersBuyer(o10, u4);
    }

    private void setOffersBuyer(Offer offer, User buyer) {
        offer.setBuyer(buyer);
        offersRepository.save(offer);
    }