orange2 icon indicating copy to clipboard operation
orange2 copied to clipboard

problem accessing sqlite databases with full path

Open sanzoghenzo opened this issue 9 years ago • 0 comments

Hi all, I'm trying to use the SQLReader class in python script widget to access a sqlite database placed in a different path than orange itself. Here's the code:

from Orange.data.sql import *
r = SQLReader()
r.connect('sqlite:///d:/path/to/database.db/')

and this is the log:

Running script:
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "<string>", line 4, in <module>
  File "[...]\Orange\utils\__init__.py", line 214, in wrap_call
    return func(*args, **kwargs)
  File "[...]\Orange\data\sql.py", line 195, in connect
    (self.quirks, self.conn) = _connection(uri)
  File "[...]\Orange\data\sql.py", line 141, in _connection
    return (quirks, dbmod.connect(host))
ValueError: database parameter must be string or APSW Connection object

Looking at the source code it seem that the connection string is not treated at it should since line 15 is handling the third slash incorrectly.

sanzoghenzo avatar Jul 14 '16 14:07 sanzoghenzo