Python DBSession.delete方法代码示例

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete(self,user):
     recurso = DBSession.query(Recurso).filter(user.id_fase == Recurso.id_fase)
     DBSession.delete(recurso)
     transaction.commit()
     
     DBSession.delete(user)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete(self,per):
     """
 Elimina un permiso de la base de datos
 @param per: el permiso que se quiere eliminar
 @return: none
 """
     DBSession.delete(per)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def deleteById(self, id):
     recurso = DBSession.query(Recurso).filter(id == Recurso.id_proyecto).one()
     DBSession.delete(recurso)
     transaction.commit()
     
     u = self.getById(id)
     DBSession.delete(u)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete(self,lb):
     """
 Elimina una linea base de la base de datos
 @param lb: el objeto linea base que se quiere eliminar de la base de datos
 @return: none
 """
     DBSession.delete(lb)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def deleteById(self, id):
     """
 Elimina un permiso de la base de datos
 @param id: el identificador del permiso que se quiere eliminar
 @return: none
 """
     u = self.getById(id)
     DBSession.delete(u)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def quitarRol (self, id_rol, id_user, id_proyecto):
     print ("Quitar Rol -> id_rol: " + str(id_rol) + "id_usuario: " + str(id_user) + " id_proyecto: "+str(id_proyecto))
     r = self.getByRolUsuarioProyecto(id_rol, id_user, id_proyecto)
     for i in r.permisos_recursos:
         transaction.begin()
         DBSession.delete(i)
         transaction.commit()
     transaction.begin()
     DBSession.delete(r)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def deleteById(self, id1, id2, tipo):
     '''Elimina una relacion de la base de datos mediante
     su clave primaria
     @param: id_item1
     @param: id_item2
     @param: tipo de relacion
     '''
     u = self.getById(id1, id2, tipo)
     DBSession.delete(u)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def quitarRol(self, r):
     transaction.begin()
     permisos_recursos = DBSession.query(RolUsuario).filter(RolUsuario.id_rol_usuario==r.id_rol_usuario).one().permisos_recursos
    
     
     for i in permisos_recursos:
         DBSession.delete(i)
     transaction.commit()
     
     transaction.begin()
     DBSession.delete(r)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
    def deleteById(self, id):
        ''' Elimina un Proyecto de la base de datos
        @param: id del proyecto'''
        roles = DBSession.query(RolUsuario).filter(RolUsuario.id_proyecto==id)
        if roles.count()>0:
            return False
        transaction.begin()
        u = self.getById(id)
        if u.fases != []:
            for i in u.fases:
                transaction.begin()
                recurso = DBSession.query(Recurso).filter(Recurso.id_fase==i.id_fase).one()
                DBSession.delete(recurso)
                transaction.commit()
                transaction.begin()
                fase = DBSession.query(Fase).filter(Fase.id_fase==i.id_fase).one()
                DBSession.delete(fase)
                transaction.commit()
        transaction.begin()
        recurso = DBSession.query(Recurso).filter(id == Recurso.id_proyecto).one()
        DBSession.delete(recurso)
        transaction.commit()
        transaction.begin()
        u = self.getById(id)

        DBSession.delete(u)
        transaction.commit()
        transaction.commit()
        return True

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def deleteById(self, id):     
     proyectos = ProyectoManager().getByAdministrador(id)
     sin_administrador = self.getByLogin('sin administrador')
     '''Desasignar si es Administrador de Proyecto'''
     for proyecto in proyectos: 
         transaction.begin()
         proyecto.id_administrador = sin_administrador.id_usuario
         ProyectoManager().update(proyecto)
         transaction.commit()
         
     '''Quitar los roles''' 
     u=self.getById(id)
     for rolUsuario in u.roles:
         transaction.begin()
         self.quitarRol(rolUsuario)
         transaction.commit()
         
     '''Borrar Usuario'''
     transaction.begin()
     u=self.getById(id)
     DBSession.delete(u)
     transaction.commit()
     
     return True

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def deleteById(self, id):
     u = self.getById(id)
     DBSession.delete(u)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete(self,rol):
     DBSession.delete(rol)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete(self,adjunto):
     DBSession.delete(adjunto)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete(self, relacion):
     ''' Elimina una relacion de la base de datos
     @param: Objeto relacion'''
     DBSession.delete(relacion)
     transaction.commit()

# 需要导入模块: from sgp.model import DBSession [as 别名]
# 或者: from sgp.model.DBSession import delete [as 别名]
 def delete_recurso(self,user):
     recurso = DBSession.query(Recurso).filter(user.id_proyecto == Recurso.id_proyecto)
     DBSession.delete(recurso)
     transaction.commit()