Forum Discussion

Tris's avatar
Tris
Contributor
6 years ago

Delete a file based on date?

Hi all,   I've been looking for a way to manage files by deleting based on the files creation date.   I've seen the aqFile.GetCreationTime method, however this appears to want a specific file nam...
Tris's avatar
Tris
Contributor

FYI - I've manage to do exactly as I said I would try above, taken a matter of minutes via batch file.

 

I made a batch file which TC will call and that will manage the files older than x days, see batchfile code below.

 

ForFiles /p "C:\FOLDER" /d -14 /c "cmd /c del @file"

/d sets the days value you are looking to delete, the example is going to delete anything older than 14 days

/c is for the command string which deletes the files which are older than 14 days in the example above

 

note, if you have sub-directories you want to clear out use /s like so... "C;FOLDER" /s 

 

Note - still interested if my original question is possible, find TC is rather limited in a few ways and ideally want to keep as much of the functionality within the program if possible.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
6 years ago

I would use a combination of several objects.  You should use the aqFileSystem object and the method "findfiles" to retrieve a list of files.  Then you can iterate through that list (all aqFileInfo objects) and, if the CreatedDate matches what you're looking for, delete it.

Relveant objects:

 

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqfilesystem/findfiles.html

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqobjiterator/index.html

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqfileinfo/index.html

  • Tris's avatar
    Tris
    Contributor
    6 years ago

    Thanks Tristaanogre, will look in to this later today, think it's a case of getting the item info back, from what I remember I could only get the number of files to be returned, so will have another stab at it with fresh eyes.

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      6 years ago

      The aqFileSystem.FindFiles method will return a collection of aqFileInfo objects for all files that match the directory search.  You then iterate through that and check the CreationDate and, if it matches what you want, simply call Delete.

      • Tris's avatar
        Tris
        Contributor
        6 years ago

        Finally got round to being able to look in to this and have managed to get this working :)

         

        Thought I'd share my code in case this helps someone in the future.

         

        function LogFinder()
{
  var foundFiles, aFile;
  foundFiles = aqFileSystem.FindFiles("C:\\Automation\\Log\\All", "*");
  if (foundFiles != null)
    while (foundFiles.HasNext())
    {
      aFile = foundFiles.Next();
      OldLogsDelete(aFile);
    }
  else
    Log.Message("No files were found.");
}

function OldLogsDelete(aFile){
  var DateTime = aqDateTime.Now();
  var DateTimeMinusXDays = aqDateTime.AddDays(DateTime, -14);
  if (aFile.DateCreated < DateTimeMinusXDays)
    {
      FilePathString = aqConvert.VarToStr(aFile.Path)
      aqFileSystem.DeleteFile(FilePathString);
      Log.Message(FilePathString + " deleted" );
    }
}