| 1 | [[PageOutline(2-5,Contents,pullout)]] |
| 2 | |
| 3 | = Perform SQL queries on the Trac project database plugin = |
| 4 | |
| 5 | == Description == |
| 6 | |
| 7 | The TracSQL project is a plugin for the 'trac' project management tool. |
| 8 | |
| 9 | A "SQL" tab is added to the trac project. Inside this tab SQL queries can be |
| 10 | performed on the project database. |
| 11 | |
| 12 | This plugin supports Trac installations with SQLite, MySQL, and PostgreSQL |
| 13 | database backends (although the queries will need to be written differently |
| 14 | according to which SQL database is being used). |
| 15 | |
| 16 | |
| 17 | == Bugs/Feature Requests == |
| 18 | |
| 19 | Existing bugs and feature requests for TracSqlPlugin are |
| 20 | [report:9?COMPONENT=TracSqlPlugin here]. |
| 21 | |
| 22 | If you have any issues, create a |
| 23 | [http://trac-hacks.org/newticket?component=TracSqlPlugin&owner=mrjbq7 new ticket]. |
| 24 | |
| 25 | == Download == |
| 26 | |
| 27 | Download the zipped source from [download:tracsqlplugin here]. |
| 28 | |
| 29 | == Source == |
| 30 | |
| 31 | You can check out TracSqlPlugin from [http://trac-hacks.org/svn/tracsqlplugin here] using Subversion, or [source:tracsqlplugin browse the source] with Trac. |
| 32 | |
| 33 | == Example == |
| 34 | |
| 35 | It is configured in the trac.ini file by enabling and configuring: |
| 36 | |
| 37 | {{{ |
| 38 | [components] |
| 39 | tracsql.* = enabled |
| 40 | }}} |
| 41 | |
| 42 | The TRAC_ADMIN permission is used to control access to the query pages. |
| 43 | |
| 44 | |
| 45 | == Recent Changes == |
| 46 | |
| 47 | [[ChangeLog(tracsqlplugin, 3)]] |
| 48 | |
| 49 | == Author/Contributors == |
| 50 | |
| 51 | '''Author:''' [wiki:mrjbq7] [[BR]] |
| 52 | '''Maintainer:''' [wiki:mrjbq7] [[BR]] |
| 53 | '''Contributors:''' |