AttributeError: 'SQLite' object has no attribute 'file_open'

[Jitun John]

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.

[Massimo Di Pierro]

Can you please open a PyDAL ticket so we can track. This should work.

[Lisandro]

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.

[Massimo Di Pierro]

Committed c995fd7 that should fix this

[Jitun John]

Hi Massimo,

I have the 2.15.3 version installed, but the issue remains.

I confirm the same code works on 2.14.6

[Lisandro]

John, could you try with the web2py version for testers?

The commit fixed the problem, but I think it will be included in the next stable version.

At least that's what I did: I downloaded the "for testers" source code version, and it worked ok:

This is the link to the download:

https://mdipierro.pythonanywhere.com/examples/static/nightly/web2py_src.zip

You can find it also in the official webpage:

http://web2py.com/init/default/download

Hope it helps.

Regards,

Lisandro.

[Massimo Di Pierro]

you have the latest web2py but you have an older pydal.

[Jitun John]

You are totally correct my friend.

I updated gluon\packages\dal\pydal with latest pyDal to resolve the issue.