SysDataviewController.java

/*
 * Copyright 2024 Global Crop Diversity Trust
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.gringlobal.api.v2.impl;

import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import lombok.extern.slf4j.Slf4j;

import org.gringlobal.api.model.SysDataviewDTO;
import org.gringlobal.api.model.SysDataviewDetailsDTO;
import org.gringlobal.api.model.SysDataviewFieldDTO;
import org.gringlobal.api.model.SysDataviewFieldLangDTO;
import org.gringlobal.api.model.SysDataviewLangDTO;
import org.gringlobal.api.model.SysDataviewParamDTO;
import org.gringlobal.api.model.SysDataviewSqlDTO;
import org.gringlobal.api.model.TranslatedSysDataviewDTO;
import org.gringlobal.api.model.TranslatedSysDataviewFieldDTO;
import org.gringlobal.api.v1.ApiBaseController;
import org.gringlobal.api.v2.CRUDController;
import org.gringlobal.api.v2.TranslatedCRUDController;
import org.gringlobal.api.v2.facade.SysDataviewApiService;
import org.gringlobal.api.v2.facade.SysDataviewFieldApiService;
import org.gringlobal.api.v2.facade.SysDataviewParamApiService;
import org.gringlobal.api.v2.facade.SysDataviewSqlApiService;
import org.gringlobal.model.SysDataview;
import org.gringlobal.model.SysDataviewField;
import org.gringlobal.model.SysDataviewFieldLang;
import org.gringlobal.model.SysDataviewLang;
import org.gringlobal.model.SysDataviewParam;
import org.gringlobal.model.SysDataviewSql;
import org.gringlobal.service.filter.SysDataviewFieldFilter;
import org.gringlobal.service.filter.SysDataviewFilter;
import org.springframework.http.MediaType;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController("dataviewApi2")
@RequestMapping(SysDataviewController.API_URL)
@PreAuthorize("hasAuthority('GROUP_ADMINS')")
@Tag(name = "Dataview")
@Slf4j
public class SysDataviewController extends TranslatedCRUDController<SysDataviewDTO, TranslatedSysDataviewDTO, SysDataviewLangDTO, SysDataview, SysDataviewLang, SysDataviewApiService, SysDataviewFilter> {

	/** The Constant API_URL. */
	public static final String API_URL = ApiBaseController.APIv2_BASE + "/dataview";

	@GetMapping(value = "/{id:\\d+}/details", produces = { MediaType.APPLICATION_JSON_VALUE })
	@Operation(operationId = "getDetails", description = "Get SysDataview details by ID", summary = "Get details")
	public SysDataviewDetailsDTO getDetails(@PathVariable("id") final long id) {
		return translatedApiService.getDetails(id);
	}

	@PostMapping(value = "/generate", produces = { MediaType.APPLICATION_JSON_VALUE })
	@Operation(operationId = "generateDataview", description = "Generate SysDataview from SQL SELECT statement", summary = "Generate dataview from SQL")
	public SysDataviewDetailsDTO generateDataview(@RequestBody(required = true) final String sqlStatement) {
		return translatedApiService.generateDataview(sqlStatement);
	}

	@RestController("dataviewParameterApi2")
	@RequestMapping(SysDataviewParamController.API_URL)
	@PreAuthorize("hasAuthority('GROUP_ADMINS')")
	@Tag(name = "Dataview")
	@Slf4j
	public static class SysDataviewParamController extends CRUDController<SysDataviewParamDTO, SysDataviewParam, SysDataviewParamApiService> {

		/** The Constant API_URL. */
		public static final String API_URL = SysDataviewController.API_URL + "/param";

	}

	@RestController("dataviewSqlApi2")
	@RequestMapping(SysDataviewSqlController.API_URL)
	@PreAuthorize("hasAuthority('GROUP_ADMINS')")
	@Tag(name = "Dataview")
	@Slf4j
	public static class SysDataviewSqlController extends CRUDController<SysDataviewSqlDTO, SysDataviewSql, SysDataviewSqlApiService> {

		/** The Constant API_URL. */
		public static final String API_URL = SysDataviewController.API_URL + "/sql";

	}

	@RestController("dataviewFieldApi2")
	@RequestMapping(SysDataviewFieldController.API_URL)
	@PreAuthorize("hasAuthority('GROUP_ADMINS')")
	@Tag(name = "Dataview")
	@Slf4j
	public static class SysDataviewFieldController extends TranslatedCRUDController<SysDataviewFieldDTO, TranslatedSysDataviewFieldDTO, SysDataviewFieldLangDTO, SysDataviewField, SysDataviewFieldLang, SysDataviewFieldApiService, SysDataviewFieldFilter> {

		/** The Constant API_URL. */
		public static final String API_URL = SysDataviewController.API_URL + "/field";

	}

}