1.开发环境在pycharm,用的py2.7,flask框架
2.开发时就是直接在pycharm中创建flask工程
代码如下:
3.现象就是指定了端口或者监听ip和端口一起设置后访问/?user=xxx报错 404页面未找到
app.run(
host = '0.0.0.0',
port = 7777,
debug = True
)
!/usr/bin/python
-- coding: UTF-8 --
import pyotp
import MySQLdb
import time
from flask import Flask
from flask.ext.httpauth import HTTPBasicAuth
from flask import request
import json
from threading import Timer
renzheng
auth = HTTPBasicAuth()
app = Flask(__name__)
def dingshi(USER):
db = MySQLdb.connect("localhost", "root", "xxxxx", "flask")
cursor = db.cursor()
BASE = pyotp.random_base32()
totp = pyotp.TOTP("%s" % BASE)
PASSWD = totp.now()
sql4 = "delete from users where name='%s'" % USER
cursor.execute(sql4)
db.commit()
print '修改完毕'
db.close()
print '关闭数据库链接'
@app.route('/')
def getvpnpasswd():
global VPNUSER
VPNUSER = request.args.get('user')
BASE = pyotp.random_base32()
totp = pyotp.TOTP("%s" % BASE)
PASSWD = totp.now()
打开数据库连接
db = MySQLdb.connect("localhost","root","asin7SGAcdB12ci^t5987.com","flask" )
使用cursor()方法获取操作游标
cursor = db.cursor()
SQL 查询语句
sql1 = "SELECT name FROM users where name='%s'" %VPNUSER
sql5 = "select passwd from users where name='%s'" %VPNUSER
sql insert
sql2 = ('insert into users(name) values("%s")' %VPNUSER)
sql3 = "update users set passwd='%s' where name='%s'" %(PASSWD,VPNUSER)
try:
cursor.execute(sql1)
results = cursor.fetchone()
results = cursor.fetchall()
if results:
print "have data"
cursor.execute(sql5)
db.commit()
db.close()
result_now = cursor.fetchall()
# print result_now[0][0]
result = {
'VPNUSER': VPNUSER,
'PASSWD': result_now[0][0]
}
Timer(280, dingshi,[VPNUSER]).start()
print '定时任务开始执行'
return json.dumps(result)
else:
print "no data"
cursor.execute(sql2)
cursor.execute(sql3)
db.commit()
print "yijing charu"
db.close()
result = {
'VPNUSER': VPNUSER,
'PASSWD': PASSWD
}
Timer(280, dingshi,[VPNUSER]).start()
print '定时任务开始执行'
return json.dumps(result)
if name == '__main__':
app.run()