SmartDukaan – /trunk/PyProj/src/shop2020/helpers/impl/

Rev 35718 – fix: use session.remove() instead of session.close() to prevent memory leaks ...

amit — Tue, 10 Feb 2026 00:17:06 +0530

amit – 12 file(s) modified
fix: use session.remove() instead of session.close() to prevent memory leaks in all services

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/script/CompetitorScraping.py
~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/CartDataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/PromotionDataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/UserDataAccessors.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/purchase/main/handler/PurchaseServiceHandler.py
~ /trunk/PyProj/src/shop2020/purchase/main/script/PendingPurchaseOrderReport.py

Rev 35701 – Performance fix: reduce logging level to WARNING, remove incompatible pool_pre_ping, ...

amit — Mon, 09 Feb 2026 16:59:51 +0530

amit – 14 file(s) modified
Performance fix: reduce logging level to WARNING, remove incompatible pool_pre_ping, fix tornado dependency

- Changed logging.basicConfig from DEBUG to WARNING in 6 service files to stop
SQLAlchemy query spam that caused memory bloat (TransactionServer 553MB -> 63MB)
- Set echoOn=False as default in PurchaseServiceHandler
- Removed pool_pre_ping=True from 7 DataService files (incompatible with SQLAlchemy 0.6.6)
- Updated tornado dependency from 1.0.1 to 1.0 in setup.py (1.0.1 unavailable on PyPI)

~ /trunk/PyProj/src/setup.py
~ /trunk/PyProj/src/shop2020/content/main/handler/ContentHandler.py
~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/EcomExpressService.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/ObsoleteDataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/Dataservice.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
~ /trunk/PyProj/src/shop2020/purchase/main/handler/PurchaseServiceHandler.py

Rev 35608 – Fix DB connection pooling to reduce service restarts - ...

amit — Wed, 28 Jan 2026 17:15:30 +0530

amit – 8 file(s) modified
Fix DB connection pooling to reduce service restarts

- Add pool_timeout=30 to fail fast instead of hanging indefinitely
- Add pool_pre_ping=True to detect stale MySQL connections before use
- Reduce pool_recycle from 7200s to 3600s for fresher connections
- Disable SQL echo logging (echo=False) to reduce memory/CPU usage
- Fix MongoDB connection with thread-safe initialization and proper pooling

Modified services: helper, user, inventory, order, payment, logistics, catalog

~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/Dataservice.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
~ /trunk/PyProj/src/shop2020/utils/ContentUploadUtil.py

Rev 23839 – changed mail domain profitmandi.com -> smartdukaan.com

amit.gupta — Tue, 03 Jul 2018 11:15:44 +0530

amit.gupta – 30 file(s) modified
changed mail domain profitmandi.com -> smartdukaan.com

~ /trunk/Crm/src/main/java/in/shop2020/util/CRMConstants.java
~ /trunk/Crm/src/main/java/in/shop2020/util/CRMEmailProcessor.java
~ /trunk/Crm/src/main/java/in/shop2020/util/EmailReader.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/nonbillable/Warehouse.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ContactUsController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/InsuranceController.java
~ /trunk/PyDTR/src/scripts/AmazonBestSellers.py
~ /trunk/PyDTR/src/scripts/FlipkartBestSeller.py
~ /trunk/PyDTR/src/scripts/HomeShopBestSellers.py
~ /trunk/PyDTR/src/scripts/PaytmBestSellers.py
~ /trunk/PyDTR/src/scripts/ProfitMandiUserDataUpdationRequest.py
~ /trunk/PyDTR/src/scripts/SaholicBestSellers.py
~ /trunk/PyDTR/src/scripts/ShopCluesBestSellers.py
~ /trunk/PyDTR/src/scripts/SnapdealBestSellers.py
~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/logistics/service/script/DestinationProviderAllocationLoader.py
~ /trunk/PyProj/src/shop2020/logistics/service/script/EcomAwbUpdater.py
~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/OrderServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/order/script/AramexLogisticsReconciliation.py
~ /trunk/PyProj/src/shop2020/model/v1/order/script/DelayedOrdersReport.py
~ /trunk/PyProj/src/shop2020/model/v1/order/script/EcomExpressLogisticsReconciliation.py
~ /trunk/PyProj/src/shop2020/model/v1/order/script/ProfitMandiSalesAssociate.py
~ /trunk/PyProj/src/shop2020/model/v1/order/script/RQuickLogisticsReconciliation.py
~ /trunk/PyProj/src/shop2020/purchase/main/script/PendingPurchaseOrderReport.py
~ /trunk/PyProj/src/shop2020/utils/EmailAttachmentSender.py
~ /trunk/ShipDEWebServiceClient/src/main/java/com/aramex/impl/Aramex.java
~ /trunk/ThriftGen/thriftsrc/UserModel/UserModel.thrift
~ /trunk/WarehouseService/src/main/java/in/shop2020/warehouse/util/InventoryMismatchGenerator.java

