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