How to use a file to load data into database in Django

Question

Hi I am new learner of Django and would like to figure out how to load some data into the database using a file(.py).

There are three tables in the database.

class region(models.Model):
    region_name = models.CharField(primary_key=True,max_length=50, null=False)


class country(models.Model):
    country_name = models.CharField(primary_key=True,max_length=40, null=False)
    region = models.ForeignKey(region)

class office(models.Model):
    office_name = models.CharField(primary_key=True,max_length=50, null=False)
    address = models.CharField(max_length=200, null=False)
    postal_code = models.IntegerField(null = False)
    country = models.ForeignKey(country)

Initially I use the python shell of enter some simple data into the db using

>>> r = region(region_name='asia')
>>> r.save()

Can anyone help to create such a file to load data of region, country, office into the database? as there are sets of region,country,office that really need to be there.

Thank you very much for helping out!

Which database are you using? Generally the bulk loading tools that come with the database are a better way to load data in than writing your own. — hd1
– hd1, Commented May 29, 2013 at 3:58

Sudip Kafle · Accepted Answer · 2013-05-29 07:03:27Z

1

You can provide initial data to your models by using fixtures. For that, you can store all data in a file named initial_data.xml (or yaml/json] file in the fixtures directory of your app. You can see the django reference for details

answered May 29, 2013 at 7:03

Sudip Kafle

4,4115 gold badges38 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use a file to load data into database in Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related