orbeckst / recsql Goto Github PK

TABs cannot be used in tables because we are using whitespace to count columns.

There should be a warning or an exception when a tab \t character is detected in an input reST table.

I'm getting an import error in sqlarray.py when it tries to load sqlfunctions.

Changing the import statement to: "from . import sqlfunctions" solved the problem for me.

I haven't reviewed sources, but I'd like to know the usage licensing. Would you be willing to add licensing (MIT, LGPL, etc) to this package?

This a known issue, as documented for the SQLarray class. Eventually we would like to have a way to always (correctly) read in recarrays. Until that happens, the rest of this issue report explains the problem and suggests workarounds.

The error occurs because the recarray contained NumPy data types such as numpy.int64 that are not understood by sqlite. Either convert the data manually (by setting the numpy dtypes yourself on the recarray, or better: feed a simple list of tuples (“records”) to this class in the keyword argument records. Make sure that these tuples only contain standard Python types. Together with records you will also have to supply the names of the data columns in the keyword argument columns.

If you are reading from a file then it might be simpler to use recsql.sqlarray.SQLarray_fromfile().

Use six for compatibility.