Advertisement
MrFishPL

Jedna funkcja

Mar 30th, 2020
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.76 KB | None | 0 0
  1. def write_to_log(req:"flask_request", res:str) -> None:
  2.  
  3.  
  4.     dbconfig = {
  5.         "host": "127.0.0.1",
  6.         "database": "vsearchlogDB",
  7.         "user": "vsearch",
  8.         "password": "vsearchpasswd",
  9.     }
  10.  
  11.     import mysql.connector
  12.  
  13.  
  14.     conn = mysql.connector.connect(**dbconfig)
  15.     cursor = conn.cursor()
  16.  
  17.  
  18.  
  19.     _SQL = """insert into log
  20.              (phrase, letters, ip, browser_string, results)
  21.              values
  22.              (%s, %s, %s, %s, %s)"""
  23.  
  24.  
  25.     cursor.execute(_SQL, (req.form['phrase'],
  26.                           req.form['letters'],
  27.                           req.remote_addr,
  28.                           req.user_agent.browser,
  29.                           res))
  30.  
  31.     conn.commit()
  32.  
  33.     cursor.close()
  34.     conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement