def saveProject(argRequest, argGroupId, format=None): try: if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR103', None) tmpData = JSONParser().parse(argRequest) if argRequest.method == 'POST': tmpNewProject = Project.objects.create(name=getPropertyByName('name', tmpData.items()), description=getPropertyByName('description', tmpData.items()), created=date.today(), entity_status=0, group=Group.objects.get(pk=argGroupId)) updateUserListInProject(tmpData, tmpNewProject.id) tmpSerializer = ProjectSerializer(tmpNewProject) return responseJsonUtil(True, None, tmpSerializer) if argRequest.method == 'PUT': Project.objects.filter(id=getPropertyByName('id', tmpData.items())).update( name=getPropertyByName('name', tmpData.items()), description=getPropertyByName('description', tmpData.items()), group=Group.objects.get(pk=argGroupId)) updateUserListInProject(tmpData, getPropertyByName('id', tmpData.items())) return responseJsonUtil(True, None, None) except Project.DoesNotExist: return responseJsonUtil(False, 'ERROR500', None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)
def getRoles(argRequest): if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR100', None) try: tmpRoles = Role.objects.all() tmpRolesSerializer = RoleSerializer(tmpRoles) return responseJsonUtil(True, None, tmpRolesSerializer) except Role.DoesNotExist: return responseJsonUtil(False, 'ERROR600', None)
def user_services(request, pk, format=None): if not userAuthentication(request): return responseJsonUtil(False, 'ERROR103', None) if request.method == 'GET': return user_authentication(request) if request.method == 'POST': return register_user(request) if request.method == 'PUT': return update_user(request, pk)
def deleteUser(argRequest, argUserID, argGroupID): if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR100', None) try: tmpGroupUser = Group_User.objects.get(user_id=str(argUserID), group_id=str(argGroupID)) tmpGroupUser.delete() return responseJsonUtil(True, None, None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)
def setPassword(request, format=None): if request.method == 'PUT': if not userAuthentication(request): return responseJsonUtil(False, 'ERROR103', None) data = JSONParser().parse(request) tmpPassword = getPropertyByName('password', data.items()) User.objects.filter(session_key=request.session._session_key).update(password=tmpPassword) tmpUser = getUserByRequest(request) tmpSerializer = UserSerializer(tmpUser) return responseJsonUtil(True, None, tmpSerializer)
def getUsers(argRequest, argEmail, format=None): try: if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR103', None) tmpLimit = 10 tmpResult = User.objects.filter(email__icontains=argEmail)[:tmpLimit] tmpSerializer = UserSerializer(tmpResult) return responseJsonUtil(True, None, tmpSerializer) except Group.DoesNotExist: return responseJsonUtil(False, "ERROR200", None)
def getUserAuth(argRequest, format=None): try: if userAuthentication(argRequest): tmpUser = User.objects.raw( 'Select * from main_user where session_key = \'' + argRequest.session.session_key + '\'') tmpSerializer = UserSerializer(tmpUser) return responseJsonUtil(True, None, tmpSerializer) return responseJsonUtil(False, 'ERROR103', None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)
def getAllProjectsByUser(argRequest, format=None): if not userAuthentication(argRequest): return responseJsonUtil(False,'ERROR103', None) try: tmpUserId = getUserByRequest(argRequest)._get_pk_val tmpResult = Project.objects.all().filter(project_user__user=tmpUserId, entity_status=0) serializer = ProjectSerializer(tmpResult) return responseJsonUtil(True,None,serializer) except User.DoesNotExist: return responseJsonUtil(False, 'ERROR400', None) except Project.DoesNotExist: return responseJsonUtil(False, 'ERROR500', None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)
def deleteProject(argRequest, argProjectID, format=None): try: if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR103', None) if argRequest.method == 'DELETE': Project.objects.filter(id=argProjectID).update(entity_status=1) tmpProject = Project.objects.filter(id=argProjectID) tmpSerializer = ProjectSerializer(tmpProject) return responseJsonUtil(True, None, tmpSerializer) except Project.DoesNotExist: return responseJsonUtil(False, 'ERROR500', None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)
def getUserByGroupAndProject(request, group, project): if not userAuthentication(request): return responseJsonUtil(False, 'ERROR103', None) if not groupExists(group): return responseJsonUtil(False, 'ERROR200', None) if not projectExists(project): return responseJsonUtil(False, 'ERROR500', None) if request.method == 'GET': tmpResultUser = User.objects.raw('select * from main_user tmpUser ' 'inner join (select user_id as userId, role_id as role_id from main_project_user where project_id in ' '(select id from main_project where group_id = ' + str( group) + ' and id=' + str(project) + ' )) tmpProjectUser on tmpUser.id = tmpProjectUser.userId') tmpSerializer = UserDTOSerializer(tmpResultUser) return responseJsonUtil(True, None, tmpSerializer)
def getProjectsByUserAndGroup(argRequest, argGroupID, format=None): if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR103', None) try: tmpMail = getUserByRequest(argRequest).email tmpResult = Project.objects.raw('select mproject.id, mproject.name, mproject.created, mproject.group_id \ from main_project_user project_user inner join main_user muser on project_user.user_id = muser.id \ inner join main_project mproject on project_user.project_id = mproject.id \ where muser.entity_status = 0 and mproject.entity_status = 0 and muser.email= \'' + str(tmpMail) + '\' and mproject.group_id = ' + str(argGroupID)) serializer = ProjectSerializer(tmpResult) return responseJsonUtil(True, None, serializer) except User.DoesNotExist: return responseJsonUtil(False, 'ERROR400', None) except Project.DoesNotExist: return responseJsonUtil(False, 'ERROR500', None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)
def getUserProjectByGroup(argRequest, argProjectID, format=None): if not userAuthentication(argRequest): return responseJsonUtil(False, 'ERROR103', None) try: tmpProject = Project.objects.get(id=argProjectID) tmpProjectSerializer = ProjectSerializer(tmpProject) cursor = connection.cursor() cursor.execute('select muser.id as id, muser.email as name, mrole.name as role\ from main_project_user project_user inner join main_user muser on muser.id = project_user.user_id \ inner join main_role mrole on project_user.role_id = mrole.id \ where muser.entity_status = 0 and project_user.project_id = ' + str(argProjectID)) tmpResult = cursor.fetchall() connection.close() tmpUserSerializer = convertUserRole(tmpResult) tmpProjectUserListSerializer = createProjectListDTOObject(tmpProjectSerializer, tmpUserSerializer, argProjectID) return responseJsonUtil(True, None, tmpProjectUserListSerializer) except Project.DoesNotExist: return responseJsonUtil(False, 'ERROR500', None) except BaseException: return responseJsonUtil(False, 'ERROR000', None)