i am a SQLAlchemy user and i think most of us are using its object- relational mapping instead. i've been using pylons but tried of its lack of document and really enjoy the idea of "all in one package" in web2py. will web2py give us an option to use SQLAlchemy instead of its own DAL?
-vinc On 11月17日, 下午11時12分, mdipierro <[EMAIL PROTECTED]> wrote: > - The Table must have an integer field called 'id'. > > - ForeignKey must always reference such field. > > - Many SQLAlchemey field attributes are ignored. > > - It does not check for errors. > > - This is not the recommended way to use web2py. This is designed to > lower the entry barrier for current SQLAlchemy users and to > acknowledge the importance of SQLAlchemy within the Python community. > > Massimo > > On Nov 16, 10:36 pm, mdipierro <[EMAIL PROTECTED]> wrote: > > > ** This is incomplete and to be considered a proof of concept ** > > > 1) download > > >http://groups.google.com/group/web2py/web/sqlalchemy.py > > > 2) import it in your app and try the following model: > > > db=SQLDB() > > metadata=MetaData(db) > > > users = Table('users', metadata, > > Column('id', Integer), > > Column('name', String(40)), > > Column('age', Integer), > > Column('password', String), > > Column('blob1',Binary), > > ) > > > dogs = Table('dogs', metadata, > > Column('id', Integer), > > Column('name', String(40)), > > Column('owner', ForeignKey('users.id')), > > ) > > > print users.fields > > print dogs.fields > > > 3) click on [database administration] to see the generated interface. > > > As in the Django cases, the above code defines tables 'users' and > > 'dogs'. They are web2py tables so you can do: > > > id=users.insert(name='Test') > > dogs.insert(name='Snoopy',owner=id) > > for row in db(dogs.owner==users.id).select(): print > > row.dogs.name,row.users.name > > > Massimo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
