.. java:import:: java.sql PreparedStatement

.. java:import:: java.sql ResultSet

.. java:import:: java.sql Types

.. java:import:: java.util LinkedList

.. java:import:: java.util List

.. java:import:: org.caosdb.server.database.access Access

.. java:import:: org.caosdb.server.database.backend.interfaces GetIDByNameImpl

.. java:import:: org.caosdb.server.database.exceptions TransactionException

.. java:import:: org.caosdb.server.entity EntityID

MySQLGetIDByName
================

.. java:package:: org.caosdb.server.database.backend.implementation.MySQL
   :noindex:

.. java:type:: public class MySQLGetIDByName extends MySQLTransaction implements GetIDByNameImpl

   Retrieve the entity id of an entity with the given name (or null).

   :author: Timm Fitschen

Fields
------
STMT_GET_ID_BY_NAME
^^^^^^^^^^^^^^^^^^^

.. java:field:: public static final String STMT_GET_ID_BY_NAME
   :outertype: MySQLGetIDByName

   Resolves the (primary) name of an entity to an id. This query is not necessarily unique. Therefore \ :java:ref:`STMT_AND_ROLE`\ , \ :java:ref:`STMT_NOT_ROLE`\ , and \ :java:ref:`STMT_LIMIT`\  can as additional conditions.

Constructors
------------
MySQLGetIDByName
^^^^^^^^^^^^^^^^

.. java:constructor:: public MySQLGetIDByName(Access access)
   :outertype: MySQLGetIDByName

Methods
-------
execute
^^^^^^^

.. java:method:: @Override public List<EntityID> execute(String name, String role, String limit) throws TransactionException
   :outertype: MySQLGetIDByName