@RestController
@RequestMapping(ProjectRestController.ENDPOINT)
@Api(produces = MediaType.APPLICATION_JSON_VALUE, tags = "项目")
public class ProjectRestController {
	public static final String ENDPOINT = "/api/v2/projects";
	public static final String ENDPOINT_ID = "/{id}";
	public static final String PATH_VARIABLE_ID = "id";
	public static final String ENDPOINT_SYSTEM_ID = "/{systemId}/projects";
	private static final String API_PARAM_ID = "ID";
    
	@Autowired
	private SdlcService sdlcService;
	@Autowired
	private ProjectService projectService;
	@ApiOperation("获取项目")
	@GetMapping(ENDPOINT_ID)
	public Project getProject(
			@ApiParam(name = API_PARAM_ID, required = true) @PathVariable(PATH_VARIABLE_ID) final long projectId) {
		return projectService.getProject(projectId);
	}
	@ApiOperation("创建项目")
	@PostMapping(ENDPOINT_SYSTEM_ID)
	public Project createProject(@PathVariable(value = "systemId") Long systemId, @Valid @RequestBody Project project) {
		sdlcService.findById(systemId).ifPresent(project::setSdlcSystem);
		return projectService.saveProject(project);
	}
}

@Entity
@lombok.Data
@Table(name = "project")
@EntityListeners(AuditingEntityListener.class)
public class Project {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;
    public long getId() {
        return this.id;
    }
    public void setId(long id) {
        this.id = id;
    }
    @Column(name = "external_id", nullable = false)
    @NotBlank
    private String externalId;
    public String getExternalId() {
        return this.externalId;
    }
    public void setExternalId(String externalId) {
        this.externalId = externalId;
    }
    @Column(name = "name")
    private String name;
    public String getName() {
        return this.name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @ManyToOne
    @JoinColumn(name = "sdlc_system_id")
    @NotNull
    private SdlcSystem sdlcSystem;
    public SdlcSystem getSdlcSystem() {
        return this.sdlcSystem;
    }
    public void setSdlcSystem(SdlcSystem sdlcSystem) {
        this.sdlcSystem = sdlcSystem;
    }
    @Column(name = "created_date", nullable = false)
    @CreatedDate
    private Instant createdDate;
    public Instant getCreatedDate() {
        return this.createdDate;
    }
    public void setCreatedDate(Instant createdDate) {
        this.createdDate = createdDate;
    }
    @Column(name = "last_modified_date", nullable = false)
    @LastModifiedDate
    private Instant lastModifiedDate;
    public Instant getLastModifiedDate() {
        return this.lastModifiedDate;
    }
    public void setLastModifiedDate(Instant lastModifiedDate) {
        this.lastModifiedDate = lastModifiedDate;
    }
}

@Data
@Entity
@Table(name = "sdlc_system")
@EntityListeners(AuditingEntityListener.class)
public class SdlcSystem {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;
    @NotEmpty
    @URL
    @Column(name = "base_url", nullable = false)
    private String baseUrl;
    public String getBaseUrl() {
        return this.baseUrl;
    }
    public void setBaseUrl(String baseUrl) {
        this.baseUrl = baseUrl;
    }
    @Column(name = "description")
    private String description;
    public String getDescription() {
        return this.description;
    }
    public void setDescription(String description) {
        this.description = description;
    }
    @Column(name = "created_date", nullable = false)
    @CreatedDate
    private Instant createdDate;
    public Instant getCreatedDate() {
        return this.createdDate;
    }
    public void setCreatedDate(Instant createdDate) {
        this.createdDate = createdDate;
    }
    @Column(name = "last_modified_date", nullable = false)
    @LastModifiedDate
    private Instant lastModifiedDate;
    public Instant getLastModifiedDate() {
        return this.lastModifiedDate;
    }
    public void setLastModifiedDate(Instant lastModifiedDate) {
        this.lastModifiedDate = lastModifiedDate;
    }
}

@Repository
public interface ProjectRepository extends JpaRepository<Project, Long> {
    Optional<Project> findBySdlcSystemIdAndId(long sdlcSystemId, long projectId);
    Optional<Project> findById(long projectId);
}

@Repository
public interface SdlcSystemRepository extends JpaRepository<SdlcSystem, Long> {
    Optional<SdlcSystem> findById(long systemId);
}

@Service
public interface ProjectService {
    Project getProject(long id);
    Project saveProject(Project project);
}

public class ProjectServiceImpl implements ProjectService {
	@Autowired
	private ProjectRepository projectRepository;
	public Project getProject(long id) {
		return projectRepository.findById(id).orElseThrow(
				() -> new RuntimeException("找不到类" + Project.class + "和 id：" + id));
	}
	public Project saveProject(Project project) {
		try {
			return projectRepository.save(project);
		} catch (Exception e) {
			return null;
		}
	}
}

@Service
public interface SdlcService {
    Optional<SdlcSystem> findById(Long systemId);
}

public class SdlcServiceImpl {
    @Autowired
    private SdlcSystemRepository sdlcSystemRepository;
    SdlcSystem findById(Long systemId) {
        return sdlcSystemRepository.findById(systemId).orElseThrow(
                () -> new RuntimeException("找不到类" + SdlcSystem.class + "和 id：" + systemId));
    }
}

@SpringBootApplication
public class RestapiApplication {
	public static void main(String[] args) {
		SpringApplication.run(RestapiApplication.class, args);
	}
}