Init. Add Usuario RESTful API. Add READMEHEADmaster

12 files changed, 461 insertions, 0 deletions

diff --git a/src/main/java/com/odiparpack/back/odiparback/OdiparbackApplication.java b/src/main/java/com/odiparpack/back/odiparback/OdiparbackApplication.java
new file mode 100644
index 0000000..7de9ec2
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/OdiparbackApplication.java
@@ -0,0 +1,22 @@
+package com.odiparpack.back.odiparback;
+
+import com.odiparpack.back.odiparback.student.Student;
+import org.springframework.boot.SpringApplication;
+import org.springframework.boot.autoconfigure.SpringBootApplication;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import java.time.LocalDate;
+import java.time.Month;
+import java.util.List;
+
+@SpringBootApplication
+public class OdiparbackApplication {
+
+	public static void main(String[] args) {
+		SpringApplication.run(OdiparbackApplication.class, args);
+	}
+
+}
+
+
diff --git a/src/main/java/com/odiparpack/back/odiparback/student/Student.java b/src/main/java/com/odiparpack/back/odiparback/student/Student.java
new file mode 100644
index 0000000..aaf89ab
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/student/Student.java
@@ -0,0 +1,95 @@
+package com.odiparpack.back.odiparback.student;
+
+// Make sure to use this javax.persistence instead of Hibernate or other
+// provider (of what?)
+import javax.persistence.*;
+import java.time.LocalDate;
+import java.time.Period;
+
+@Entity     // For Hibernate
+@Table      // Table in DB
+public class Student {
+    @Id
+    @SequenceGenerator(
+            name = "student_sequence",
+            sequenceName = "student_sequence",
+            allocationSize = 1
+    )
+    @GeneratedValue(
+            strategy = GenerationType.SEQUENCE,
+            generator = "student_sequence"
+    )
+    private Long id;
+    private String name;
+    private String email;
+    private LocalDate dob;
+    @Transient
+    private Integer age;
+
+    public Student() {
+    }
+
+    public Student(Long id, String name, String email, LocalDate dob) {
+        this.id = id;
+        this.name = name;
+        this.email = email;
+        this.dob = dob;
+    }
+
+    public Student(String name, String email, LocalDate dob) {
+        this.name = name;
+        this.email = email;
+        this.dob = dob;
+    }
+
+    public Long getId() {
+        return id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+    }
+
+    public String getName() {
+        return name;
+    }
+
+    public void setName(String name) {
+        this.name = name;
+    }
+
+    public String getEmail() {
+        return email;
+    }
+
+    public void setEmail(String email) {
+        this.email = email;
+    }
+
+    public LocalDate getDob() {
+        return dob;
+    }
+
+    public void setDob(LocalDate dob) {
+        this.dob = dob;
+    }
+
+    public Integer getAge() {
+        return Period.between(this.dob, LocalDate.now()).getYears();
+    }
+
+    public void setAge(Integer age) {
+        this.age = age;
+    }
+
+    @Override
+    public String toString() {
+        return "Student{" +
+                "id=" + id +
+                ", name='" + name + '\'' +
+                ", email='" + email + '\'' +
+                ", dob=" + dob +
+                ", age=" + age +
+                '}';
+    }
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/student/StudentController.java b/src/main/java/com/odiparpack/back/odiparback/student/StudentController.java
new file mode 100644
index 0000000..ce3e6e0
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/student/StudentController.java
@@ -0,0 +1,41 @@
+package com.odiparpack.back.odiparback.student;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@RestController
+@RequestMapping(path = "api/v1/student")
+public class StudentController {
+
+    private final StudentService studentService;
+
+    @Autowired
+    public StudentController(StudentService studentService) {
+        this.studentService = studentService;
+    }
+
+    @GetMapping
+    public List<Student> getStudents() {
+        return studentService.getStudents();
+    }
+
+    @PostMapping
+    public void registerNewStudent(@RequestBody Student student) {
+        studentService.addNewStudent(student);
+    }
+
+    @DeleteMapping(path = "{studentId}")
+    public void deleteStudent(@PathVariable("studentId") Long studentId) {
+        studentService.deleteStudent(studentId);
+    }
+
+    @PutMapping(path = "{studentId}")
+    public void updateStudent(
+            @PathVariable Long studentId,
+            @RequestParam(required = false) String name,
+            @RequestParam(required = false) String email) {
+        studentService.updateStudent(studentId, name, email);
+    }
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/student/StudentRepository.java b/src/main/java/com/odiparpack/back/odiparback/student/StudentRepository.java
new file mode 100644
index 0000000..2d0fc31
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/student/StudentRepository.java
@@ -0,0 +1,17 @@
+package com.odiparpack.back.odiparback.student;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.stereotype.Repository;
+
+import java.util.Optional;
+
+@Repository
+public interface StudentRepository extends JpaRepository<Student, Long> {
+
+    // Transforms to an SQL such as: select * from student where email = ?
+    //@Query("SELECT s FROM Student s WHERE s.email = ?1")
+    //      ^ JPQL
+    Optional<Student> findStudentByEmail(String email);
+
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/student/StudentService.java b/src/main/java/com/odiparpack/back/odiparback/student/StudentService.java
new file mode 100644
index 0000000..6831dd8
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/student/StudentService.java
@@ -0,0 +1,69 @@
+package com.odiparpack.back.odiparback.student;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import javax.transaction.Transactional;
+import java.time.LocalDate;
+import java.time.Month;
+import java.util.List;
+import java.util.Objects;
+import java.util.Optional;
+
+@Service
+public class StudentService {
+
+    private final StudentRepository studentRepository;
+
+    @Autowired
+    public StudentService(StudentRepository studentRepository) {
+        this.studentRepository = studentRepository;
+    }
+
+    public List<Student> getStudents() {
+        return studentRepository.findAll();
+    }
+
+    public void addNewStudent(Student student) {
+        /* check if the email is already registered, if so throw error */
+        Optional<Student> studentOptional =
+                studentRepository.findStudentByEmail(student.getEmail());
+        if (studentOptional.isPresent()) {
+            throw new IllegalStateException("email taken");
+            // email validation is also possible here
+        }
+        studentRepository.save(student);
+    }
+
+    public void deleteStudent(Long studentId) {
+        boolean exists = studentRepository.existsById(studentId);
+        if (!exists) {
+            throw new IllegalStateException(
+                    "student with id " + studentId + " does not exists");
+        }
+        studentRepository.deleteById(studentId);
+    }
+
+    // "The entity goes into a managed state".  Changes are seaved automatically
+    @Transactional
+    public void updateStudent(Long studentId, String name, String email) {
+        Student student = studentRepository.findById(studentId)
+                .orElseThrow(() -> new IllegalStateException(
+                        "student with id " + studentId + " does not exist"
+                ));
+        /* check that attributes are valid before updating object/record */
+        if (name != null && name.length() > 0 &&
+                !Objects.equals(student.getName(), name)) {
+            student.setName(name);
+        }
+        if (email != null && email.length() > 0 &&
+                !Objects.equals(student.getName(), email)) {
+            Optional<Student> studentOptional = studentRepository
+                    .findStudentByEmail(email);
+            if (studentOptional.isPresent()) {
+                throw new IllegalStateException("email taken");
+            }
+            student.setEmail(email);
+        }
+    }
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/student/studentConfig.java b/src/main/java/com/odiparpack/back/odiparback/student/studentConfig.java
new file mode 100644
index 0000000..cd6668a
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/student/studentConfig.java
@@ -0,0 +1,35 @@
+package com.odiparpack.back.odiparback.student;
+
+import org.springframework.boot.CommandLineRunner;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+
+import java.time.LocalDate;
+import java.time.Month;
+import java.util.List;
+
+@Configuration
+public class studentConfig {
+
+    @Bean
+    CommandLineRunner commandLineRunner(StudentRepository repository) {
+        return args -> {
+            Student ana = new Student(
+                    "Ana",
+                    "[email protected]",
+                    LocalDate.of(2000, Month.JANUARY, 5)
+            );
+
+            Student bob = new Student(
+                    "Bob",
+                    "[email protected]",
+                    LocalDate.of(2000, Month.JANUARY, 5)
+            );
+
+            repository.saveAll(
+                    List.of(ana, bob)
+            );
+        };
+
+    }
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/usuario/Usuario.java b/src/main/java/com/odiparpack/back/odiparback/usuario/Usuario.java
new file mode 100644
index 0000000..416ada1
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/usuario/Usuario.java
@@ -0,0 +1,39 @@
+package com.odiparpack.back.odiparback.usuario;
+
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
+import lombok.Setter;
+
+import javax.persistence.*;
+
+@Entity
+@Table
+
+@NoArgsConstructor
+@AllArgsConstructor
+@Getter
+@Setter
+public class Usuario {
+    @Id
+    @SequenceGenerator(
+            name = "usuario_sequence",
+            sequenceName = "usuario_sequence",
+            allocationSize = 1
+    )
+    @GeneratedValue(
+            strategy = GenerationType.SEQUENCE,
+            generator = "usuario_sequence"
+    )
+    private Long id;
+    private String usuario;
+    private String clave;
+    private String nombre;
+    private String apellido;
+    private String dni;
+    private String correo;
+
+    @ManyToOne
+    private Usuario creador;
+
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioController.java b/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioController.java
new file mode 100644
index 0000000..9ada36e
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioController.java
@@ -0,0 +1,49 @@
+package com.odiparpack.back.odiparback.usuario;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+import java.util.Optional;
+
+@RestController
+@RequestMapping(path = "api/v1/usuario")
+public class UsuarioController {
+
+    private final UsuarioService usuarioService;
+
+    @Autowired
+    public UsuarioController(UsuarioService usuarioService) {
+        this.usuarioService = usuarioService;
+    }
+
+    @GetMapping
+    public List<Usuario> getAll() {
+        return usuarioService.getAll();
+    }
+
+    @GetMapping(path = "{id}")
+    public Optional<Usuario> get(@PathVariable Long id) {
+        return usuarioService.get(id);
+    }
+
+    @PostMapping
+    public Long register(@RequestBody Usuario usuario) {
+        return usuarioService.register(usuario);
+    }
+
+    @PostMapping(path = "0")
+    public void registerAll(@RequestBody List<Usuario> usuarios) {
+        usuarioService.registerAll(usuarios);
+    }
+
+    @DeleteMapping(path = "{id}")
+    public void delete(@PathVariable("id") Long id) {
+        usuarioService.delete(id);
+    }
+
+    @PutMapping
+    public void update(@RequestBody Usuario usuario) {
+        usuarioService.update(usuario);
+    }
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioRepository.java b/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioRepository.java
new file mode 100644
index 0000000..668a3d8
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioRepository.java
@@ -0,0 +1,8 @@
+package com.odiparpack.back.odiparback.usuario;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+@Repository
+public interface UsuarioRepository extends JpaRepository<Usuario, Long> {
+}
diff --git a/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioService.java b/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioService.java
new file mode 100644
index 0000000..a42c2a5
--- /dev/null
+++ b/src/main/java/com/odiparpack/back/odiparback/usuario/UsuarioService.java
@@ -0,0 +1,60 @@
+package com.odiparpack.back.odiparback.usuario;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import javax.transaction.Transactional;
+import java.util.List;
+import java.util.Optional;
+
+@Service
+public class UsuarioService {
+
+    private final UsuarioRepository usuarioRepository;
+
+    @Autowired
+    public UsuarioService(UsuarioRepository usuarioRepository) {
+        this.usuarioRepository = usuarioRepository;
+    }
+
+    public List<Usuario> getAll() {
+        return usuarioRepository.findAll();
+    }
+
+    public Optional<Usuario> get(Long id) {
+        return usuarioRepository.findById(id);
+    }
+
+    public Long register(Usuario usuario) {
+        usuario.setId(null);    // overwrite protection
+        usuario = usuarioRepository.save(usuario);
+        return usuario.getId();
+    }
+
+    public void registerAll(List<Usuario> usuarios) {
+        usuarioRepository.saveAll(usuarios);
+    }
+
+    public void delete(Long id) {
+        boolean exists = usuarioRepository.existsById(id);
+        if (!exists) {
+            throw new IllegalStateException(
+                    "usuario with id " + id + " does not exists");
+        }
+        usuarioRepository.deleteById(id);
+    }
+
+    // "Managed mode".  Changes saved automatically
+    @Transactional
+    public void update(Usuario usuarioNew) {
+        Long id = usuarioNew.getId();
+        if (usuarioNew.getId() == null ||
+                !usuarioRepository.existsById(id)) {
+            throw new IllegalStateException(
+                    "usuario id (" + id + ") doesn't exist"
+            );
+        }
+        usuarioRepository.save(usuarioNew);
+    }
+
+}
diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
new file mode 100644
index 0000000..1c129a0
--- /dev/null
+++ b/src/main/resources/application.properties
@@ -0,0 +1,13 @@
+# application.properties
+
+spring.datasource.url=jdbc:postgresql://localhost:5432/odiparback
+spring.datasource.username=opp
+spring.datasource.password=odiparfront
+
+# create-drop,update
+spring.jpa.hibernate.ddl-auto=update
+spring.jpa.show-sql=true
+spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
+spring.jpa.properties.hibernate.format_sql=true
+
+server.error.include-message=always
\ No newline at end of file
diff --git a/src/test/java/com/odiparpack/back/odiparback/OdiparbackApplicationTests.java b/src/test/java/com/odiparpack/back/odiparback/OdiparbackApplicationTests.java
new file mode 100644
index 0000000..3117093
--- /dev/null
+++ b/src/test/java/com/odiparpack/back/odiparback/OdiparbackApplicationTests.java
@@ -0,0 +1,13 @@
+package com.odiparpack.back.odiparback;
+
+import org.junit.jupiter.api.Test;
+import org.springframework.boot.test.context.SpringBootTest;
+import org.springframework.web.bind.annotation.GetMapping;
+
+@SpringBootTest
+class OdiparbackApplicationTests {
+
+	@Test
+	void contextLoads() {
+	}
+}