Committed c995fd7 that should fix this
On Tuesday, 8 August 2017 14:40:34 UTC-5, Lisandro wrote:
>
> Same problem here, but using PostgreSQL.
> This is the function that I was using to connect to a database:
>
> def connect_db(db_host, db_name, db_user, db_user_password):
> # gets the table_hash from one of the .table files in the databases
> folder
> table_hash = None
> for file in os.listdir(databases_folder):
> if archivo.endswith('.table'):
> table_hash = file.split('_')[0]
> break
> return DAL('postgres://%s:%s@%s:5432/%s' % (db_user, db_user_password,
> db_host, db_name),
> migrate=False,
> folder=databases_folder,
> auto_import=True,
> table_hash=table_hash)
>
>
> But after upgrading to 2.15.3, the function throws this error:
>
> Traceback (most recent call last):
> File "/home/gonguinguen/medios/gluon/restricted.py", line 219, in restricted
> exec(ccode, environment)
> File
> "/home/gonguinguen/medios/applications/webmedios/controllers/admin.py", line
> 550, in <module>
> File "/home/gonguinguen/medios/gluon/globals.py", line 409, in <lambda>
> self._caller = lambda f: f()
> File
> "/home/gonguinguen/medios/applications/webmedios/controllers/admin.py", line
> 548, in prueba
> dbs = sitio.conectar_db()
> File "/home/gonguinguen/medios/gluon/packages/dal/pydal/objects.py", line
> 2368, in __call__
> return self.method(self.row, *args, **kwargs)
> File "/home/gonguinguen/medios/applications/webmedios/models/db.py", line
> 149, in <lambda>
> Field.Method('conectar_db', lambda row: sitios_conectar_db(row.sitios)),
> File "applications/webmedios/modules/virtual_methods.py", line 79, in
> sitios_conectar_db
> table_hash=table_hash)
> File "/home/gonguinguen/medios/gluon/packages/dal/pydal/base.py", line 170,
> in __call__
> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
> File "/home/gonguinguen/medios/gluon/packages/dal/pydal/base.py", line 500,
> in __init__
> tables=tables)
> File "/home/gonguinguen/medios/gluon/packages/dal/pydal/base.py", line 522,
> in import_table_definitions
> tfile = self._adapter.file_open(filename, 'r')
> AttributeError: 'PostgrePsyco' object has no attribute 'file_open'
>
>
>
> Meanwhile, I'll check if there is an opened issue about this.
> Let me know if there is anything I can do to help you fix the problem.
>
>
> El jueves, 20 de julio de 2017, 18:56:29 (UTC-3), Massimo Di Pierro
> escribió:
>>
>> Can you please open a PyDAL ticket so we can track. This should work.
>>
>> On Saturday, 15 July 2017 05:13:45 UTC-5, Jitun John wrote:
>>>
>>> Here is a Code that worked fine on 2.14.6 but doesn't on 2.15.1
>>>
>>>
>>> import datetime
>>> import gc
>>> import os
>>> from gluon import *
>>> from current_config import *
>>> from memory_profiler import memory_usage
>>>
>>>
>>> manager_rows = ''
>>>
>>>
>>> dummy_path = os.path.abspath('.') +
>>> '/applications/enLIGHTen/static/dummy/'
>>>
>>>
>>> def read_alerts_rows():
>>> alerts_db_conn = DAL('sqlite://alerts.sqlite', folder=
>>> get_current_path(), auto_import=True)
>>> global alerts_rows
>>> alerts_rows = alerts_db_conn(alerts_db_conn.alerts_log.id > 0).
>>> select(orderby=alerts_db_conn.alerts_log.datetime)
>>> alerts_db_conn.close()
>>>
>>>
>>> def get_alerts_rows():
>>> return alerts_rows
>>>
>>>
>>> ....
>>>
>>>
>>> def add_clear():
>>> dummy_alerts_db_conn = DAL('sqlite://alerts.sqlite', folder=
>>> dummy_path, auto_import=True)
>>> global alerts_rows
>>>
>>>
>>> ....
>>>
>>>
>>> Gives the following error.
>>>
>>> File "applications\enLIGHTen\modules\read_logs_to_rows.py", line 141, in
>>> add_clear
>>> dummy_alerts_db_conn = DAL('sqlite://alerts.sqlite', folder=dummy_path,
>>> auto_import=True)
>>> File
>>> "E:\Jitun_Backup\Web2py\web2py_win_2.15.1\gluon\packages\dal\pydal\base.py",
>>> line 170, in __call__
>>> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>>> File
>>> "E:\Jitun_Backup\Web2py\web2py_win_2.15.1\gluon\packages\dal\pydal\base.py",
>>> line 500, in __init__
>>> tables=tables)
>>> File
>>> "E:\Jitun_Backup\Web2py\web2py_win_2.15.1\gluon\packages\dal\pydal\base.py",
>>> line 522, in import_table_definitions
>>> tfile = self._adapter.file_open(filename, 'r')
>>> AttributeError: 'SQLite' object has no attribute 'file_open'
>>>
>>> Any pointers/help is appreciated.
>>>
>>>
>>>
>>>
>>>
--
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.
