WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py

         vatMaster = CategoryVatMaster.query.filter(and_(CategoryVatMaster.categoryId==item.category, CategoryVatMaster.minVal<=price,  CategoryVatMaster.maxVal>=price)).first()
         vatPercentage = vatMaster.vatPercent
         if  vatPercentage is None:
             vatPercentage = 0
     return vatPercentage
+def add_tag (displayName, catalogId):
+    ent_tag = None
+    if catalogId is None or (not is_valid_catalog_id(catalogId)):
+        raise InventoryServiceException(id, "Invalid CatalogId")
+    else:
+        ent_tag = EntityTag()
+        ent_tag.entityId = catalogId
+    if displayName is None:
+        raise InventoryServiceException(id, "Tag should not be empty")
+    else:
+        ent_tag.tag = displayName
+    session.commit()
+    return True
+def get_all_tags ():
+    return [tuple[0] for tuple in session.query(EntityTag.tag).distinct().all()]
+def get_all_entities_by_tag_name(displayName):
+    return [tuple[0] for tuple in session.query(EntityTag.entityId).filter_by(tag=displayName).all()]
+def delete_tag(displayName):
+    session.query(EntityTag.entityId).filter_by(tag=displayName).delete()
+    session.commit()
+    return True

Subversion Repositories SmartDukaan