a 3ѳh@sddlmZmZmZddlmZddlmZddlm Z m Z m Z ddl Z ddl mZmZe Ze eZeZeddZe eZed ed d d Zed ed ed ed feeeedddZdS)) APIRouterRequestForm)RedirectResponse)Jinja2Templates) open_mysqlget_mysql_credsget_pingconf_varsN)ListSet templates) directoryz /postcomment)requestc s8|jd}t|jdd}d}d}ztt}|jdd}|dkr||d|f|}|rnd|d<|}qd |d }n<|d ||f|}|rd |d<|}nd |d|d }Wdn1s0YWn:ty}z t d|d}WYd}~n d}~00t d|||||r,|nd|dS)NArtNumComNumrT) dictionarya% SELECT a.ArtNum, a.Title, a.Article, a.Author, a.PostDate, a.PubDate, a.Source, a.URL AS URL_Source, a.ViewCnt, a.HandleID AS AuthorID FROM Articles a WHERE a.ArtNum = %s AND a.Deleted = 0 articletypez Article #z does not exist.a= SELECT c.ComNum, c.ArtNum, c.Comment, c.PostDate, i.Name AS HandleStr FROM Comments c JOIN Handles h ON c.HandleID = h.HandleID JOIN ID i ON h.HandleID = i.IDNum WHERE c.ArtNum = %s AND c.ComNum = %s commentz Comment #z of article #z#Error loading postcomment context: zAn unexpected error occurred.postcomment.html)r article_id parent_comnum context_itemrerror) query_paramsgetintr mysql_credscursorexecutefetchone Exceptionloggerrr TemplateResponse) rZart_numZcom_numrrconnrrower'./wd/v2025.freedom4um.com/routes/postcomment.pyget_post_commentsJ   4 r).)rrrCommentc sd}zr|jdid}|s,d}t||s@d}t|tt}|}|d|f|d}t } | IdH} g} d| vr| d} n:d| vr| d} n&d | vr| d r| d  d ng} | D]8} zt | } | dkr| | WqtyYq0q| s"| dg}td d | D}|rd d gt|}|d|dt||}dd|D}|D](}||vr||r|||qd| vrt| dkrdg}d|}t|dkr|ddd}|d||||||f|j}| D]}|d||d||fq|Wdn1sV0Ytd|d|ddWSty}z&td||sd}WYd}~n d}~00td |||d|d!S)"Nuseridz(You must be signed in to post a comment.zComment cannot be empty.z SELECT IFNULL(MAX(ComNum), 0) + 1 FROM Comments WHERE ArtNum = %s rZ ToHandleIDZ ToHandleIDsto_list,cSsg|]}|dkr|qS)rr').0ridr'r'r( z'submit_post_comment..z%sz+SELECT IDNum, Name FROM ID WHERE IDNum IN ()cSs*i|]"}|r|ddur|d|dqS)rNr')r/rr'r'r( r2z'submit_post_comment..r4ZAllz, z...z INSERT INTO Comments (HandleID, ArtNum, ComNum, PostDate, Comment, ReplyToComNum, ReplyToHandleStr) VALUES (%s, %s, %s, NOW(), %s, %s, %s) z INSERT INTO Ping (GlobComNum, ArtNum, CatNum, FromHandleID, ToHandleID) VALUES (%s, %s, %s, %s, %s) z/readarticle?ArtNum=z#Ci/)url status_codezError submitting comment: z)Failed to post comment. Please try again.r)rrrrr)sessionrr!striprrrrr setformgetlistsplitraddsortedjoinlentuplefetchallappend lastrowidcommitrr"rr r#)rrrr*rZuser_idr$rZ next_comnum recipientsZ form_dataZraw_idsvZvidZ reply_namesZ positive_ids placeholdersrowsZ id_to_namer0Zreply_to_handle_strZ globcomnumZto_userr&r'r'r(submit_post_commentKs       (rN)fastapirrrfastapi.responsesrfastapi.templatingrutils.pingdatarrr loggingtypingr r PingConfrrouterr getLogger__name__r"rr)postrstrrNr'r'r'r(s,    :