[Patch] Add Trac 0.12 compatible version

[anonymous]

I tried setting this up in our development environment but ran into some issues. To run this plugin on MySQL I first needed to make the changes mentioned in ​http://trac-hacks.org/ticket/5568

I then had more problems that I think are due to 0.12 changes. First with

RuntimeError: No Content-Length header set

so I changed

req.write(jsdstr)

to

req.send(jsdstr.encode('utf-8'))

Stats were now returned but they were all 0. I noticed the sql generated looked for dates in seconds while the table used microseconds. I changed all the

to_timestamp

to

to_utimestamp

That was enough to get it working.

​http://www.moxy.com.au/

[anonymous]

Replying to anonymous:

Stats were now returned but they were all 0. I noticed the sql generated looked for dates in seconds while the table used microseconds. I changed all the

to_timestamp

to

to_utimestamp

That was enough to get it working.

​http://www.moxy.com.au/

I can confirm this.

[Ryan J Ollos]

Partial duplicate of #6333, but I'll close the other tickets since this also has a fix for the 0.12 timestamp format.

[Ryan J Ollos]

(In [8413]) Creating a 0.12 branch. Refs #7038.

[Ryan J Ollos]

(In [8414]) Changed timestamp format for Trac 0.12. Fixes #7038.

[Ryan J Ollos]

(In [13103]) Refs #7038: Follow-on to [8414]. Made trunk compatible with Trac 0.11 and higher by importing to_utimestamp only when the function exists, and falling back to to_timestamp.