def delete_user_post(user_id, rst_id): """UserPostテーブルから、user_idとrst_idの組をもつ行を削除する """ if not user_id: return False session = Session() try: userpost = ( session.query(UserPost) .filter("user_id = :user_id and rst_id = :rst_id") .params(user_id=user_id, rst_id=rst_id) .first() ) print userpost session.delete(userpost) session.flush() session.commit() session.close() return True except Exception, e: print "delete_user_post :", e session.rollback() session.commit() session.close() return False
def delete_userstats(user_id): session = Session() try: userstats = session.query(UserStats).filter(user_id=user_id).first() print userstats session.delete(userstats) session.flush() session.commit() session.close() return True except Exception, e: print "delete_userstats :", e session.rollback() session.commit() session.close() return False
def delete_title(id): session = Session() try: title = session.query(Title).filter(Title.id == id).first() print title session.delete(title) session.flush() session.commit() session.close() return True except Exception, e: print "delete_user_post :", e session.rollback() session.commit() session.close() return False # }}}
def delete_user(user_id, confirmation=False): """Userテーブルからユーザーを削除 確認(confirmation)を指定する """ if not confirmation: return False session = Session() try: user = session.query(User).filter("id = :user_id").params(user_id=user_id).first() session.delete(user) session.flush() session.commit() session.close() return True except Exception, e: session.rollback() print e session.commit() session.close() return False # }}}
def delete_user_post(user_id, rst_id): '''UserPostテーブルから、user_idとrst_idの組をもつ行を削除する ''' if not user_id: return False session = Session() try: userpost = session.query(UserPost)\ .filter('user_id = :user_id and rst_id = :rst_id')\ .params(user_id = user_id, rst_id = rst_id).first() print userpost session.delete(userpost) session.flush() session.commit() session.close() return True except Exception, e: print 'delete_user_post :', e session.rollback() session.commit() session.close() return False