o i @s@ddlmZmZddlmZddlmZddlmZddZdS))requestjsonify)closing)connect_to_database)datetimec Cst}ddg}t}zzt|jddt}|d|df|}|s;tddddfWdWW|S|d |d|dt f|d ro|d |df|}|d |d kro|d |d|df| tddddfWdWW|S1swYWn)t y}z| tdt|dddfWYd}~W|Sd}~wwW|dS|w)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_jsonrrcursorexecutefetchonerclosernowcommit Exceptionrollbackstr)datarequired_fields connectionr subscriptionusageerP/Users/harjaapdhillon/Desktop/newidea/medvista_backend/Services/Billing/Usage.py record_usages` 9  95( 9r N) flaskrr contextlibrconfrrr rrrrs