New schema.py with Elixir defined model (sqlalchemy-ng branch)

[sevenseeker]

Since I am more familiar with Elixir (and thus the new SQLAlchemy declarative language as well) I have produced an Elixir declared model for Trac with minimal relations. I assumed a 'User' class and table as well for some of the relations to demonstrate its use. I will be submitting a revised edition with relations defined in the top SQLAlchemy section hopefully this afternoon.

[sevenseeker (jtgalyon@…]

Elixir defined model

[Jeroen Ruigrok van der Werven]

Looking at the SQLAlchemy change notes, we might even have to move to UnicodeText instead of Unicode.

[Jeroen Ruigrok van der Werven]

Actually, we might need to revisit the entirety of the types based on the now documented stuff in ​http://www.sqlalchemy.org/docs/04/types.html

[jtgalyon@…]

String or Unicode without a numerical specifier results in Text, btw. Should all of these fields be Text or some varchar with lengths?

[Jeroen Ruigrok van der Werven]

Hi,

I'm going to close this and first get everything back on the rails again. Using the declarative support from SQLAlchemy 0.5 ought to be enough, I've done a lot of work with it in recent weeks. As such, it does not make sense to keep this one open.

[Christian Boos]

(clearing report:35)