Re: [IBMiOSS] ibm_db and itoolkit for Python -- OPENSOURCE

Here is that I get after copying the file:

[qsecofr@QLFI2]/home/jsteil/dev/flask_test# pip3 install flask
Traceback (most recent call last):
File "/QOpenSys/usr/bin/pip3", line 7, in <module>
from pip import main
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/__init__.py",
line 13, in <module>
from pip.commands import commands, get_summaries, get_similar_commands
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/commands/__init__.py",
line 6, in <module>
from pip.commands.bundle import BundleCommand
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/commands/bundle.py",
line 6, in <module>
from pip.commands.install import InstallCommand
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/commands/install.py",
line 5, in <module>
from pip.req import InstallRequirement, RequirementSet,
parse_requirements
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/req/__init__.py",
line 3, in <module>
from .req_install import InstallRequirement
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/req/req_install.py",
line 42, in <module>
from pip.utils.hashes import Hashes
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/utils/hashes.py",
line 5, in <module>
from pip.exceptions import HashMismatch, HashMissing, InstallationError
ImportError: cannot import name 'HashMissing'

-Jim

On Fri, Jun 24, 2016 at 5:05 PM, Kevin Adler <kadler@xxxxxxxxxx> wrote:

Looks like you've upgraded pip (since the traceback is pointing to
site-packages instead of vendor-packages). pip includes its own version of
six here:

/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/_vendor/six.py

Make sure this shows 1.10.0:

python3 -c 'import pip._vendor.six as six; print(six.__version__)'

If not, you might want to copy
/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/six.py
to

/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/pip/_vendor/six.py
and see if that fixes your problem. If so, I'd recommend upgrading pip (in
case there's other problems).

"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 06/23/2016
02:29:09 PM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/23/2016 02:29 PM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

[qsecofr@QLFI2]/QOpenSys/QIBM/ProdData/OPS# python3 -c 'import six;
print(six.__version__); print(six.__file__);'

1.10.0
/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/six.py

...and, pip3 is broken now. It doesn't work for me, getting the same

error

as when I tried to pip3 install ibm_db

Bill - Any way to grab this whole conversation and bring it in to Ryver?

-Jim

On Thu, Jun 23, 2016 at 1:21 PM, Bill Gravelle <starbg@xxxxxxxxxxx>

wrote:

Sorry to interrupt - I know this is very complicated stuff y’all are
working out here …

Since you’re both on the new community collaboration/communication
platform over on Ryver (and everyone else here in this list has been
invited), might this kind of interactive(ish) Q&A be more efficient

and

effective within that interface?

On Jun 23, 2016, at 12:12 PM, Kevin Adler <kadler@xxxxxxxxxx> wrote:

Do you have an older version of six installed?

If you've gotten to a recent PTF level of the Python 3 runtime it

will be

included by default.

What is the output of the following commands?

pip3 list | grep six

python3 -c 'import six; print(six.__version__);

print(six.__file__);'

"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 06/23/2016
12:56:35 PM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/23/2016 12:56 PM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I received the following trying ti pip3 install it:

[qsecofr@QLFI2]/QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db# pip3

install

ibm_db-2.0.5.4-cp34-cp34m-os400_powerpc.whl

Traceback (most recent call last):
File "/QOpenSys/usr/bin/pip3", line 7, in <module>
from pip import main
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/__init__.py",
line 13, in <module>
from pip.commands import commands, get_summaries,

get_similar_commands

