[gentoo-commits] proj/tinderbox-cluster:master commit in: pym/tbc/

[Magnus Granberg]

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()