results via pgAdmin but not via psycopg2
От | Krystian Samp |
---|---|
Тема | results via pgAdmin but not via psycopg2 |
Дата | |
Msg-id | E4D40EAD-6FFA-4CB5-834A-6020146DB1E6@gmail.com обсуждение исходный текст |
Ответы |
Re: results via pgAdmin but not via psycopg2
|
Список | psycopg |
Hello everyone, I’ve been struggling with an issue for 2 days now and couldn’t find the answer via google search. here’s a method of my db class: def get_old_feeds( self, not_refreshed_for_secs ): cursor = self.connection.cursor( cursor_factory = psycopg2.extras.RealDictCursor ) cursor.execute( "SELECT id, url FROM feeds WHERE refreshed_on is not NULL AND refreshed_on < ( now() - interval '%sseconds' );", ( not_refreshed_for_secs, ) ) old_feeds = cursor.fetchall() cursor.close() return old_feeds there’s a loop that invokes this method every X minutes. All “old_feeds” get their value for “refreshed_on” updated to thecurrent date when processed using this method: def set_feed_last_refresh( self, feed_id, refresh_datetime ): cursor = self.connection.cursor() cursor.execute( "UPDATE feeds SET refreshed_on = %s WHERE id = %s;", ( refresh_datetime, feed_id ) ) self.connection.commit() cursor.close() The problem is that the select query in the first method returns some results only the first time it is run, all subsequentexecutions give 0 results. The odd thing is that when I issue exactly the same query via pgAdmin I get the resultsas one would expect. I’d highly appreciate your help with this issue, Thank you, Krystian
В списке psycopg по дате отправления: