asset_dao.py 985 B

1234567891011121314151617181920212223242526272829303132333435
  1. from utils.UpdateOwnId import updateOwnId
  2. from datetime import datetime
  3. def getInserterdAssetsCount(asset_type,mongo):
  4. count=0
  5. try:
  6. count=mongo["i_tbl_asset_master_new"].count({'asset_type':asset_type})
  7. except Exception as err:
  8. print(err)
  9. return count
  10. def getAssetCategoryListDao(mongo):
  11. category=[]
  12. try:
  13. category=list(mongo["i_assets_sub_cat_master"].find({},{'_id':0}))
  14. except Exception as err:
  15. print('getAssetCategoryListDao',err)
  16. return category
  17. def getAllAssetsListDao(mongo):
  18. assets=[]
  19. try:
  20. assets=list(mongo["i_tbl_asset_master_new"].find({},{'_id':0}))
  21. except Exception as err:
  22. print('getVendorListByUID',err)
  23. return assets
  24. def updateAssetReportDetailsDao(asset_id,update_obj,mongo):
  25. try:
  26. UpdateResult =mongo["i_tbl_asset_master_new"].update_one({'id':str(asset_id)},{'$set':update_obj})
  27. except Exception as identifier:
  28. print(identifier)