RE: [PEAR-DEV] feature (add-on) MDB proposal

> From: Laurent Laville [mailto:laurent.laville@worldonline.fr] > Sent: Saturday, July 05, 2003 5:03 PM > > > > It is possible through variable tags. However I am not sure if the > > following works: > > > > <name> > > <variable>prefix</variable>_foobar > > </name> > > > > I've just tested it and it seems to work only when there is no sequence > defined : > > Sources page updated there : > http://farell.free.fr/en/pear/docs/mdb/show.php ah just a little mistake on your part. MDB picks up the fact that you have defined a sequence on a table that hasn't been defined, since you forgot to add the prefix to the on tag as well: <sequence> <name>users_sequence</name> <start>1</start> <on> <field>user_id</field> <table><variable>prefix</variable>users</table> </on> </sequence> Then things should work. So is that a good enough solution for you? Anyways I would really like to thank you for the very clean work you did; makes evaluation a breeze. I hope to hear more suggestions like that from you (or any other user for that matter). > > As you may know I am working on MDB 2.0 which will make it possible to > > simply tell the Manager to use a different parser. However I do see that > > this would be a useful feature, so if the above is not possible we > > should certainly make it possible. > > As lot of people i'm happy that you are working on a new major version > especially about Schema_Manager ( a late +1 ) > BTW, could you think to integrate a really GRANT user management with > your > schema manager. Well this will be sort of tricky. The differences there might be very hard to abstract. I hope that in the future more drivers will become capable of listing and creating users. However when it comes to managing users rights I think that is still fairly far off. But as always this could be done by someone else. However I would be hesitant to quickly integrate a MySQL specific solution, as this might make things difficult further down the roadin terms of API breakage. However it might be worthwhile to develop a MySQL specific solution as a separate class which uses MDB. Regards, Lukas