fork download
copy 
  1. from flask import Flask,render_template,request,escape
  2. from vsearch import search_for_letters
  3.  
  4. app = Flask(__name__)
  5.  
  6. def log_request(req: 'flask_request',res:str)->None:
  7.     dbconfig = {'host':'127.0.0.1',
  8.                 'user':'vsearch',
  9.                 'password':'vsearchpasswd',
  10.                 'database':'vsearchlogDB'}
  11.  
  12.     import mysql.connector
  13.  
  14.     conn = mysql.connector.connect(**dbconfig)
  15.     cursor = conn.cursor()
  16.  
  17.     _SQL = """insert into log
  18.            (phrase,letters,ip,browser_string,results)
  19.             values
  20.            (%s,%s,%s,%s,%s)"""
  21.     cursor.execute(_SQL,(req.form['phrase'],
  22.                          req.form['letters'],
  23.                          req.remote_addr,
  24.                          req.user_agent.browser,
  25.                          res,))
  26.     conn.commit()
  27.     cursor.close()
  28.     conn.close()
  29.  
  30. """@app.route('/viewlog',methods=['POST','GET'])
  31. def view_the_log()->'html':
  32.     contents = []
  33.     with open('vsearch.log') as log: #открыть файл журнала для чтения
  34.         for line in log:
  35.             contents.append([])
  36.             for item in line.split('|'):
  37.                 contents[-1].append(escape(item))
  38.     titles = ('Form Data', 'Remote_addr', 'User_agent', 'Results')
  39.     return render_template('viewlog.html',
  40.                             the_title = 'View Title',
  41.                             the_row_titles = titles,
  42.                             the_data=contents,)"""
  43.  
  44.  
  45.  
  46. @app.route('/search4',methods=['POST','GET'])
  47. def do_search()->'html':
  48.     phrase = request.form['phrase']
  49.     letters = request.form['letters']
  50.     title = 'Here are your results:'
  51.     results = str(search_for_letters(phrase,letters))
  52.     log_request(request,results)
  53.     return render_template('results.html',the_title=title,
  54.                            the_letters=letters,the_phrase=phrase,the_results=results)
  55. @app.route('/')
  56. @app.route('/entry')
  57. def entry_page() ->'html':
  58.     return render_template('entry.html',the_title='Welcome for our site!')
  59.  
  60. app.run(debug=True)
  61.  
Runtime error #stdin #stdout #stderr 0.04s 9436KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Traceback (most recent call last):
  File "./prog.py", line 1, in <module>
    from flask import Flask,render_template,request,escape
ImportError: No module named 'flask'
https://ideone.com/xpPCwe
language:
Python 3 nbc (python 3.7.3)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!