Data Management

Application

Here you have the opportunity to test the first version of the 'Project Editor' of the Datamanagement tool.
[Download] War archive

Configuration

If you have a working J4Fry context with a j4FryDS datasource it should run out of the box after installation of the sql scripts (execute in psql, lookup tables must be present):

DROP TABLE Project;
CREATE TABLE Project (
SatzId SERIAL NOT NULL
, Name VARCHAR(50)
, Description VARCHAR(100)
, Version INTEGER NOT NULL
, PRIMARY KEY (SatzId)
);

create sequence t_project_satzid_seq;
insert into t_aspectCollection (aspectCollectionKey, aspectKey, aspectValue, version) values (1000, 'enum', 'labels', 1);
insert into t_aspectCollection (aspectCollectionKey, aspectKey, aspectValue, version) values (1000, 'language', 'de', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'projectChooser', 'Projekt Editor', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'createProject', 'Projekt anlegen', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'editProject', 'Projektstammdaten', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'useProject', 'Projekt bearbeiten', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'deleteProject', 'Projekt loeschen', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'saveProject', 'Projekt speichern', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'selectProject', 'Projektauswahl', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'projectName', 'Projektname', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'projectDescription', 'Projektbeschreibung', 1);
insert into t_lookup (aspectCollectionKey, key, value, version) values (1000, 'sureToDelete', 'Sind Sie sicher, dass Sie dieses Projekt loeschen wollen', 1);

The WEB-INF folder also contains the sources including the modified TransactionManager and modified lookups based on the new TransactionManager. We should separate all three of them (TransactionManager, Lookups and ProjektManager) when Michael has sent his proposal for our module structure. The language is determined in the LanguageBean by the first 2 letters of the "Accept-language" header your browser sends - these scripts are obviously limited to "de". I know this is suboptimal, the language should be retrieved from the portal in the future.

Call http://localhost:8080/J4Fry/Projects/ProjectChooser.jsf to test it.
If it doesn't run: I've included http://localhost:8080/J4Fry/DBTest.jsp which runs without myfaces and without hibernate and only tests your database connectivity and lists the contents of your lookups table.

Design Documents

The data model which is in the Clay format
[Download] Datamanagement Clay Model

For better understanding we've got some example data
[View] Example data

Last but not least we've got the drafts