Uh pSSKJrJrJrJr SSKrSSKrSSKrSSK J r J r SSSSS.r S r S r \R"\RS \R "\ 5\R""5/S 9 \"\5r\R)S 5S5r\R)S5S5r\S:Xa\R/SSSS9 gg))Flaskrender_templatejsonifyrequestN)datetime timedelta localhostroot9FtVUZD3hN7MZkKZavailable_scrapping)hostuserpassworddatabasezAmerica/Los_Angelesz0/var/www/home/psychics-availability/app_data.logz'%(asctime)s [%(levelname)s] %(message)s)levelformathandlers/c[S5$)Nz index.html)r*/var/www/home/psychics-availability/app.pyindexr!s < ((rz/fetch-db-datacd[SSS5Vs/sHoSS3PM nn[R"[5n[R "U5R 5n[RRSS5n[RRS5nS n/nUS:Xa#S nURURS 55 OUS :Xa/U[S S9- nS nURURS 55 OUS:XanU[SS9- n U[S S9- n SnURU RS 5U RS 5/5 [R"SUSSUS 35 O0US:XaU(aS nURU5 O[!SS05S4$["R$R&"S!0[(D6n U R+5n SUS3n U R-U [/U55 U R15nU R35 UVs0sHoSUS US4_M nn//nnUH[nUU;a0URUUS5 URUUS 5 M9URS5 URS5 M] [5SUU-55(a[!///SS.5$[!UUUS.5$s snfs snf!["R$R6a2n[R8"SU35 [!SS05S 4sSnA$SnAff=f)"Nr02dz:00filtertodaydatezDATE(scraped_at) = %sz%Y-%m-%d yesterday)days last7daysz"DATE(scraped_at) BETWEEN %s AND %sz2Filtering for LAST 7 DAYS (excluding today): From z To customerrorzInvalid filterizz SELECT slot, SUM(available) AS available, SUM(busy) AS busy FROM psychic_stats WHERE z= GROUP BY slot ORDER BY slot c3*# UH oS:Hv M g7f)rNr).0vs r get_data..cs0/!Av/szNo data found for this date)slots availablebusymessage)r.r/r0z DB Error: zDatabase error occurredir)rangepytztimezoneTIMEZONErnowr rargsgetappendstrftimerextendlogginginformysql connectorconnect DB_CONFIGcursorexecutetuplefetchallcloseallErrorr()h all_slotstzr filter_val custom_datedate_conditionparamsr" start_dateend_dateconnrBqueryrowsrow data_dictr/r0slotes rget_datarY%s(-aQ81c7#I8 x B LL  ! ! #E!!(G4J,,""6*KN FW0 ennZ01 { "I1-- 0 i((45 { "YA.. 9!,,= z**:68I8I*8UVW I&QR)TXY_`aYbXcde x K0 k"!123S88"B&&33""#   ueFm,  9=>#Vc!fc!f-- >b4 Dy   4!34 IdOA./  # A  0y4/0 0 0Rb"Qnop pDQRR9`?" ?? B 1#&'!:;