package com.example.configuration;


import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.JpaVendorAdapter;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.AbstractJpaVendorAdapter;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import com.example.repository.Marker;

import javax.persistence.EntityManagerFactory;
import javax.sql.DataSource;
import java.beans.PropertyVetoException;
import java.util.Properties;

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(basePackageClasses = Marker.class)
@ComponentScan({"com.example"})
public class DataBase {

    @Bean
    public DataSource dataSource() {
        return new DriverManagerDataSource("jdbc:h2:~/test", "sa", "");
    }

    @Bean
    public JpaVendorAdapter jpaVendorAdapter() {
        AbstractJpaVendorAdapter adapter = new HibernateJpaVendorAdapter();
        adapter.setShowSql(true);
        adapter.setGenerateDdl(true);
        return adapter;
    }

    @Bean
    public EntityManagerFactory entityManagerFactory(DataSource dataSource,
                                                     JpaVendorAdapter jpaVendorAdapter) {
        LocalContainerEntityManagerFactoryBean factory =
                new LocalContainerEntityManagerFactoryBean();
        factory.setJpaVendorAdapter(jpaVendorAdapter);
        factory.setPackagesToScan("com/example/domain");
        factory.setDataSource(dataSource);
        factory.setJpaProperties(jpaProperties());
        factory.afterPropertiesSet();
        return factory.getObject();
    }

    private Properties jpaProperties() {
        Properties properties = new Properties();
        properties.put("hibernate.dialect", "org.hibernate.dialect.H2Dialect");
        return properties;
    }

    @Bean
    public PlatformTransactionManager transactionManager(EntityManagerFactory emf)
            throws PropertyVetoException {
        return new JpaTransactionManager(emf);
    }
}

package com.example.configuration;

import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;

@Configuration
@Import(DataBase.class)
public class MainConfig {
}

package com.example.domain;


import javax.persistence.*;
import java.io.Serializable;

@Entity
@Table(name="BOOKS")
public class Book implements Serializable{

    @Id
    @GeneratedValue
    @Column(name = "ID")
    private Long id;


    @Column(name = "NAME")
    private String name;

    @Column(name = "AUTHOR")
    private String author;


    public Book() {
    }

    public Book(String author, String name) {
        this.name = name;
        this.author = author;
    }

    public Long getId() {
        return id;
    }

    public String getName() {
        return name;
    }

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

    public String getAuthor() {
        return author;
    }

    public void setAuthor (String author) {
        this.author = author;
    }

    @Override
    public String toString() {
        return "Book{" +
                "id=" + id +
                ": "+name+" "+author+
                '}';
    }
}

package com.example.domain;

import javax.persistence.*;
import java.io.Serializable;
import java.util.LinkedList;
import java.util.List;

@Entity
public class Library implements Serializable{

    @Id
    @GeneratedValue
    @Column(name = "ID")
    private Long id;

    @Column(name = "USERID")
    private Long idUser;

   @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
   @JoinTable(name = "Library_books", joinColumns = @JoinColumn(name = "Library_id", referencedColumnName = "ID"),
           inverseJoinColumns = @JoinColumn(name = "book_id", referencedColumnName = "ID"))
   private List<Book> bookList = new LinkedList<>();

    public Library(){
    }
    public Library(Long idUser) {
        this.idUser = idUser;

    }
    public Long getId() {
        return id;
    }
    public Long getIdUser() {
        return idUser;
    }

    public void setIdUser(Long idUser) {
        this.idUser = idUser;
    }

    public List<Book> getBookList() {
        return bookList;
    }

    public void setBookList(List<Book> bookList) {
        this.bookList = bookList;
    }


    @Override
    public String toString() {
        return "Library{" +
                "BookList=" + bookList +
                '}';
    }
}

package com.example.repository;
import com.example.domain.Book;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;


public interface  BookRepo  extends JpaRepository<Book, Long> {

        Book findFirstByName(String name);
        Book findFirstById(Long id);
        List<Book> findByName(String name);
        List<Book> findByAuthor(String musician);
}

package com.example.repository;

import com.example.domain.Library;
import org.springframework.data.jpa.repository.JpaRepository;

public interface  LibraryRepo extends JpaRepository<Library, Long> {
    Library findByIdUser(Long id);
}

package com.example;

import com.example.domain.Book;
import com.example.domain.Library;
import com.example.repository.BookRepo;
import com.example.repository.LibraryRepo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;


@Component
public class UserLibraryImpl implements UserLibrary {

    @Autowired
    private BookRepo bookRepo;

    @Autowired
    private LibraryRepo libraryRepo;
    private Library library;
    private Long idUser;

    public void setIdUser(Long idUser) {
        this.idUser = idUser;
    }


    public UserLibraryImpl(){}
    public UserLibraryImpl(Long idUser) {
        this.idUser=idUser;
    }

    @Override
    @Transactional
    public void addBook(Book book) {
        library = libraryRepo.findByIdUser(idUser);

        Book bookForLibraray =bookRepo.save(book);

        library.getBookList().add(bookForLibraray);

    }

    @Override
    public Book findBookForAll(String name) {
        return null;
    }

    @Override
    public Book findBook(String name) {
        return null;
    }

    @Override
    public void deleteBook(Book book) {

    }

    @Override
    public void editBook(Book book) {

    }

    @Override
    public void showAll() {

    }


}

package com.example;

import com.example.domain.Book;

public interface UserLibrary {
    void addBook(Book book);
    Book findBookForAll(String name);
    Book findBook(String name);
    void deleteBook(Book book);
    void editBook(Book book);
    void showAll();
}