Mengu.net - SQLAlchemy http://www.mengu.net/ mengu on web programming. en-us Sat, 19 May 2012 12:22:27 AM +0300 Tue, 10 Jun 2003 09:41:01 GMT Mengu.net mengu@mengu.net mengu@mengu.net Subqueries With SQLAlchemy http://www.mengu.net/post/subqueries-with-sqlalchemy I have been developing the new version of www.osesturkiye.com for the Turkish version of the show called "The Voice". It's already built with TurboGears, mako and SQLAlchemy. In the new version we have a gallery and many photos in it. My SQLAlchemy model is like this:

class GalleryPhoto(DeclarativeBase):
    __tablename__ = 'gallery_photo'

    id = Column(Integer, primary_key=True)
    photo_image = Column(UnicodeText)
    photo_description = Column(UnicodeText)
    dateline = Column(DateTime, default=datetime.now)

The problem I have is, in the photo detail page I will display "Previous" and "Next" links. I can implement this with two ways..

]]> 2011-12-22 05:28:11 http://www.mengu.net/post/subqueries-with-sqlalchemy