Re: [IBMiOSS] IBM i python ibm_db_dbi example usage

On Thu, Jul 14, 2016 at 12:31 PM, Kevin Adler <kadler@xxxxxxxxxx> wrote:

From: Aaron Bartell <aaronbartell@xxxxxxxxx>

To get ibm_db to work I had to run this
command, not sure if this is normally necessary.

pip install
/QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db/ibm_db-2.0.5.4-cp34-
cp34m-os400_powerpc.w
hl

Aaron: As Kevin explained, that's actually how the PTF was designed.
But that pip install step is still rightfully the administrator's job,
not the programmer's. (In other words, whoever applied the PTF should
also be the one to do the pip install).

From a Python programmer's perspective, the package is not installed

until you can just do the import from Python. So you should set up the
Python Litmis Space such that the user doesn't have to do the pip
install step. This goes for itoolkit, bottle, and flipflop as well.

But thank you for putting on the new PTFs! Now I can get a better feel
of how IBM's Python interacts with native-side stuff. I've already
confirmed that my new space can make the ibm_db_dbi connection to the
local database without username and password.

Note that you only installed the ibm_db package for Python 2, for Python 3
you must use pip3 to install it (and it's a different wheel).

Kevin: No, if you look carefully, Aaron did use the correct wheel. The
way the Python Litmis Space is configured, "pip" already points to
"pip3", and Option 2 is the only Python installed.[1]

As I understand it, this kind of setup is pretty common in Linux
distributions that have decided upon Python 3 as their "system"
Python.

[1] It so happens that the Litmis Space *also* has the cp27 wheel,
which is currently superfluous.

John Y.