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
