def whatever(): id = 'wisid_RegionProfileData2016_56c377709c1c5' data = [u'taccpuPSch', u'accprPhar', u'popEleRol', u'accpuPSch', u'taccprGP', u'accpuFood', u'accprGP', u'hlthLLTI', u'taccpuPO', u'popSpkWlsh', u'taccpuLib', u'accprPO', u'taccprPhar', u'pop16to64', u'accprFood', u'taccprPSch', u'taccprPO', u'popTotPop', u'emyInact', u'accpuSSch', u'accprLC', u'houFlat', u'houSDet', u'accpuPO', u'houAll', u'taccpuFood', u'pop65plus', u'hlthLExpF', u'accprLib', u'eduThres2', u'accpuGP', u'accpuLib', u'taccpuLC', u'taccpuSSch', u'eduNQF4', u'hlthLExpM', u'houTer', u'accpuPhar', u'taccpuPhar', u'accprSSch', u'accprPetrl', u'emyEmploy', u'taccprLib', u'taccprSSch', u'accpuLC', u'houTaxEF', u'taccprFood', u'taccprPetr', u'taccpuGP', u'accprPSch', u'houTaxGI', u'pop0to15', u'eduNoQual', u'houTaxCD', u'emyBenClai', u'houDet', u'emyWkEarn', u'houTaxAB', u'taccprLC'] for d in data: uuid_str = str(uuid.uuid4()) nomis_search = models.NomisSearch() nomis_search.uuid = uuid_str nomis_search.user = get_request_user(None) nomis_search.dataset_id = dataset_id nomis_search.geography_id = geog nomis_search.search_attributes = codelist_to_attributes(codelist) nomis_search.search_type = models.SearchType.objects.get(name='Nomis') nomis_search.save()
def whatever(): id = 'wisid_RegionProfileData2016_56c377709c1c5' data = [ u'taccpuPSch', u'accprPhar', u'popEleRol', u'accpuPSch', u'taccprGP', u'accpuFood', u'accprGP', u'hlthLLTI', u'taccpuPO', u'popSpkWlsh', u'taccpuLib', u'accprPO', u'taccprPhar', u'pop16to64', u'accprFood', u'taccprPSch', u'taccprPO', u'popTotPop', u'emyInact', u'accpuSSch', u'accprLC', u'houFlat', u'houSDet', u'accpuPO', u'houAll', u'taccpuFood', u'pop65plus', u'hlthLExpF', u'accprLib', u'eduThres2', u'accpuGP', u'accpuLib', u'taccpuLC', u'taccpuSSch', u'eduNQF4', u'hlthLExpM', u'houTer', u'accpuPhar', u'taccpuPhar', u'accprSSch', u'accprPetrl', u'emyEmploy', u'taccprLib', u'taccprSSch', u'accpuLC', u'houTaxEF', u'taccprFood', u'taccprPetr', u'taccpuGP', u'accprPSch', u'houTaxGI', u'pop0to15', u'eduNoQual', u'houTaxCD', u'emyBenClai', u'houDet', u'emyWkEarn', u'houTaxAB', u'taccprLC' ] for d in data: uuid_str = str(uuid.uuid4()) nomis_search = models.NomisSearch() nomis_search.uuid = uuid_str nomis_search.user = get_request_user(None) nomis_search.dataset_id = dataset_id nomis_search.geography_id = geog nomis_search.search_attributes = codelist_to_attributes(codelist) nomis_search.search_type = models.SearchType.objects.get(name='Nomis') nomis_search.save()
def survey_metadata(request, wiserd_id): wiserd_id = wiserd_id.strip() user_profile = get_request_user(request) allowed, access_data = survey_visible_to_user(wiserd_id, user_profile) surveys = [] if allowed: survey_models = models.Survey.objects.all().filter(identifier=wiserd_id).values("surveyid", "identifier", "survey_title", "datacollector", "collectionstartdate", "collectionenddate", "moc_description", "samp_procedure", "collectionsituation", "surveyfrequency", "surveystartdate", "surveyenddate", "des_weighting", "samplesize", "responserate", "descriptionofsamplingerror", "dataproduct", "dataproductid", "location", "link", "notes", "user_id", "created", "updated", "long", "short_title", "spatialdata") for survey_model in survey_models: surveys.append({ 'data': survey_model, 'wiserd_id': wiserd_id }) else: # TODO decide if more info is needed here pass api_data = { 'url': request.get_full_path(), 'method': 'survey_metadata', 'search_result_data': surveys, 'results_count': len(surveys), 'access_data': access_data, 'read_access': allowed } return HttpResponse(json.dumps(api_data, indent=4, default=date_handler), content_type="application/json")
def get_login_redirect_url(self, request): request_user = get_request_user(request) # If the user hasn't been shown the welcome screen before, show it now. if not request_user.init_user: return reverse("welcome") else: print "user role", request_user.role if request_user.role == "naw": return reverse("naw_dashboard") else: return reverse("index")
def get_login_redirect_url(self, request): request_user = get_request_user(request) # If the user hasn't been shown the welcome screen before, show it now. if not request_user.init_user: return reverse('welcome') else: print 'user role', request_user.role if request_user.role == 'naw': return reverse('naw_dashboard') else: return reverse('index')
def usage_tracker(request): userr = get_request_user(request) # print 'User loaded a page : ', userr.user.username, datetime.now(), get_client_ip(request), request.get_full_path() if 'admin_tools' not in request.get_full_path(): ut = models.UserTracking() ut.user = userr ut.ip = get_client_ip(request) ut.url = request.get_full_path() ut.save() return {}
def convert_csv_to_json(csv_file): reader = csv.reader(open(csv_file, 'r')) header = None ds = [] for r in reader: if header: d = dict() for idx, h in enumerate(header): if h: d[h] = r[idx] ds.append(d) else: header = r print header print pprint.pformat(ds) fixtures = [] categories = [] for idx, d in enumerate(ds): d['geom'] = "POINT ({} {})".format(d['x'], d['y']) categories.append(d['category'].strip()) fixtures.append( { "pk": str(idx), "model": "dataportal3.WMHpoints", "fields": d } ) with open('mining_features.json', 'w') as mhw_fixtures: mhw_fixtures.write(json.dumps(fixtures, indent=4)) from django.core.management import call_command call_command('loaddata', 'mining_features.json', app_label='dataportal3', database='new') html_snippet = ''' <li> <a href="#" data-wiserd_layer_uuid="{}" class="wiserd_layer_toggle"> <i class="fa fa-map-marker fa-fw"></i> {} </a> </li> ''' ns, created = models.NomisSearch.objects.get_or_create( uuid = 'WMHpoints', user=get_request_user() ) ns.name = 'All Locations' ns.uuid = 'WMHpoints' ns.dataset_id = 'WMHpoints' ns.geography_id = '' ns.search_attributes = {} ns.display_attributes = { "bin_num": "5", "bin_type": "q", "colorpicker": "YlGnBu", "point_icon": "fa-bolt", "remote_value_key": "category", } ns.display_fields = {} ns.search_type = models.SearchType.objects.get(name='LocalResearch') ns.save() all_html = html_snippet.format('WMHpoints', 'All locations') for category in set(categories): ns, created = models.NomisSearch.objects.get_or_create( uuid = 'WMHpoints_{}'.format(category.replace(' ', '_')), user=get_request_user() ) ns.name = '{}'.format(category) ns.dataset_id = 'WMHpoints' ns.geography_id = '' ns.search_attributes = {} ns.display_attributes = { "bin_num": "5", "bin_type": "q", "colorpicker": "YlGnBu", "point_icon": "fa-bolt", "remote_value_key": "category", "filter": category } ns.display_fields = {} ns.search_type = models.SearchType.objects.get(name='LocalResearch') ns.save() all_html += html_snippet.format(ns.uuid, category) print all_html