o lj@sddlmZddlZddlZddlZddlmZmZmZddlm Z ddl m Z m Z ddl mZmZddlmZddlmZd'd d Zd(ddZd)d*ddZd+ddZd,ddZd-d!d"Zed#d$geegd%d&ZdS).) annotationsN)datetime timedeltatimezone)Any) DatabaseError connections)api_viewpermission_classes)AllowAny)ResponsenamestrreturncCsd|dddS)N`z``)replace)r r"backend/config/mcube_data_views.py_q_identsrvaluerdefaultintcCs4zt|}|dkr |WS|WSty|YSw)Nr)r Exception)rrvrrr _require_ints  r prefixncs,tjtj|dfddt|DS)Nc3s|]}tVqdSN)randomchoice).0_alphabetrr sz_rand_token..)stringascii_lowercasedigitsjoinrange)rrrr$r _rand_tokens  r,biddict[str, Any]c CsZttjjdd}|ttddd}|ttddd}tdd}id td d d td ddtddd|d|dd|ddtddddtdddtdddddddtddd d!td"d#d$d!td"d#d%td&d'd(td)d'd*||t dt || d+dd,d-t d.d/gd||d0 S)1Nr) microsecondiX)seconds callidcall_calidcal_refidref_r-gid groupnamezGroup agentnamezAgent 2assigntoeidisourcemcube landingnumber 1800123456hidicallfromz+91las$z!_table_columns..)executefetchall)cursorrvrrr_table_columnsXs r}GETPOSTc st|jddd}|jdpd}|p|d}|ds)tddd d d St|s4t|nd| d d zt d}| v}t ||setdd|d dd Wd WSfdd D}|stdd|dd d Wd WSfdd|D}ddd|D}ddgt|} dt|d|d| d} || ||j} Wd n1swYWnty} ztdt| |ddd WYd } ~ Sd } ~ wwtd|| |d S)!a URL: /api/mcube-data - GET: inserts one dummy row (default bid=2000) into `{bid}_mcubecallhistory` - POST: inserts provided JSON payload; missing/empty payload falls back to dummy Query params: - bid: business id (default 2000) -> table name `{bid}_mcubecallhistory` - table: override full table name (optional). If provided, it must end with `_mcubecallhistory`. r-i)rrvr_mcubecallhistoryFzInvalid table.)successmessagei)rWcall_history_idNclusterzTable not found: icsg|]}|vr|qSrr)r"k)colsrr szmcube_data..z1No valid columns found in payload for this table.)rrrvcsg|]}|qSrrr"c)payloadrrrsz, css|]}t|VqdSr)rrrrrr&szmcube_data..z%sz INSERT INTO z (z ) VALUES ()iT)rrv inserted_idinserted_columns)r query_paramsgetrnendswithr rurd setdefaultpoprr|r}keysr*lenrrz lastrowidrr) rqr-table_overridervconnr| insert_colsvaluescol_sqlphsqlrer)rrr mcube_datadsh         r)r rrr)rrrrrr)r)rrrrrr)r-rrr.)rr.)rvrrrw) __future__rror r'rrrtypingr django.dbrrrest_framework.decoratorsr r rest_framework.permissionsr rest_framework.responser rrr,rdrur}rrrrrs&         #