Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def write_to_log(req:"flask_request", res:str) -> None:
- dbconfig = {
- "host": "127.0.0.1",
- "database": "vsearchlogDB",
- "user": "vsearch",
- "password": "vsearchpasswd",
- }
- import mysql.connector
- conn = mysql.connector.connect(**dbconfig)
- cursor = conn.cursor()
- _SQL = """insert into log
- (phrase, letters, ip, browser_string, results)
- values
- (%s, %s, %s, %s, %s)"""
- cursor.execute(_SQL, (req.form['phrase'],
- req.form['letters'],
- req.remote_addr,
- req.user_agent.browser,
- res))
- conn.commit()
- cursor.close()
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement