Django won't import values to database - sqlite3

Question

I am trying to put values to my django database.

My app_name/models.py looks like:

from django.db import models

# Create your models here.

class Language(models.Model):
    id = models.AutoField(primary_key=True)
    code = models.TextField(max_length=14)

I ran this commands:

python3 manage.py makemigrations app_name
python3 manage.py migrate app_name

After that I starting importing values to my database. So I run this command:

python3 manage.py shell

and put this code to the shell:

from app_name.models import *

with open('lang.txt', 'r') as file:
    for i in file:
        a = Language.objects.create(code=i.strip())

File lang.txt contains 309 lines with language codes. The file looks like:

en
fr
af
de
...

When I run this code in the manage.py shell Django created 309 Language objects. But when I try type random id in the shell -> Language(id=1).code it return only empty string - ''.

I tried use save() method too but still same problem.

from definitions.models import *

with open('lang.txt', 'r') as file:
    for i in file:
        a = Language(code=i.strip())
        a.save()

Django version 1.10.1

So my question is where can be a problem?

Do you get an empty string using Language.objects.get(id=1), too? — nik_m
– nik_m, Commented Jul 31, 2017 at 19:24
No, I see text what I excpected. Why get() method shows right string and Language(id=1).code shows empty string? Thanks — kolurbo
– kolurbo, Commented Jul 31, 2017 at 19:29
That's the way Django interacts with the db. Using the objects.get method. I think its time for reading ;) — nik_m
– nik_m, Commented Jul 31, 2017 at 19:32

v1k45 · Accepted Answer · 2017-07-31 19:33:32Z

2

This is happening because you are not fetching Language objects properly.

When you do Language(id=1).code, You are instantiating Language object with no value in given to code field.

In django, to fetch a object, you do Model.objects.get(field=value). So your code becomes:

Language.objects.get(id=1).code

answered Jul 31, 2017 at 19:33

v1k45

8,2502 gold badges33 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Django won't import values to database - sqlite3

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