o zi}@sddlZddlZddlZddlZddlmZdZddZddZdd Z d e d e fd d Z dddZ ddZ edkr?e dSdS)N)datetimez./home/cpsweather/theweathermonitor.com/auth.dbcCstjtdd}tj|_|S)Ng@)timeout)sqlite3connectDB_PATHRow row_factorycxr change_notification_settings.py db_connect sr cCsRt}|d|d|d|WddS1s"wYdS)Na CREATE TABLE IF NOT EXISTS recipient_preferences_requests ( id INTEGER PRIMARY KEY AUTOINCREMENT, email TEXT NOT NULL, phone TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'pending', requested_ts TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')), processed_ts TEXT, result_code TEXT, result_detail TEXT ) z CREATE INDEX IF NOT EXISTS idx_recipient_preferences_requests_status ON recipient_preferences_requests(status) z CREATE INDEX IF NOT EXISTS idx_recipient_preferences_requests_requested_ts ON recipient_preferences_requests(requested_ts) )r executecommitr r r r ensure_tables "rcCsz ttjddp d}Wn tyd}Ynw|dkr$tjj|nd}tj j |dd}|ddgdp8d }|ddgdpEd }||fS) NCONTENT_LENGTH0rT)keep_blank_valuesemailphone) intosenvironget ValueErrorsysstdinreadurllibparseparse_qsstrip)content_lengthrawparsedrrr r r parse_post_body0s r&rrcCsHt}|d||f|WddS1swYdS)Nz INSERT INTO recipient_preferences_requests(email, phone, status) VALUES (?, ?, 'pending') )r rlowerr)rrr r r r insert_request>s  "r(rc Cstj|dd}tj|dd}|rdt|dnd}|r&dt|dnd}d|d|d |d |d }td td tt|dS)NT)quotez
z
rz/
aF Change Notification Settings - The Weather Monitor

Change Notification Settings

Enter your email address and phone number to request a secure link to manage your notification settings.
z z
zStatus: 200 OKz&Content-Type: text/html; charset=utf-8)htmlescapeprint) rrerrormessageemail_hphone_h error_html message_htmlbodyr r r render_pageJs*GHLOX r4cCslttjdp d}|dkr1t\}}|r|s#t||dddSt||t||dddStdS)NREQUEST_METHODGETPOSTz,Email address and phone number are required.)rrr-z=If we found a matching recipient, a secure link will be sent.)rrr.)rrrrupperr&r4r()methodrrr r r mains   r:__main__)rrrr)r*rr urllib.parserrrr rr&strr(r4r:__name__r r r r s  i