def fin():
model = DBSession.query(group_table).filter(group_table.group_id == group.group_id).scalar()
if model:
DBSession.delete(model)
DBSession.flush()
transaction.commit()
print '(A_group fixture) delete'
if DBSession.dirty:
transaction.commit()
def fin():
model = DBSession.query(user_table).filter(user_table.user_id == user.user_id).scalar()
if model:
DBSession.delete(model)
DBSession.flush()
transaction.commit()
print '(A_user fixture)=> delete'
if DBSession.dirty:
transaction.commit()
def test_delete_group(engine_fixture):
group_table = models.account.Group_TB
new_group_name = id_generator(size=25).decode('utf-8')
with transaction.manager as tm:
#create
new_model = group_table(group_name=new_group_name)
DBSession.add(new_model)
DBSession.flush()
model = DBSession.query(group_table).filter(group_table.group_name == new_group_name).scalar()
assert model
#delete
DBSession.delete(model)
DBSession.flush()
model = DBSession.query(group_table).filter(group_table.group_name == new_group_name).first()
assert model == None
def test_delete_user(engine_fixture, A_group):
user_table = models.account.User_TB
user_name=id_generator(size=25).decode('utf-8')
salt = os.urandom(26).encode('hex')
password = os.urandom(10).encode('hex')
with transaction.manager as tm:
success, user = user_table.create(
user_name = user_name,
password=password,
activated=True,
group_id=A_group.group_id
)
assert success == True
#delete
DBSession.delete(user)
DBSession.flush()
model = DBSession.query(user_table).filter(user_table.user_id == user.user_id).first()
assert model == None
