def import_camps(self, fname, year): reader = csv.reader(open(fname, 'r')) y = Year.objects.get(year = year) campct = 0 for row in reader: if row: name = smart_unicode(row[1], errors='ignore') name = name.replace('"', '') slug = slugify(name) t = ThemeCamp(name=name, year=y, slug=slug, bm_fm_id = int(row[0])) t.save() campct += 1 print ("done, loaded %i Camps" % campct)
def _create_or_update(self, request, year_year=None, camp_id=None): user = request.user if not user.get_profile().api_allowed: return rc_response(request, rc.BAD_REQUEST, 'User not permitted to use the API') method = request.method if method == "PUT": data = request.PUT.copy() elif method == "POST": data = request.POST.copy() else: return rc_response(request, rc.BAD_REQUEST, 'Bad request method: %s' % method) if year_year and 'year' not in data: data['year'] = year_year if not (data and user): log.debug('Bad request: data=%s, user=%s', data, user) return rc_response(request, rc.BAD_REQUEST, 'Missing critical information') log.debug('data for create_or_update: %s', data) if camp_id: try: obj = ThemeCamp.objects.get(pk=camp_id) log.debug('got themecamp #%i for update', obj.id) except ThemeCamp.DoesNotExist: return rc_response(request, rc.NOT_HERE, 'ThemeCamp not found #%s' % camp_id) # no updating the year! if 'year' in data: del data['year'] else: log.debug('creating new event') obj = ThemeCamp() obj.creator = user # get rid of illegal-to-update attributes for key in ('id','pk','bm_fm_id','deleted'): if key in data: del data[key] # now loop through the data, updating as needed if 'year' in data: try: year = Year.objects.get(year=data['year']) except Year.DoesNotExist: return rc_response(request, rc.NOT_HERE, 'No such year: %s' % data['year']) obj.year = year if 'circular_street' in data: key = data['circular_street'] try: street = CircularStreet.objects.get(pk=key) obj.circular_street = street except CircularStreet.DoesNotExist: return rc_response(request, rc.NOT_HERE, 'No such CircularStreet: %s' % key) if 'time_street' in data: key = data['time_street'] try: street = TimeStreet.objects.get(pk=key) obj.time_street = street except TimeStreet.DoesNotExist: return rc_response(request, rc.NOT_HERE, 'No such TimeStreet: %s' % key) # text fields for key in ('name','description', 'url', 'hometown', 'location_string', 'slug'): if key in data: val = data[key] log.debug('setting %s=%s', key, val) setattr(obj, key, val) # booleans for key in ('list_online',): if key in data: val = data[key].upper() val = val in ('1', 'T', 'Y', 'YES', 'TRUE', 'ON') log.debug('setting %s=%s', key, val) setattr(obj, key, val) obj.save() if method == 'PUT': response = rc.ALL_OK else: response = rc.CREATED response.content = json.dumps({'pk' : obj.id}) return response