Package io.vertigo.database.sql

Interface SqlManager

All Superinterfaces:
io.vertigo.core.node.component.Component, io.vertigo.core.node.component.CoreComponent, io.vertigo.core.node.component.Manager
All Known Implementing Classes:
SqlManagerImpl
public interface SqlManager extends io.vertigo.core.node.component.Manager
Manages connections to database.
Author:
pchretien

  • Field Details

    • MAIN_CONNECTION_PROVIDER_NAME

      static final String MAIN_CONNECTION_PROVIDER_NAME
      The name of the main connectionProvider.
      See Also:

  • Method Details

    • getConnectionProvider

      SqlConnectionProvider getConnectionProvider(String name)
      Parameters:
      name - ConnectionProvider name
      Returns:
      SecondaryConnectionProvider

    • executeQuery

      <O> List<O> executeQuery(SqlStatement sqlStatement, Class<O> dataType, Map<Class,io.vertigo.core.lang.BasicTypeAdapter> basicTypeAdapters, Integer limit, SqlConnection connection) throws SQLException
      Executes a sql query returning a list
      Parameters:
      sqlStatement - sqlStatement
      dataType - the return dataType of the list
      basicTypeAdapters - a list of adapters from complexTypes (not natively supported by db) to basicType (supported ones). Values are transformed from complex types to basic one before storage.
      limit - the return limit (null if no limit)
      connection - the sqlConnection
      Returns:
      the list
      Throws:
      SQLException

    • executeUpdate

      int executeUpdate(SqlStatement sqlStatement, Map<Class,io.vertigo.core.lang.BasicTypeAdapter> basicTypeAdapters, SqlConnection connection) throws SQLException
      Executes a sql query returning the number of modified rows.
      Parameters:
      sqlStatement - sqlStatement
      basicTypeAdapters - a list of adapters from complexTypes (not natively supported by db) to basicType (supported ones). Values are transformed from complex types to basic one before storage.
      connection - sqlConnection
      Returns:
      either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing
      Throws:
      SQLException

    • executeUpdateWithGeneratedKey

      <O> io.vertigo.core.lang.Tuple<Integer,O> executeUpdateWithGeneratedKey(SqlStatement sqlStatement, SqlDialect.GenerationMode generationMode, String columnName, Class<O> dataType, Map<Class,io.vertigo.core.lang.BasicTypeAdapter> basicTypeAdapters, SqlConnection connection) throws SQLException
      Executes a sql query returning the number of modified rows.
      Parameters:
      sqlStatement - sqlStatement
      generationMode - the generation methode
      columnName - the column name (of the generated key)
      dataType - the dataType of the generated key
      basicTypeAdapters - a list of adapters from complexTypes (not natively supported by db) to basicType (supported ones). Values are transformed from complex types to basic one before storage.
      connection - sqlConnection
      Returns:
      a tuple with the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing and the generated key
      Throws:
      SQLException

    • executeBatch

      OptionalInt executeBatch(SqlStatement sqlStatement, Map<Class,io.vertigo.core.lang.BasicTypeAdapter> basicTypeAdapters, SqlConnection connection) throws SQLException
      Executes the batch .
      Parameters:
      sqlStatement - sqlStatement
      basicTypeAdapters - a list of adapters from complexTypes (not natively supported by db) to basicType (supported ones). Values are transformed from complex types to basic one before storage.
      connection - sqlConnection
      Returns:
      the SUM of row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing if no info available an empty Optional is returned
      Throws:
      SQLException - Si erreur

    • executeBatchWithGeneratedKeys

      <O> io.vertigo.core.lang.Tuple<Integer,List<O>> executeBatchWithGeneratedKeys(SqlStatement sqlStatement, SqlDialect.GenerationMode generationMode, String columnName, Class<O> dataType, Map<Class,io.vertigo.core.lang.BasicTypeAdapter> basicTypeAdapters, SqlConnection connection) throws SQLException
      Throws:
      SQLException