Quick (and simple) Tip 2: Zipping old files

As a follow up to my earlier post on cleaning up old files, here is a modified version that zips and deletes. This would be very handy for log directories. <cfset logdir = "/Applications/ColdFusion8/logs">

<cfdirectory action=”list” directory=”#logdir#” name=”files” type=”file”>

<cfset thirtydaysago = dateAdd(“d”, -50, now())>

<!— get older files —> <cfquery name=”oldfiles” dbtype=”query”> select name from files where datelastmodified < <cfqueryparam cfsqltype=”cf_sql_timestamp” value=”#thirtydaysago#”> and upper(name) not like ‘%.ZIP’ </cfquery>

<cfoutput>Out of #files.recordCount# files, there are #oldfiles.recordCount# to zip.</cfoutput>

<cfif oldfiles.recordCount> <cfloop query=”oldfiles”> <cfzip file=”#logdir#/#name#.zip” source=”#logdir#/#name#” action=”zip”> <cffile action=”delete” file=”#logdir#/#name#”> </cfloop> </cfif> </code>

This code is the exact same as the last version except for:

  • I switched the thirtydaysago variable to actually be 50 days ago. This was just to give me a good dataset in my log directory. The date really isn't critical.
  • My query of queries to get old files now also filters out any zips. Notice the use of upper. This ensures the case doesn't matter.
  • I added the cfzip tag, a new feature of ColdFusion 8. Nice and easy, right? </ul>
Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support.

Lafayette, LA https://www.raymondcamden.com