IBM i V7R2 (most recent groups/cumulative) : sqlalchemy version
I'm trying to get an sqlalchemy test to work and it stops with the
bash-4.4$ python3.6 alchemy_test.py
Traceback (most recent call last):
File "alchemy_test.py", line 3, in <module> import ibm_db_sa.ibm_db_sa
line 22, in <module> from . import ibm_db, pyodbc, base, zxjdbc File
20, in <module> from .base import DB2ExecutionContext, DB2Dialect File
30, in <module> from . import reflection as ibm_reflection File
line 26, in <module>
from future.utils import iteritems
ModuleNotFoundError: No module named 'future'
If I am readying this right, the module "future.utils" is part of the
sqalchemy package. The code calling it is:
from sqlalchemy import *
metadata = MetaData()
users = Table('users', metadata,
Column('user_id', Integer, primary_key = True), Column('user_name',
String(16), nullable = False), Column('email_address', String(60),
key='email'), Column('password', String(20), nullable = False)
metadata.bind = db2
users_table = Table('users', metadata, autoload=True,
I think it's the import* that's causing the issue.
This is just a see if it can connect script and I lifted it from the
IBM page on sqlalchemy (which of course has no reference to IBM i)
Agile Technology Architects
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)
mailing list To post a message email: WEB400@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.