def edit_profile():
form = EditProfileForm(current_user.login)
cursor = conn.cursor()
vuz = form.SelVUZ.data
cursor.execute('select idFack,nameFack from facultet where idvuz = %s', [vuz])
fack = cursor.fetchall()
conn.commit()
kolvofack = len(fack)
form.SelFack.choices = fack
Fack = form.SelFack.data
cursor.execute('select idKafedra,nameKafedra from kafedra where idfack = %s', [Fack])
kaf = cursor.fetchall()
conn.commit()
form.SelKaf.choices = kaf
Kaf = form.SelKaf.data
if form.validate_on_submit():
cursor = conn.cursor()
current_user.fio = form.fio.data
current_user.phone = form.phone.data
current_user.gender = form.gender.data
current_user.about_me = form.about_me.data
current_user.avatar = form.avatar.data
cursor.execute(
'update Uzer set fio = %s, login = %s, phone = %s, gender = %s, about_me = %s, avatar = %s where login = %s',
[current_user.fio, form.login.data, current_user.phone, current_user.gender, current_user.about_me,
current_user.avatar, current_user.login])
conn.commit()
cursor.execute('SELECT iduser FROM VO WHERE iduser = %s', [current_user.id])
iduser = cursor.fetchone()
conn.commit()
if iduser is None:
cursor.execute('INSERT INTO VO(iduser,idvuz,idfack,idkafedra) VALUES(%s,%s,%s,%s)',
[current_user.id, vuz, Fack, Kaf])
conn.commit()
else:
cursor.execute('UPDATE VO SET idvuz = %s,idfack = %s, idkafedra = %s WHERE iduser = %s',
[vuz, Fack, Kaf, current_user.id])
conn.commit()
current_user.login = form.login.data
flash(_('Your changes have been saved.'))
return redirect(url_for('main.edit_profile'))
elif request.method == 'GET':
form.fio.data = current_user.fio
form.login.data = current_user.login
form.phone.data = current_user.phone
form.gender.data = current_user.gender
form.about_me.data = current_user.about_me
form.avatar.data = current_user.avatar
cursor.execute('SELECT idvuz,idfack,idkafedra from VO where iduser = %s', [current_user.id])
numb = cursor.fetchone()
if numb is not None:
form.SelVUZ.data = numb[0]
form.SelFack.data = numb[1]
form.SelKaf.data = numb[2]
return render_template('edit_profile.html', title=_('Edit Profile'),
form=form, vuz=vuz, kolvofack=kolvofack, Kaf=Kaf, fack=fack)
def delete_profile(id):
cursor = conn.cursor()
cursor.execute('select * from Uzer where login = %s',
[current_user.login])
user = cursor.fetchone()
conn.commit()
if user[5] == current_user.login and current_user.login == '*****@*****.**':
cursor.execute(
'DELETE FROM addfriend WHERE id1user = %s or id2user = %s',
[id, id])
conn.commit()
cursor.execute(
'DELETE FROM com WHERE idavtor = %s or idrecepient = %s or idrecepientpost =%s',
[id, id, id])
conn.commit()
cursor.execute(
'DELETE FROM post WHERE idavtor = %s or idrecepient = %s',
[id, id])
conn.commit()
cursor.execute(
'DELETE FROM vo WHERE iduser = %s',
[id])
conn.commit()
cursor.execute(
'DELETE FROM uzer WHERE iduser = %s',
[id])
conn.commit()
return redirect(url_for('main.user', id=id))
return redirect(url_for('main.user', id=current_user.id))
def deletecom(id):
cursor = conn.cursor()
cursor.execute('select * from Uzer where login = %s',
[current_user.login])
user = cursor.fetchone()
if user[5] == current_user.login:
if current_user.login == '*****@*****.**':
cursor.execute(
'SELECT idrecepient from com where idcom=%s',
[id])
biba = cursor.fetchone()
conn.commit()
cursor.execute(
'DELETE FROM com WHERE idcom=%s',
[id])
conn.commit()
cursor.close()
return redirect(url_for('main.user', id=biba[0]))
else:
cursor.execute(
'SELECT idrecepient from com where (idavtor = %s and idcom = %s) or (idrecepient = %s and idcom = %s)',
[current_user.id, id, current_user.id, id])
biba = cursor.fetchone()
conn.commit()
cursor.execute(
'DELETE FROM com WHERE (idavtor = %s and idcom = %s) or (idrecepient = %s and idcom = %s)',
[current_user.id, id, current_user.id, id])
conn.commit()
cursor.close()
return redirect(url_for('main.user', id=biba[0]))
return redirect(url_for('main.user', id=current_user.id))
def validate_email(self, login): # валидация ящика
cursor = conn.cursor()
cursor.execute('select login from Uzer where login = %s', [login])
cursor.fetchone()
user = cursor.fetchone()
if user is not None:
raise ValidationError(_('Please use a different email address.'))
class EditProfileForm(FlaskForm):
fio = StringField('Фамилия Имя Отчество')
login = StringField(_l('Login'), validators=[DataRequired()])
about_me = TextAreaField(_l('About me'),
validators=[Length(min=0, max=140)])
phone = StringField('Номер')
avatar = StringField('Аватар')
gender = SelectField(
'Пол',
choices=[('Мale', 'Male'), ('Female', 'Female'),
('Transexual Male', 'Transexsual Male'),
(' Transexsual Female', 'Transexsual Female'),
('Metrosexual Male', 'Metrosexual Male'),
('Metrosexual Female', 'Metrosexual Female'),
('Male, but curious what being a Female like',
'Male, but curious what being a Female like'),
('Female, but curious what being a Male like',
'Female, but curious what being a Male like'),
('Hermaphrodite with Predominant Male leanings',
'Hermaphrodite with Predominant Male leanings'),
('Hermaphrodite with Predominant Female leanings',
'Hermaphrodite with Predominant Female leanings'),
('Hermaphrodite with no strong gender leanings',
'Hermaphrodite with no strong gender leanings'),
('Conjoined Twin - Male', 'Conjoined Twin - Male'),
('Conjoined Twin - Female', 'Conjoined Twin - Female'),
('Born without genitals - identify as a Male',
'Born without genitals - identify as a Male'),
('Born without genitals - identify as a Female',
'Born without genitals - identify as a Female'),
('Born without genitals - proud of it',
'Born without genitals - proud of it'),
('Artificial intelligence with no gender',
'Artificial intelligence with no gender'),
('Artificial intelligence - identifies as Male',
'Artificial intelligence -identifies as Male'),
('Artificial intelligence - identifies as Female',
'Artificial intelligence -identifies as Female'),
('Household pet that walked across the keyboard - Male',
'Household pet that walked across the keyboard - Male'),
('Household pet that walked across the keyboard - Female',
'Household pet that walked across the keyboard - Female'),
('Household pet that walked across the keyboard - Other',
'Household pet that walked across the keyboard - Other'),
('Attack helicopter', 'Attack helicopter')])
cursor = conn.cursor()
submit = SubmitField(_l('Submit'))
def __init__(self, original_username, *args, **kwargs):
super(EditProfileForm, self).__init__(*args, **kwargs)
self.original_username = original_username
def validate_username(self, username):
if username.data != self.original_username:
user = User.query.filter_by(username=self.username.data).first()
if user is not None:
raise ValidationError(_('Please use a different username.'))
def follow(id):
cursor = conn.cursor()
cursor.execute('select * from Uzer where iduser = %s',
[id])
user = cursor.fetchone()
conn.commit()
if user is None:
flash(_('User %(username)s not found.', username=user[5]))
return redirect(url_for('main.index'))
if current_user.login == user[5]:
flash(_('You cannot unfollow yourself!'))
return redirect(url_for('main.user', id=user[4]))
cursor = conn.cursor()
cursor.execute(
'insert into addfriend (dataadd,id1user,id2user) values(clock_timestamp(),%s,%s)',
(user[4], current_user.id))
cursor.close()
conn.commit()
flash(_('You are following %(username)s!', username=user[5]))
return redirect(url_for('main.user', id=user[4]))
def foloww(id):
cursor = conn.cursor()
cursor.execute('select * from Uzer where iduser = %s',
[id])
user = cursor.fetchone()
cursor.execute(
'SELECT * FROM addfriend inner join uzer on addfriend.id2user=uzer.iduser and addfriend.id1user = %s',
[id])
frendi = cursor.fetchall()
conn.commit()
friendempty = False
if len(frendi) == 0:
friendempty = True
idfoll = id
return render_template('foloww.html', title=_('Пiдписники'), frendi=frendi, friendempty=friendempty, idfoll=idfoll,
login=user[5], id=user[4])
def search():
arg = request.args['q']
if arg == '':
return redirect(url_for('main.index'))
cursor = conn.cursor()
cursor.execute('SELECT * FROM ITEMS WHERE to_tsvector(BRAND) || to_tsvector(nameitem) || to_tsvector(typeitem) @@ plainto_tsquery(%s)', [arg])
items = cursor.fetchall()
ult = convert_to_list(items)
conn.commit()
page, per_page, offset = get_page_args(page_parameter='page', per_page_parameter='per_page')
cursor.execute(
'SELECT count(*) FROM ITEMS WHERE to_tsvector(BRAND) || to_tsvector(nameitem) || to_tsvector(typeitem) @@ plainto_tsquery(%s)', [arg])
total = cursor.fetchone()
pagination_posts = ult[offset: offset + per_page]
pagination = Pagination(page=page, total=total[0], record_name='items', per_page=per_page)
checksrch = True
return render_template('main.html', items=pagination_posts, pagination=pagination, paga=page, arg=arg, checksrch=checksrch )
def shopg(gender):
if gender == 'women':
gend = 'W'
elif gender == 'men':
gend = 'M'
cursor = conn.cursor()
cursor.execute('select * from ITEMS WHERE gender = %s or gender = %s', ['U', gend])
items = cursor.fetchall()
ult = convert_to_list(items)
conn.commit()
page, per_page, offset = get_page_args(page_parameter='page', per_page_parameter='per_page')
cursor.execute(
'SELECT count(*) FROM ITEMS WHERE gender = %s or gender = %s', ['U', gend])
total = cursor.fetchone()
pagination_posts = ult[offset: offset + per_page]
pagination = Pagination(page=page, total=total[0], record_name='items', per_page=per_page)
return render_template('main.html', items=pagination_posts, pagination=pagination, paga=page)
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
maxprice = minprice
minprice = buf
if gender:
if gender == 'women':
cursor.execute('SELECT * FROM ITEMS WHERE gender = %s or gender = %s', ['W','U'])
genderY = cursor.fetchall()
elif gender == 'men':
cursor.execute('SELECT * FROM ITEMS WHERE gender = %s or gender = %s', ['M', 'U'])
genderY = cursor.fetchall()
elif gender == 'all':
cursor.execute('SELECT * FROM ITEMS WHERE gender = %s', ['U'])
genderY = cursor.fetchall()
cursor.execute('select * from ITEMS')
items = cursor.fetchall()
ult = convert_to_list(items)
conn.commit()
page, per_page, offset = get_page_args(page_parameter='page', per_page_parameter='per_page')
cursor.execute(
'SELECT count(*) FROM ITEMS')
total = cursor.fetchone()
cursor.execute(
'SELECT distinct(Brand) FROM ITEMS ORDER BY Brand ASC')
brands = cursor.fetchall()
cursor.execute(
'SELECT distinct(site) FROM ITEMS ORDER BY site ASC')
sites = cursor.fetchall()
cursor.execute('SELECT MAX(saleprice) FROM ITEMS;')
maxcost = cursor.fetchone()
pagination_posts = ult[offset: offset + per_page]
pagination = Pagination(page=page, total=total[0], record_name='items', per_page=per_page)
chkindex = True
return render_template('main.html', items=pagination_posts, pagination=pagination, paga=page, chkindex=chkindex, brands=brands, sites=sites, maxcost=maxcost)
def unfollow(id):
cursor = conn.cursor()
cursor.execute('select * from Uzer where iduser = %s',
[id])
user = cursor.fetchone()
conn.commit()
if user is None:
flash(_('User %(username)s not found.', username=user[5]))
return redirect(url_for('main.index'))
if user == current_user:
flash(_('You cannot unfollow yourself!'))
return redirect(url_for('main.user', id=user[4]))
cursor.execute(
'DELETE FROM addfriend WHERE id2user = %s and id1user = %s',
[current_user.id, user[4]])
conn.commit()
flash(_('You are not following %(username)s.', username=user[5]))
return redirect(url_for('main.user', id=user[4]))
def comment(id):
cursor = conn.cursor()
cursor.execute('select * from Uzer where login = %s',
[current_user.login])
user = cursor.fetchone()
cursor.execute('select idrecepient,idavtor from post where idpost = %s',
[id])
usten = cursor.fetchone()
conn.commit()
forma = ComForm()
if forma.validate_on_submit():
vremy = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
if user is None:
return redirect(url_for('main.index'))
else:
cursor.execute(
'INSERT INTO com(tekst,datacom,idavtor,idpost,idrecepient,idrecepientpost) VALUES (%s,%s,%s,%s,%s,%s)',
[forma.com.data, vremy, current_user.id, id, usten[0], usten[1]])
conn.commit()
return redirect(url_for('main.user', id=usten[0]))
return render_template('sendcom.html', forma=forma)
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,
force=True) # создание пользователя как обьекта
return redirect(url_for('main.user', id=current_user.id))
return render_template('auth/login.html', title=_('Sign In'), form=form)
def register(): # регистрация
if current_user.is_authenticated:
return redirect(url_for('main.index'))
form = RegistrationForm() # инициализация форм указанных в forms.py
cursor = conn.cursor()
if form.validate_on_submit():
fio = form.familiya.data + ' ' + form.imya.data + ' ' + form.otchestvo.data
cursor.execute(
'insert into Uzer (fio,phone,gender,dyennarodjenya,login,password,avatar) values(%s,%s,%s,%s,%s,%s,%s)',
[
fio, form.phone.data, form.gender.data, form.dr.data,
form.login.data,
generate_password_hash(form.password.data),
'https://sun9-31.userapi.com/c622218/v622218469/3809c/DVjj0zqmizo.jpg'
])
conn.commit() # добавление данных введенных при регистрации в БД
flash(_('Учетная запись для %(fio)s создана успешно!', fio=fio))
flash(_('Login: %(login)s', login=form.login.data))
flash(_('Password: %(passw)s', passw=form.password.data))
return redirect(url_for('auth.login'))
return render_template('auth/register.html',
title=_('Register'),
form=form)
def item_fw(id):
cursor = conn.cursor()
cursor.execute('select * from ITEMS where id = %s',
[id])
tkitem = cursor.fetchone()
descr = re.sub(r'[\r]','',tkitem[12])
description = [x for x in descr.strip().split('\n') if x]
item = list(tkitem)
item[10] = re.sub(r'[{}]', '', item[10]).split(',')
full = [it.replace('737x737', '1474x1474') for it in item[10]]
review = [it.replace('737x737', '120x120') for it in item[10]]
conn.commit()
cursor.execute('SELECT * FROM ITEMS WHERE TYPEITEM=%s AND NOT ID=%s', [item[9], id])
types = cursor.fetchall()
type = convert_to_list(types)
cursor.execute('SELECT count(*) FROM ITEMS WHERE TYPEITEM=%s AND NOT ID=%s', [item[9], id])
skilko = cursor.fetchone()
if skilko[0] < 4:
relateditems = type
elif skilko[0] >= 4:
relateditems = random.sample(type, 4)
kolvo = len(item[10])
return render_template('submainitem.html', title=item[5], item=item, kolvo=kolvo, review=review, full=full,
related=relateditems, description=description)
