[odrs-web] Allow recoving from database up->down->up

[Richard Hughes <rhughes src gnome org>]

commit f402857e0195daa7c03f381590328b8212d08be9
Author: Richard Hughes <richard hughsie com>
Date:   Mon Jul 1 13:44:26 2019 +0100

    Allow recoving from database up->down->up

 app_data/migrations/versions/b8243269e9cf_.py | 5 +++++
 1 file changed, 5 insertions(+)
---
diff --git a/app_data/migrations/versions/b8243269e9cf_.py b/app_data/migrations/versions/b8243269e9cf_.py
index 5eeb4ce..5bff90d 100644
--- a/app_data/migrations/versions/b8243269e9cf_.py
+++ b/app_data/migrations/versions/b8243269e9cf_.py
@@ -11,6 +11,7 @@ revision = 'b8243269e9cf'
 down_revision = None
 
 from alembic import op
+import datetime
 import sqlalchemy as sa
 from sqlalchemy.dialects import mysql
 
@@ -22,9 +23,13 @@ def upgrade():
                existing_type=mysql.TIMESTAMP(),
                nullable=True,
                existing_server_default=sa.text("'0000-00-00 00:00:00'"))
+    since = datetime.datetime.now() - datetime.timedelta(hours=3)
     for review in db.session.query(Review).all():
         if review.date_deleted == '0000-00-00 00:00:00':
              review.date_deleted = None
+        if review.date_deleted > since:
+             review.date_deleted = None
+
     db.session.commit()