def generate_records(count=20): names = generate_names_list(20) for i in xrange(count): item = Catalog() item.name = names[i] item.country = get_country() item.date = get_date() item.save()
def handle(self, *args, **options): logger.info("Clear catalog table.....") Catalog.objects.all().delete() logger.info("Start loading.....") import urllib2 doc = urllib2.urlopen(IMPORT_CATALOG_URL) dom = minidom.parse(doc) items=dom.getElementsByTagName('genre') for i in items: c = Catalog() c.original_id = i.getAttribute('id') c.name = i.getAttribute('title_ru') c.lft = i.getAttribute('lft') c.rght = i.getAttribute('rght') c.tree_id = i.getAttribute('tree_id') c.level = i.getAttribute('level') c.save() print i.getAttribute('id') logger.info("adding...%s" % c.name_slug) logger.info("Done")
#!/usr/bin/python # -*- coding: utf-8 -*- import csv, sys, os project_dir = '/home/vova/MyProject_Django/Django_project/mysite/mysite' sys.path.append(project_dir) os.environ['DJANGO_SETTINGS_MODULE'] = 'settings' import django django.setup() from catalog.models import Catalog data = csv.reader( open('/home/vova/MyProject_Django/Django_project/mysite/data.csv'), delimiter=",") for row in data: if row[0] != 'Наименование': print(row[0]) post = Catalog() post.name = row[0] post.place = row[1] post.price = row[2] post.save()