def create_projects(self):
charity = UserProfile.objects.get(id=2)
for x in xrange(0,20):
project = Project()
for y in xrange(0, 8):
setattr(project, project_field_list[y], project_lists[y][x])
country = Country.objects.get(country_name='United Kingdom')
project.country = country
state = State.objects.get(state_name__startswith='n/a')
project.state = state
project.charity = charity
project.save()
skills = Skill.objects.all()
skills_sample = random.sample(skills, 3)
project.skills = skills_sample
td = datetime.timedelta(days=x)
time_created = datetime.datetime.now() - 2*td
if project.status == 'completed':
project.time_completed = datetime.datetime.now() - td
project.save()
