openstack
/
monasca-events-api
Code Issues Proposed changes

Removing soft delete functionality 

Transform repository now deletes row rather than setting the deleted_at
attribute.
This commit is contained in:
Joe Keen 2015-08-14 13:22:24 -06:00
parent 05d5a2b114
commit 8158e755bc
1 changed files with 6 additions and 13 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

19
monasca_events_api/common/repositories/mysql/transforms_repository.py
View File

@ -17,8 +17,8 @@ from oslo_log import log
from oslo_utils import timeutils
from monasca_events_api.common.repositories.mysql import mysql_repository
from monasca_events_api.common.repositories import transforms_repository
from monasca_events_api.common.repositories import constants
from monasca_events_api.common.repositories import transforms_repository
LOG = log.getLogger(__name__)
@ -81,21 +81,14 @@ class TransformsRepository(mysql_repository.MySQLRepository,
tenant_id_clause = " and tenant_id = \"{}\"".format(tenant_id)
transform_id_clause = " and id = \"{}\"".format(transform_id)
query = (base_query+
tenant_id_clause+
query = (base_query +
tenant_id_clause +
transform_id_clause)
rows = self._execute_query(query, [])
return rows
def delete_transform(self, tenant_id, transform_id):
now = timeutils.utcnow()
base_query = "update event_transform set deleted_at = \"{}\" where"\
.format(now)
tenant_id_clause = " tenant_id = \"{}\"".format(tenant_id)
transform_id_clause = " and id = \"{}\"".format(transform_id)
query = (base_query +
tenant_id_clause +
transform_id_clause)
self._execute_query(query, [])
self._execute_query("""delete from event_transform
where tenant_id = %s and id = %s""",
[tenant_id, transform_id])