Hi Vince, You can use sqlalchemy right now (just easy_install and import sqlalchemy).
The problem is that you will miss a lot of web2py features. We have no plan to port those feature to sqlalchemy. Moreover we do no like to use third party packages in web2py because of our backward compatibility promise. But, we will be happy to help you port your sqlalchemy models to web2py. Massimo On Nov 30, 1:23 am, vince <[EMAIL PROTECTED]> wrote: > i am a sqlalchemy user and i think most of us are using object mapping > instead. i've been using pylons but really tried of the lack of > document, and i really enjoy the all in one package advantage in > web2py. > will web2py give us an option to use sqlalchemy instead of web2py's > DAL soon? > > -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 -~----------~----~----~----~------~----~------~--~---
