How to delete packages created before certain date from package manager using curl in CQ / WEM

Use case: You upload CQ packages a lot and end up having many packages in package manager. This cause package manager to load slow, also cause un necessary space consumption.

Solution: You can use following unix script to delete packages created before (Or after) certain date.

Please change variable based on your need.

I have commented curl command for now, First see if right package is getting deleted then uncomment curl command to delete.

#!/bin/bash

# Author: upadhyay.yogesh@gmail.com

# The host and port of the source server

SOURCE="localhost:4504"

# The user credentials on the source server (username:password)

SOURCE_CRED="admin:admin"

#This is your package location in CRX. Change this package location based on your need

PACKAGE_LOCATION="/etc/packages/my_packages"

# This is date after which you want to delete all package <YYYY>-<MM>-<DD>

DATE="2011-12-11"

#############################################################################

#Query to get all files uploaded after certain date

ALL_PATHS=`curl -s -u $SOURCE_CRED "$SOURCE/bin/querybuilder.json?path=$PACKAGE_LOCATION&type=nt:file&p.limit=-1&daterange.property=jcr:created&daterange.upperBound=2011-11-11&daterange.upperOperation=

echo "$ALL_PATHS"

for SINGLE_PATH in $ALL_PATHS

do

# I have commented this line. Please see what is getting deleted before deleting it

# curl -u $SOURCE_CRED -X POST http://$SOURCE/crx/packmgr/service/.json$SINGLE_PATH?cmd=delete

done

You can also do if else within script to compare package name

if [[ $string =~ .*My.* ]]

then

DELETE PACKAGE

fi

Please check http://dev.day.com/docs/en/crx/current/how_to/package_manager.html#Managing Packages on the Command Line for different curl options

IMPORTANT NOTE: Please test this script before use. I have not tested this script yet :)