Changes between Version 3 and Version 4 of SqlAlchemy

Timestamp:

Feb 28, 2015, 12:08:59 PM (9 years ago)

Author:

figaro

Comment:

Added SQLAlchemy script

SqlAlchemy

@@ -1 +1 @@
 = SQLAlchemy =
 
-[http://www.sqlalchemy.org SqlAlchemy] is an object-oriented DB API for Python.
+[http://www.sqlalchemy.org SqlAlchemy] is an object-oriented DB 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.''
@@ -7 +7 @@
   ''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.''
 
-----
+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
 
-We talked a bit about adopting it for Trac's DB abstraction layer, eventually replacing our home grown [source:trunk/trac/db db layer].
+Some experimental work has started in source:sandbox/Attic/sqlalchemy-ng.
 
-Some experimental work has started in source:sandbox/Attic/sqlalchemy-ng
+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.