File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/commands/__init__.py",
line 6, in <module>
from pip.commands.bundle import BundleCommand
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/commands/bundle.py",
line 6, in <module>
from pip.commands.install import InstallCommand
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/commands/install.py",
line 5, in <module>
from pip.req import InstallRequirement, RequirementSet,
parse_requirements
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/req/__init__.py",
line 3, in <module>
from .req_install import InstallRequirement
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/req/req_install.py",
line 35, in <module>
from pip.utils import (
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/utils/__init__.py",
line 100, in <module>
def rmtree(dir, ignore_errors=False):
File
"/QOpenSys/QIBM/ProdData/OPS/Python3.4/lib/python3.4/site-packages/
pip/_vendor/retrying.py",
line 47, in wrap
@six.wraps(f)
AttributeError: 'module' object has no attribute 'wraps'
[qsecofr@QLFI2]/QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db#

-Jim

On Thu, Jun 23, 2016 at 12:31 PM, Kevin Adler <kadler@xxxxxxxxxx>

wrote:

Oops, sorry gave you the wrong PTF number. Here's the Py3 PTF:

SI60563

All the Python PTFs are documented here:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/

wiki/IBM%20i%20Technology%20Updates/page/Python%20PTFs

"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 06/23/2016
09:26:58 AM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/23/2016 09:27 AM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I did not have SI60567 install. I've installed it now. It added

a

.whl

file to /QOpenSys/QIBM/ProdData/OPS/Python-pkgs/ibm_db, but only

one

for

Python 2.7:

ibm_db-2.0.5.4-cp27-cp27m-os400_powerpc.whl

There is also an egg file, but that is for ibm_db v2.0.5.1 which

I

think

is

what I already had installed. Is there a .whl file for ibm_db v

2.0.5.4

for Python 3?

-Jim

On Wed, Jun 22, 2016 at 10:29 PM, Kevin Adler <kadler@xxxxxxxxxx>

wrote:

connect/pconnect take implementation specific parameters, so

they

aren't

in the PEP. We should probably document them somewhere. Here's

the

function definitions from the ibm_db_dbi.py:

def connect(dsn=None, user='', password='', host='',

database='',

conn_options=None):
def pconnect(dsn, user='', password='', host='', database='',
conn_options=None):

(Note, host is not supported on IBM i, since you have to specify

this

in

the RDB)

try this:

import ibm_db_dbi as dbi

conn = dbi.pconnect(dsn=None, database='*LOCAL', user=None,

password=None)

You can specify a DSN string like so:

dbi.pconnect("DATABASE=*LOCAL;UID=user;PWD=pass")

and this should be equivalent as above *LOCAL/None/None:

dbi.pconnect("DATABASE=*LOCAL")

Now that I'm looking at it again, it looks like I missed the

default

parameter for dsn on pconnect. Once that's there, you can do:

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

(Already works on connect)

Make sure you're on the latest version of ibm_db. I'm not sure

if

the

original shipped version of ibm_db_dbi actually worked. Since

2.0.5.1

it

should work, but I'd get to 2.0.5.4, which is shipped with

SI60567.

"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on

06/22/2016

09:33:07 PM:

From: Jim Steil <jim@xxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 06/22/2016 09:34 PM
Subject: Re: [IBMiOSS] ibm_db and itoolkit for Python
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I'm trying ibm_db_dbi but can't figure out the pconnect

parameters.

Trying

to connect to the local database. Any pointers?

Jim
On Jun 22, 2016 8:25 PM, "John Yeung"

<gallium.arsenide@xxxxxxxxx>

wrote:

On Wed, Jun 22, 2016 at 5:54 PM, Jim Steil

<jim@xxxxxxxxxxxxxxx>

wrote:

Hey John - where can I get some info on ibm_db? I tried out

the

itoolkit

on my IBM i today and was a bit disappointed in what I had

to do

to

access

the database. I'm guessing this is not going to be the

preferred

method

of

db access for Python. I'd appreciate pointers to any info

you

have

on

ibm_db for Python...

I agree with Kevin: Under normal circumstances, you should not

be

using ibm_db directly, but rather ibm_db_dbi, to get the

standard

Python database interface as laid out in PEP 249. If you're a
long-time Python user, you're probably already familiar with

this

interface. If not, I find the PEP is pretty good documentation

for

it.

To be completely honest, I have never had especially high

hopes

for

itoolkit, whether for accessing data or programs:

http://yips.idevcloud.com/wiki/index.php/XMLSERVICE/Python

The documentation for the underlying XMLSERVICE has been

around

for

quite some time now, as well as some of its wrappers in other
languages. It just seems fundamentally verbose and cumbersome,

by

Python standards. The Python version (judging by the

documentation

linked to above) is about as verbose as I was expecting. It

looks

almost as bulky as Java, but with a style reminiscent of Ruby.

Or

maybe JavaScript. (I only have a passing familiarity with

those

languages.) But I haven't given it a fair shake yet, so we'll

see.

If I do become a convert to IBM's Python (as opposed to the
third-party iSeriesPython which I'm using now), I may wind up

writing

my own wrapper for itoolkit, or my own fork of itoolkit.

To me, itoolkit seems to be mainly for calling native programs

and

service programs (mostly written by your own shop, mostly in

RPG),

or

IBM system APIs. Both of these uses are probably dwindling

niches,

as

more and more people write stored procedures and UDFs, and IBM

exposes

more and more system services to SQL. Eventually, you may be

able

to

just do everything with ibm_db_dbi. But I know our shop is far

from

that point.

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.

--
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.

--
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.

--
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.

--
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.

--
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.

--
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.

--
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.

--
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.

--
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.