Lastupdated attribute: a timestamp that updates itself whenever it's item changes

This is more your kind of thing, I think.

A good idea but I will wait for supporting use-cases before doing anything with it.

I had a go at doing this: http://deadbeefbabe.org/paste/2322

I got it partially working using an SQL trigger, but the main problem is that unless you clean Axiom's cache, it doesn't know about the change made to the lastUpdatedDate in the database.

I suppose that this is related to #450 in that a lastTransactionID table could be maintained by sqlite using triggers.

Another problem is that the time sqlite strftime function doesn't return Unix microseconds and is not therefore as accurate as extime.

-RichardW.

Also, I talked to exarkun about this on IRC and he suggested that it would also be useful for getSchema to return any triggers associated with an item. I wondered if an ItemSchema? class might be a good idea and that getScema could be changed to return a ItemSchema? instance.

class IAxiomItemSchema:
  def getAttributes(): pass
 
  def getTriggers(): pass

...but that's as far as I got.

Contents of deadbeefbabe paste