Changes between Version 112 and Version 113 of TestManagerForTracPlugin


Ignore:
Timestamp:
Oct 25, 2014, 8:22:25 AM (9 years ago)
Author:
Roberto Longobardi
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • TestManagerForTracPlugin

    v112 v113  
    678678 * TEST_PLAN_ADMIN - Ability to generate and delete test plans
    679679 * TEST_STATS_VIEW - Ability to view test management statistics
     680 * SQL_RUN - Ability to run arbitrary queries and statements on the Trac database. The SQLExecutor plugin shipped with the Test Manager provides this feature.
    680681
    681682== Programmatic API ==
    … …  
    734735  3) Test Manager
    735736
    736 An additional plugin is only useful for debugging and should not be installed in a production environment.
    737 
    738  * SQL Executor
    739 
    740 With the latter plugin, you can perform '''arbitrary SQL''' queries or statements on the Trac database from your web browser (including creating, modifying and dropping tables...!).  Just click on the '''SQL Executor''' button on the toolbar at the top of the page and enter your query in the text area, or use the REST API as follows:
     737An additional plugin is very useful for debugging, but has been proved very handy also in a production environment to fix problems with the Trac data. It provides the ability to run '''arbitrary SQL''' queries or statements on the Trac database from your web browser (including creating, modifying and dropping tables...!).
     738
     739  4) SQL Executor
     740
     741To use it, just click on the '''SQL Executor''' button on the toolbar at the top of the page and enter your SQL in the text area, or use the REST API as follows:
    741742
    742743  !http://yourserver/yourenvironment/sqlexec?sql=any SQL statement
    … …  
    745746
    746747  !http://localhost/sampleproject/sqlexec?sql=select * from testcatalog
     748
     749Since this feature is pretty dangerous, the specific Trac permission '''SQL_RUN''' has been added to protect it. You must have this permission to see and use the plugin.
    747750
    748751Follow the '''[wiki:TestManagerForTracPluginQuickSetup quick setup guide]''' or the '''[http://www.youtube.com/watch?v=BIi3QMT0rT4 video tutorial on YouTube]''' to get started.