Re: [IBMiOSS] IBM i python ibm_db_dbi example usage

That would be simple enough, but it doesn't work on Litmis Spaces:

​I haven't been following the Python PTFs as closely in 5733OPS. Was there
a change in the ibm_db adapter?​


​>That kind of stuff is pretty simple. I could probably manage some pull
requests, once I'm able to establish access to an environment in which I
can test my own mods.​

Let me know what you need and I will add it to your Space. This is the
same thing I did for David Dressler** to get his PHP/Nginx stuff compiled.

​**
https://godzillai5.wordpress.com/2016/06/21/compiling-php7-from-source-on-ibmi-pase-aix/
​

​Thanks,
Aaron Bartell
litmis.com - Services for open source on IBM i


On Sat, Jul 9, 2016 at 8:22 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Fri, Jul 8, 2016 at 12:28 PM, Kevin Adler <kadler@xxxxxxxxxx> wrote:

Simplest is

ibm_db_dbi.[p]connect("DATABASE=*LOCAL")

That would be simple enough, but it doesn't work on Litmis Spaces:

*** begin quote ***
Traceback (most recent call last):
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/ibm_db-2.0.5.1-py3.4-os400-powerpc.egg/ibm_db_dbi.py",
line 585, in connect
ibm_db.set_option(conn, {SQL_ATTR_CURRENT_SCHEMA : user}, 1)
Exception: Supplied connection object Parameter is invalid

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/ibm_db-2.0.5.1-py3.4-os400-powerpc.egg/ibm_db_dbi.py",
line 587, in connect
raise _get_exception(inst)
ibm_db_dbi.Error: ibm_db_dbi::Error: Supplied connection object
Parameter is invalid
*** end quote ***

ibm_db_dbi.connect(dsn=None, database='*LOCAL', user=None, password=None)
# connect has a bug where you have to specify dsn=None currently

*** begin quote ***

Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/ibm_db-2.0.5.1-py3.4-os400-powerpc.egg/ibm_db_dbi.py",
line 547, in connect
raise InterfaceError("connect expects a not None dsn value")
ibm_db_dbi.InterfaceError: ibm_db_dbi::InterfaceError: connect expects
a not None dsn value

*** end quote ***

ibm_db_dbi.pconnect(database='*LOCAL', user=None, password=None)

*** begin quote ***

Traceback (most recent call last):
File "<stdin>", line 1, in <module>
TypeError: pconnect() missing 1 required positional argument: 'dsn'

*** end quote ***

One of these days, I'll get around to adding a default for dsn on
connect() and setting user and password defaults to None instead of empty
strings (Pull requests welcome). Then you could do:

ibm_db_dbi.connect(database='*LOCAL')

if you wanted.

That kind of stuff is pretty simple. I could probably manage some pull
requests, once I'm able to establish access to an environment in which
I can test my own mods.

John Y.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/opensource.