Edgewall Software
Home
Trac
Trac Hacks
Genshi
Babel
Bitten
Home
Download
Documentation
Mailing Lists
License
FAQ
Search:
Login
Preferences
Help/Guide
About Trac
Wiki
Timeline
Roadmap
Browse Source
View Tickets
New Ticket
Search
Context Navigation
+0
Start Page
Index
History
Editing SqlAlchemy
Adjust edit area height:
8
12
16
20
24
28
32
36
40
Edit side-by-side
= SQLAlchemy [http://www.sqlalchemy.org 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 * Instructions for using SQLAlchemy as a plugin are listed at th:SqlAlchemyQueryMacro. * We talked a bit about adopting it for Trac's DB abstraction layer, eventually replacing our home grown [source:trunk/trac/db db layer]. * A proposal has been worked on: trac-dev:228 * Some experimental work has started in source:sandbox/Attic/sqlalchemy-ng. == SQLAlchemy installation script An installation consists of the following steps: 1. Download and install [https://pypi.python.org/pypi/SQLAlchemy/0.9.8 Python egg SqlAlchemyQuery]. 1. Set some variables and formatting rules: {{{ TRAC_PATH_REPLACE="my-trac-environment" USER="myuser" MAX_ROW_COUNT_REPLACE="1000" TABLE_BORDER_REPLACE="border=\"1\"" }}} 1. Copy the sorttable javascript to htdocs: {{{ cp sorttable.js /home/$USER/$TRAC_PATH_REPLACE/htdocs }}} 1. 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 }}} 1. 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 }}} 1. Reboot tracd.
Note:
See
WikiFormatting
and
TracWiki
for help on editing wiki content.
Change information
Your email or username:
E-mail address and name can be saved in the
Preferences
Comment about this change (optional):
Note:
See
TracWiki
for help on using the wiki.