commit:     e8fbf308450b9b257f1cd16532591caba51cc192
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Thu Dec 22 11:09:24 2016 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Thu Dec 22 11:09:24 2016 +0000
URL:        
https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=e8fbf308

reset new and updated on ebuild and package metadata

 pym/tbc/sqlquerys.py | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/pym/tbc/sqlquerys.py b/pym/tbc/sqlquerys.py
index 1d69151..a64c5ef 100644
--- a/pym/tbc/sqlquerys.py
+++ b/pym/tbc/sqlquerys.py
@@ -616,3 +616,30 @@ def add_old_category(session, category_id):
        CategorysInfo = session.query(Categories).filter_by(CategoryId = 
category_id).one()
        CategorysInfo.Active = False
        session.commit()
+
+def reset_new_updated(session):
+       try:
+               PMInfo = 
session.query(PackagesMetadata).filter(PackagesMetadata.New == True).all()
+       except NoResultFound as e:
+               pass
+       else:
+               for x in PMInfo:
+                       x.New = False
+                       session.flush()
+       try:
+               EMInfo = 
session.query(EbuildsMetadata).filter(EbuildsMetadata.New == True).all()
+       except NoResultFound as e:
+               pass
+       else:
+               for x in EMInfo:
+                       x.New = False
+                       session.flush()
+       try:
+               EMInfo = 
session.query(EbuildsMetadata).filter(EbuildsMetadata.Updated == True).all()
+       except NoResultFound as e:
+               pass
+       else:
+               for x in EMInfo:
+                       x.Updated = False
+                       session.flush()
+       session.commit()

Reply via email to