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', '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: phone_reader = csv.reader(csvfile, delimiter=';') # пропускаем заголовок next(phone_reader) for line in phone_reader: 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.save()
def handle(self, *args, **options): with open('phones.csv', 'r') as csv_file: phone_reader = csv.reader(csv_file, delimiter=';') # skip caption next(phone_reader) for line in phone_reader: # Add info to model Phone row = Phone() row.name = line[1] row.image = line[2] row.price = line[3] row.release_date = line[4] row.lte_exists = line[5] row.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): 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.DictReader(csvfile, delimiter=';') for line in phone_reader: phone = Phone() phone.id = line['id'] phone.name = line['name'] phone.image = line['image'] phone.price = line['price'] phone.release_date = line['release_date'] print(f'PRICE IS {phone.release_date}') print(f'LTE IS {line["lte_exists"]}, {type(line["lte_exists"])}') phone.lte_exists = line['lte_exists'] phone.slug = slugify(phone.name) 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: device = Phone() device.id_device = int(line[0]) device.name = line[1] device.image = line[2] device.price = int(line[3]) device.release_date = datetime.fromisoformat(line[4]) device.lte_exists = line[5] device.slug = slugify(device.name, allow_unicode=True) device.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)
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: unit = Phone() unit.uid = line[0] unit.name = line[1] unit.image = line[2] unit.price = line[3] unit.release_date = datetime.date( datetime.strptime(line[4], "%Y-%m-%d")) unit.lte_exists = line[5] unit.slug = slugify(unit.name) unit.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: Добавьте сохранение модели print(line) p = Phone() p.name=line[1] p.image=line[2] p.price=line[3] p.release_date=line[4] p.lte_exists=line[5] p.save() pass
def handle(self, *args, **options): file = open('phones.csv', 'r') for index, line in enumerate(file): if index == 0: continue line = line.split(';') 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() file.close()
def handle(self, *args, **options): Phone.objects.all().delete() with open('phones.csv') as f: phones = csv.DictReader(f, delimiter=';') for row in phones: phone = Phone() phone.id = row['id'] phone.name = row['name'] phone.image = row['image'] phone.lte_exists = row['lte_exists'] phone.price = re.sub('[^0-9]', '', row['price']) phone.release_date = datetime.strptime(row['release_date'], '%Y-%m-%d') phone.slug = slugify(row['name']) phone.save() if Phone.objects.all(): print('Импорт прошел успешно') else: print('Что-то пошло не так')
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: mobile = Phone() mobile.title = line[1] mobile.image = line[2] mobile.price = line[3] mobile.release_date = line[4] mobile.lte_exists = line[5] mobile.slug = mobile.sluggg() try: mobile.save() print(f'Телефон {mobile} в базу внесён') except: print( f'Что-то пошло не так. Телефон {mobile} не был внесён')
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_model = Phone() phone_model.name = line[1] phone_model.price = int(line[3]) phone_model.image = line[2] phone_model.release_date = datetime.strptime( line[4], '%Y-%m-%d').date() phone_model.lte_exists = bool(line[5]) slug_text = phone_model.name slug_text = slug_text.lower() slug_text = slug_text.replace(' ', '-') phone_model.slug = slug_text phone_model.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: phone = Phone() phone.id = int(line["id"]) print(line["id"]) phone.name = str(line["name"]) print(line["name"]) phone.image = str(line["image"]) print(line["image"]) phone.price = int(line["price"]) print(line["price"]) phone.release_date = line["release_date"] print(line["release_date"]) phone.lte_exists = line["lte_exists"] print(line["lte_exists"]) phone.slug = slugify(line["name"]) print(slugify(line["name"])) 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: Добавьте сохранение модели # pass reader = csv.DictReader(csvfile, delimiter=';') for row in reader: phone_data = Phone() phone_data.id = row['id'] phone_data.name = row['name'] phone_data.price = row['price'] phone_data.image = row['image'] phone_data.release_date = row['release_date'] phone_data.lte_exists = row['lte_exists'] phone_data.slug = slugify(phone_data.name) phone_data.save()
import csv import os import django # определяем настройки для импорта из джанго моделей для работы с ними os.environ.setdefault("DJANGO_SETTINGS_MODULE", "main.settings") django.setup() from phones.models import Phone 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()