commit 3fcfdb7674436861d6ab0740972573293b9a355f
author tierno <alfonso.tiernosepulveda@telefonica.com> Tue Oct 24 07:48:24 2017 +0200
committer tierno <alfonso.tiernosepulveda@telefonica.com> Tue Nov 14 13:42:13 2017 +0100
tree e41170e1a48c11320501db67f03c07d5e8ed5c96
parent 5fd09ae8b82f73266da2d103ff6f3c88afb1cc9c

Avoid database growth by cleaning old vim_actions

Change-Id: Ib3ad233c1a85e72fe24229282b59a88bc536c692
Signed-off-by: tierno <alfonso.tiernosepulveda@telefonica.com>

osm_ro/httpserver.py

diff --git a/osm_ro/httpserver.py b/osm_ro/httpserver.py
index b043267..0497bba 100644
--- a/osm_ro/httpserver.py
+++ b/osm_ro/httpserver.py
@@ -1088,15 +1088,13 @@
             nfvo.check_tenant(mydb, tenant_id)
         select_,where_,limit_ = filter_query_string(bottle.request.query, None,
                 ('uuid', 'name', 'osm_id', 'description', 'public', "tenant_id", "created_at") )
-        where_or = {}
         if tenant_id != "any":
-            where_or["tenant_id"] = tenant_id
-            where_or["public"] = True
-        vnfs = mydb.get_rows(FROM='vnfs', SELECT=select_,WHERE=where_,WHERE_OR=where_or, WHERE_AND_OR="AND",LIMIT=limit_)
-        #change_keys_http2db(content, http2db_vnf, reverse=True)
+            where_["OR"]={"tenant_id": tenant_id, "public": True}
+        vnfs = mydb.get_rows(FROM='vnfs', SELECT=select_, WHERE=where_, LIMIT=limit_)
+        # change_keys_http2db(content, http2db_vnf, reverse=True)
         utils.convert_str2boolean(vnfs, ('public',))
         convert_datetime2str(vnfs)
-        data={'vnfs' : vnfs}
+        data={'vnfs': vnfs}
         return format_out(data)
     except bottle.HTTPError:
         raise
@@ -1398,11 +1396,9 @@
         #obtain data
         s,w,l=filter_query_string(bottle.request.query, None,
                                   ('uuid', 'name', 'osm_id', 'description', 'tenant_id', 'created_at', 'public'))
-        where_or={}
         if tenant_id != "any":
-            where_or["tenant_id"] = tenant_id
-            where_or["public"] = True
-        scenarios = mydb.get_rows(SELECT=s, WHERE=w, WHERE_OR=where_or, WHERE_AND_OR="AND", LIMIT=l, FROM='scenarios')
+            w["OR"] = {"tenant_id": tenant_id, "public": True}
+        scenarios = mydb.get_rows(SELECT=s, WHERE=w, LIMIT=l, FROM='scenarios')
         convert_datetime2str(scenarios)
         utils.convert_str2boolean(scenarios, ('public',) )
         data={'scenarios':scenarios}