Ejemplo n.º 1
0
def projinfo (request, webargs):
  """Return project and dataset configuration information"""
  
  try:  
    return django.http.HttpResponse(ocpcarest.projInfo(webargs), mimetype="product/hdf5" )
  except OCPCAError, e:
    return django.http.HttpResponseNotFound(e.value)
Ejemplo n.º 2
0
def projinfo(request, webargs):
    """Return project and dataset configuration information"""

    try:
        return django.http.HttpResponse(ocpcarest.projInfo(webargs),
                                        content_type="product/hdf5")
    except OCPCAError, e:
        return django.http.HttpResponseNotFound(e.value)
Ejemplo n.º 3
0
def getProjects(request):

  try:
    if request.method == 'POST':
      if 'filter' in request.POST:
        #FILTER PROJECTS BASED ON INPUT VALUE
        userid = request.user.id
        filteroption = request.POST.get('filteroption')
        filtervalue = (request.POST.get('filtervalue')).strip()
        
        pd = ocpcaproj.OCPCAProjectsDB()

        # get the visible data sets
        if request.user.is_superuser:
          visible_datasets=Dataset.objects.all()
        else:
          visible_datasets=Dataset.objects.filter(user_id=userid) | Dataset.objects.filter(public=1)

        visible_datasets.sort()

        projs = defaultdict(list)

        dbs = defaultdict(list)

        for db in visible_datasets:
          proj = Project.objects.filter(dataset_id=db.dataset_name, user_id=userid) | Project.objects.filter(dataset_id=db.dataset_name, public=1)
          if proj:
            dbs[db.dataset_name].append(proj)
          else:
            dbs[db.dataset_name].append(None)

        if request.user.is_superuser:
          visible_projects = Project.objects.all()
        else:
          visible_projects = Project.objects.filter(user_id=userid) | Project.objects.filter(public=1) 

        return render_to_response('projects.html', { 'databases': dbs.iteritems() ,'projects': visible_projects.values_list(flat=True) },context_instance=RequestContext(request))

      elif 'delete_data' in request.POST:

        pd = ocpcaproj.OCPCAProjectsDB()
        username = request.user.username
        project_to_delete = (request.POST.get('project_name')).strip()
                
        reftokens = Token.objects.filter(project_id=project_to_delete)
        if reftokens:
          messages.error(request, 'Project cannot be deleted. Please delete all tokens for this project first.')
          return HttpResponseRedirect(get_script_prefix()+'ocpuser/projects')
        else:
          proj = Project.objects.get(project_name=project_to_delete)
          if proj:
            if proj.user_id == request.user.id or request.user.is_superuser:
              #Delete project from the table followed  by the database.
              # deleting a project is super dangerous b/c you may delete it out from other tokens.
              #  on other servers.  So, only delete when it's on the same server for now
              pd.deleteOCPCADB(project_to_delete)
              proj.delete()          
              messages.success(request,"Project deleted")
            else:
              messages.error(request,"Cannot delete.  You are not owner of this project or not superuser.")
          else:
            messages.error( request,"Project not found.")
          return HttpResponseRedirect(get_script_prefix()+'ocpuser/projects')

      elif 'delete' in request.POST:
        pd = ocpcaproj.OCPCAProjectsDB()
        username = request.user.username
        project_to_delete = (request.POST.get('project_name')).strip()
                
        reftokens = Token.objects.filter(project_id=project_to_delete)
        if reftokens:
          messages.error(request, 'Project cannot be deleted. Please delete all tokens for this project first.')
          return HttpResponseRedirect(get_script_prefix()+'ocpuser/projects')
        else:
          proj = Project.objects.get(project_name=project_to_delete)
          if proj:
            if proj.user_id == request.user.id or request.user.is_superuser:
              #Delete project from the table followed  by the database.
              # RBTODO deleting a project is super dangerous b/c you may delete it out from other tokens.
              #  on other servers.  So, only delete when it's on the same server for now
              #if proj.getKVServer()==proj.getDBHost():
              #   pd.deleteOCPCADB(project_to_delete)
              proj.delete()          
              messages.success(request,"Project deleted")
            else:
              messages.error(request,"Cannot delete.  You are not owner of this project or not superuser.")
          else:
            messages.error( request,"Project not found.")
          return HttpResponseRedirect(get_script_prefix()+'ocpuser/projects')
      
      elif 'info' in request.POST:
      #GET PROJECT INFO -----------TODO
        token = (request.POST.get('roptions')).strip()
        return HttpResponse(ocpcarest.projInfo(token), content_type="product/hdf5" )
      
      elif 'update' in request.POST:
        project_to_update =(request.POST.get('project_name')).strip() 
        request.session["project_name"] = project_to_update
        return redirect(updateProject)
      
      elif 'tokens' in request.POST:
        projname=(request.POST.get('project_name')).strip()
        request.session["project"] = projname
        return redirect(getTokens)

      elif 'channels' in request.POST:
        projname=(request.POST.get('project_name')).strip()
        request.session["project"] = projname
        return redirect(getChannels)

      elif 'backup' in request.POST:
        projname=(request.POST.get('project_name')).strip()
        request.session["project"] = projname
        return redirect(backupProject)
 



