use sql now() instead of python
support legacy engine

in near future we need to auto detect this
can be no permission
Merge pull request #2 from alonbl/f

some more fixes