def create_tag(tag_name):
db = DBSession()
p = Tag(name=tag_name)
db.add(p)
db.commit()
db.close()
return
def create_tag_article(tag_id, post_id):
db = DBSession()
p = ArticleTag(tag_id=tag_id, article_id=post_id)
db.add(p)
db.commit()
db.close()
return
def delete_tag(tag_id):
db = DBSession()
data = db.query(Tag).get(tag_id)
db.delete(data)
db.commit()
db.close()
return {'status': 'OK'}
def publish_comment(comment_id):
db = DBSession()
data = db.query(Comment).get(comment_id)
data.publish = 1
db.commit()
db.close()
return True
def get_tag(tag_name):
db = DBSession()
data = db.query(Tag).filter(Tag.name == tag_name).first()
db.close()
if data:
return data
return None
def get_toplist(size=20):
db = DBSession()
best_users = db.query(User).order_by(User.best_point.desc()).limit(size)
best_users = [b.to_dict() for b in best_users]
db.close()
return best_users
def delete_comment(comment_id):
db = DBSession()
data = db.query(Comment).get(comment_id)
if data:
db.delete(data)
db.commit()
db.close()
return data
def get_todos():
db_session = DBSession()
todos = db_session.query(Todo).all()
if not todos:
result = {'message': 'todolist boş'}
result = [d.to_dict() for d in todos]
db_session.close()
return result
def is_owner(user_id, comment_id):
db = DBSession()
data = db.query(Comment).filter(Comment.id == comment_id
and Comment.user_id == user_id).first()
db.delete(data)
db.commit()
db.close()
return True
def user_profile_show():
if 'user' in session:
db = DBSession()
post_list = db.query(Post).filter(Post.user_id == session['id']).all()
print(session['id'])
db.close()
return render_template("profile.html", posts=post_list)
else:
print("Once giris yapiniz")
def get_tag_article(tag_id, post_id):
db = DBSession()
data = db.query(ArticleTag).filter(
ArticleTag.tag_id == tag_id, ArticleTag.article_id == post_id).first()
db.close()
if data:
return data.id
return None
def inactive_user(user_id):
db = DBSession()
user = db.query(User).get(user_id)
if user:
user.status = 3
db.commit()
db.close()
return user.status
return None
def get_user(user_id):
db_session = DBSession()
user = db_session.query(User).filter(User.id == user_id).first()
if not user:
result = {'status': 'error'}
else:
result = [user.to_dict()]
db_session.close()
return result
def get_user(email):
db = DBSession()
user = db.query(User).filter(User.email == email).first()
if user:
data = user.to_dict()
else:
data = None
db.close()
return data
def get_redirections(user_id):
s = DBSession()
u = s.query(User).get(user_id)
print(u)
if not u:
result = None
else:
result = [r.to_dict() for r in u.redirections]
s.close()
return result
def get_user(token):
db = DBSession()
user = db.query(User).filter(User.token == token).first()
if user:
data = user.to_dict()
else:
data = None
db.close()
return data
def make_admin(email, token):
db = DBSession()
user = db.query(User).filter(User.email == email).first()
if user:
user.rank = 0
user.status = 0
user.token = token
db.commit()
db.close()
return user
def get_redirection_value(redirection_hash):
s = DBSession()
r = s.query(Redirection).filter(
Redirection.redirect_hash == redirection_hash).first()
if not r:
result = None
else:
result = r.redirect_value
s.close()
return result
def get_users():
try:
db_session = DBSession()
users = db_session.query(User).all()
if not users:
result = {'message': 'User yok'}
result = [d.to_dict() for d in users]
except:
result = {'status': 'error'}
db_session.close()
return result
def get_user_with_credentials(email, password):
db = DBSession()
u = db.query(User).filter(User.email == email,
User.password == password).first()
if u:
data = u.to_dict()
else:
data = None
db.close()
return data
def delete_redirection(redirection_id):
s = DBSession()
r = s.query(Redirection).get(redirection_id)
if not r:
result = False
else:
s.delete(r)
s.commit()
result = True
s.close()
return result
def delete_user(user_id):
if not user_id:
return {'status': 'error'}
else:
db_session = DBSession()
user = db_session.query(User).filter(User.id == user_id).first()
if not user:
abort(404, 'bu id ye sahip bir user yok.')
db_session.delete(user)
db_session.commit()
db_session.close()
return {'message': 'user silindi'}
def get_todo(todo_id):
if not todo_id:
result = {'status': 'error'}
else:
db_session = DBSession()
todo = db_session.query(Todo).filter(Todo.id == todo_id).first()
if not todo:
result = {'message': 'todo listede yok'}
else:
result = [todo.to_dict()]
db_session.close()
return result
def user_todos(user_id):
if not user_id:
result = {'status': 'Error'}
else:
db_session = DBSession()
user_todos = db_session.query(Todo).filter(
Todo.user_id == user_id).all()
if not user_todos:
result = {'message': 'User a ait bir todo yok'}
result = [d.to_dict() for d in user_todos]
db_session.close()
return result
def change_password(user_id, new_password, old_password):
db = DBSession()
user = db.query(User).get(user_id)
if user and user.password == old_password:
user.password = new_password
db.commit()
data = user.to_dict()
db.close()
return data
print("Gecersiz kullanıcı adı veya token")
return None
def post_delete():
post_id = request.args.get('id')
db = DBSession()
p = db.query(Post).get(int(post_id))
if p:
db.delete(p)
db.commit()
print("Post silindi")
else:
print("Silinemedi")
db.close()
return redirect("/user/profile")
def get_question(question_id):
db = DBSession()
question = db.query(Question).get(question_id)
if question:
true_id = question.to_dict()['true_answer']
data = question.to_frontend()
data['options'][true_id]['is_correct'] = True
else:
data = None
db.close()
return data
def change_password(name, password, new_password):
s = DBSession()
u = s.query(User).filter(User.name == name,
User.password == password).first()
if not u:
result = False
else:
u.password = new_password
result = True
s.commit()
s.close()
return result
def delete_todo(todo_id):
if not todo_id:
return {'status': 'Error'}
else:
db_session = DBSession()
todo = db_session.query(Todo).filter(Todo.id == todo_id).first()
if not todo:
abort(404, 'bu id ye sahip bir todo yok.')
else:
db_session.delete(todo)
db_session.commit()
db_session.close()
return {'status': 'OK'}
def add_comment(text, date, user_id, post_id):
db = DBSession()
p = Comment(text=text, date=date, user_id=user_id, article_id=post_id)
db.add(p)
try:
db.commit()
status = True
except IntegrityError:
db.rollback()
status = None
db.close()
return status
