def delete_news(news_id):
if 'username' not in session:
return redirect('/login')
nm = NewsModel(db.get_connection())
a = nm.delete(news_id)
return redirect("/index")
def add_news(comment=''):
if 'username' not in session:
return redirect('/login')
form = AddNewsForm()
path = os.getcwd()
print(path)
if form.validate_on_submit():
title = form.title.data
content = form.content.data
picture = form.picture.data
game = form.game.data
nm = NewsModel(db.get_connection())
a = nm.insert(title, content, picture.filename, game.filename,
session['username'])
if a[0]:
file = picture
filename = secure_filename(file.filename)
game_file = game
game_name = secure_filename(game.filename)
if not os.path.exists('static/users/{}'.format(
session['username'])):
os.chdir('static/users')
os.mkdir(session['username'])
os.chdir(session['username'])
else:
os.chdir('static/users/{}'.format(session['username']))
os.mkdir(title)
os.chdir(title)
file.save(filename)
game_file.save(game_name)
os.chdir('../../../..')
return redirect("/index")
else:
return render_template('add_news.html',
title='Добавление новости',
form=form,
username=session['username'],
comment=a[1])
return render_template('add_news.html',
title='Добавление новости',
form=form,
username=session['username'],
comment='')
def scatman():
um = UsersModel(db.get_connection())
user_list = um.get_all()
nm = NewsModel(db.get_connection())
news_list = nm.get_all()
stats_list = []
for i in user_list:
hobosti = list(
filter(lambda x: x == i[0], map(lambda x: x[3], news_list)))
stats_list.append([i[0], i[1], len(hobosti)])
return render_template('stats.html', stats_list=stats_list)
def add_news():
if 'username' not in session:
return redirect('/login')
form = AddNewsForm()
if form.validate_on_submit():
title = form.title.data
content = form.content.data
nm = NewsModel(db.get_connection())
nm.insert(title, content, session['user_id'])
return redirect("/index")
return render_template('add_news.html',
title='Добавление новости',
form=form,
username=session['username'])
def index():
if 'username' not in session:
return redirect('/login')
news = NewsModel(db.get_connection()).get_all()
return render_template('index.html',
username=session['username'],
news=news)
def index():
if 'username' not in session:
usname = None
else:
usname = session['username']
news = NewsModel(db.get_connection()).get_all()
return render_template('index.html', username=usname, news=news)
def jsonToNewsModel(newsSummary: str, date: datetime.date, watsonCallResult):
news_obj = NewsModel(
date.strftime("%Y/%m/%d"), newsSummary,
NewsModel.missingValuesHandler(watsonCallResult, 'categories', 0,
'label', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'categories', 0,
'score', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'categories', 1,
'label', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'categories', 1,
'score', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0, 'text',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'sentiment', 'score'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'relevance', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'emotion', 'sadness'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'emotion', 'joy'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'emotion', 'fear'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'emotion', 'disgust'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 0,
'emotion', 'anger'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1, 'text',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'sentiment', 'score'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'relevance', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'emotion', 'sadness'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'emotion', 'joy'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'emotion', 'fear'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'emotion', 'disgust'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 1,
'emotion', 'anger'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2, 'text',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'sentiment', 'score'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'relevance', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'emotion', 'sadness'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'emotion', 'joy'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'emotion', 'fear'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'emotion', 'disgust'),
NewsModel.missingValuesHandler(watsonCallResult, 'keywords', 2,
'emotion', 'anger'),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 0, 'type',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 0, 'text',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 0,
'relevance', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 1, 'type',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 1, 'text',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 1,
'relevance', ""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 2, 'type',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 2, 'text',
""),
NewsModel.missingValuesHandler(watsonCallResult, 'entities', 2,
'relevance', ""))
return news_obj
from AddNews import AddNewsForm
from data_init import DB
from flask import Flask, redirect, render_template, session
from LoginForm import LoginForm
from NewsModel import NewsModel
from UsersModel import UsersModel
app = Flask(__name__)
app.config['SECRET_KEY'] = 'yandexlyceum_secret_key'
#инициализируем таблицу
db = DB('asav')
NewsModel(db.get_connection()).init_table()
UsersModel(db.get_connection()).init_table()
# http://127.0.0.1:8080/login
@app.route('/login', methods=['GET', 'POST'])
def login():
form = LoginForm()
if form.validate_on_submit():
user_name = form.username.data
password = form.password.data
user_model = UsersModel(db.get_connection())
exists = user_model.exists(user_name, password)
if (exists[0]):
session['username'] = user_name
session['user_id'] = exists[1]
return redirect("/index")
return render_template('login.html', title='Авторизация', form=form)