Edgewall Software

SQLAlchemy

SqlAlchemy is an object-oriented database API for Python. From the website:

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

Status

SQLAlchemy installation script

An installation consists of the following steps:

  1. Download and install Python egg SqlAlchemyQuery.
  2. Set some variables and formatting rules:
    TRAC_PATH_REPLACE="my-trac-environment"
    USER="myuser"
    MAX_ROW_COUNT_REPLACE="1000"
    TABLE_BORDER_REPLACE="border=\"1\""
    
  3. Copy the sorttable javascript to htdocs:
    cp sorttable.js /home/$USER/$TRAC_PATH_REPLACE/htdocs
    
  4. Apply the settings in macro.py:
    sed -i "s/TRAC_PATH_REPLACE/$TRAC_PATH_REPLACE/g" macro.py
    sed -i "s/MAX_ROW_COUNT_REPLACE/$MAX_ROW_COUNT_REPLACE/g" macro.py
    sed -i "s/TABLE_BORDER_REPLACE/$TABLE_BORDER_REPLACE/g" macro.py
    
  5. Unzip the egg and copy it to the plugins area:
    cp SqlAlchemyQuery-0.1-py2.7.egg /home/$USER/$TRAC_PATH_REPLACE/plugins
    mv SqlAlchemyQuery-0.1-py2.7.egg ../dist
    
  6. Reboot tracd.
Last modified 28 hours ago Last modified on Feb 28, 2015 12:14:39 PM