def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for phone in phone_reader: del(phone[None]) phone = Phone(**phone, slug=slugify(phone['name'])) phone.save()
def handle(self, *args, **options): with open('phones.csv') as f: phones = csv.DictReader(f, delimiter=';') for phone in phones: phone.pop(None) phone['release_date'] = str_to_date(phone['release_date']) slugged_name = phone['name'].replace(' ', '-') p = Phone(slug=slugged_name, **phone) p.save()
def handle(self, *args, **options): with open('phones.csv', 'r', newline='') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for line in phone_reader: line.pop(None) new_phone = Phone(**line) new_phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: p = Phone(*line) p.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: phone = Phone(id=line[0], name=line[1], price=line[3], image=line[2], release_date=line[4], lte_exists=line[5], slug=slugify(line[1])) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: date_object = datetime.strptime(line[4], '%Y-%m-%d') phone = Phone(id=int(line[0]), name=line[1], image=line[2], price=int(line[3]), release_date=date_object, lte_exists=line[5], slug=translit.slugify(line[1])) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for line in phone_reader: phone = Phone(ID=line["id"], name=line["name"], image=line["image"], price=line["price"], release=line["release_date"], lte_exists=line["lte_exists"], slug=line["name"].replace(" ", "_").lower()) phone.save()
def handle(self, *args, **options): with open(FILE_PATH) as f: phone_reader = csv.reader(f, delimiter=';') next(phone_reader) for line in phone_reader: phone_db = Phone(id=line[0], name=line[1], image=line[2], price=line[3], release_date=line[4], lte_exists=line[5], slug=slugify(line[1], allow_unicode=True)) phone_db.save()
def handle(self, *args, **options): with open('phones.csv', newline='', encoding='utf-8') as csvfile: reader = csv.reader(csvfile, delimiter=';', quotechar=' ') for row in reader: if row[0] != 'id': phone = Phone() phone.id = row[0] phone.name = row[1] phone.image = row[2] phone.price = row[3] phone.release_date = row[4] phone.lte_exists = row[5] phone.save()
def handle(self, *args, **options): with open('phones.csv', newline='') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=";") for line in phone_reader: p = Phone(id=line.get('id'), name=line.get('name'), image=line.get('image'), price=line.get('price'), release_date=datetime.strptime( line.get('release_date'), "%Y-%m-%d").date(), slug=line.get('name').replace(' ', '_')) p.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') next(phone_reader) for line in phone_reader: phone = Phone(id=line[0], name=line[1], image=line[2], price=line[3], release_date=line[4], lte_exists=line[5], slug=line[1].replace(' ', '-').lower()) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: # TODO: Добавьте сохранение модели phone = Phone(id=line[0], name=line[1], image=line[2], price=line[3], release_date=line[4], lte_exists=line[5], slug=line[1].strip().replace(' ', '-')) phone.save() pass
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for line in phone_reader: slug = line['name'].lower().replace(' ', '_') line['slug'] = slug model = Phone(id=line['id'], name=line['name'], image=line['image'], price=line['price'], release_date=line['release_date'], lte_exists=line['lte_exists'], slug=line['slug']) model.save()
def handle(self, *args, **options): with open('E:/disk.evropa04/PY/PycharmProjects/Netology_homeworks/dj-homeworks/databases/work_with_database/phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') next(phone_reader) for line in phone_reader: item = Phone(id = line[0], name = line[1], slug = line[1].replace(' ', '-'), image = line[2], price = line[3], release_date = line[4], lte_exists = line[5]) item.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') next(phone_reader) for line in phone_reader: # TODO: Добавьте сохранение модели phone = Phone() phone.name = line[1] phone.image = line[2] phone.price = line[3] phone.release_date = line[4] phone.lte_exists = line[5] phone.slug = slugify(line[1]) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: for line in csv.DictReader(csvfile, delimiter=';'): try: line['price'] = int(line['price']) line['release_date'] = date.fromisoformat( line['release_date']) line['lte_exists'] = line['lte_exists'] == 'True' except (ValueError, KeyError): continue if None in line: del (line[None]) phone = Phone(**dict(line)) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as isfile: phone_reader = csv.reader(isfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: result = Phone(name=line[1], image=line[2], price=line[3], release_date=line[4], lte_exists=line[5]) result.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: name = line[1] image = line[2] price = int(line[3]) date = line[4].replace('-', '') date = datetime.strptime(date, '%Y%m%d') lte = line[5] slug = slugify(name) phones = Phone(name=name, image=image, price=price, release_date=date, lte_exists=lte, slug=slug) phones.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: p = Phone(name=line[1], price=int(line[3]), image=line[2], release_date=line[4], lte_exists=line[5], slug=line[1].replace(" ", "-")) p.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for line in phone_reader: slug = slugify(line['name']) phone = Phone(name=line['name'], price=line['price'], image=line['image'], release_date=line['release_date'], lte_exists=line['lte_exists'], slug=slug) phone.save()
def handle(self, *args, **options): with open('phones.csv', newline='', encoding='utf-8') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for line in phone_reader: slugg = slugify(line['name'], allow_unicode=True) phone = Phone(id=line['id'], name=line['name'], image=line['image'], price=line['price'], release_date=line['release_date'], lte_exists=line['lte_exists'], slug=slugg) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') next(phone_reader) # skip header for line in phone_reader: date_object = datetime.strptime(line[DATE], '%Y-%m-%d') phone = Phone(id=int(line[ID]), name=line[NAME], image=line[IMAGE], price=int(line[PRICE]), release_date=date_object, lte_exists=line[LTE], slug=slugify(line[NAME])) phone.save()
def get_or_create_phones(phones): if not phones: return [] result = [] for code, number in phones: p = None try: p = Phone.objects.get(code=code, number=number) except: p = Phone(code=code, number=number) p.save() finally: result.append(p) return result
def handle(self, *args, **options): filename = options['file'] with open(filename, 'r') as csvfile: phone_reader = csv.DictReader(csvfile, delimiter=';') for line in phone_reader: phone = Phone() phone.id = line['id'] phone.name = line['name'] phone.price = line['price'] phone.image = line['image'] phone.release_date = datetime.strptime(line['release_date'], '%Y-%m-%d').date() phone.lte_exists = bool(line['lte_exists']) phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for phone_id, name, image, price, release_date, lte_exists, _ in phone_reader: # TODO: Добавьте сохранение модели p = Phone(id=phone_id, name=name, image=image, price=price, release_date=release_date, lte_exists=lte_exists, slug=slugify(name, allow_unicode=True)) p.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: phone = Phone() phone.id = line[0] phone.name = line[1] phone.image = line[2] phone.price = line[3] phone.release_date = line[4] phone.lte_exists = line[5] phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') phone_list = [] for i in list(phone_reader)[1:]: phone_list.append(i) for line in phone_list: new_phone = Phone(name = line[1], price = line[3], image = line[2], release_date = line[4], lte_exists = line[5], slug = slugify(line[1])) new_phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: # TODO: Добавьте сохранение модели phone = Phone() phone.id = line[0] phone.name = line[1] phone.image = line[2] phone.price = line[3] phone.release_date = datetime.strptime(line[4], '%Y-%m-%d').date() phone.lte_exists = line[5] phone.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: # TODO: Добавьте сохранение модели phone_db = Phone(id=line[0], name=line[1], image=line[2], price=line[3], release_date=line[4], lte_exists=line[5], slug=slugify(line[1], allow_unicode=True)) phone_db.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: # TODO: Добавьте сохранение модели result = Phone( # line[0] - пропускаем - порядковый номер записи name=line[1], image=line[2], price=line[3], release_date=line[4], lte_exists=line[5]) result.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csvfile: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: # TODO: Добавьте сохранение модели cur_phone = Phone() cur_phone.name = line[1] cur_phone.image = line[2] cur_phone.price = line[3] cur_phone.release_date = line[4] cur_phone.lte_exists = line[5] cur_phone.slug = slugify(cur_phone.name) cur_phone.save(cur_phone)