Will this help; not that it directly addresses your problem... but...
just wondering: https://github.com/web2py/web2py/issues/1034 . Am
thinking the rname capability:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#rname--Record-representation
________________________________________
Kiran Subbaraman
http://subbaraman.wordpress.com/about/
On Sun, 30-04-2017 4:38 AM, ramstein74 wrote:
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 <[email protected]>
Data: 27/04/17 13:20 (GMT+00:00)
Para: [email protected]
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 <[email protected]
<mailto:[email protected]>> wrote:
@Jim any news on this ?
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Sem vírus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
2017-04-21 16:36 GMT+01:00 Massimo Di Pierro
<[email protected] <mailto:[email protected]>>:
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/adapters
You 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')
classDB2IBM(DB2):
drivers = ('ibm_db_dbi',)
defconnector(self):
uriparts = self.ruri.split(";")
cnxn = {}
forvar inuriparts:
v = var.split('=')
cnxn[v[0].lower()] = v[1]
returnself.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
<[email protected] <mailto:[email protected]>> wrote:
Maybe Massimo will read this and give us some hints on
how to make DAL use the ibm_dbi
Regards
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Sem vírus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
2017-03-17 21:06 GMT+00:00 Jim S <[email protected]
<mailto:[email protected]>>:
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
<http://github.com/web2py/web2py> (Source code)
- https://code.google.com/p/web2py/issues/list
<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
[email protected]
<mailto:[email protected]>.
For more options, visit
https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py
<http://github.com/web2py/web2py> (Source code)
- https://code.google.com/p/web2py/issues/list
<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
<https://groups.google.com/d/topic/web2py/qrlN5TSSBgs/unsubscribe>.
To unsubscribe from this group and all its topics,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit
https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py
<http://github.com/web2py/web2py> (Source code)
- https://code.google.com/p/web2py/issues/list
<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 [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py
<http://github.com/web2py/web2py> (Source code)
- https://code.google.com/p/web2py/issues/list
<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
<https://groups.google.com/d/topic/web2py/qrlN5TSSBgs/unsubscribe>.
To unsubscribe from this group and all its topics, send an email
to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<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 [email protected]
<mailto:[email protected]>.
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 [email protected]
<mailto:[email protected]>.
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
