[odrs-web] Allow recoving from database up->down->up
- From: Richard Hughes <rhughes src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [odrs-web] Allow recoving from database up->down->up
- Date: Mon, 1 Jul 2019 12:44:36 +0000 (UTC)
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()
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]