U - i @s@ddlmZmZddlmZddlmZddlmZddZdS))requestjsonify)closing)connect_to_database)datetimec Cspt}ddg}t}zHzt|jdd}|d|df|}|sptddddfW5QRWWS|d |d|dt f|d r|d |df|}|d |d kr|d |d|df| tddddfW5QRWW`SQRXWnPt k r\}z0| tdt|dddfWYWSd}~XYnXW5|XdS)Nsubscription_idZ usage_typeT) dictionaryz SELECT s.id, p.maximum_bookings, p.price_after_max FROM subscriptions s JOIN packages p ON s.package_id = p.id WHERE s.id = %s AND s.status = 'active' zActive subscription not found)messageerroria INSERT INTO subscription_usage ( subscription_id, usage_type, recorded_at ) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE count = count + 1, last_used = VALUES(recorded_at) maximum_bookingsz SELECT COUNT(*) as usage_count FROM subscription_usage WHERE subscription_id = %s Z usage_countz INSERT INTO invoices ( subscription_id, amount, status ) VALUES (%s, %s, 'unpaid') price_after_maxzUsage recorded successfullyFzError recording usage: i)rget_jsonrclosercursorexecutefetchonerrnowcommit Exceptionrollbackstr)datarequired_fields connectionr subscriptionusageer4/var/www/html/api-medvista/Services/Billing/Usage.py record_usagesN$  :r N) flaskrr contextlibrconfrrr rrrrs