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)