# RB old backup code
#
#        path = settings.BACKUP_PATH + '/' + request.user.username
#        if not os.path.exists(path):
#          os.mkdir( path, 0755 )
#        # Get the database information
#        pd = ocpcaproj.OCPCAProjectsDB()
#        db = (request.POST.get('project_name')).strip()
#        ofile = path +'/'+ db +'.sql'
#        outputfile = open(ofile, 'w')
#        dbuser = settings.DATABASES['default']['USER']
#        passwd = settings.DATABASES['default']['PASSWORD']
#
#        p = subprocess.Popen(['mysqldump', '-u'+ dbuser, '-p'+ passwd, '--single-transaction', '--opt', db], stdout=outputfile).communicate(None)
#        messages.success(request, 'Sucessfully backed up database '+ db)
#        return HttpResponseRedirect(get_script_prefix()+'ocpuser/projects')

      else:
        # Invalid POST
        messages.error(request,"Unrecognized POST")
        return HttpResponseRedirect(get_script_prefix()+'ocpuser/projects')

    else:
    # GET Projects
      userid = request.user.id

      # get the visible data sets
      if request.user.is_superuser:
        visible_datasets=Dataset.objects.all()
      else:
        visible_datasets=Dataset.objects.filter(user_id=userid) | Dataset.objects.filter(public=1)

      dbs = defaultdict(list)
    
      for db in visible_datasets:
        proj = Project.objects.filter(dataset_id=db.dataset_name, user_id=userid) | Project.objects.filter(dataset_id=db.dataset_name, public=1)
        if proj:
          dbs[db.dataset_name].append(proj)
        else:
          dbs[db.dataset_name].append(None)
      
      if request.user.is_superuser:
        visible_projects = Project.objects.all()
      else:
        visible_projects = Project.objects.filter(user_id=userid) | Project.objects.filter(public=1) 

      return render_to_response('projects.html', { 'databases': sorted(dbs.iteritems()) ,'projects':visible_projects },context_instance=RequestContext(request))
    
  except OCPCAError, e:

    messages.error(request,"Unknown exception in administrative interface = {}".format(e)) 

    # GET Projects
    username = request.user.username
    all_datasets= Dataset.objects.all()
    dbs = defaultdict(list)
    for db in all_datasets:
      proj = Project.objects.filter(dataset_id=db.dataset_name, user_id = request.user)
      if proj:
        dbs[db.dataset_name].append(proj)
      else:
        dbs[db.dataset_name].append(None)
    
    all_projects = Project.objects.values_list('project_name',flat= True)
    return render_to_response('projects.html', { 'databases': dbs.iteritems() ,'projects':all_projects },context_instance=RequestContext(request))
