[sqlalchemy] Re: Sybase T-SQL join Dialect

2009-12-18 Thread Shuaib Osman
its true, the dialect was never written for ASE.   It also hasn't been used by anyone I'm aware of since the original author submitted it against version 0.3 of SQLA.  I'm surprised its usable at all at this point. If you'd like to help us with a real Sybase dialect, it would be targeted

[sqlalchemy] Sybase T-SQL join Dialect

2009-12-17 Thread Shuaib Osman
Hi Guys, I'm busy with Sybase ASE and things are somewhat unpleasant. I've had to modify the default Sybase.py driver as it was not targeted specifically for ASE. I've got a barely working version (the reflect code returns all tables and columns but not foreign keys or other constaints). The big

[sqlalchemy] Custom Orm

2009-09-25 Thread Shuaib Osman
Hi, I've been playing around with SA for about a week now and need a custom ORM. The datatype that will hold all data is essentially a modified dictionary - the key of the dictionary (may be a tuple) is the key in the database and the list associated is the rest of the row. However, some of the

[sqlalchemy] Adjacency tree linked list

2009-09-22 Thread Shuaib Osman
Hi guys, I’m to build an adjacency list in SA and have looked at the basic_tree.py example provided, however, I need to order the children. Now I don’t really want to use nested sets and I know linked lists can be implemented in SA quite easily. So naturally I tried something like trees =