Rev 23356 – Changed sms id.

amit.gupta — Tue, 13 Feb 2018 18:42:06 +0530

amit.gupta – 3 file(s) modified
Changed sms id.

~ /trunk/PyDTR/src/scripts/ItemAvailablityCaching.py
~ /trunk/PyDTR/src/scripts/ProfitMandiNewSmsBlaster.py
~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 22768 –

amit.gupta — Mon, 30 Oct 2017 19:24:08 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 22759 –

amit.gupta — Mon, 30 Oct 2017 12:16:41 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 22469 –

amit.gupta — Wed, 20 Sep 2017 10:19:33 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 22397 – Minor changes related to mail and messaging

amit.gupta — Fri, 08 Sep 2017 09:43:18 +0530

amit.gupta – 2 file(s) modified
Minor changes related to mail and messaging

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py

Rev 22395 –

amit.gupta — Fri, 08 Sep 2017 09:20:22 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 21454 – Order creation changes

amit.gupta — Fri, 12 May 2017 10:19:57 +0530

amit.gupta – 6 file(s) modified
Order creation changes

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/CartDataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/UserContextSerivceHandler.py
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/user/UserContextService-remote
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/user/UserContextService.py

Rev 20471 – added password

amit.gupta — Thu, 03 Nov 2016 12:14:54 +0530

amit.gupta – 1 file(s) modified
added password

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 20244 – Fixed email sender

amit.gupta — Tue, 02 Aug 2016 09:52:23 +0530

amit.gupta – 1 file(s) modified
Fixed email sender

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py

Rev 20242 – Fixed email sender and sms sender logic

amit.gupta — Sun, 31 Jul 2016 13:34:22 +0530

amit.gupta – 1 file(s) modified
Fixed email sender and sms sender logic

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py

Rev 16445 – Committed by Manish Sharma for Profit Mandi Email Sender on ...

manish.sharma — Thu, 20 Aug 2015 16:16:44 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit Mandi Email Sender on 20-Aug-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 16444 – Committed by Manish Sharma for Profit Mandi Email Sender on ...

manish.sharma — Thu, 20 Aug 2015 16:04:41 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit Mandi Email Sender on 20-Aug-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 16443 – Committed by Manish Sharma for Profit Mandi Email Sender on ...

manish.sharma — Thu, 20 Aug 2015 15:56:27 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit Mandi Email Sender on 20-Aug-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 16442 – Committed by Manish Sharma for Profit Mandi Email Sender on ...

manish.sharma — Thu, 20 Aug 2015 15:51:09 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit Mandi Email Sender on 20-Aug-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 16441 – Committed by Manish Sharma for Profit Mandi Email Sender on ...

manish.sharma — Thu, 20 Aug 2015 15:41:12 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit Mandi Email Sender on 20-Aug-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 16438 – Committed by Manish Sharma for Profit Mandi Email Sender on ...

manish.sharma — Thu, 20 Aug 2015 14:57:26 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit Mandi Email Sender on 20-Aug-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 15010 – Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

manish.sharma — Wed, 29 Apr 2015 11:52:39 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 15009 – Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

manish.sharma — Wed, 29 Apr 2015 11:50:40 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 15008 – Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