Ejemplo n.º 4
0
def profile(request):
  try:
    if request.method == 'POST':
      if 'filter' in request.POST:
      #FILTER PROJECTS BASED ON INPUT VALUE
        openid = request.user.username
        filteroption = request.POST.get('filteroption')
        filtervalue = (request.POST.get('filtervalue')).strip()
        pd = ocpcaproj.OCPCAProjectsDB()
        projects = pd.getFilteredProjects ( openid,filteroption,filtervalue )
        
        databases = pd.getDatabases ( openid)
        dbs = defaultdict(list)
        for db in databases:
          proj = pd.getFilteredProjs(openid,filteroption,filtervalue,db[0]);
          dbs[db].append(proj)
          
        return render_to_response('profile.html', { 'projs': projects,'databases': dbs.iteritems() },
                                context_instance=RequestContext(request))
      elif 'delete' in request.POST:
      #DELETE PROJECT WITH SPECIFIED TOKEN

        pd = ocpcaproj.OCPCAProjectsDB()
        openid = request.user.username
        
        project = (request.POST.get('projname')).strip()
        print " Ready to delete " ,project
      #token = (request.POST.get('token')).strip()
       
        pd.deleteOCPCADatabase(project)
        # pd.deleteTokenDescription(token)
        #return redirect(profile)
      elif 'downloadtoken' in request.POST:
      #DOWNLOAD TOKEN FILE
        #      token = (request.POST.get('token')).strip()
        token = (request.POST.get('roptions')).strip()
        print token
        response = HttpResponse(token,content_type='text/html')
        response['Content-Disposition'] = 'attachment; filename="ocpca.token"'
        return response
      elif 'info' in request.POST:
      #GET PROJECT INFO -----------TODO
        token = (request.POST.get('roptions')).strip()
      #token = (request.POST.get('token')).strip()+"/projinfo/test"
        return HttpResponse(ocpcarest.projInfo(token), mimetype="product/hdf5" )
      elif 'update' in request.POST:
      #UPDATE PROJECT TOKEN -- FOLOWUP
      #token = (request.POST.get('token')).strip()
        token = (request.POST.get('roptions')).strip()
        print token
        request.session["token"] = token
        return redirect(updateproject)
      elif 'tokens' in request.POST:
      #View token for the project        
        #import pdb;pdb.set_trace();
        print "in view tokens"
        projname = (request.POST.get('projname')).strip()
        print projname
        request.session["project"] = projname
        #return render_to_response('token.html',
       # projname,
        #                  context_instance=RequestContext(request))
        return redirect(tokens)

      elif 'backup' in request.POST:
      #BACKUP DATABASE
        path = '/data/scratch/ocpbackup/'+ request.user.username
        if not os.path.exists(path):
          os.mkdir( path, 0755 )
              #subprocess.call('whoami')
      # Get the database information
        pd = ocpcaproj.OCPCAProjectsDB()
        db = (request.POST.get('projname')).strip()
              #Open backupfile
        ofile = path +'/'+ db +'.sql'
        outputfile = open(ofile, 'w')
        p = subprocess.Popen(['mysqldump', '-ubrain', '-p88brain88', '--single-transaction', '--opt', db], stdout=outputfile).communicate(None)
         # return redirect(profile)
        messages.success(request, 'Sucessfully backed up database '+ db)
        return redirect(profile)
      else:
        # Invalid POST
        #
        pd = ocpcaproj.OCPCAProjectsDB()
        openid = request.user.username
# projects = pd.getProjects ( openid )
        projects = pd.getFilteredProjects ( openid ,"","")
        databases = pd.getDatabases ( openid)
        dbs = defaultdict(list)
        for db in databases:
          proj = pd.getFilteredProjs(openid,"","",db[0]);
          dbs[db].append(proj)
        return render_to_response('profile.html', { 'projs': projects, 'databases': dbs.iteritems() },context_instance=RequestContext(request))

    else:
    # GET Option
      #import pdb;pdb.set_trace()
      pd = ocpcaproj.OCPCAProjectsDB()
      openid = request.user.username
      databases = pd.getDatabases ( openid)
      dbs = defaultdict(list)
      for db in databases:
        proj = pd.getFilteredProjs(openid,"","",db[0]);
        dbs[db].append(proj)
        
      return render_to_response('profile.html', { 'databases': dbs.iteritems() },context_instance=RequestContext(request))
    
  except OCPCAError, e:
    #import pdb;pdb.set_trace();
    messages.error(request, e.value)
    pd = ocpcaproj.OCPCAProjectsDB()
    openid = request.user.username
    projects = pd.getFilteredProjects ( openid ,"","")
    databases = pd.getDatabases ( openid)
    dbs = defaultdict(list)
    for db in databases:
      proj = pd.getFilteredProjs(openid,"","",db[0]);
      dbs[db].append(proj)
      
    return render_to_response('profile.html', { 'projs': projects, 'databases': dbs.iteritems() },context_instance=RequestContext(request))