Error running query: datetime.time(13, 52, 27) is not JSON serializable

[SomeKittens]

My table schema:

CREATE TABLE F_entrances (
  id SERIAL PRIMARY KEY,
  timeOfEntrance time,
  customerId int REFERENCES D_customers
);

(and yes, I committed the horrible sin of camel_case vs underScore. I'll be fixing that soonish)

The query

SELECT
timeofentrance
FROM F_entrances

Gives me the error Error running query: datetime.time(13, 52, 27) is not JSON serializable. I worked around it with to_char but this seems to be a problem at the Python layer.

[arikfr]

It's definitely is. What datasource type are you using?

[arikfr]

Ok, I believe I know where the problem is. Expect a fix tomorrow.

On Sunday, June 28, 2015, Randall Koutnik notifications@github.com wrote:

My table schema:

CREATE TABLE F_entrances (
id SERIAL PRIMARY KEY,
timeOfEntrance time,
customerId int REFERENCES D_customers
);

(and yes, I committed the horrible sin of camel_case vs underScore. I'll
be fixing that soonish)

The query

SELECT
timeofentranceFROM F_entrances

Gives me the error Error running query: datetime.time(13, 52, 27) is not
JSON serializable. I worked around it with to_char but this seems to be a
problem at the Python layer http://stackoverflow.com/a/11875813/1216976.

—
Reply to this email directly or view it on GitHub
#463.

[SomeKittens]

I'm using postgres here. Thanks for the quick response!

[arikfr]

Fixed this in #464 and it's part of the 0.6.1-RC release. See details on how to upgrade here.

There is still some room for improvement in the UI (time columns treated as plain strings), but at least it will return results now.