Hello everyone,
I think this question may be for the database side, but i 'd like to post
here if you don't mind.
I have a certain periodic task that bult updates a couple of columns has
expired in "License" table. ( It doesn't matter what it is. )
In this situation, time accuracy was really important to me so i was
running the task per one minute.
The code is like this.
# call in every one minute with something like MQ
session.query( License ).filter( License.expired_at > func.now() ).update({
License.type: 'basic'
})
But, if I want to modify this period down to 1 sec, as you know performance
is gonna be really bad.
If License.expired_at were not datetime field, i would try with
sqlalchemy's event api at the orm attribute's changing point...
I think the problem is nothing is aware of the time goes by and even
Postgresql has not a time triggered feature.
Am I approached in wrong way ?
I'm searching for the best practice of this situation.
Any thoughts will be great help, thank you.
Regards,
Tate
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