manish.sharma — Wed, 29 Apr 2015 11:45:56 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 15006 – Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

manish.sharma — Wed, 29 Apr 2015 11:07:16 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit_Mandi CRM Integration on 29-Apr-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 14927 – Committed by Manish Sharma for Profit_Mandi CRM Integration on 22-Apr-2015

manish.sharma — Wed, 22 Apr 2015 11:28:36 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Profit_Mandi CRM Integration on 22-Apr-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 13543 – Committed by Manish Sharma for SMS API Integration on 14-Jan-2015

manish.sharma — Wed, 14 Jan 2015 18:00:38 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS API Integration on 14-Jan-2015

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py

Rev 13476 – Source parsing issue

kshitij.sood — Mon, 29 Dec 2014 21:16:08 +0530

kshitij.sood – 1 file(s) modified
Source parsing issue

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 13363 – Committed by Manish Sharma for Bulk Shipment Creation Process on ...

manish.sharma — Thu, 18 Dec 2014 11:31:46 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Bulk Shipment Creation Process on 18-Dec-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/EmailSender.py

Rev 13360 – Committed by Manish Sharma for Bulk Shipment Creation Process on ...

manish.sharma — Thu, 18 Dec 2014 11:26:04 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for Bulk Shipment Creation Process on 18-Dec-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py

Rev 13225 –

kshitij.sood — Sat, 06 Dec 2014 20:36:30 +0530

kshitij.sood – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py

Rev 13214 – Campaign & gosf

kshitij.sood — Sat, 06 Dec 2014 16:01:44 +0530

kshitij.sood – 8 file(s) modified
Campaign & gosf

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/helpers/impl/HelperServiceHandler.py
~ /trunk/PyProj/src/shop2020/thriftpy/utils/HelperService.py
~ /trunk/PyProj/src/shop2020/thriftpy/utils/ttypes.py
+ /trunk/ThriftConfig/src/main/java/in/shop2020/utils/Campaigns.java
~ /trunk/ThriftConfig/src/main/java/in/shop2020/utils/HelperService.java
~ /trunk/ThriftGen/thriftsrc/Helpers/HelperService.thrift

Rev 13202 – Committed by Manish Sharma for SMS API Integration on 03-Dec-2014

manish.sharma — Wed, 03 Dec 2014 12:03:16 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS API Integration on 03-Dec-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 13171 –

kshitij.sood — Mon, 01 Dec 2014 12:35:35 +0530

kshitij.sood – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 13121 – Committed by Manish Sharma for SMS Api Integration on 25-Nov-2014

manish.sharma — Tue, 25 Nov 2014 14:42:25 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS Api Integration on 25-Nov-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 13119 – Committed by Manish Sharma for SMS Api Integration on 25-Nov-2014

manish.sharma — Tue, 25 Nov 2014 14:41:12 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS Api Integration on 25-Nov-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 13106 – Committed by Manish Sharma for SMS Api Integration on 21-Nov-2014

manish.sharma — Fri, 21 Nov 2014 12:41:36 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS Api Integration on 21-Nov-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 13105 – Committed by Manish Sharma for SMS Api Integration on 21-Nov-2014

manish.sharma — Fri, 21 Nov 2014 12:15:42 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS Api Integration on 21-Nov-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 13100 – Committed by Manish Sharma for SMS Api Integration on 19-Nov-2014

manish.sharma — Wed, 19 Nov 2014 12:35:29 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS Api Integration on 19-Nov-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 12967 – Committed by Manish Sharma for SMS api Integration on 29-Oct-2014

manish.sharma — Wed, 29 Oct 2014 10:50:23 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS api Integration on 29-Oct-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py

Rev 12955 – Committed by Manish Sharma for SMS api Integration on 27-Oct-2014

manish.sharma — Mon, 27 Oct 2014 15:37:50 +0530

manish.sharma – 1 file(s) modified
Committed by Manish Sharma for SMS api Integration on 27-Oct-2014

~ /trunk/PyProj/src/shop2020/helpers/impl/SmsSender.py