Changes between Version 8 and Version 9 of TracSqlPlugin
- Timestamp:
- Mar 28, 2015, 11:55:24 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracSqlPlugin
v8 v9 1 1 [[PageOutline(2-5,Contents,pullout)]] 2 2 3 = Perform SQL queries on the Trac database =3 = Perform SQL queries on the Trac database 4 4 5 == Description ==5 == Description 6 6 7 The TracSQL plugin adds a "SQL" tab to the trac project. Inside this tab, the plugin 8 supports interacting with the project database. 7 The TracSQL plugin adds a "SQL" tab to the Trac project. Inside this tab, the plugin supports interacting with the project database. 9 8 10 Some features include:9 Key features: 11 10 12 11 * perform queries on the project database … … 15 14 * browse the database schema 16 15 17 This plugin supports Trac installations with SQLite, MySQL, and PostgreSQL 18 database backends (although the queries will need to be written differently 19 according to which SQL database is being used). 16 This plugin supports Trac installations with SQLite, MySQL and PostgreSQL database backends. The queries will need to be written differently according to which SQL database is being used. 17 18 == Source 19 20 See http://github.com/mrjbq7/tracsql for more details and the source code, or to report issues or request features. 21 22 == Installation 20 23 21 24 You can install it with: 22 25 23 26 {{{ 24 $ easy_install tracsql 27 #!sh 28 easy_install tracsql 25 29 }}} 26 30 27 == Source ==31 == Configuration 28 32 29 See http://github.com/mrjbq7/tracsql for more details and the source code, or to report issues or request features. 30 31 == Configuration == 32 33 It is configured in the trac.ini file by enabling and configuring: 33 It is configured in the `trac.ini` file by enabling and configuring: 34 34 35 35 {{{ 36 #!ini 36 37 [components] 37 38 tracsql.* = enabled 38 39 }}} 39 40 40 The TRAC_ADMINpermission is used to control access to the query pages.41 The `TRAC_ADMIN` permission is used to control access to the query pages. 41 42 42 By default, the TracSQL plugin connects to the project database. To use an 43 external database, set the database parameter in the tracsql section 44 of the trac.ini file to a valid database connection string: 43 By default, the TracSQL plugin connects to the project database. To use an external database, set the database parameter in the tracsql section of the `trac.ini` file to a valid database connection string: 45 44 46 45 {{{ 46 #!ini 47 47 [tracsql] 48 48 database = sqlite:db/external.db 49 49 }}} 50 50 51 == Example ==51 == Example 52 52 53 53 Some screenshots, showing a few of the features: 54 54 55 === SQL query screen 56 55 57 [[Image(sql-query.png)]] 58 59 === SQL schema screen 56 60 57 61 [[Image(sql-schema.png)]] 58 62 63 === SQL query 2 screen 64 59 65 [[Image(sql-query2.png)]] 60 66 61 == Recent Changes ==67 == Recent Changes 62 68 63 69 [[ChangeLog(tracsqlplugin, 3)]] 64 70 65 == Author/Contributors ==71 == Author/Contributors 66 72 67 73 '''Author:''' [wiki:mrjbq7] [[BR]]