SmartDukaan – /trunk/PyProj/src/shop2020/model/v1/order/

Rev 35751 – TransactionServer: add session.expunge_all() and periodic gc.collect() in close_session() to prevent ...

amit — Thu, 12 Feb 2026 13:38:14 +0530

amit – 1 file(s) modified
TransactionServer: add session.expunge_all() and periodic gc.collect() in close_session() to prevent memory growth from ORM identity map accumulation and Python 2.7 memory fragmentation

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

Rev 35734 – Remove AlertClient dependency from order DataAccessors and ObsoleteDataAccessors

amit — Wed, 11 Feb 2026 15:31:27 +0530

amit – 2 file(s) modified
Remove AlertClient dependency from order DataAccessors and ObsoleteDataAccessors

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

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 34206 – Added comment

amit.gupta — Mon, 17 Feb 2025 15:26:42 +0530

amit.gupta – 1 file(s) modified
Added comment

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

Rev 34205 – Removed change color

amit.gupta — Mon, 17 Feb 2025 15:13:08 +0530

amit.gupta – 1 file(s) modified
Removed change color

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

Rev 30063 –

amit.gupta — Sat, 19 Feb 2022 20:19:49 +0530

amit.gupta – 1 file(s) modified

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

Rev 26410 –

amit.gupta — Thu, 05 Mar 2020 17:09:39 +0530

amit.gupta – 1 file(s) modified

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

Rev 26409 –

amit.gupta — Thu, 05 Mar 2020 17:09:07 +0530

amit.gupta – 1 file(s) modified

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

Rev 26000 –

amit.gupta — Fri, 13 Dec 2019 13:51:22 +0530

amit.gupta – 1 file(s) modified

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

Rev 25944 – Invoice details should not be removed once billed.

amit.gupta — Tue, 03 Dec 2019 11:44:27 +0530

amit.gupta – 1 file(s) modified
Invoice details should not be removed once billed.

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

Rev 25193 –

amit.gupta — Wed, 03 Jul 2019 12:51:04 +0530

amit.gupta – 1 file(s) modified

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

Rev 25020 –

amit.gupta — Thu, 06 Jun 2019 19:04:28 +0530

amit.gupta – 1 file(s) modified

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

Rev 25019 –

amit.gupta — Thu, 06 Jun 2019 18:06:18 +0530

amit.gupta – 1 file(s) modified

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

Rev 24945 – Fixed status

amit.gupta — Mon, 13 May 2019 15:18:54 +0530

amit.gupta – 1 file(s) modified
Fixed status

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

Rev 24908 –

amit.gupta — Tue, 07 May 2019 20:04:42 +0530

amit.gupta – 1 file(s) modified

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

Rev 24907 –

amit.gupta — Tue, 07 May 2019 19:54:02 +0530

amit.gupta – 1 file(s) modified

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

Rev 24262 – Fixed

amit.gupta — Tue, 04 Dec 2018 15:38:32 +0530

amit.gupta – 1 file(s) modified
Fixed

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

Rev 24214 –

amit.gupta — Mon, 12 Nov 2018 14:24:37 +0530

amit.gupta – 1 file(s) modified

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

Rev 24212 –

amit.gupta — Mon, 05 Nov 2018 15:38:15 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataService.py

Rev 24210 –

amit.gupta — Mon, 05 Nov 2018 14:45:40 +0530

amit.gupta – 1 file(s) modified

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

Rev 24209 – Fixed

amit.gupta — Mon, 05 Nov 2018 13:56:15 +0530

amit.gupta – 1 file(s) modified
Fixed

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

Rev 24208 – Fixed delivery challan

amit.gupta — Mon, 05 Nov 2018 12:53:36 +0530

amit.gupta – 1 file(s) modified
Fixed delivery challan

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

Rev 24137 – Fixed issue with warehouse marked to 0

amit.gupta — Fri, 05 Oct 2018 13:39:35 +0530

amit.gupta – 1 file(s) modified
Fixed issue with warehouse marked to 0

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

Rev 23864 – Added LineItem Imei

amit.gupta — Thu, 05 Jul 2018 15:44:54 +0530

amit.gupta – 1 file(s) modified
Added LineItem Imei

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataService.py

Rev 23863 – Added line item imei

amit.gupta — Thu, 05 Jul 2018 15:42:12 +0530

amit.gupta – 1 file(s) modified
Added line item imei

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.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 23812 – Added feature to reverse advance amount in wallet

amit.gupta — Wed, 27 Jun 2018 06:56:25 +0530

amit.gupta – 2 file(s) modified
Added feature to reverse advance amount in wallet

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/Support/src/main/webapp/WEB-INF/content/user-wallet-credit-edit.vm

Rev 23810 –

amit.gupta — Wed, 27 Jun 2018 06:48:49 +0530

amit.gupta – 1 file(s) modified

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

Rev 23809 – Added feature to reverse advance amount in wallet

amit.gupta — Wed, 27 Jun 2018 06:38:04 +0530

amit.gupta – 3 file(s) modified
Added feature to reverse advance amount in wallet

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/Support/src/main/java/in/shop2020/support/controllers/UserWalletCreditController.java
~ /trunk/Support/src/main/webapp/WEB-INF/content/user-wallet-credit-edit.vm

Rev 23777 – Fixed delivery message.

amit.gupta — Thu, 07 Jun 2018 13:39:05 +0530

amit.gupta – 1 file(s) modified
Fixed delivery message.

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

Rev 23710 – Fixed fields

amit.gupta — Sun, 27 May 2018 09:22:30 +0530

amit.gupta – 1 file(s) modified
Fixed fields

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

Rev 23686 – Fixed order creation for courier

amit.gupta — Wed, 23 May 2018 17:54:49 +0530

amit.gupta – 3 file(s) modified
Fixed order creation for courier

~ /trunk/PyProj/src/shop2020/logistics/service/impl/LogisticsServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/OrderServiceHandler.py

Rev 23636 – Removed messages of split

amit.gupta — Sat, 05 May 2018 08:30:46 +0530

amit.gupta – 1 file(s) modified
Removed messages of split

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

Rev 23590 –

amit.gupta — Tue, 24 Apr 2018 19:24:37 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/order/script/DelayedOrdersReport.py

Rev 23537 –

amit.gupta — Mon, 09 Apr 2018 16:46:10 +0530

amit.gupta – 1 file(s) modified

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

Rev 23536 – Wallet refund fixed in case of cancelled by customer request.

amit.gupta — Mon, 09 Apr 2018 16:18:55 +0530

amit.gupta – 1 file(s) modified
Wallet refund fixed in case of cancelled by customer request.

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

Rev 23525 –

amit.gupta — Fri, 06 Apr 2018 12:18:48 +0530

amit.gupta – 1 file(s) modified

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

Rev 23524 –

amit.gupta — Fri, 06 Apr 2018 12:17:11 +0530

amit.gupta – 1 file(s) modified

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