Hi Rich, 419 is not that many. I'd probably do that via a Python shell. import models.Cities for item in lists_of_lists_of_419 temp = Cities(city+name=item[0], county_name=item[1]) temp.save()
John Thomas 310-947-8572 On Thu, Jun 29, 2017 at 11:16 AM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > Reading > <https://docs.djangoproject.com/en/1.11/ref/migration-operat > ions/#django.db.migrations.operations.RunSQL> > tells me that runSQL allows arbitrary SQL to run on the database ... except > for the postgres backend: "On most database backends (all but PostgreSQL), > Django will split the SQL into individual statements prior to executing > them." > > I want to insert data into the two columns of the database. The model > reads: > > class Cities (models.Model): > city_name=models.CharField(max_length=24, unique=True) > county_name=models.CharField(max_length=12, unique=True) > > and I have a list of 419 pairs of names I want to pre-load into this > database table. The rows contain the two variables; e.g., > Bend,Deschutes > Birkenfeld,Columbia > Blachly,Lane > Black Butte Ranch,Deschutes > > So, using a postgres back end can I write, > > migrations.RunSQL("INSERT INTO Cities (city_name,county_name) VALUES > ('Bend','Dechutes');") > > repeated for each row in the table (easy to do with emacs)? And, can I put > this code in models.py after the classes? > > Rich > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAJ22gMA%3Dir3HGr3_7fjcWi9jxQ%2BaY8Rciies43MfD29D%3DxgVNA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
