T - TipoID - ID@Transactional(rollbackFor=java.lang.Throwable.class, propagation=REQUIRED, readOnly=true, transactionManager="transactionManagerSQL") public abstract class AbstractSQLResourceRest<T,ID extends Serializable> extends Object
| Modifier and Type | Field and Description |
|---|---|
protected static br.com.anteros.core.log.Logger |
log |
| Constructor and Description |
|---|
AbstractSQLResourceRest() |
| Modifier and Type | Method and Description |
|---|---|
protected void |
addInstanceOfExpression(br.com.anteros.persistence.dsl.osql.BooleanBuilder builder,
br.com.anteros.persistence.dsl.osql.DynamicEntityPath entityPath) |
protected void |
addRelationShipExpression(String field,
String id,
br.com.anteros.persistence.dsl.osql.BooleanBuilder builder,
br.com.anteros.persistence.dsl.osql.DynamicEntityPath entityPath) |
protected br.com.anteros.persistence.dsl.osql.types.OrderSpecifier<?>[] |
convertToSortExpression(String sort,
br.com.anteros.persistence.dsl.osql.DynamicEntityPath entityPath) |
long |
count()
Retorna a quantidade de objetos da classe.
|
protected List<T> |
createConcreteList(List<T> result) |
protected br.com.anteros.persistence.session.repository.Page<T> |
createConcretePage(List<T> content,
br.com.anteros.persistence.session.repository.PageRequest pageRequest,
long totalElements) |
boolean |
exists(List<String> ids)
Verifica a existência dos objetos contidos na lista.
|
boolean |
exists(String id)
Verifica a existência de um objeto com o ID.
|
br.com.anteros.persistence.session.repository.Page<T> |
find(br.com.anteros.persistence.session.query.filter.Filter filter,
int page,
int size,
String fieldsToForceLazy)
Busca os objetos da classe de acordo com o objeto filtro.
|
br.com.anteros.persistence.session.repository.Page<T> |
find(String field,
String id,
br.com.anteros.persistence.session.query.filter.Filter filter,
int page,
int size,
String fieldsToForceLazy)
Busca os objetos da classe de acordo com o objeto filtro e o relacionamento
|
br.com.anteros.persistence.session.repository.Page<T> |
find(String filter,
String fields,
int page,
int size,
String sort,
String fieldsToForceLazy)
Busca os objetos da classe de acordo com a string de filtro e os campos.
|
br.com.anteros.persistence.session.repository.Page<T> |
find(String field,
String id,
String filter,
String fields,
int page,
int size,
String sort,
String fieldsToForceLazy)
Busca os objetos da classe de acordo com a string de filtro, campos e o relacionamento.
|
br.com.anteros.persistence.session.repository.Page<T> |
findAll(int page,
int size,
String fieldsToForceLazy)
Busca os objetos da classe com paginação.
|
br.com.anteros.persistence.session.repository.Page<T> |
findAll(int page,
int size,
String sort,
String fieldsToForceLazy)
Busca os objetos da classe com paginação e ordenado
|
List<T> |
findAll(List<String> ids,
String fieldsToForceLazy)
Busca os objetos da classe contido na lista de ID's.
|
br.com.anteros.persistence.session.repository.Page<T> |
findAll(String field,
String id,
int page,
int size,
String fieldsToForceLazy)
Busca os objetos da classe com paginação e com filtro por relacionamento
|
br.com.anteros.persistence.session.repository.Page<T> |
findAllByRelationShip(String field,
String id,
int page,
int size,
String sort,
String fieldsToForceLazy)
Busca os objetos da classe com paginação, ordenado e com filtro por relacionamento
|
br.com.anteros.persistence.session.repository.Page<T> |
findByNamedQuery(br.com.anteros.persistence.session.query.filter.Filter filter,
String queryName,
int page,
int size,
List<String> parameters,
String fieldsToForceLazy)
Busca os objetos da classe usando uma consulta nomeada de acordo com os
parâmetros e filtro.
|
br.com.anteros.persistence.session.repository.Page<T> |
findByNamedQuery(br.com.anteros.persistence.session.query.filter.Filter filter,
String queryName,
int page,
int size,
String fieldsToForceLazy)
Busca os objetos da classe usando uma consulta nomeada e um filtro.
|
br.com.anteros.persistence.session.repository.Page<T> |
findByNamedQuery(String queryName,
int page,
int size,
List<String> parameters,
String fieldsToForceLazy)
Busca os objetos da classe usando uma consulta nomeada de acordo com os
parâmetros.
|
br.com.anteros.persistence.session.repository.Page<T> |
findByNamedQuery(String queryName,
int page,
int size,
String fieldsToForceLazy)
Busca os objetos da classe usando uma consulta nomeada.
|
T |
findCode(String code,
String fieldsToForceLazy)
Busca um objeto pelo seu CODE.
|
T |
findOne(String id,
String fieldsToForceLazy)
Busca um objeto pelo seu ID.
|
protected br.com.anteros.persistence.dsl.osql.DynamicEntityPath |
getEntityPath() |
abstract br.com.anteros.persistence.session.service.SQLService<T,ID> |
getService()
Método abstrato que irá fornecer a classe de serviço para ser usada no
controller.
|
Boolean |
removeAll(List<String> ids)
Remove todos os objetos da classe.
|
T |
removeById(String id)
Remove um objeto pelo ID.
|
T |
save(T object)
Insere ou atualiza um objeto.
|
void |
validate(T object)
Valida um objeto.
|
void |
validateGroup(T object,
Class<?>... groups)
Valida um objeto.
|
@RequestMapping(value="/",
method={POST,PUT})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=false,
transactionManager="transactionManagerSQL")
public T save(@RequestBody
T object)
throws Exception
object - Objeto a ser salvoException@RequestMapping(value="/validate",
method={POST,PUT})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=false,
transactionManager="transactionManagerSQL")
public void validate(@RequestBody
T object)
throws Exception
object - Objeto a ser validadoException@RequestMapping(value="/validateGroup",
method={POST,PUT})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=false,
transactionManager="transactionManagerSQL")
public void validateGroup(@RequestBody
T object,
Class<?>... groups)
throws Exception
object - Objeto a ser validadogroups - Grupo de validaçãoException@RequestMapping(value="/{id}",
method=DELETE)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=false,
transactionManager="transactionManagerSQL")
public T removeById(@PathVariable(value="id")
String id)
throws Exception
id - Identificador do objetoException@RequestMapping(value="/",
method=DELETE)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=false,
transactionManager="transactionManagerSQL")
public Boolean removeAll(@RequestParam(required=true)
List<String> ids)
throws Exception
ids - Lista dos id's a serem removidos.Exception@RequestMapping(value="/{id}",
params="fieldsToForceLazy",
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public T findOne(@PathVariable(value="id")
String id,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
throws Exception
id - Identificador do objeto.Exception@RequestMapping(value="/code/{code}",
params="fieldsToForceLazy",
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public T findCode(@PathVariable(value="code")
String code,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
throws Exception
id - Code do objeto.Exception@RequestMapping(method=GET,
value="/findAll",
params={"page","size","fieldsToForceLazy"})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findAll(@RequestParam(value="page")
int page,
@RequestParam(value="size")
int size,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
page - Número da páginasize - Tamanho da página@RequestMapping(method=GET,
value="/findAllByRelationShip/{field}/{id}",
params={"page","size","fieldsToForceLazy"})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findAll(@PathVariable(value="field")
String field,
@PathVariable(value="id")
String id,
@RequestParam(value="page")
int page,
@RequestParam(value="size")
int size,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
page - Número da páginasize - Tamanho da páginaprotected void addRelationShipExpression(String field, String id, br.com.anteros.persistence.dsl.osql.BooleanBuilder builder, br.com.anteros.persistence.dsl.osql.DynamicEntityPath entityPath)
protected void addInstanceOfExpression(br.com.anteros.persistence.dsl.osql.BooleanBuilder builder,
br.com.anteros.persistence.dsl.osql.DynamicEntityPath entityPath)
protected br.com.anteros.persistence.dsl.osql.DynamicEntityPath getEntityPath()
@RequestMapping(method=GET,
value="/findAll",
params={"page","size","sort","fieldsToForceLazy"})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findAll(@RequestParam(value="page")
int page,
@RequestParam(value="size")
int size,
@RequestParam(value="sort")
String sort,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
page - Número da páginasize - Tamanho da páginasort - Campos para ordenaçãoprotected br.com.anteros.persistence.dsl.osql.types.OrderSpecifier<?>[] convertToSortExpression(String sort, br.com.anteros.persistence.dsl.osql.DynamicEntityPath entityPath)
@RequestMapping(method=GET,
value="/findAllByRelationShip/{field}/{id}",
params={"page","size","sort","fieldsToForceLazy"})
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findAllByRelationShip(@PathVariable(value="field")
String field,
@PathVariable(value="id")
String id,
@RequestParam(value="page")
int page,
@RequestParam(value="size")
int size,
@RequestParam(value="sort")
String sort,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
page - Número da páginasize - Tamanho da páginasort - Campos para ordenaçãoprotected br.com.anteros.persistence.session.repository.Page<T> createConcretePage(List<T> content, br.com.anteros.persistence.session.repository.PageRequest pageRequest, long totalElements)
@RequestMapping(method=GET,
value="/findAll",
params="fieldsToForceLazy")
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public List<T> findAll(@RequestParam(required=true)
List<String> ids,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
ids - Lista de ID's@RequestMapping(value="/findWithFilter",
params={"page","size","fieldsToForceLazy"},
method=POST)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> find(@RequestBody
br.com.anteros.persistence.session.query.filter.Filter filter,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
throws Exception
filter - Objeto filtropage - Número da páginasize - Tamanho da páginaException@RequestMapping(value="/findWithFilterByRelationShip/{field}/{id}",
params={"page","size","fieldsToForceLazy"},
method=POST)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> find(@PathVariable(value="field")
String field,
@PathVariable(value="id")
String id,
@RequestBody
br.com.anteros.persistence.session.query.filter.Filter filter,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
throws Exception
filter - Objeto filtropage - Número da páginasize - Tamanho da páginaException@RequestMapping(value="/findMultipleFields",
params={"filter","fields","page","size","sort","fieldsToForceLazy"},
method=POST)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> find(@RequestParam(value="filter",required=true)
String filter,
@RequestParam(value="fields",required=true)
String fields,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="sort")
String sort,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
throws Exception
filter - String filterfields - String fieldspage - Número da páginasize - Tamanho da páginaException@RequestMapping(value="/findMultipleFieldsByRelationShip/{field}/{id}",
params={"filter","fields","page","size","sort","fieldsToForceLazy"},
method=POST)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> find(@PathVariable(value="field")
String field,
@PathVariable(value="id")
String id,
@RequestParam(value="filter",required=true)
String filter,
@RequestParam(value="fields",required=true)
String fields,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="sort")
String sort,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
throws Exception
filter - String filterfields - String fieldspage - Número da páginasize - Tamanho da páginaException@RequestMapping(value="/findByNamedQuery/{queryName}",
params={"page","size","fieldsToForceLazy"},
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findByNamedQuery(@PathVariable(value="queryName")
String queryName,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
queryName - Nome da consultapage - Número da páginasize - Tamanho da página@RequestMapping(value="/findByNamedQueryWithFilter/{queryName}",
params={"page","size","fieldsToForceLazy"},
method=POST)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findByNamedQuery(@RequestBody
br.com.anteros.persistence.session.query.filter.Filter filter,
@PathVariable(value="queryName")
String queryName,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
filter - Objeto filtroqueryName - Nome da consultapage - Número da páginasize - Tamanho da página@RequestMapping(value="/findByNamedQueryWithParams/{queryName}",
params={"page","size","parameters","fieldsToForceLazy"},
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findByNamedQuery(@PathVariable(value="queryName")
String queryName,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="parameters",required=true)
List<String> parameters,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
queryName - Nome da consultapage - Número da páginasize - Tamanho da páginaparameters - Lista de parâmetros@RequestMapping(value="/findByNamedQueryWithParamsAndFilter/{queryName}",
params={"page","size","parameters","fieldsToForceLazy"},
method=POST)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public br.com.anteros.persistence.session.repository.Page<T> findByNamedQuery(@RequestBody
br.com.anteros.persistence.session.query.filter.Filter filter,
@PathVariable(value="queryName")
String queryName,
@RequestParam(value="page",required=true)
int page,
@RequestParam(value="size",required=true)
int size,
@RequestParam(value="parameters",required=true)
List<String> parameters,
@RequestParam(value="fieldsToForceLazy")
String fieldsToForceLazy)
filter - Objeto filtroqueryName - Nome da consultapage - Número da páginasize - Tamanho da páginaparameters - Lista de parâmetros@RequestMapping(value="/count",
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public long count()
@RequestMapping(value="/exists/{id}",
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public boolean exists(@PathVariable
String id)
id - Id do objeto@RequestMapping(value="/exists",
method=GET)
@ResponseStatus(value=OK)
@ResponseBody
@Transactional(rollbackFor=java.lang.Throwable.class,
propagation=REQUIRED,
readOnly=true,
transactionManager="transactionManagerSQL")
public boolean exists(@RequestParam(required=true)
List<String> ids)
ids - Lista de id's para verificar a existência.Copyright © 2021 Anteros Tecnologia. All rights reserved.