SmartDukaan – /trunk/PyProj/src/shop2020/payments/impl/DataService.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 2747 – Added the missing links to create a refund

chandranshu — Thu, 28 Jul 2011 12:35:56 +0530

chandranshu – 20 file(s) modified
Added the missing links to create a refund

~ /trunk/HotspotDashboard/src/main/java/in/shop2020/hotspot/dashbaord/client/inbox/InboxPresenterImpl.java
~ /trunk/HotspotDashboard/src/main/java/in/shop2020/hotspot/dashbaord/client/inbox/OrderDetails.java
~ /trunk/HotspotDashboard/src/main/java/in/shop2020/hotspot/dashbaord/client/inbox/RejectReasonBox.java
~ /trunk/HotspotDashboard/src/main/java/in/shop2020/hotspot/dashbaord/server/handler/RejectOrderHandler.java
+ /trunk/PaymentService/src/main/java/in/shop2020/payment/domain/Refund.java
+ /trunk/PaymentService/src/main/java/in/shop2020/payment/domain/RefundAttribute.java
+ /trunk/PaymentService/src/main/java/in/shop2020/payment/handler/RefundHandler.java
+ /trunk/PaymentService/src/main/java/in/shop2020/payment/persistence/RefundMapper.java
~ /trunk/PaymentService/src/main/java/in/shop2020/payment/service/handler/PaymentServiceHandler.java
+ /trunk/PaymentService/src/main/resources/in/shop2020/payment/persistence/RefundMapper.xml
~ /trunk/PaymentService/src/main/resources/mybatis-config.xml
+ /trunk/PyProj/src/shop2020/clients/PaymentClient.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/UserDataAccessors.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/ttypes.py
~ /trunk/ThriftConfig/src/main/java/in/shop2020/payments/PaymentService.java
+ /trunk/ThriftConfig/src/main/java/in/shop2020/payments/Refund.java
~ /trunk/ThriftGen/thriftsrc/PaymentService/PaymentService.thrift

Rev 1248 – Made database name a configurable parameter for Payment, Logistics and ...

chandranshu — Mon, 04 Apr 2011 12:20:01 +0530

chandranshu – 11 file(s) modified
Made database name a configurable parameter for Payment, Logistics and Helper service to ensure that test and development databases can be different

~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/helpers/impl/HelperServer.py
~ /trunk/PyProj/src/shop2020/helpers/impl/HelperServiceHandler.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/LogisticsServiceHandler.py
~ /trunk/PyProj/src/shop2020/logistics/service/LogisticsServer.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py
~ /trunk/PyProj/src/shop2020/payments/PaymentsServer.py

Rev 1131 – Added pool_recycle parameter to the create_engine call

chandranshu — Thu, 24 Mar 2011 18:10:53 +0530

chandranshu – 3 file(s) modified
Added pool_recycle parameter to the create_engine call

~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataService.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py

Rev 1130 – modified size of the description column to 200

rajveer — Thu, 24 Mar 2011 17:45:35 +0530

rajveer – 1 file(s) modified
modified size of the description column to 200

~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py

Rev 746 – support mysql added for mysql

rajveer — Thu, 03 Feb 2011 12:31:46 +0530

rajveer – 7 file(s) modified
support mysql added for mysql

~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/LogisticsServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/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

Rev 743 – Logistic provider addition to order, code moved to OrderService.

rajveer — Wed, 02 Feb 2011 14:49:05 +0530

rajveer – 3 file(s) modified
Logistic provider addition to order, code moved to OrderService.

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/CartDataAccessors.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py

Rev 703 – Removed some extraneous commas from the data service

chandranshu — Fri, 28 Jan 2011 14:20:00 +0530

chandranshu – 1 file(s) modified
Removed some extraneous commas from the data service

~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py

Rev 701 – Implemented all methods of the payment service

chandranshu — Fri, 28 Jan 2011 14:13:14 +0530

chandranshu – 5 file(s) modified
Implemented all methods of the payment service

~ /trunk/PyProj/src/shop2020/payments/impl/converters.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/ttypes.py

Rev 420 – payment service

ashish — Thu, 26 Aug 2010 15:23:29 +0530

ashish – 26 file(s) modified
payment service

~ /trunk/Common/conf/shop2020.cfg
+ /trunk/Common/src/in/shop2020/thrift/clients/PaymentServiceClient.java
~ /trunk/Common/src/in/shop2020/utils/ConfigClientKeys.java
+ /trunk/PyProj/src/shop2020/payments
+ /trunk/PyProj/src/shop2020/payments/impl
+ /trunk/PyProj/src/shop2020/payments/impl/converters.py
+ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
+ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
+ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py
+ /trunk/PyProj/src/shop2020/payments/impl/__init__.py
+ /trunk/PyProj/src/shop2020/payments/PaymentsServer.py
+ /trunk/PyProj/src/shop2020/payments/test
+ /trunk/PyProj/src/shop2020/payments/test/__init__.py
+ /trunk/PyProj/src/shop2020/payments/__init__.py
+ /trunk/PyProj/src/shop2020/thriftpy/payments
+ /trunk/PyProj/src/shop2020/thriftpy/payments/constants.py
+ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService-remote
+ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService.py
+ /trunk/PyProj/src/shop2020/thriftpy/payments/ttypes.py
+ /trunk/PyProj/src/shop2020/thriftpy/payments/__init__.py
~ /trunk/ThriftConfig/src/in/shop2020/payments/Payment.java
~ /trunk/ThriftConfig/src/in/shop2020/payments/PaymentGateway.java
+ /trunk/ThriftConfig/src/in/shop2020/payments/PaymentGatewayStatus.java
~ /trunk/ThriftConfig/src/in/shop2020/payments/PaymentRequest.java
~ /trunk/ThriftConfig/src/in/shop2020/payments/PaymentService.java
~ /trunk/ThriftGen/thriftsrc/PaymentService/PaymentService.thrift