def publish_comment(comment_id):
db = DBSession()
data = db.query(Comment).get(comment_id)
data.publish = 1
db.commit()
db.close()
return True
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 create_tag(tag_name):
db = DBSession()
p = Tag(name=tag_name)
db.add(p)
db.commit()
db.close()
return
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 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 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 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 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 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 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 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 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 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 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
def create_redirection(owner_id, url):
print(owner_id, url)
s = DBSession()
r = Redirection(owner_id=owner_id, redirect_value=url)
r.redirect_hash = uuid4().hex
s.add(r)
try:
s.commit()
result = True
except IntegrityError:
s.rollback()
result = False
s.close()
return result
def create_user(name, password):
try:
s = DBSession()
u = User(name=name, password=password)
s.add(u)
s.commit()
result = True
except:
s.rollback()
result = False
s.close()
return result
def del_user(name, password):
s = DBSession()
u = s.query(User).filter(User.name == name,
User.password == password).first()
print(u)
if not u:
result = False
else:
s.delete(u)
s.commit()
result = True
s.close()
return result
def post_create():
text = request.form.get("text").strip()
if text:
if 'user' in session:
db = DBSession()
p = Post(text=text, user_id=session['id'], timestamp=int(time()))
db.add(p)
db.commit()
print("-{}- kisisi post atti".format(session['user']))
else:
print("-{}- kisisi post atamadi".format(session['user']))
else:
print("Gecerli Post girin")
return redirect('/user/profile')
def update_todo(data):
db_session = DBSession()
todo = db_session.query(Todo).filter(Todo.id == data['id']).first()
if not todo:
result = {'messages': 'Todo not found'}
else:
todo.title = data['title']
todo.content = data['content']
todo.due_date = data['due_date']
todo.checked = data['checked']
db_session.commit()
db_session.close()
result = {'message': 'todo güncellendi.'}
return result
def create_user(email, password, fullname, userinfo="..."):
db = DBSession()
user = User(email=email,
password=password,
fullname=fullname,
userinfo=userinfo)
db.add(user)
try:
db.commit()
except IntegrityError:
print("Bu kullanıcı zaten var")
db.rollback()
user = None
data = user.to_dict() if user else None
db.close()
return data
def login(email, password):
db = DBSession()
u = db.query(User).filter(User.email == email,
User.password == password).first()
token = None
# print(u)
if u and u.status == 0:
token = u.update_token()
db.commit()
db.close()
if not u:
print("Gecersiz kullanici")
return None
return token
def remove_user():
username = request.form.get("username")
password = request.form.get("password")
db = DBSession()
u = db.query(User).filter(User.username == username,
User.password == password).first()
if u:
db.delete(u)
db.commit()
print("-{}-kullanici Silindi".format(username))
else:
print("-{}-kullanici Silinemedi".format(username))
db.close()
return redirect('/')
def create_todo(data):
db_session = DBSession()
new_todo = Todo(title=data['title'],
content=data['content'],
due_date=data['due_date'],
checked=data['checked'],
user_id=data['user_id'])
db_session.add(new_todo)
db_session.commit()
new_todo = new_todo.to_dict()
db_session.close()
print('todo oluşturuldu.', new_todo['id'])
return new_todo
def update_redirection(redirection_id, url):
print(redirection_id, url)
s = DBSession()
r = s.query(Redirection).get(redirection_id)
if not r:
result = False
else:
r.redirect_value = url
try:
s.commit()
result = True
except IntegrityError:
s.rollback()
result = False
return result
def update_best_point(email, point):
db = DBSession()
user = db.query(User).filter(User.email == email).first()
if user:
user.point = point
try:
db.commit()
user.update_best_point()
db.commit()
except IntegrityError:
print('Veritabanı commit işlemi sırasında hata oluştu')
db.rollback()
data = user.to_dict()
db.close()
return data
def create_user(email):
data = get_user(email)
if not data:
print('Yeni kullanıcı eklendi')
db = DBSession()
user = User(email=email)
db.add(user)
try:
db.commit()
except IntegrityError:
print('Veritabanı commit esnasında hata oluştu')
db.rollback()
user = None
data = user.to_dict() if user else None
db.close()
return data
def change_password():
username = request.form.get("username")
password = request.form.get("password")
new_password = request.form.get("new_password")
db = DBSession()
u = db.query(User).filter(User.username == username,
User.password == password).first()
if u:
u.password = new_password
db.commit()
print("{} kisisinin sifresi Degistirildi".format(username))
else:
print("{} kisisinin sifresi Degistirilemedi".format(username))
db.close()
return redirect('/')
def create_user(data):
db_session = DBSession()
user = db_session.query(User).filter(User.email == data['email']).first()
if user:
abort(404, 'bu email kullanılmış.')
else:
password = sha512(data['password'].encode('utf-8')).hexdigest()
new_user = User(username=data['username'],
email=data['email'],
password=password)
try:
db_session.add(new_user)
db_session.commit()
result = [new_user.to_dict()]
except:
db_session.rollback()
result = {'status': 'error'}
db_session.close()
print('user oluşturuldu')
return result
def add_question(question, answer1, answer2, answer3, answer4, answer5,
true_answer):
db = DBSession()
question = Question(question=question,
answer1=answer1,
answer2=answer2,
answer3=answer3,
answer4=answer4,
answer5=answer5,
true_answer=true_answer)
db.add(question)
try:
db.commit()
except IntegrityError:
print('Veritabanı commit esnasında hata oluştu')
db.rollback()
question = None
data = question.to_dict() if question else None
db.close()
return data
def bootstrap(app):
from app.models import DBSession, Company, User
user = User(document=1128417376, name=u'Willington Vega', email=u'*****@*****.**', password=u'password')
company = Company.create(nit=9003671435, name=u'Inv. Sinapsis S.A.S', user=user)
DBSession.add(user)
DBSession.add(company)
DBSession.commit()
# environ = {
# 'path': '/company/create',
# 'method': 'POST',
# 'data': {
# 'nit': '9003671435',
# 'name': 'Inv. Sinapsis S.A.S',
# 'document': '1128417376',
# 'username': '******',
# 'email': '*****@*****.**',
# 'password': '******',
# 'confirm': 'password'
# }
# }
