.. java:import:: com.google.common.base Objects

.. java:import:: java.sql ResultSet

.. java:import:: java.sql SQLException

.. java:import:: java.util AbstractMap.SimpleEntry

.. java:import:: java.util ArrayList

.. java:import:: java.util Deque

.. java:import:: java.util HashMap

.. java:import:: java.util Iterator

.. java:import:: java.util LinkedList

.. java:import:: java.util List

.. java:import:: java.util Map

.. java:import:: java.util Map.Entry

.. java:import:: java.util.stream Collectors

.. java:import:: org.caosdb.server.database.proto FlatProperty

.. java:import:: org.caosdb.server.database.proto ProtoProperty

.. java:import:: org.caosdb.server.database.proto SparseEntity

.. java:import:: org.caosdb.server.database.proto VerySparseEntity

.. java:import:: org.caosdb.server.datatype AbstractCollectionDatatype

.. java:import:: org.caosdb.server.datatype CollectionValue

.. java:import:: org.caosdb.server.datatype GenericValue

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

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

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

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

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

.. java:import:: org.caosdb.server.entity.wrapper Property

DatabaseUtils
=============

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

.. java:type:: public class DatabaseUtils

Methods
-------
bytes2UTF8
^^^^^^^^^^

.. java:method:: public static final String bytes2UTF8(byte[] bytes)
   :outertype: DatabaseUtils

deriveStage1Inserts
^^^^^^^^^^^^^^^^^^^

.. java:method:: public static int deriveStage1Inserts(List<Property> stage1Inserts, EntityInterface e)
   :outertype: DatabaseUtils

deriveStage2Inserts
^^^^^^^^^^^^^^^^^^^

.. java:method:: public static void deriveStage2Inserts(List<Property> stage2Inserts, List<Property> stage1Inserts, Deque<EntityID> replacementIds, EntityInterface entity)
   :outertype: DatabaseUtils

parseEntityResultSet
^^^^^^^^^^^^^^^^^^^^

.. java:method:: public static SparseEntity parseEntityResultSet(ResultSet rs) throws SQLException
   :outertype: DatabaseUtils

   Helper function for parsing MySQL results.

   This function creates SparseEntities and parses all fields which belong to a SparseEntity: id, name, role, acl, description, datatype, and the file properties.

   Never returns null.

parseFromProtoProperties
^^^^^^^^^^^^^^^^^^^^^^^^

.. java:method:: public static ArrayList<Property> parseFromProtoProperties(EntityInterface entity, List<ProtoProperty> protos)
   :outertype: DatabaseUtils

parseNameRoleACL
^^^^^^^^^^^^^^^^

.. java:method:: public static SparseEntity parseNameRoleACL(ResultSet rs) throws SQLException
   :outertype: DatabaseUtils

   Helper function for parsing MySQL results.

   This function creates SparseEntities and parses only the name, the role and the acl of an entity.

   Never returns null.

parseOverrides
^^^^^^^^^^^^^^

.. java:method:: public static void parseOverrides(List<ProtoProperty> properties, ResultSet rs) throws SQLException
   :outertype: DatabaseUtils

parseParentResultSet
^^^^^^^^^^^^^^^^^^^^

.. java:method:: public static LinkedList<VerySparseEntity> parseParentResultSet(ResultSet rs) throws SQLException
   :outertype: DatabaseUtils

parsePropertyResultset
^^^^^^^^^^^^^^^^^^^^^^

.. java:method:: public static List<ProtoProperty> parsePropertyResultset(ResultSet rs) throws SQLException
   :outertype: DatabaseUtils

transformToDeepPropertyTree
^^^^^^^^^^^^^^^^^^^^^^^^^^^

.. java:method:: @SuppressWarnings public static LinkedList<ProtoProperty> transformToDeepPropertyTree(List<ProtoProperty> properties, boolean isHead)
   :outertype: DatabaseUtils