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):
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):
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):
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:
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()
