SmartDukaan – /trunk/PyProj/src/

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 35738 – Add session.expunge_all() after commits in inventory cache update functions to ...

amit — Wed, 11 Feb 2026 16:11:43 +0530

amit – 1 file(s) modified
Add session.expunge_all() after commits in inventory cache update functions to prevent ORM object accumulation

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.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 35732 – Replace Warehouse ORM queries with raw SQL cache in inventory ...

amit — Wed, 11 Feb 2026 15:16:19 +0530

amit – 1 file(s) modified
Replace Warehouse ORM queries with raw SQL cache in inventory DataAcessors - same approach as logistics fix

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 35722 – perf: use raw SQL for logistics startup caches to avoid ...

amit — Tue, 10 Feb 2026 12:03:10 +0530

amit – 1 file(s) modified
perf: use raw SQL for logistics startup caches to avoid ORM memory overhead

~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataAccessor.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 35705 – Include resource files (cfg, xml, xls) in egg build via ...

amit — Mon, 09 Feb 2026 18:21:45 +0530

amit – 1 file(s) modified
Include resource files (cfg, xml, xls) in egg build via package_data

~ /trunk/PyProj/src/setup.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 33491 – Added new db

amit.gupta — Wed, 26 Jun 2024 18:11:34 +0530

amit.gupta – 1 file(s) modified
Added new db

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 31115 –

amit.gupta — Sat, 29 Oct 2022 22:37:28 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 31041 –

amit.gupta — Wed, 12 Oct 2022 17:53:25 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/logistics/service/impl/LogisticsServiceHandler.py

Rev 31015 –

amit.gupta — Fri, 07 Oct 2022 17:10:40 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 30569 –

amit.gupta — Thu, 02 Jun 2022 15:11:28 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/user/impl/Dataservice.py

Rev 30540 –

amit.gupta — Tue, 31 May 2022 15:07:39 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 30536 –

amit.gupta — Mon, 30 May 2022 19:42:13 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 30528 –

amit.gupta — Mon, 30 May 2022 14:53:14 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 30520 –

amit.gupta — Sat, 28 May 2022 18:51:12 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 30515 –

amit.gupta — Fri, 27 May 2022 11:40:48 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 30503 –

amit.gupta — Thu, 26 May 2022 15:19:00 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

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 28986 –

amit.gupta — Wed, 18 Aug 2021 11:45:50 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 28647 – Added expunge

amit.gupta — Mon, 19 Jul 2021 14:56:50 +0530

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

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28630 –

amit.gupta — Fri, 16 Jul 2021 13:03:22 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28629 –

amit.gupta — Fri, 16 Jul 2021 12:57:33 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28628 –

amit.gupta — Fri, 16 Jul 2021 12:57:20 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28621 –

amit.gupta — Wed, 14 Jul 2021 18:23:59 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28620 – Done changes related to Warehouse issue

amit.gupta — Wed, 14 Jul 2021 14:39:51 +0530

amit.gupta – 1 file(s) modified
Done changes related to Warehouse issue

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28554 –

amit.gupta — Wed, 07 Jul 2021 17:30:30 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28553 –

amit.gupta — Wed, 07 Jul 2021 17:26:35 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 28522 –

amit.gupta — Mon, 28 Jun 2021 17:06:42 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/config/resources/shop2020.cfg

Rev 28178 –

amit.gupta — Wed, 07 Apr 2021 17:47:34 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 27448 –

amit.gupta — Sat, 05 Dec 2020 15:38:29 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 26995 – Fixed tax rate issues

amit.gupta — Fri, 28 Aug 2020 15:15:58 +0530

amit.gupta – 2 file(s) modified
Fixed tax rate issues

~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/CatalogServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py

Rev 26911 –

amit.gupta — Sat, 08 Aug 2020 14:19:41 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataAcessors.py

Rev 26887 –

amit.gupta — Sun, 02 Aug 2020 12:50:27 +0530

amit.gupta – 1 file(s) modified

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

Rev 26816 –

amit.gupta — Thu, 16 Jul 2020 11:12:02 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/content/main/handler/ContentHandler.py

Rev 26506 –

amit.gupta — Fri, 03 Apr 2020 13:51:51 +0530

amit.gupta – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py