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')
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
>>
>>
>> <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>
>>
>> <#CAERBpoB9XHiZLmMc2ZRmOb=JTAwUc+3=AKTvYoVXpYzostc8gQ@mail.gmail.com_m_-8595142087007992887_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>> 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.
