Editing Updating Trac Components (section)

== Workflow ==

=== Update the component name using `sqlite3` ===

* Open Powershell.
* Navigate to the Trac installation directory.
* Trac uses a sqlite3 database, located in the `db` directory in the Trac installation directory.
* `sqlite3 [trac-database.db]`
* Rename components with `update component set name = 'new name' where name = 'old name';`
* Update tickets to reflect the changes: `update ticket set component = 'new name' where component = 'old name';`
* Quit sqlite3 with `.quit`

=== Refreshing the Trac cache ===

Trac caches the component names. For example, when creating or editing a custom query, the component dropdown options will not be updated with the current values in the sqlite3 `component` table.

To refresh the Trac cache, touch the Trac ini file:

* Open Powershell.
* Navigate to the Trac installation directory.
* `cd conf\`
* `touch trac.ini`