Open Source Document Management System | OpenKM

CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`()
BEGIN
DECLARE finished INTEGER default 0;
DECLARE docId varchar(100) default "";
DECLARE maxId INTEGER;

DECLARE curs CURSOR FOR select NDV_PARENT from okmdb.okm_node_document_version as T2 where not exists ( select * from okmdb.okm_node_property as T1 where T1.NPG_NODE = T2.NDV_PARENT and T1.NPG_NAME='okp:OPENKM.USER');
DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;
    
  OPEN curs;
    select max(NPG_ID) + 1 into maxId from okmdb.okm_node_property;
    insertRecords:LOOP 
		FETCH curs into docId;
        if finished = 1 then
			leave insertRecords;
        end if;
	insert into okmdb.okm_node_property (NPG_ID, NPG_GROUP, NPG_NAME, NPG_VALUE, NPG_NODE) 
    values (maxId, 'okg:OPENKM','okp:OPENKM.USER', (select NDV_AUTHOR from okmdb.okm_node_document_version where NDV_PARENT = docId), docId);
    set maxId = maxId + 1;
    END LOOP insertRecords;
    CLOSE curs;
END

public class OpenKMTest {
    public static void main(String[] args) {
        String host = "http://localhost:8180/OpenKM";
        String username = "okmAdmin";
        String password = "admin";
        OKMWebservices ws = OKMWebservicesFactory.newInstance(host, username, password);
        
       try {        
               	List<FormElement> fElements = new ArrayList<>();
                Input user = new Input();
                user.setName("okg:OPENKM.USER");
                user.setValue("MyUser");
                fElements.add(user);
                ws.setPropertyGroupProperties("4ac33d91-9bd2-413f-a4c3-1fb1079f4e5b","okg:OPENKM", fElements);
                System.out.println("Done");
            } catch (Exception e) {
                e.printStackTrace();
            }
        } 
 }