Adding data to created sqlite database in Django

Question

I have created two classes in models.py in my application.

models.py

 from django.db import models

 # Create your models here.
 class User(models.Model):
 first_name = models.CharField(max_length=264, unique=True)
 last_name = models.CharField(max_length=264, unique=True)
 email = models.CharField(max_length=264,unique=True)

 def __str__(self):
    return self.first_name

 class NewUser(models.Model):
 categorie = models.ForeignKey('User',on_delete=models.DO_NOTHING)
 area = models.CharField(max_length=264)

def __str__(self):
    return self.name

as shown in my image my (User and New users)tables are created. data is getting added to my (User) table. But when I try to add data to my (New users) table I get this error

Totally unrelated, but I kindly suggest you use django.contrib.auth for all user management stuff... — bruno desthuilliers
– bruno desthuilliers, Commented Dec 16, 2019 at 8:42

bmons · Accepted Answer · 2019-12-16 09:05:29Z

2

Since you don't have any custom fields in your User model, you dont need to create a seperate User class, only you have to import the built in User class.

from django.contrib.auth.models import User

class NewUser(models.Model):
   categorie = models.ForeignKey('User',on_delete=models.DO_NOTHING)
   area = models.CharField(max_length=264)

   def __str__(self):
      return self.categorie.user.username

You can still get username, first_name, last_name, email etc from the default user class. Refer: https://docs.djangoproject.com/en/3.0/ref/contrib/auth/#django.contrib.auth.models.User

answered Dec 16, 2019 at 9:05

bmons

3,4022 gold badges13 silver badges18 bronze badges

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

3 Comments

shaswat kumar Over a year ago

I think the name (NewUser) is misleading. I dont want to create a new user. I just want to create another table and add data to it. The name can be anything other than new user

bmons Over a year ago

naming you can change as you wish, it should be relevant to the project, so that in future you or any other developers can trace it.

supersaiyan Over a year ago

I have a "class User" in my models.py just like yours. When I tried to make migrations and migrate, there are no tables created. When I renamed it to "class Person" it created a bunch of tables along with the table "projectApp_person"

filiphl · Accepted Answer · 2019-12-16 09:08:38Z

1

Most likely you haven't migrated properly. Try:

python manage.py makemigrations
python manage.py migrate

The models show up in the admin because they are present in the apps models.py. This is not related to the database!

edited Dec 16, 2019 at 9:08

answered Dec 16, 2019 at 8:36

filiphl

9911 gold badge9 silver badges15 bronze badges

Collectives™ on Stack Overflow

Adding data to created sqlite database in Django

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related