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