Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The <a href="http://wix.sourceforge.net/manual-wix3/wix_xsd_removefile.htm" rel="nofollow">RemoveFile element</a> is designed to do exactly this. You use this to teach MSI to remove application data it didn't install. The advantage is during a rollback the files will be put back in place.</p> <p>You can also use the RemoveFolder element to delete the entire directory. Generally the concept is to * the file removal and specify the folder also. This isn't recursive so you need to do this for any subdirectories that might have got created also.</p> <p>Writing custom actions is just reinventing the wheel and increases installer fragility. It should only be used when the subdirectories cannot be known in advance. In that situation the ideal story is to use temp rows in MSI to dynamically emit the rows into the MSI at install time and let MSI handle thea actual delete. This allows the rollback functionality to still work.</p> <p>Here is a really simple version of what that would look like. It could be improved by making it data driven from a custom table instead of constant strings for ComponentID and DirectoryID.</p> <pre><code> public class RecursiveDeleteCustomAction { [CustomAction] public static ActionResult RecursiveDeleteCosting(Session session) { // SOMECOMPONENTID is the Id attribute of a component in your install that you want to use to trigger this happening const string ComponentID = "SOMECOMPONENTID"; // SOMEDIRECTORYID would likely be INSTALLDIR or INSTALLLOCATION depending on your MSI const string DirectoryID = "SOMEDIRECTORYID"; var result = ActionResult.Success; int index = 1; try { string installLocation = session[DirectoryID]; session.Log("Directory to clean is {0}", installLocation); // Author rows for root directory // * means all files // null means the directory itself var fields = new object[] { "CLEANROOTFILES", ComponentID, "*", DirectoryID, 3 }; InsertRecord(session, "RemoveFile", fields); fields = new object[] { "CLEANROOTDIRECTORY", ComponentID, "", DirectoryID, 3 }; InsertRecord(session, "RemoveFile", fields); if( Directory.Exists(installLocation)) { foreach (string directory in Directory.GetDirectories(installLocation, "*", SearchOption.AllDirectories)) { session.Log("Processing Subdirectory {0}", directory); string key = string.Format("CLEANSUBFILES{0}", index); string key2 = string.Format("CLEANSUBDIRECTORY{0}", index); session[key] = directory; fields = new object[] { key, ComponentID, "*", key, 3 }; InsertRecord(session, "RemoveFile", fields); fields = new object[] { key2, ComponentID, "", key, 3 }; InsertRecord(session, "RemoveFile", fields); index++; } } } catch (Exception ex) { session.Log(ex.Message); result = ActionResult.Failure; } return result; } private static void InsertRecord(Session session, string tableName, Object[] objects) { Database db = session.Database; string sqlInsertSring = db.Tables[tableName].SqlInsertString + " TEMPORARY"; session.Log("SqlInsertString is {0}", sqlInsertSring); View view = db.OpenView(sqlInsertSring); view.Execute(new Record(objects)); view.Close(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POwix - remove old program folder before install
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChristopher Painter
    1. USChristopher Painter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POwix - remove old program folder before install
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COOk, but what if I have some folders and subfolders. And I don't know what files and what subdirectories are created during program usage - and I need to remove entire install dir, without any care of its contents (because, its content is unknown) - can I use RemoveFile or RemoveFolder to do this?
      singulars
      1. PO
      1. USuser1209216
    2. COYou write a C#/DTF custom action that gets a list of subdirectories and for each one of them authors a temporary row into the MSI. Then when the standard action fires it cleans everything up. Something like this but different SQL table: http://blog.deploymentengineering.com/2008/05/how-dtf-is-going-to-help-me-become.html
      singulars
      1. PO
      1. USChristopher Painter
    3. CODo you mean custom action called during uninstall - it enumerates all remaining files/directories to delete and pass retrieved data somewhere - after this, standard uninstall action will delete these files? Seems to be not so easy, is there any example? What sql table should I use?
      singulars
      1. PO
      1. USuser1209216
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload