The example in "APSW - Another Python SQLite Wrapper" fails under Windows

[rogerbinns]

From rogerbinns on March 10, 2008 01:58:18

(pysqlite ticket 192)

apsw Example on http://initd.org/pub/software/pysqlite/apsw/3.3.13-r1/apsw.html Has a bug when run under Windows. This bug is caused by the conflict
between Windows use of backslash () as the path separator and Python's use
of forwardslash (/) as the path separator.

with line: sysdirs=",".join(["'%s'" % (x,) for x in sys.path[1:] if len(x)
and os.path.isdir(x)]) The execution error terminates with the tail of its
output as follows:

no commits out of hours commit was not allowed

Traceback (most recent call last):

File "D:\Python\00 Projects\IRR\apswTest.py", line 342, in -toplevel-

    cursor.execute("create virtual table sysfiles using

filesource("+sysdirs+")")

File "apsw.c", line 3518, in resetcursor File "apsw.c", line 2460, in

VirtualTable?.xCreate File "D:\Python\00 Projects\IRR\apswTest.py", line
291, in Create

    columns,data=getfiledata([eval(a) for a in args]) # eval strips off

layer of quotes

File "D:\Python\00 Projects\IRR\apswTest.py", line 278, in getfiledata

    for f in os.listdir(directory):

WindowsError?: [Errno 123] The filename, directory name, or volume label
syntax is incorrect: 'C:\x08in\Python24\Lib\idlelib/.'

with line: sysdirs=",".join(["'%s'" % (x.replace('','/'),) for x in
sys.path[1:] if len(x) and os.path.isdir(x)]) The execution terminates
normally without error.

Original issue: http://code.google.com/p/apsw/issues/detail?id=1

[rogerbinns]

From rogerbinns on May 29, 2008 21:21:19

Incidentally the actual cause is the eval line where I wanted quotes removed as
appropriate but backslashes needed to be doubled up. Eg if the string was (including
the double quotes) "c:\new\run.txt" then the eval was removing the quotes, but also
expanding the \n and \r. The fix is to double up the backslashes before running eval.

[rogerbinns]

From rogerbinns on May 29, 2008 21:24:19

Fix committed in r153

Status: Verified