I do... and you are right - the code already supports setting read_default_group. You can certainly pass it in client code.
What I was suggesting, though, is that the general case is that people don't really know all the options of the MySQL client library. Based on experiences with the MySQL command line clients, almost everyone expects that options set in /etc/my.cnf will affect how things connect. I actually wouldn't mind this being set in the MySQLdb adapter, but I doubt that will happen. I think if we give this a default value, we will solve a large number of complaints and confusion. On the other hand, if you don't want it, you can always override it - but I imagine that to be the minority case. Monty On 8/25/06, Michael Bayer <[EMAIL PROTECTED]> wrote: > do you mean the connect() function for MySQLDB ? SA can support > passing keyword arguments through to connect(). i was actually > cleaning that API up a little bit for a checkin to the trunk today. > > > On Aug 23, 2006, at 4:05 PM, Monty Taylor wrote: > > > Hi - sorry for the cross post - but it's the same general idea. > > > > I've got a possible tiny patch for better MySQL support - but I'm not > > 100% sure what would be the 'best' way to do it would be. > > > > Briefly... (this is in response to having read the turbogears wiki > > article about using a socket file) if you want the python MySQL module > > to actually read the /etc/my.cnf and ~/.my.cnf file information, you > > have to pass read_default_group='' to the contructor. If you put a > > string there (like 'sqlobject' or 'sqlalchemy') to the constructor, it > > will read [sqlalchemy] or [sqlobject] sections and [client] sections > > in the config files and behave as you expect it to. > > > > So I think it's what people expect to have the files read. Whether we > > want to add a section [sqlobject] or [sqlalchemy] by default or not, > > or just leave it to read the [client] sections is another question... > > > > Thoughts? > > > > Monty > > > > ---------------------------------------------------------------------- > > --- > > Using Tomcat but need to do more? Need to support web services, > > security? > > Get stuff done quickly with pre-integrated technology to make your > > job easier > > Download IBM WebSphere Application Server v.1.0.1 based on Apache > > Geronimo > > http://sel.as-us.falkag.net/sel? > > cmd=lnk&kid=120709&bid=263057&dat=121642 > > _______________________________________________ > > Sqlalchemy-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
