def f_useradd(): uname = request.form.get('uname') tell = request.form.get('tell') carplate = request.form.get('carplate') time = request.form.get('time') db = MyDBHelper() db.addyuyue([uname, tell, carplate, time]) u = (uname, tell, carplate, time) return jsonify({'result': "ok"})
def checkName(): username = request.args.get("name") print(username) db = MyDBHelper() username = db.GetUsername(username) if username.__len__() == 0: result = json.dumps({'result': 'ok'}) else: result = json.dumps({'result': 'no'}) return result
def logincheck(): username = request.args.get("name") password = request.args.get("password") db = MyDBHelper() print(db.GetPassword(username)) if (password == db.GetPassword(username)): print("ok") return json.dumps({'result': 'ok'}) else: return json.dumps({'result': 'no'})
def doregister(): username = request.args.get("name") password = request.args.get("password") print(username, password) db = MyDBHelper() args = [username, password] row = db.adduser(args) print("影响的行数", row) if row > 0: return json.dumps({'result': 'ok'}) else: return json.dumps({'result': 'no'})
def uploadsqlshow(): carlicense = request.form.get("license") intime = request.form.get("intime") cartype = request.form.get("type") print(carlicense) print(intime) db = MyDBHelper() carexist = db.ecarlicense(carlicense) if carexist.__len__() == 0: args = [carlicense, intime, cartype] db.addcardatai(args) return jsonify({ 'result': 'ok', 'carlicense': carlicense, 'intime': intime, 'type': cartype }) else: return jsonify({'result': 'no'})
def uploadsqlrshow(): if request.method == 'POST': carlicense = request.form.get("license") outtime = request.form.get("outtime") cartype = request.form.get("type") db = MyDBHelper() strtime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) carexist = db.ecarlicenseo(carlicense) if carexist.__len__() == 0: args = [carlicense, outtime, cartype] db.addcardatao(args) return jsonify({ 'result': 'ok', 'carlicense': carlicense, 'outtime': outtime, 'type': cartype }) else: return jsonify({'result': 'no'}) return ''
def upload_file(): if request.method == 'POST': # check if the post request has the file part if 'file' not in request.files: flash('No file part') return redirect(request.url) file = request.files['file'] # if user does not select file, browser also # submit an empty part without filename if file.filename == '': flash('No selected file') return redirect(request.url) filename = secure_filename(file.filename) if os.path.exists("D:/CARS/"): file.save(os.path.join("D:/CARS/", filename)) fileurl = "D:/CARS/" + filename # time.strftime('%H:%M:%S', time.localtime(time.time())) strtime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) APP_ID = '17061516' Type_client_id = '0aAPIpeYX7RbtFsEhSkzaFcY' Type_client_secret = 'W1jSIHOSa7zwVYnGyA2H4pmG3Y1tOpb1' get = get_type(fileurl) strtimefinal = datetime.datetime.strptime(strtime, '%Y-%m-%d %H:%M:%S') client = AipImageClassify(APP_ID, Type_client_id, Type_client_secret) image = get_file_content(fileurl) list = get_license_plate(fileurl) ctype = client.carDetect(image, options={"top_num": 1})["result"][0]["name"] db = MyDBHelper() db.addintime([strtimefinal, list]) print(type(strtime)) print(strtime) return jsonify({ 'str': list, 'time': strtime, 'type': ctype, "ctype": get }) else: os.makedirs("D:/CARS/") file.save(os.path.join("D:/CARS/", filename)) fileurl = "D:/CARS/" + filename get = get_type(fileurl) strtime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) strtimefinal = datetime.datetime.strptime(strtime, '%Y-%m-%d %H:%M:%S') print(type(strtime)) APP_ID = '17061516' Type_client_id = '0aAPIpeYX7RbtFsEhSkzaFcY' Type_client_secret = 'W1jSIHOSa7zwVYnGyA2H4pmG3Y1tOpb1' client = AipImageClassify(APP_ID, Type_client_id, Type_client_secret) image = get_file_content(fileurl) list = get_license_plate(fileurl) ctype = client.carDetect(image, options={"top_num": 1})["result"][0]["name"] db = MyDBHelper() db.addintime([strtimefinal, list]) print(strtime) return jsonify({ 'str': list, 'time': strtime, 'type': ctype, "ctype": get }) return ''
def fgetadmit(): uname = request.form.get('uname') db = MyDBHelper() db.deleteusershow(uname) return jsonify({'result': "ok"})
def f_usershowfinal(): db = MyDBHelper() list = db.GetuserInfo() return render_template("usershow.html", list=list)
def f_outshow(): db = MyDBHelper() list = db.GetCarInfoout() return render_template("outshow.html", list=list)