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_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 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(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 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 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 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 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
