On 24.06.2016 16:31, Sigurd Jervelund Hansen wrote: > Hi > > I'm using the PEP249 as a reference, and I've stumbled upon some > contradicting documentation in footnote 1. > > If I attempt to connect to a database using the example I get the following > error: > >>>> connect(host=dbHost,user=dbUser,password=dbPassword,database=dbName) > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File "/usr/local/lib/python2.7/dist-packages/MySQLdb/__init__.py", line > 81, in Connect > return Connection(*args, **kwargs) > File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", > line 193, in __init__ > super(Connection, self).__init__(*args, **kwargs2) > TypeError: 'database' is an invalid keyword argument for this function > > Changing parameter database to db: > >>>> connect(host=dbHost,user=dbUser,password=dbPassword,db=dbName) > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File "/usr/local/lib/python2.7/dist-packages/MySQLdb/__init__.py", line > 81, in Connect > return Connection(*args, **kwargs) > File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", > line 193, in __init__ > super(Connection, self).__init__(*args, **kwargs2) > TypeError: 'password' is an invalid keyword argument for this function > > Changing parameter password to passwd: > >>>> connect(host=dbHost,user=dbUser,passwd=dbPassword,db=dbName) > <_mysql.connection open to 'mysql-host' at 217e660> > > In short: Parameter password should be passwd and database should be db.
The DB-API footnote only provides a guideline on how to name the parameters. In this case the module author obviously chose different spellings. > Direct link to footnote <https://mail.google.com/>: > https://www.python.org/dev/peps/pep-0249/#id40 """ [1] As a guideline the connection constructor parameters should be implemented as keyword parameters for more intuitive use and follow this order of parameters: ... """ > Link to stackoverflow with working example: > http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Experts (#1, Jun 27 2016) >>> Python Projects, Coaching and Consulting ... http://www.egenix.com/ >>> Python Database Interfaces ... http://products.egenix.com/ >>> Plone/Zope Database Interfaces ... http://zope.egenix.com/ ________________________________________________________________________ ::: We implement business ideas - efficiently in both time and costs ::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 http://www.egenix.com/company/contact/ http://www.malemburg.com/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org https://mail.python.org/mailman/listinfo/db-sig
