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