I'm keeping a project that does pretty much the same as SQLSoup but also does automatic relationship and backref mapping.
It also relies on the new Declarative Base and it doesn't rely on anything from SQLSoup, so when Soup gets discontinued, SQLasagna will go on :) You can see the code, fork it and help developing it on: https://github.com/ygbr/SQLasagna Thanks. On Aug 18, 7:44 am, Ygor Lemos <opti...@gmail.com> wrote: > If anybody else is experiencing this same problem, I have opened a Bug > Request @ SQLA Trac and you can follow it through here: > > http://www.sqlalchemy.org/trac/ticket/2260 > > On Aug 18, 1:56 am, Ygor Lemos <opti...@gmail.com> wrote: > > > > > > > > > Oh, sorry about that, I copied from a previous declaration I've been > > testing using Table() objects... I did remove the ,'s and all worked > > fine... The relationships are normal both in py3k and py2 with the > > latest SQLA. So the problem really lies on the relate() method of > >SqlSoup. > > > Thanks again for your time. > > > On Aug 18, 1:25 am, Michael Bayer <mike...@zzzcomputing.com> wrote: > > > > On Aug 17, 2011, at 10:15 PM, Ygor Lemos wrote: > > > > > I tried the following for manually mapping the tables: > > > > > #!/usr/bin/env python3 > > > > # -*- coding: utf-8 -*- > > > > > from sqlalchemy import * > > > > from sqlalchemy import dialects > > > > from sqlalchemy import sql > > > > from sqlalchemy.orm import * > > > > from sqlalchemy.ext.declarative import declarative_base > > > > from sqlalchemy.sql.expression import * > > > > > engine = create_engine("mysql+oursql://XXXXXXXX:XXXXXXX@XXXXXXXXXXXXXX/ > > > > XXXXXXX?charset=utf8&use_unicode=True&autoping=True", echo=True) > > > > metadata = MetaData(engine) > > > > > Base = declarative_base() > > > > > class User(Base): > > > > > __tablename__ = "users" > > > > > id = Column(Integer, primary_key=True), > > > > login = Column(String(25)), > > > > name = Column(String(50)), > > > > passwd = Column(String(100)), > > > > email = Column(String(100)), > > > > atype = Column(String(50)), > > > > active = Column(Boolean), > > > > customers_id = Column('customers_id', Integer, > > > > ForeignKey('customers.id')), > > > > all of those commas at the end of each line results in the class having a > > > tuple called "id" in it, rather than a set of attributes "id", "login", > > > "name" etc which declarative can interpret as mapping directives. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
