def get_username(self, userid):
conn = dbconn.conn()
cur = conn.cursor()
sql = "SELECT username FROM app_db.tb_user WHERE userid=13314;"
try:
cur.execute(sql)
for i in cur:
username = i
finally:
conn.close()
return username[0]
def get(self, userid=None):
conn = dbconn.conn()
cur = conn.cursor()
if userid != None:
sql = "SELECT name,sex,CAST(indate AS CHAR),CAST(outdate AS CHAR)outdate,other,status from app_db.user_data where userid={};".format(
userid)
else:
sql = "SELECT name,sex,CAST(indate AS CHAR),CAST(outdate AS CHAR)outdate,other,status from app_db.user_data;"
try:
cur.execute(sql)
for i in cur:
tmp_l1 = []
for x in i:
tmp_l1.append(x)
self.tmp_list.append(tmp_l1)
finally:
conn.close()
return self.tmp_list
def add_db(self, ll, userid):
data = ll
num = 0
userid = userid
conn = dbconn.conn()
cursor = conn.cursor()
try:
insert_sql = "INSERT INTO app_db.user_data(name, sex, indate, outdate, other, userid) VALUES ('{}','{}','{}','{}', '{}', '{}')"
update_sql = "UPDATE app_db.user_data SET `name`='{}', `sex`='{}', `indate`='{}', `outdate`='{}', `other`='{}' WHERE (`name`='{}')"
for i in data:
cursor.execute(
"SELECT count(*) from app_db.user_data where `name`='{}' and `userid`='{}'"
.format(i[0], userid))
n = int(cursor.fetchone()[0])
if n > 0:
if i[3]:
ret = cursor.execute(
update_sql.format(i[0], i[1], i[2], i[3], i[4],
i[0]))
else:
ret = cursor.execute(
update_sql.format(i[0], i[1], i[2], i[3], 'NULL',
i[0]))
else:
if i[3]:
ret = cursor.execute(
insert_sql.format(i[0], i[1], i[2], i[3], i[4],
userid))
else:
ret = cursor.execute(
insert_sql.format(i[0], i[1], i[2], i[3], 'NULL',
userid))
num = num + 1
conn.commit()
finally:
conn.close()
return {'results': 0, 'num': num}
from flask import render_template, flash, redirect, url_for, request, current_app
from flask_login import current_user, login_required
import random
import re
from flask_babel import _
from app.main.forms import EditProfileForm, PostForm, ComForm, EditPostForm, EditCom
from app.models import User, Post
from app.main import bp
from flask_paginate import Pagination, get_page_args
from datetime import datetime
from app.dbconn import conn
from config import Config
conn = conn()
@bp.route('/', methods=['GET', 'POST'])
@bp.route('/index', methods=['GET', 'POST'])
def index():
cursor = conn.cursor()
argg = request.args
if argg and argg.get('page') is None:
gender = argg.get('gender')
category = argg.get('category')
discount = argg.get('discount')
minprice = argg.get('minprice')
maxprice = argg.get('maxprice')
brand = argg.get('brand')
store = argg.get('store')
if minprice > maxprice:
buf = maxprice
from flask import render_template, redirect, url_for, flash
from flask_login import login_user, logout_user, current_user
from flask_babel import _
from app.auth import bp
from werkzeug.security import generate_password_hash, check_password_hash
from app.auth.forms import LoginForm, RegistrationForm
from app.models import load_user
from app.dbconn import conn
conn = conn() # подключение к БД
@bp.route('/login', methods=['GET', 'POST'])
def login():
if current_user.is_authenticated: # проверка пользователя на авторизированость
return redirect(url_for('main.index'))
form = LoginForm()
if form.validate_on_submit(
): # проверка на нажатие пользователем кнопки Submit
cursor = conn.cursor()
cursor.execute(
'select password,login,iduser from Uzer where login = %s',
[form.login.data])
user = cursor.fetchone()
conn.commit()
parol = form.password.data
if user is None or not check_password_hash(user[0], parol):
flash(_('Invalid username or password'))
return redirect(url_for('auth.login'))
user = load_user(user[2])
login_user(user, remember=form.remember_me.data,