Edgewall Software

Changes between Version 5 and Version 6 of SqlAlchemy


Ignore:
Timestamp:
Mar 3, 2015, 7:39:37 PM (9 years ago)
Author:
Ryan J Ollos
Comment:

SqlAlchemyQueryMacro is not related to use of SQLAlchemy as a database abstraction in Trac.

Legend:

Unmodified
Added
Removed
Modified
  • SqlAlchemy

    v5 v6  
    99== Status
    1010
    11  * Instructions for using SQLAlchemy as a plugin are listed at th:SqlAlchemyQueryMacro.
    1211 * We talked a bit about adopting it for Trac's DB abstraction layer, eventually replacing our home grown [source:trunk/trac/db db layer].
    1312 * A proposal has been worked on: trac-dev:228
    1413 * Some experimental work has started in source:sandbox/Attic/sqlalchemy-ng.
    15 
    16 == SQLAlchemy installation script
    17 
    18 An installation consists of the following steps:
    19  1. Download and install [https://pypi.python.org/pypi/SQLAlchemy/0.9.8 Python egg SqlAlchemyQuery].
    20  1. Set some variables and formatting rules:
    21 {{{
    22 TRAC_PATH_REPLACE="my-trac-environment"
    23 USER="myuser"
    24 MAX_ROW_COUNT_REPLACE="1000"
    25 TABLE_BORDER_REPLACE="border=\"1\""
    26 }}}
    27  1. Copy the sorttable javascript to htdocs:
    28 {{{
    29 cp sorttable.js /home/$USER/$TRAC_PATH_REPLACE/htdocs
    30 }}}
    31  1. Apply the settings in macro.py:
    32 {{{
    33 sed -i "s/TRAC_PATH_REPLACE/$TRAC_PATH_REPLACE/g" macro.py
    34 sed -i "s/MAX_ROW_COUNT_REPLACE/$MAX_ROW_COUNT_REPLACE/g" macro.py
    35 sed -i "s/TABLE_BORDER_REPLACE/$TABLE_BORDER_REPLACE/g" macro.py
    36 }}}
    37  1. Unzip the egg and copy it to the plugins area:
    38 {{{
    39 cp SqlAlchemyQuery-0.1-py2.7.egg /home/$USER/$TRAC_PATH_REPLACE/plugins
    40 mv SqlAlchemyQuery-0.1-py2.7.egg ../dist
    41 }}}
    42  1. Reboot tracd.