def test_address_lat_long(self): """ Tests Address if no latitude and longitude """ a = Address() a.city = City(id=0, name='trabalho a distancia', state=State(name='blah', code='BL')) self.assertEqual(a.latitude, 0.0) self.assertEqual(a.longitude, 0.0)
def test_address_lat_long(self):
"""
Tests Address if no latitude and longitude
"""
a = Address()
a.city = City(id=0,
name="trabalho a distancia",
state=State(name="blah", code="BL"))
self.assertEqual(a.latitude, 0.0)
self.assertEqual(a.longitude, 0.0)
def test_address_lat_long(self): """ Tests Address if no latitude and longitude """ a = Address() a.city = City(id=0, name="trabalho a distancia", state=State(name="blah", code="BL")) self.assertEqual(a.latitude, 0.0) self.assertEqual(a.longitude, 0.0) a = self.create_address() self.assertTrue(a.latitude != 0.0) self.assertTrue(a.longitude != 0.0)
def add_volunteer_address_from_csv():
import csv
with open('users.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile, delimiter=',', quotechar='|')
for row in spamreader:
try:
id = int(row[0])
u = User.objects.get(pk=row[0])
if (u.address and not u.address.city) or not u.address:
print row[4]
address = Address()
address.city = City.objects.get(id=row[4])
address.save()
u.address = address
u.save()
except:
pass
def add_volunteer_address_from_csv():
try:
with open('users.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile, delimiter=',', quotechar='|')
for row in spamreader:
try:
id = int(row[0])
u = User.objects.get(pk=row[0])
if (u.address and not u.address.city) or not u.address:
address = Address()
address.city = City.objects.get(id=row[4])
address.save()
u.address = address
u.save()
except:
pass
except Exception as e:
rollbar.report_exc_info(sys.exc_info())
print e
return
def handle(self, *args, **options):
if options['filename'] == None :
raise CommandError("Option `--file=...` must be specified.")
with open(options['filename'], 'rb') as f:
reader = csv.reader(f)
for row in reader:
slug = row[1]
city_id = row[0]
print "Trying to update project {}...".format(slug)
try:
project = Project.objects.get(slug=slug)
try:
city = City.objects.get(id=city_id)
if project.address:
project.address.city = city
project.address.save()
else:
address = Address(city=city)
address.save()
project.address = address
project.save()
project = Project.objects.get(slug=slug)
print "Updated to {}".format(project.address)
except:
print "City with id {} not found. Skipping project {}...".format(city_id, slug)
except:
print "Project with slug {} not found. Skipping...".format(slug)
print "\n"
time.sleep(1) # Avoid QUERY_LIMIT from google maps api
def create_company(self, name="Atados"):
address = Address()
return Company.objects.create(name=name, address=address)
def save_project(request, format=None):
# Need a nonprofit user
try:
request.user.nonprofit
except Exception as e:
if not request.user.is_staff:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
return Response({"User not authenticated. " + error}, status.HTTP_403_FORBIDDEN)
try:
obj = json.loads(request.DATA["project"])
except:
obj = request.DATA["project"]
project = Project.objects.get(id=obj["id"])
try:
if obj["name"] != project.name:
slug = create_project_slug(obj["name"])
else:
slug = project.slug
project.name = obj["name"]
# Renaming the image file if the slug has changed
if slug != project.slug and project.image.name:
try:
c = boto.connect_s3()
bucket = c.get_bucket("atadosapp")
k = bucket.get_key(project.image.name)
if k:
name = "project/%s/%s.jpg" % (project.nonprofit.user.slug, obj["slug"])
if name != project.image.name:
k.copy("atadosapp", name)
k.delete()
project.image.name = name
else:
return Response(
{"detail": "Could not get boto key to change project image name on S3."},
status.HTTP_400_BAD_REQUEST,
)
except Exception as e:
print e
pass
project.slug = slug
project.details = obj["details"]
project.description = obj["description"]
project.facebook_event = obj.get("facebook_event", None)
project.responsible = obj["responsible"]
project.phone = obj["phone"]
project.email = obj["email"]
obja = obj.get("address", None)
if obja:
if project.address:
address = project.address
else:
address = Address()
address.addressline = obja.get("addressline", "")
address.addressline2 = obja.get("addressline2", "")
address.addressnumber = obja.get("addressnumber", "")
address.neighborhood = obja.get("neighborhood", "")
address.zipcode = obja.get("zipcode", "")
address.city = City.objects.get(id=obja.get("city", None))
address.save()
project.address = address
roles = obj.get("roles", [])
# Remove the roles that were deleted
for pr in project.roles.all():
found = False
for r in roles:
if r.get("id", None) == pr.id:
found = True
if not found:
project.roles.remove(pr)
for r in roles:
found = False
for pr in project.roles.all():
if r.get("id", None) == pr.id:
found = True
if found:
role = Role.objects.get(id=r["id"])
else:
role = Role()
role.name = r.get("name", "")
role.prerequisites = r.get("prerequisites", "")
role.details = r.get("details", "")
role.vacancies = r.get("vacancies", 1)
role.save()
project.roles.add(role)
# Removing all skills then adding new ones
skills = obj.get("skills", [])
for s in project.skills.all():
project.skills.remove(s)
for s in skills:
project.skills.add(Skill.objects.get(id=s))
# Removing all causes then adding new ones
causes = obj.get("causes", None)
for c in project.causes.all():
project.causes.remove(c)
for c in causes:
project.causes.add(Cause.objects.get(id=c))
if obj.get("work", None):
try:
work = project.work
except:
work = Work()
work.project = project
work.weekly_hours = obj["work"].get("weekly_hours", 0)
work.can_be_done_remotely = obj["work"].get("can_be_done_remotely", None)
work.save()
if obj["work"].get("availabilities", None):
for a in project.work.availabilities.all():
project.work.availabilities.remove(a)
availabilities = obj["work"]["availabilities"]
for a in availabilities:
availability = Availability()
availability.weekday = a["weekday"]
availability.period = a["period"]
availability.save()
work.availabilities.add(availability)
else:
project.work.availabilities = []
work.save()
try:
project.job.delete()
project.job = None
except:
pass
elif obj.get("job", None):
try:
job = project.job
except:
job = Job()
job.project = project
job.start_date = datetime.utcfromtimestamp(obj["job"]["start_date"] / 1000).replace(
tzinfo=pytz.timezone("Etc/GMT")
)
job.end_date = datetime.utcfromtimestamp(obj["job"]["end_date"] / 1000).replace(
tzinfo=pytz.timezone("Etc/GMT")
)
job.save()
try:
project.work.delete()
project.work = None
except:
pass
except Exception as e:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
return Response({"detail": error}, status.HTTP_400_BAD_REQUEST)
project.save()
return Response(ProjectSerializer(project).data, status.HTTP_201_CREATED)
def create_project(request, format=None):
nonprofit = None
# Need a nonprofit user
try:
nonprofit = request.user.nonprofit
except Exception as e:
if not request.user.is_staff:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
return Response({"User not authenticated. " + error}, status.HTTP_403_FORBIDDEN)
try:
obj = json.loads(request.DATA["project"])
except:
obj = request.DATA["project"]
project = Project()
try:
# Getting required field
if nonprofit:
project.nonprofit = nonprofit
else:
project.nonprofit = Nonprofit.objects.get(id=obj["nonprofit"])
project.name = obj["name"]
project.slug = create_project_slug(project.name)
project.details = obj["details"]
project.description = obj["description"]
project.responsible = obj["responsible"]
project.phone = obj["phone"]
project.email = obj["email"]
project.save()
skills = obj["skills"]
for s in skills:
project.skills.add(Skill.objects.get(id=s))
causes = obj["causes"]
for c in causes:
project.causes.add(Cause.objects.get(id=c))
if obj.get("work", None):
work = Work()
work.project = project
work.weekly_hours = obj["work"].get("weekly_hours", 0)
work.can_be_done_remotely = obj["work"].get("can_be_done_remotely", False)
work.save()
availabilities = obj["work"].get("availabilities", None)
if availabilities:
for a in availabilities:
availability = Availability()
availability.weekday = a["weekday"]
availability.period = a["period"]
availability.save()
work.availabilities.add(availability)
work.save()
elif obj.get("job", None):
job = Job()
job.project = project
job.start_date = datetime.utcfromtimestamp(obj["job"]["start_date"] / 1000).replace(
tzinfo=pytz.timezone("America/Sao_Paulo")
)
job.end_date = datetime.utcfromtimestamp(obj["job"]["end_date"] / 1000).replace(
tzinfo=pytz.timezone("America/Sao_Paulo")
)
job.save()
has_work = False
has_job = False
try:
project.work
has_work = True
except:
pass
try:
project.job
has_job = True
except:
pass
if not has_job and not has_work:
return Response({"detail": "Needs to have project or work."}, status.HTTP_400_BAD_REQUEST)
# Doing not required fields
try:
obja = obj.get("address", None)
if obja:
address = Address()
address.addressline = obja.get("addressline", None)
address.addressline2 = obja.get("addressline2", None)
address.addressnumber = obja.get("addressnumber", None)
address.neighborhood = obja.get("neighborhood", None)
address.zipcode = obja.get("zipcode", None)
if obja.get("city", None) and obja["city"].get("id", None):
address.city = City.objects.get(id=obja["city"]["id"])
address.save()
project.address = address
project.save()
project.facebook_event = obj.get("facebook_event", None)
project.image = request.FILES.get("image")
project.image_small = request.FILES.get("image")
project.image_medium = request.FILES.get("image")
project.image_large = request.FILES.get("image")
roles = obj.get("roles", None)
if roles:
for r in roles:
role = Role()
role.name = r["name"]
role.prerequisites = r["prerequisites"]
role.details = r["details"]
role.vacancies = r["vacancies"]
role.save()
project.roles.add(role)
except Exception as e:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
print error
except Exception as e:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
return Response({"detail": error}, status.HTTP_400_BAD_REQUEST)
project.save()
return Response({"detail": "Project succesfully created.", "slug": project.slug}, status.HTTP_201_CREATED)
def create_nonprofit(request, format=None):
obj = json.loads(request.DATA["nonprofit"])
email = obj["user"]["email"]
obja = obj["address"]
address = Address()
address.zipcode = obja["zipcode"][0:9]
address.addressline = obja["addressline"]
address.addressline2 = obja.get("addressline2")
address.addressnumber = obja["addressnumber"][0:9]
address.neighborhood = obja["neighborhood"]
address.city = City.objects.get(id=obja["city"]["id"])
address.save()
try:
user = User.objects.get(email=email)
except User.DoesNotExist:
password = obj["user"]["password"]
user = User.objects.create_user(email, password, slug=obj["user"]["slug"])
user.name = obj["user"]["name"]
user.hidden_address = obj["hidden_address"]
user.phone = obj["phone"]
user.address = address
user.save()
if Nonprofit.objects.filter(user=user):
return Response({"detail": "Nonprofit already exists."}, status.HTTP_404_NOT_FOUND)
FACEBOOK_KEY = "facebook_page"
GOOGLE_KEY = "google_page"
TWITTER_KEY = "twitter_handle"
nonprofit = Nonprofit(user=user)
nonprofit.name = obj["name"]
nonprofit.details = obj["details"]
nonprofit.description = obj["description"]
nonprofit.save()
causes = obj["causes"]
for c in causes:
nonprofit.causes.add(Cause.objects.get(name=c["name"]))
if FACEBOOK_KEY in obj:
nonprofit.facebook_page = obj[FACEBOOK_KEY]
if GOOGLE_KEY in obj:
nonprofit.google_page = obj[GOOGLE_KEY]
if TWITTER_KEY in obj:
nonprofit.twitter_handle = obj[TWITTER_KEY]
nonprofit.image = request.FILES.get("image")
nonprofit.image_small = request.FILES.get("image")
nonprofit.image_medium = request.FILES.get("image")
nonprofit.image_large = request.FILES.get("image")
nonprofit.cover = request.FILES.get("cover")
nonprofit.save()
# Sending welcome email on nonprofit signup
plaintext = get_template("email/nonprofitSignup.txt")
htmly = get_template("email/nonprofitSignup.html")
d = Context()
subject, from_email, to = "Cadastro no Atados enviado com sucesso!", "*****@*****.**", nonprofit.user.email
text_content = plaintext.render(d)
html_content = htmly.render(d)
msg = EmailMultiAlternatives(subject, text_content, from_email, [to])
msg.attach_alternative(html_content, "text/html")
msg.send()
return Response({"detail": "Nonprofit succesfully created."}, status.HTTP_200_OK)
def save_project(request, format=None):
# Need a nonprofit user
try:
request.user.nonprofit
except Exception as e:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
return Response({"User not authenticated. " + error}, status.HTTP_403_FORBIDDEN)
try:
obj = json.loads(request.DATA['project'])
except:
obj = request.DATA['project']
project = Project.objects.get(id=obj['id'])
try:
if obj['name'] != project.name:
slug = create_project_slug(obj['name'])
else:
slug = project.slug
project.name = obj['name']
# Renaming the image file if the slug has changed
if slug != project.slug and project.image.name:
try:
c = boto.connect_s3()
bucket = c.get_bucket('atadosapp')
k = bucket.get_key(project.image.name)
if k:
name = "project/%s/%s.jpg" % (project.nonprofit.user.slug, obj['slug'])
if name != project.image.name:
k.copy('atadosapp', name)
k.delete()
project.image.name = name;
else:
return Response({'detail': 'Could not get boto key to change project image name on S3.'}, status.HTTP_400_BAD_REQUEST)
except Exception as e:
print e
pass
project.slug = slug
project.details = obj['details']
project.description = obj['description']
project.facebook_event = obj.get('facebook_event', None)
project.responsible = obj['responsible']
project.phone = obj['phone']
project.email = obj['email']
obja = obj.get('address', None)
if obja:
if project.address:
address = project.address
else:
address = Address()
address.addressline = obja.get('addressline', '')
address.addressline2 = obja.get('addressline2', '')
address.addressnumber = obja.get('addressnumber', '')
address.neighborhood = obja.get('neighborhood', '')
address.zipcode = obja.get('zipcode', '')
address.city = City.objects.get(id=obja.get('city', None))
address.save()
roles = obj.get('roles', [])
# Remove the roles that were deleted
for pr in project.roles.all():
found = False
for r in roles:
if r.get('id', None) == pr.id:
found = True
if not found:
project.roles.remove(pr)
for r in roles:
found = False
for pr in project.roles.all():
if r.get('id', None) == pr.id:
found = True
if found:
role = Role.objects.get(id=r['id'])
else:
role = Role()
role.name = r.get('name', '')
role.prerequisites = r.get('prerequisites', '')
role.details = r.get('details', '')
role.vacancies = r.get('vacancies', 1)
role.save()
project.roles.add(role)
# Removing all skills then adding new ones
skills = obj.get('skills', [])
for s in project.skills.all():
project.skills.remove(s)
for s in skills:
project.skills.add(Skill.objects.get(id=s))
# Removing all causes then adding new ones
causes = obj.get('causes', None)
for c in project.causes.all():
project.causes.remove(c)
for c in causes:
project.causes.add(Cause.objects.get(id=c))
if obj.get('work', None):
try:
work = project.work
except:
work = Work()
work.project = project
work.weekly_hours = obj['work'].get('weekly_hours', 0)
work.can_be_done_remotely = obj['work'].get('can_be_done_remotely', None)
work.save()
if obj['work'].get('availabilities', None):
for a in project.work.availabilities.all():
project.work.availabilities.remove(a)
availabilities = obj['work']['availabilities']
for a in availabilities:
availability = Availability()
availability.weekday = a['weekday']
availability.period = a['period']
availability.save()
work.availabilities.add(availability)
else:
project.work.availabilities = []
work.save()
try:
project.job.delete()
project.job = None
except:
pass
elif obj.get('job', None):
try:
job = project.job
except:
job = Job()
job.project = project
job.start_date = datetime.utcfromtimestamp(obj['job']['start_date']/1000).replace(tzinfo=pytz.timezone("America/Sao_Paulo"))
job.end_date = datetime.utcfromtimestamp(obj['job']['end_date']/1000).replace(tzinfo=pytz.timezone("America/Sao_Paulo"))
job.save()
try:
project.work.delete()
project.work = None
except:
pass
project.save()
except Exception as e:
error = "ERROR - %d - %s" % (sys.exc_traceback.tb_lineno, e)
return Response({'detail': error}, status.HTTP_400_BAD_REQUEST)
return Response(ProjectSerializer(project).data, status.HTTP_201_CREATED)
def create_nonprofit(request, format=None):
obj = json.loads(request.DATA['nonprofit'])
email = obj['user']['email']
obja = obj['address']
address = Address()
address.zipcode = obja['zipcode'][0:9]
address.addressline = obja['addressline']
address.addressline2 = obja.get('addressline2')
address.addressnumber = obja['addressnumber'][0:9]
address.neighborhood = obja['neighborhood']
address.city = City.objects.get(id=obja['city']['id'])
address.save()
try:
user = User.objects.get(email=email)
except User.DoesNotExist:
password = obj['user']['password']
user = User.objects.create_user(email, password, slug=obj['user']['slug'])
user.name = obj['user']['name']
user.hidden_address = obj['hidden_address']
user.phone = obj['phone']
user.address = address
user.save()
if Nonprofit.objects.filter(user=user):
return Response({'detail': 'Nonprofit already exists.'}, status.HTTP_404_NOT_FOUND)
FACEBOOK_KEY = 'facebook_page'
GOOGLE_KEY = 'google_page'
TWITTER_KEY = 'twitter_handle'
nonprofit = Nonprofit(user=user)
nonprofit.name = obj['name']
nonprofit.details = obj['details']
nonprofit.description = obj['description']
nonprofit.save()
causes = obj['causes']
for c in causes:
nonprofit.causes.add(Cause.objects.get(name=c['name']))
if FACEBOOK_KEY in obj:
nonprofit.facebook_page = obj[FACEBOOK_KEY]
if GOOGLE_KEY in obj:
nonprofit.google_page = obj[GOOGLE_KEY]
if TWITTER_KEY in obj:
nonprofit.twitter_handle = obj[TWITTER_KEY]
nonprofit.image = request.FILES.get('image')
nonprofit.cover = request.FILES.get('cover')
nonprofit.save()
# Sending welcome email on nonprofit signup
plaintext = get_template('email/nonprofitSignup.txt')
htmly = get_template('email/nonprofitSignup.html')
d = Context()
subject, from_email, to = 'Cadastro no Atados enviado com sucesso!', '*****@*****.**', nonprofit.user.email
text_content = plaintext.render(d)
html_content = htmly.render(d)
msg = EmailMultiAlternatives(subject, text_content, from_email, [to])
msg.attach_alternative(html_content, "text/html")
msg.send()
return Response({'detail': 'Nonprofit succesfully created.'}, status.HTTP_200_OK)
