Examples with IMetaStoreElement org.pentaho.metastore.api.IMetaStoreElement used on opensource projects

Example 31 with IMetaStoreElement

use of org.pentaho.metastore.api.IMetaStoreElement in project pentaho-kettle by pentaho.

the class KettleMetaStoreTestBase method generateCustomerDimensionElement.

private IMetaStoreElement generateCustomerDimensionElement(IMetaStore metaStore, IMetaStoreElementType elementType) throws MetaStoreException {
    IMetaStoreElement element = metaStore.newElement();
    element.setElementType(elementType);
    element.setName(CUSTOMER_DIMENSION_NAME);
    element.addChild(metaStore.newAttribute("description", "This is the shared customer dimension"));
    element.addChild(metaStore.newAttribute("physical_table", "DIM_CUSTOMER"));
    IMetaStoreAttribute fieldsElement = metaStore.newAttribute("fields", null);
    element.addChild(fieldsElement);
    // A technical key
    // 
    IMetaStoreAttribute fieldElement = metaStore.newAttribute("field_0", null);
    fieldsElement.addChild(fieldElement);
    fieldElement.addChild(metaStore.newAttribute("field_name", "Customer TK"));
    fieldElement.addChild(metaStore.newAttribute("field_description", "Customer Technical key"));
    fieldElement.addChild(metaStore.newAttribute("field_phyiscal_name", "customer_tk"));
    fieldElement.addChild(metaStore.newAttribute("field_kettle_type", "Integer"));
    // A version field
    // 
    fieldElement = metaStore.newAttribute("field_1", null);
    fieldsElement.addChild(fieldElement);
    fieldElement.addChild(metaStore.newAttribute("field_name", "version field"));
    fieldElement.addChild(metaStore.newAttribute("field_description", "dimension version field (1..N)"));
    fieldElement.addChild(metaStore.newAttribute("field_phyiscal_name", "version"));
    fieldElement.addChild(metaStore.newAttribute("field_kettle_type", "Integer"));
    // Natural key
    // 
    fieldElement = metaStore.newAttribute("field_2", null);
    fieldsElement.addChild(fieldElement);
    fieldElement.addChild(metaStore.newAttribute("field_name", "Customer ID"));
    fieldElement.addChild(metaStore.newAttribute("field_description", "Customer ID as a natural key of this dimension"));
    fieldElement.addChild(metaStore.newAttribute("field_phyiscal_name", "customer_id"));
    fieldElement.addChild(metaStore.newAttribute("field_kettle_type", "Integer"));
    // Start date
    // 
    fieldElement = metaStore.newAttribute("field_3", null);
    fieldsElement.addChild(fieldElement);
    fieldElement.addChild(metaStore.newAttribute("field_name", "Start date"));
    fieldElement.addChild(metaStore.newAttribute("field_description", "Start of validity of this dimension entry"));
    fieldElement.addChild(metaStore.newAttribute("field_phyiscal_name", "start_date"));
    fieldElement.addChild(metaStore.newAttribute("field_kettle_type", "Date"));
    // End date
    // 
    fieldElement = metaStore.newAttribute("field_4", null);
    fieldsElement.addChild(fieldElement);
    fieldElement.addChild(metaStore.newAttribute("field_name", "End date"));
    fieldElement.addChild(metaStore.newAttribute("field_description", "End of validity of this dimension entry"));
    fieldElement.addChild(metaStore.newAttribute("field_phyiscal_name", "end_date"));
    fieldElement.addChild(metaStore.newAttribute("field_kettle_type", "Date"));
    // 
    for (int i = 5; i <= 10; i++) {
        fieldElement = metaStore.newAttribute("field_" + i, null);
        fieldsElement.addChild(fieldElement);
        fieldElement.addChild(metaStore.newAttribute("field_name", "Field name " + i));
        fieldElement.addChild(metaStore.newAttribute("field_description", "Field description " + i));
        fieldElement.addChild(metaStore.newAttribute("field_phyiscal_name", "physical_name_" + i));
        fieldElement.addChild(metaStore.newAttribute("field_kettle_type", "String"));
    }
    // Some security
    // 
    element.setOwner(metaStore.newElementOwner("joe", MetaStoreElementOwnerType.USER));
    // The "users" role has read/write permissions
    // 
    IMetaStoreElementOwner usersRole = metaStore.newElementOwner("users", MetaStoreElementOwnerType.ROLE);
    MetaStoreOwnerPermissions usersRoleOwnerPermissions = new MetaStoreOwnerPermissions(usersRole, MetaStoreObjectPermission.READ, MetaStoreObjectPermission.UPDATE);
    element.getOwnerPermissionsList().add(usersRoleOwnerPermissions);
    return element;
}