Open Source Document Management System | OpenKM

for (DatabaseMetadataValue dmv : DatabaseMetadataDAO.executeValueQuery(DatabaseMetadataUtils.buildQuery("country", "", "$country_name"))) {
    Window.alert(dmv.toString();
    }

[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building OpenKM Web Application 6.3.7-DEV
[INFO] ------------------------------------------------------------------------
.
.
.
.
[INFO] --- gwt-maven-plugin:2.4.0:compile (default-cli) @ openkm ---
[INFO] Compiling module com.openkm.frontend.Main
[INFO]    Validating newly compiled units
[INFO]       Ignored 6 units with compilation errors in first pass.
[INFO] Compile with -strict or with -logLevel set to TRACE or DEBUG to see all errors.
[INFO]    [ERROR] Errors in 'file:/home/openkm/Development/workspace/openkm/src/main/java/com/openkm/extension/frontend/client/DBTest.java'
[INFO]       [ERROR] Line 39:  The import com.openkm.core.DatabaseException cannot be resolved
[INFO]       [ERROR] Line 40:  The import com.openkm.dao.DatabaseMetadataDAO cannot be resolved
[INFO]       [ERROR] Line 41:  The import com.openkm.dao.bean.DatabaseMetadataValue cannot be resolved
[INFO]       [ERROR] Line 42:  The import com.openkm.util.DatabaseMetadataUtils cannot be resolved
[INFO]       [ERROR] Line 64:  DatabaseMetadataValue cannot be resolved to a type
[INFO]       [ERROR] Line 64:  DatabaseMetadataDAO cannot be resolved
[INFO]       [ERROR] Line 64:  DatabaseMetadataUtils cannot be resolved
[INFO]       [ERROR] Line 68:  DatabaseException cannot be resolved to a type
[INFO]       [ERROR] Line 73:  DatabaseMetadataValue cannot be resolved to a type
[INFO]       [ERROR] Line 73:  DatabaseMetadataDAO cannot be resolved
[INFO]       [ERROR] Line 77:  DatabaseException cannot be resolved to a type
[INFO]    [ERROR] Cannot proceed due to previous errors
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 41.321 s
[INFO] Finished at: 2018-07-25T11:17:50+02:00
[INFO] Final Memory: 23M/174M
[INFO] ------------------------------------------------------------------------
.
.
.
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

package com.openkm.frontend.client;

import java.util.List;
import java.util.Map;

import com.google.gwt.core.client.GWT;
import com.google.gwt.user.client.rpc.AsyncCallback;
import com.openkm.extension.frontend.client.bean.GWTExtendedSecurity;
import com.openkm.frontend.client.extension.comunicator.GeneralComunicator;
import com.openkm.frontend.client.service.OKMDatabaseMetadataService;
import com.openkm.frontend.client.service.OKMDatabaseMetadataServiceAsync;

public class Example {
    private final OKMDatabaseMetadataServiceAsync metadataService = (OKMDatabaseMetadataServiceAsync) GWT.create(OKMDatabaseMetadataService.class);

    public void test() {
        // get sequence
        metadataService.getNextSequenceValue("table_name", "col_name" , new AsyncCallback<Double>() {
            @Override
            public void onSuccess(Double result) {
                int value = result.intValue();
            }

            @Override
            public void onFailure(Throwable caught) {
            }
        });

        // create value
        final GWTExtendedSecurity security = new GWTExtendedSecurity();
        security.setUuid("some uuid");
        security.setName("some name");
        security.setType(GWTExtendedSecurity.TYPE_ROLE);
        security.setRealTable(GWTExtendedSecurity.MV_TABLE_NAME);
        metadataService.createValue(security.restoreToMap(), new AsyncCallback<Double>() {
            @Override
            public void onSuccess(Double result) {
                // created
            }

            @Override
            public void onFailure(Throwable caught) {
            }
        });

        // Execute query
    String filter = "$" + GWTExtendedSecurity.MV_COLUMN_NAME_UUID + "='some uuid'";
        metadataService.executeValueQuery(GWTExtendedSecurity.MV_TABLE_NAME, filter, "", new AsyncCallback<List<Map<String,String>>>() {
            @Override
            public void onSuccess(List<Map<String, String>> result) {
                if (result.size() > 0) {
                    GWTExtendedSecurity security = new GWTExtendedSecurity();
                    security.loadFromMap(result.get(0));
                }
            }

            @Override
            public void onFailure(Throwable caught) {
                GeneralComunicator.showError("executeValueQuery", caught);
            }
        });

        // Update value
        security.setName("some name changed");
        metadataService.updateValue(security.restoreToMap(), new AsyncCallback<Object>() {
            @Override
            public void onSuccess(Object result) {
            }

            @Override
            public void onFailure(Throwable caught) {
            }
        });

        // Delete value
        metadataService.deleteValue(security.restoreToMap(), new AsyncCallback<Object>() {
            @Override
            public void onSuccess(Object result) {
            }

            @Override
            public void onFailure(Throwable caught) {
            }
        });
    }
}