Entity Engine

scipio-admin-entity-data-maintenance

The entity engine provides you with database related utilities, such as data maintenance tools, auto-generated entity references, performance and status tools, as well as utility functions.


Check/Update Database

“Entity Engine » Check/Update Database” can be used to run database specific actions, such as create/remove primary keys, remove specific entities (tables), update character set and alike.

All database actions are permanent and can destabilize the system. Perform at your own risk!

Connection Pool Status

“Entity Engine » Connection Pool Status” lists the current state of the available connection pool(s). Can be used to review the current entity configuration.


Entity Data Maintenance

“Entity Engine » Entity Data Maintenance” provides an overview of all available entities & view-entities. The list can be filtered by alphabet or through the search dialog:

scipio-admin-entity-data-maintenance_search

Generally speaking, this view is meant as an easy interface to navigate the database tables, view table information & relationships and create or edit individual database entries. The database table provides direct access to relationships (“Reln”), and the stored data via find (“Find”) or view-all (“All”) function.

Relations

relations
All entity relations are automatically listed, as they are defined by the entity definitions.  Each relation will show the relation type and field. “FK Name” specifies the foreign key, which is being used inside the entity defintion for aggregation functions.

Entity Data

scipio-admin-find-values-for-entity-imagedataresource

Entity data is automatically listed inside of a table underneath the entity definition. The lastUpdatedStamp, lastUpdatedTxtStamp, createdStamp and createdTxtStamp are automatically added to each entity by the system.

It is possible to view and delete individual rows, as required. It is important to understand, however, that each delete action is followed by a series of events, in which each relation is tested for now defunct relations. Delete actions will be rolled back and an error thrown, if the entry is required by a different, related entity.

entity_view

The view- action provides the current value, access to related values and an xml representation, that can be copied and used for seed- or imported data. Create & Edit actions are available to create and update new values.


Entity Reference (Interactive/PDF/Static)

“Entity Engine » Entity Reference (Interactive/PDF/Static)” provides auto-generated information on the current entity layout. Can be used to gather information on the database architecture easily. For further information on the overall entity architecture, we highly recommend the following :


Entity SQL Processor

All database actions are permanent and can destabilize the system. Perform at your own risk!
 Individual SQL statements can be run through the “Entity Engine » Entity SQL Processor”. The entity-group “org.ofbiz” should be used for modifications on current system data (tenant is used on multi-tenant systems only). All SQL commands have to be entered without a trailing ‘;’. The camel-case used within the entity reference & data maintenance screens are auto-transformed, replacing the new words with a leading ‘_’.

Example SQL request:

SELECT * FROM JOB_SANDBOX WHERE STATUS_ID IN ('SERVICE_PENDING')

Entity Sync Status

“Entity Engine » Entity Sync Status” lists the current entity synchronisation services, if required. Entity synchronisation is a concept mostly used in POS systems and not common for a generic ERP solution. If required, the tool can be used to trigger the synchronisation services and load external data remotely.


Performance Tests

“Entity Engine » Performance Tests” will run several entity tests and print the results in a table. Current tests include:

  • Multiple Select statements
  • CRUD (create,update,delete) statements
  • Calls to the cache

Scipio Data Generator Services

“Entity Engine » Scipio Data Generator Services” lists a set of services that can be used to auto-generate demo data. The services provided are most useful for generating current data in development environments, where it is often required by developers for functional testing. Each service gives the option to set the number of records added and a limit to the time-interval in which they are created.


Scipio Utility Services

“Entity Engine » Scipio Utility Services” provides entity specific services to reload data (mostly seed data) on runtime.