SqlQueryImpl (diego 2023.7.8 API)

diego.db.SqlQueryImpl

All Implemented Interfaces and Traits:: SqlQuery

@groovy.util.logging.Slf4j
class SqlQueryImpl
extends java.lang.Object
implements SqlQuery

Constructor Summary

Constructors
Constructor and description
`SqlQueryImpl(org.hibernate.Session session, java.lang.String sql)`

Methods Summary

Methods
Type Params	Return Type	Name and description
	`SqlQuery`	`bind(java.lang.Object bean)`
	`void`	`executeUpdate()`
	`java.util.Map<java.lang.String, java.lang.Object>`	`findRow()` Returns: A single row from the database that matches the criteria of the query.
`<T>`	`T`	`findRow(java.lang.Class<T> type)`
	`java.util.List<java.util.Map<java.lang.String, java.lang.Object>>`	`findRows()` Returns: Rows from the database matching the criteria of the query.
`<T>`	`java.util.List<T>`	`findRows(java.lang.Class<T> type)`
`<T extends Serializable>`	`T`	`findScalar(java.lang.Class<T> resultType)`
`<T extends Serializable>`	`java.util.List<T>`	`findScalarList(java.lang.Class<T> type)`
`<T>`	`java.util.List<T>`	`findValueList(java.lang.Class<T> type)`
`<T>`	`protected static T`	`mapToBean(java.lang.Class<T> type, java.util.Map<java.lang.String, java.lang.Object> row)` Creates an instance of T filled with the data from a database query.
	`SqlQueryImpl`	`param(java.lang.String name, java.lang.Object value)`
	`SqlQueryImpl`	`params(java.lang.Object[] positionalParams)`
	`SqlQueryImpl`	`params(java.util.Map<java.lang.String, java.lang.Object> namedParameters)`
	`SqlQuery`	`setFirstRow(int firstRow)`
	`SqlQuery`	`setMaxRows(int maxRows)`
	`static java.lang.String`	`toCamelCase(java.lang.String str)`

Inherited Methods Summary

Inherited Methods
Methods inherited from class	Name
`class java.lang.Object`	`java.lang.Object#wait(long, int), java.lang.Object#wait(), java.lang.Object#wait(long), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#notify(), java.lang.Object#notifyAll()`

- Constructor Detail
  - SqlQueryImpl(org.hibernate.Session session, java.lang.String sql)
- Method Detail
  - SqlQuery bind(java.lang.Object bean)
  - @javax.transaction.Transactional
    void executeUpdate()
  - java.util.Map<java.lang.String, java.lang.Object> findRow()
    
    Returns:
    A single row from the database that matches the criteria of the query.
  - <T> T findRow(java.lang.Class<T> type)
  - java.util.List<java.util.Map<java.lang.String, java.lang.Object>> findRows()
    
    Returns:
    Rows from the database matching the criteria of the query.
  - <T> java.util.List<T> findRows(java.lang.Class<T> type)
  - <T extends Serializable> T findScalar(java.lang.Class<T> resultType)
  - <T extends Serializable> java.util.List<T> findScalarList(java.lang.Class<T> type)
  - <T> java.util.List<T> findValueList(java.lang.Class<T> type)
  - <T> protected static T mapToBean(java.lang.Class<T> type, java.util.Map<java.lang.String, java.lang.Object> row)
    
    Creates an instance of T filled with the data from a database query.
    Parameters:
    type - The Bean type
    row - Data retrieved from the database
    Returns:
    An instance of T with its values set from the row data
  - SqlQueryImpl param(java.lang.String name, java.lang.Object value)
  - SqlQueryImpl params(java.lang.Object[] positionalParams)
  - SqlQueryImpl params(java.util.Map<java.lang.String, java.lang.Object> namedParameters)
  - SqlQuery setFirstRow(int firstRow)
  - SqlQuery setMaxRows(int maxRows)
  - static java.lang.String toCamelCase(java.lang.String str)
    
    Converts a snake_case String to camelCase. If there is a camel case pattern anywhere in the input string, the input string is returned as is.
    
    At the very least, the input string is converted to lower case.
    
    Parameters:
    str - The input string.
    Returns:
    The input string in camelCase.

Summary:
Constructor
Method

| Detail:
Constructor
Method

Groovy Documentation

[Groovy] Class SqlQueryImpl

Constructor Summary

Methods Summary

Inherited Methods Summary

Constructor Detail

SqlQueryImpl(org.hibernate.Session session, java.lang.String sql)

Method Detail

SqlQuery bind(java.lang.Object bean)

@javax.transaction.Transactional
void executeUpdate()

java.util.Map<java.lang.String, java.lang.Object> findRow()

<T> T findRow(java.lang.Class<T> type)

java.util.List<java.util.Map<java.lang.String, java.lang.Object>> findRows()

<T> java.util.List<T> findRows(java.lang.Class<T> type)

<T extends Serializable> T findScalar(java.lang.Class<T> resultType)

<T extends Serializable> java.util.List<T> findScalarList(java.lang.Class<T> type)

<T> java.util.List<T> findValueList(java.lang.Class<T> type)

<T> protected static T mapToBean(java.lang.Class<T> type, java.util.Map<java.lang.String, java.lang.Object> row)

SqlQueryImpl param(java.lang.String name, java.lang.Object value)

SqlQueryImpl params(java.lang.Object[] positionalParams)

SqlQueryImpl params(java.util.Map<java.lang.String, java.lang.Object> namedParameters)

SqlQuery setFirstRow(int firstRow)

SqlQuery setMaxRows(int maxRows)

static java.lang.String toCamelCase(java.lang.String str)

[Groovy] Class SqlQueryImpl

Constructor Summary

Methods Summary

Inherited Methods Summary

Constructor Detail

SqlQueryImpl(org.hibernate.Session session, java.lang.String sql)

Method Detail

SqlQuery bind(java.lang.Object bean)

@javax.transaction.Transactionalvoid executeUpdate()

java.util.Map<java.lang.String, java.lang.Object> findRow()

<T> T findRow(java.lang.Class<T> type)

java.util.List<java.util.Map<java.lang.String, java.lang.Object>> findRows()

<T> java.util.List<T> findRows(java.lang.Class<T> type)

<T extends Serializable> T findScalar(java.lang.Class<T> resultType)

<T extends Serializable> java.util.List<T> findScalarList(java.lang.Class<T> type)

<T> java.util.List<T> findValueList(java.lang.Class<T> type)

<T> protected static T mapToBean(java.lang.Class<T> type, java.util.Map<java.lang.String, java.lang.Object> row)

SqlQueryImpl param(java.lang.String name, java.lang.Object value)

SqlQueryImpl params(java.lang.Object[] positionalParams)

SqlQueryImpl params(java.util.Map<java.lang.String, java.lang.Object> namedParameters)

SqlQuery setFirstRow(int firstRow)

SqlQuery setMaxRows(int maxRows)

static java.lang.String toCamelCase(java.lang.String str)

@javax.transaction.Transactional
void executeUpdate()