def save(self): customers_csv = csv.reader(self.cleaned_data["file"]) Customer.objects.all().delete() for customer_csv in customers_csv: customer = Customer() customer.customer_id = customer_csv[0] customer.name = customer_csv[1] customer.adress = customer_csv[2] customer.phone_number = customer_csv[3] customer.contact = customer_csv[4] customer.save()
def cliente(): with open('/maladireta/database/clientes.csv') as csv_file: csv_reader = csv.reader(csv_file, delimiter=',') line_count = 0 for row in csv_reader: if line_count == 0: print(f'{", ".join(row)}') line_count += 1 elif line_count == 1: customer = Customer() customer.name = row[0] if row[1]: customer.birth = to_datetime_inverted(row[1].split(' ')[0]) customer.nickname = row[2] customer.reference = row[3] customer.state = row[4] customer.cep = row[5] customer.old_id = row[10] customer.note = row[11] customer.cpf = row[12] customer.rg = row[13] customer.phone_home = row[14] customer.phone_number = row[15] customer.cellphone = row[16] customer.complement = row[17] customer.street = row[18] customer.leadership = row[20] customer.location_reference = row[21] customer.number = row[26] customer.email = row[27] customer.profession = row[28] customer.neighborhood = row[29] customer.city = row[30] customer.recurrence = row[32] customer.subscription = row[38] customer.zone = row[39] customer.section = row[40] customer.save() else: break
def form_valid(self, form): try: customer = Customer.objects.get( phone_number=form.data['phone_number']) except Customer.DoesNotExist: customer = Customer() customer.first_name = form.data['first_name'] customer.last_name = form.data['last_name'] customer.phone_number = form.data['phone_number'] customer.save() cleaner = Cleaner.objects.filter(cities=form.data['city'])\ .exclude(booking__date=form.data['date'])\ .first() booking = Booking.objects.create(customer=customer, cleaner=cleaner, date=form.data['date']) template = render_to_string('booking/email_notification.txt', {'booking': booking}) send_mail('New booking', template, settings.DEFAULT_FROM_EMAIL, [cleaner.email]) return super(BookingCreateView, self).form_valid(form)