Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35718 73 d 17 h amit /trunk/PyProj/src/shop2020/ fix: use session.remove() instead of session.close() to prevent memory leaks in all services  
35701 74 d 0 h amit /trunk/PyProj/src/ 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)
 
35608 86 d 0 h amit /trunk/PyProj/src/shop2020/ 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
 
2747 5384 d 5 h chandranshu /trunk/ Added the missing links to create a refund  
2309 5420 d 2 h ankur.singhal /trunk/PyProj/src/shop2020/payments/impl/ bug fixed in to_t_payment_gateway  
2192 5427 d 23 h chandranshu /trunk/PyProj/src/shop2020/payments/impl/ Closed the session after querying for statistics.  
2062 5439 d 22 h ankur.singhal /trunk/PyProj/src/shop2020/ change method getPayments comments. If gatewayId is passed as 0, it is ignored.  
1731 5468 d 1 h ankur.singhal /trunk/ optimisation of methods for getting max, min amounts of orders and payments. These methods are used for statistics (Support).  
1659 5470 d 3 h chandranshu /trunk/PyProj/src/shop2020/payments/impl/ Payment status was not getting set to INIT since the attribute used there was named ps  
1657 5470 d 4 h ankur.singhal /trunk/PyProj/src/shop2020/payments/impl/ modified max and min payment amount calls to return the amounts of only successful payments.  
1627 5471 d 6 h ankur.singhal /trunk/PyProj/src/shop2020/ added methods in PaymentsHandler and OrderServiceHandler for getting statistics. (max & min order amount, max & min payment amount, distinct customers who have bought)  
1493 5482 d 0 h vikas /trunk/PyProj/src/shop2020/ Return all transactions/payments when status passed is None.  
1415 5487 d 21 h chandranshu /trunk/PyProj/src/shop2020/ Added dbname parameter to all the servers  
1267 5498 d 1 h chandranshu /trunk/PyProj/src/shop2020/ Started reading dbname parameters from the config file  
1248 5499 d 5 h chandranshu /trunk/PyProj/src/shop2020/ Made database name a configurable parameter for Payment, Logistics and Helper service to ensure that test and development databases can be different  
1131 5509 d 23 h chandranshu /trunk/PyProj/src/shop2020/ Added pool_recycle parameter to the create_engine call  
1130 5509 d 23 h rajveer /trunk/PyProj/src/shop2020/payments/impl/ modified size of the description column to 200  
1129 5510 d 0 h rajveer /trunk/PyProj/src/shop2020/payments/impl/ fixed payment argument  
1120 5510 d 2 h rajveer /trunk/PyProj/src/shop2020/ Added gatewayTxnDate in update payment method. Updated code to update timestamp. Updated code to return zero count if there are no items  
859 5538 d 5 h chandranshu /trunk/PyProj/src/shop2020/payments/impl/ Corrected a typo  

Show All