This topic is very important. Having web2py running in a top tech ibm machine
is worthy of notice.Any help on this ... PLEASE
Anyone know if there is a quick way to tell the DAL to ignore the case of the
table/field names when connecting?
Enviado a partir do meu smartphone Samsung Galaxy.
-------- Mensagem original --------De: Jim Steil <ato.st...@gmail.com> Data:
27/04/17 13:20 (GMT+00:00) Para: web2py@googlegroups.com Assunto: Re:
[web2py] Access DB2/400 from IBM i (AS/400) PASE environment
Yes, I was able to get it to connect and the DAL created my tables, but not it
won't access them because it is looking for lower case table names and
evidently when the tables were created the names became upper case. Since I'm
working with this in a Litmis space I don't have full access to do all the work
needed. I do have a 7.3 IBM i box that I'm just getting setup with the new OPS
PTFs and am planning on continuing my testing when that becomes available. I
was planning on reporting back once I had that all working.
Anyone know if there is a quick way to tell the DAL to ignore the case of the
table/field names when connecting?
-Jim
On Thu, Apr 27, 2017 at 6:48 AM, António Ramos <ramstei...@gmail.com> wrote:
@Jim any news on this ?
Sem vírus. www.avast.com
2017-04-21 16:36 GMT+01:00 Massimo Di Pierro <massimo.dipie...@gmail.com>:
We do have an adapter for db2:ibm_db_dbi did you try it? Anyway, in general
adapter are defined in
web2py/gluon/packages/dal/pydal/adaptersYou can make your own adapter. The
first step is identify which existing adapter to extend. You want to pick the
one with the closest SQL dialect. Then you create (in a new adapter file) a new
class that extends that adapter. db2:ibm_db_dbi for example is defined in
db2.py as follows:
@adapters.register_for('db2:ibm_db_dbi')
class DB2IBM(DB2):
drivers = ('ibm_db_dbi',)
def connector(self):
uriparts = self.ruri.split(";")
cnxn = {}
for var in uriparts:
v = var.split('=')
cnxn[v[0].lower()] = v[1]
return self.driver.connect(
cnxn['dsn'], cnxn['uid'], cnxn['pwd'], **self.driver_args)
and can be called as:
db = DAL('db2:ibm_db_dbi:dsn=....;uid=...;pwd=...')
On Friday, 21 April 2017 09:50:03 UTC-5, Jim S wrote:I would love to do some
work on this if there was a mentor out there willing to help me get started.
-Jim
On Fri, Apr 21, 2017 at 5:34 AM, António Ramos <ramstei...@gmail.com> wrote:
Maybe Massimo will read this and give us some hints on how to make DAL use the
ibm_dbi
Regards
Sem vírus. www.avast.com
2017-03-17 21:06 GMT+00:00 Jim S <ato.st...@gmail.com>:
Hi
In a former (and somewhat current) life I was an AS/400 guy. Our shop still
uses the platform though most of my time is spent on Python and web2py now.
Recently Python became available and officially supported on IBM i and I'm
trying to get web2py running there accessing the local DB2/400 database. Using
the local python on the system I can create a database connection to the local
database doing this:
import ibm_db_dbi as db
conn = db.connect(database='*LOCAL')
I'm hoping to find an easy way to convert this into a connectstring for the DAL
so I can have my database created there. The SQL-flavor it should use would be
the same as ODBC-flavored SQL.
Can anyone give me a clue how to modify the DAL code to connect to my db? Any
pointers to other articles or links would really be appreciated. It would be
exciting for me to get this working since I could then show RPG developers how
easy it would be to get an application on the web from the AS/400 using
python/web2py.
-Jim
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google
Groups "web2py-users" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/web2py/qrlN5TSSBgs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google
Groups "web2py-users" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/web2py/qrlN5TSSBgs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
