Sample script that queries the JCR and updates property

aem-jcr-update-sample-script.groovy

/*This method is used to Query the JCR and find results as per the Query.*/
def buildQuery(parent) {
    def queryManager = session.workspace.queryManager;
    def statement = 'select * from [nt:file] as t where ISDESCENDANTNODE(['+parent+']) AND NAME() LIKE \'%.jpg\'';
    queryManager.createQuery(statement, 'JCR-SQL2');
}

final def query = buildQuery(<replace_parent_path_here>);
final def result = query.execute()

count = 0;
//Get initial number of nodes
println 'No Of nodes found :' + result.nodes.size();

result.nodes.each { 
    node ->
    String nodePath = node.path;
    //check if has content
    if(node.hasNode('jcr:content')){
        def contentNode = node.getNode('jcr:content');
        //check if has mimeType
        if(contentNode.hasProperty('jcr:mimeType')){
            contentNode.setProperty('jcr:mimeType', 'image/jpeg')
            count ++;
        }
        //Log the path updated
        println 'updated --' + contentNode ;
        //Save the session
        session.save();
    }
}
//Verify if all nodes updated
println 'Number of nodes updated: ' + count;