Getting Information from the FESA Database

During release of FESA software or on demand information about FESA designs of FESA classes, deploy-units and instantiations are exported to the FESA database.

To improve transparency a set of scripts is available to retrieve information from the FESA database for certain use cases. The use cases were identified during work on the topic deployment system for FESA software.

Command Line Tools

The following scripts are usable by FESA developers on the asl cluster (FESA developers = members of the Linux user group fesa), /common/usr/fesa/bin should be in the PATH environment variable:

Name	Description	Additional Parameter	Usage Example
fesa-class-info	List information about FESA classes from FESA DB, expects deploy-unit and device-instance information in the DB as well	-d / -i / -p *	fesa-class-info -d/-p <class name or beginning of class name> [FESA FWK version]
fesa-class-only-info	List information about FESA classes from FESA DB, does not care about deploy-unit or device-instance information	-d / -i / -p *	fesa-class-only-info -d/-p <class name or beginning of class name> [FESA FWK version]
fesa-deploy-unit-info	List information about FESA deploy-units from FESA DB, expects device-instance information in the DB as well	-d / -i / -p *	fesa-deploy-unit-info -d/-p <deploy-unit name or beginning of deploy-unit name> [FESA FWK version]
fesa-deploy-unit-only-info	List information about FESA deploy-units from FESA DB, does not care about device-instance information in the DB as well	-d / -i / -p *	fesa-deploy-unit-only-info -d/-p <deploy-unit name or beginning of deploy-unit name> [FESA FWK version]
fesa-device-info	List information about FESA devices from FESA DB	-d / -i / -p *	fesa-device-info -d/-p <device name or beginning of device name>
fesa-fec-device-info	List FESA device information from DB per FEC, performs a status check wether the device is accessible by calling the standard property 'Version'**	-d / -i / -p *	fesa-fec-device-info -d/-p <FEC name> or fesa-fec-device-info <beginning of FEC name>
fesa-fec-info	List FEC information from FESA DB	-d / -i / -p *	fesa-fec-info -d/-p <FEC name> or fesa-fec-info <beginning of FEC name>
locate-fesa-software	Check in which database environment (development and test or production) to a device or deploy-unit is set up. Parses the CMW directory server databases.	-d / -f	locate-fesa-software -d <device name or its beginning> locate-fesa-software -f <deploy-unit name or its beginning>

To run the scripts enter the name of the scripts on the command line. If no parameters are given a short help string will be displayed.

All scripts perform wildcard searches, so the beginning of a name to search for in the FESA database is sufficient. The search is not case-sensitive as well.

If no information can be found, an empty list will be displayed.

* The parameter -d / -i / -p controls in which database environment to search. The parameter -d stands for development (and test) environment, the parameter -i stands for integration system environment, the parameter -p stands for production environment.

---

Web Interfaces

The FESA database can also be accessed via web interface. This is possible within the asl cluster.

Production Environment

https://websvcpro.acc.gsi.de/groups/cscosv/fesaweb/

Integration Environment

https://websvcint.acc.gsi.de/groups/cscosv/fesaweb/

Development Environment (ACO/SV sandbox, without any guarantee)

http://websvcdev.acc.gsi.de/groups/cscosv/web-prototype/V0/fesa/

FESA Database REST API

https://www-acc.gsi.de/wiki/FESA/FESA3RESTInterfaceToFESADB

---

** this check works only if the property 'Version' is available.

-- SolveighMatthies - 30 Jun 2016