SQLite does not return data types in the description of the result set. Thus the standard solution does not work. In order to support complex, multi-table queries (joins) I have patched sqltable.py in the following way:
128,129c128
< # if not query or dbtype == 'sqlite':
< if not query:
---
> if not query or dbtype == 'sqlite':
157d155
< results = cursor.fetchall()
160,161d157
< column_names = map(lambda x:x[0], cursor.description)
< column_types = map(lambda x:type(x),results[0])
175c171
< results = cursor.fetchall()
---
> results = cursor.fetchall()
295a292
>
With this change complex queries do work correctly also for SQLite.
SQLite does not return data types in the description of the result set. Thus the standard solution does not work. In order to support complex, multi-table queries (joins) I have patched sqltable.py in the following way:
With this change complex queries do work correctly also for SQLite.