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):
bool_val = {
'True': True,
'False': False,
}
with open('phones.csv', 'r') as csvfile:
phone_reader = csv.reader(csvfile, delimiter=';')
# пропускаем заголовок
next(phone_reader)
for phone in phone_reader:
# TODO: Добавьте сохранение модели
ph = Phone(
int(phone[0]),
phone[1],
phone[2],
int(phone[3]),
datetime.date(int(phone[4][:4]), int(phone[4][5:7]),
int(phone[4][8:])),
bool_val[phone[5]],
)
# ph.save()
ph.slug = ph.get_slug()
ph.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 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:
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 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)
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.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 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:
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 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):
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 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(settings.PHONES, 'r') as csvfile:
phone_reader = csv.reader(csvfile, delimiter=';')
# пропускаем заголовок
next(phone_reader)
# TODO: Добавьте сохранение модели
for line in phone_reader:
new_phone = Phone(name=line[1],
price=int(line[3]),
image=line[2],
release_date=line[4],
lte_exists=line[5],
slug='')
new_phone.get_slug()
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(name=line[1],
price=int(line[3]),
image=line[2],
release_date=date.fromisoformat(line[4]),
lte_exists=line[5],
slug=slugify(line[1]))
p.clean_fields()
p.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 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()
