SmartDukaan – /trunk/PyProj/src/shop2020/payments/

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 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 2309 – bug fixed in to_t_payment_gateway

ankur.singhal — Wed, 22 Jun 2011 15:24:42 +0530

ankur.singhal – 1 file(s) modified
bug fixed in to_t_payment_gateway

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

Rev 2192 – Closed the session after querying for statistics.

chandranshu — Tue, 14 Jun 2011 18:07:48 +0530

chandranshu – 1 file(s) modified
Closed the session after querying for statistics.

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

Rev 2062 – change method getPayments comments. If gatewayId is passed as 0, ...

ankur.singhal — Thu, 02 Jun 2011 19:14:02 +0530

ankur.singhal – 2 file(s) modified
change method getPayments comments. If gatewayId is passed as 0, it is ignored.

~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService.py

Rev 1731 – optimisation of methods for getting max, min amounts of orders ...

ankur.singhal — Thu, 05 May 2011 16:24:31 +0530

ankur.singhal – 12 file(s) modified
optimisation of methods for getting max, min amounts of orders and payments. These methods are used for statistics (Support).

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/OrderServiceHandler.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/order/TransactionService-remote
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/order/TransactionService.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService-remote
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService.py
~ /trunk/Support/src/main/java/in/shop2020/support/controllers/StatisticsController.java
~ /trunk/ThriftConfig/src/main/java/in/shop2020/model/v1/order/TransactionService.java
~ /trunk/ThriftConfig/src/main/java/in/shop2020/payments/PaymentService.java
~ /trunk/ThriftGen/thriftsrc/OrderService/OrderService.thrift
~ /trunk/ThriftGen/thriftsrc/PaymentService/PaymentService.thrift

Rev 1659 – Payment status was not getting set to INIT since the ...

chandranshu — Tue, 03 May 2011 14:03:50 +0530

chandranshu – 1 file(s) modified
Payment status was not getting set to INIT since the attribute used there was named ps

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

Rev 1657 – modified max and min payment amount calls to return the ...

ankur.singhal — Tue, 03 May 2011 13:12:31 +0530

ankur.singhal – 1 file(s) modified
modified max and min payment amount calls to return the amounts of only successful payments.

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

Rev 1627 – added methods in PaymentsHandler and OrderServiceHandler for getting statistics. (max ...

ankur.singhal — Mon, 02 May 2011 11:22:20 +0530

ankur.singhal – 8 file(s) modified
added methods in PaymentsHandler and OrderServiceHandler for getting statistics. (max & min order amount, max & min payment amount, distinct customers who have bought)

~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/OrderServiceHandler.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/order/TransactionService-remote
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/order/TransactionService.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService-remote
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService.py

Rev 1493 – Return all transactions/payments when status passed is None.

vikas — Thu, 21 Apr 2011 16:49:04 +0530

vikas – 2 file(s) modified
Return all transactions/payments when status passed is None.

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

Rev 1415 – Added dbname parameter to all the servers

chandranshu — Fri, 15 Apr 2011 19:46:20 +0530

chandranshu – 3 file(s) modified
Added dbname parameter to all the servers

~ /trunk/PyProj/src/shop2020/model/v1/catalog/CatalogServer.py
~ /trunk/PyProj/src/shop2020/model/v1/user/UserContextServer.py
~ /trunk/PyProj/src/shop2020/payments/PaymentsServer.py

Rev 1267 – Started reading dbname parameters from the config file

chandranshu — Tue, 05 Apr 2011 15:52:01 +0530

chandranshu – 6 file(s) modified
Started reading dbname parameters from the config file

~ /trunk/PyProj/src/shop2020/helpers/impl/HelperServer.py
~ /trunk/PyProj/src/shop2020/logistics/service/LogisticsServer.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/CatalogServer.py
~ /trunk/PyProj/src/shop2020/model/v1/order/TransactionServer.py
~ /trunk/PyProj/src/shop2020/model/v1/user/UserContextServer.py
~ /trunk/PyProj/src/shop2020/payments/PaymentsServer.py

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 1129 – fixed payment argument

rajveer — Thu, 24 Mar 2011 17:28:00 +0530

rajveer – 1 file(s) modified
fixed payment argument

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

Rev 1120 – Added gatewayTxnDate in update payment method. Updated code to update ...

rajveer — Thu, 24 Mar 2011 15:20:15 +0530

rajveer – 4 file(s) modified
Added gatewayTxnDate in update payment method. Updated code to update timestamp. Updated code to return zero count if there are no items

~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService-remote
~ /trunk/PyProj/src/shop2020/thriftpy/payments/PaymentService.py

Rev 859 – Corrected a typo

chandranshu — Thu, 24 Feb 2011 12:26:34 +0530

chandranshu – 1 file(s) modified
Corrected a typo

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

Rev 854 – payment service changes

rajveer — Wed, 23 Feb 2011 16:31:28 +0530

rajveer – 1 file(s) modified
payment service changes

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

Rev 766 – Closing all database connection once we finished a call to ...

rajveer — Wed, 09 Feb 2011 17:32:30 +0530

rajveer – 16 file(s) modified
Closing all database connection once we finished a call to the service

~ /trunk/PyProj/src/shop2020/clients/UserClient.py
~ /trunk/PyProj/src/shop2020/helpers/impl/DataAccessor.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/LogisticsServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/InventoryServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/script/ItemLoader.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/OrderServiceHandler.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/model/v1/user/impl/UserDataAccessors.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/WidgetDataAccessor.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.py

Rev 755 – server constant name changes

rajveer — Thu, 03 Feb 2011 17:41:40 +0530

rajveer – 3 file(s) modified
server constant name changes

~ /trunk/PyProj/src/shop2020/helpers/impl/HelperServer.py
~ /trunk/PyProj/src/shop2020/logistics/service/LogisticsServer.py
~ /trunk/PyProj/src/shop2020/payments/PaymentsServer.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 717 – minor fixes

rajveer — Mon, 31 Jan 2011 11:23:29 +0530

rajveer – 3 file(s) modified
minor fixes

~ /trunk/PyProj/src/shop2020/model/v1/user/impl/CartDataAccessors.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataAccessor.py
~ /trunk/PyProj/src/shop2020/payments/impl/PaymentsHandler.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