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