I am also facing the same problem i am using PostgreSQL data base . please do share this issue bug
*Thanks and Kind Regards* ==================== <https://about.me/sachin.thakur?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb> *Sachin Thakur* about.me/sachin.thakur <https://about.me/sachin.thakur?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api&utm_content=thumb> *PG Student* Dept. of Computer Applications, *Christ ( Deemed to Be university) Main Campus Bangalore, India* *UG (DSCASC under Bangalore University )* Bangalore, India. Mob: *+91 8792560572* *E-mail : sachin.thakur9...@gmail.com <sachin.thakur9...@gmail.com>* *E-mail : sachin.tha...@mca.christuniversity.in <sachin.thakur9...@gmail.com>* On Sat, Jun 29, 2019 at 3:38 AM Joe Reitman <jreitma...@gmail.com> wrote: > The notes say: > > - The exact output will vary depending on the database you are using. > The example above is generated for* PostgreSQL.* > > Are you using the default SQLite? > > You could try running migrate and then checking the tables to see if the > constraint was added using a DB admin viewer. > > For SQLite I use - https://sqlitebrowser.org/ > For Postgres - https://www.pgadmin.org/ > > > > On Tuesday, May 28, 2019 at 7:44:44 PM UTC-5, K Tan wrote: >> >> Hi, everyone, >> >> This is my first time using Django and I think I'm missing something or >> there is a bug. I am following the instructions on ( >> https://docs.djangoproject.com/en/2.2/intro/tutorial02/) and I've just >> added the following chunk of code to "polls/models.py". (I copied/pasted so >> I know it's correct.) >> >> <quote> >> from django.db import models >> >> >> class Question(models.Model): >> question_text = models.CharField(max_length=200) >> pub_date = models.DateTimeField('date published') >> >> >> class Choice(models.Model): >> question = models.ForeignKey(Question, on_delete=models.CASCADE) >> choice_text = models.CharField(max_length=200) >> votes = models.IntegerField(default=0) >> </quote> >> >> >> Then I ran the following command: >> >> <quote> >> LITTLEBLACK:www samktan$ python3 manage.py makemigrations polls >> Migrations for 'polls': >> polls/migrations/0001_initial.py >> - Create model Question >> - Create model Choice >> </quote> >> >> Which is missing one line compared to the tutorial: >> >> - Add field question to choice >> >> >> >> Now when I run this command: >> >> <quote> >> LITTLEBLACK:www samktan$ python3 manage.py sqlmigrate polls 0001 >> BEGIN; >> -- >> -- Create model Question >> -- >> CREATE TABLE `polls_question` (`id` integer AUTO_INCREMENT NOT NULL >> PRIMARY KEY, `question_text` varchar(200) NOT NULL, `pub_date` datetime(6) >> NOT NULL); >> -- >> -- Create model Choice >> -- >> CREATE TABLE `polls_choice` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY >> KEY, `choice_text` varchar(200) NOT NULL, `votes` integer NOT NULL, >> `question_id` integer NOT NULL); >> ALTER TABLE `polls_choice` ADD CONSTRAINT >> `polls_choice_question_id_c5b4b260_fk_polls_question_id` FOREIGN KEY >> (`question_id`) REFERENCES `polls_question` (`id`); >> COMMIT; >> </quote> >> >> It is missing the "on delete cascade" clause, which I suspect it caused >> by the missing line above. >> >> I have confirmed in MySQL that the "on delete cascade" clause is >> definitely missing. >> >> <quote> >> mysql> show create table `polls_choice`; >> >> +--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> | Table | Create Table >> >> >> >> >> >> | >> >> +--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> | polls_choice | CREATE TABLE `polls_choice` ( >> `id` int(11) NOT NULL AUTO_INCREMENT, >> `choice_text` varchar(200) COLLATE utf8mb4_general_ci NOT NULL, >> `votes` int(11) NOT NULL, >> `question_id` int(11) NOT NULL, >> PRIMARY KEY (`id`), >> KEY `polls_choice_question_id_c5b4b260_fk_polls_question_id` >> (`question_id`), >> CONSTRAINT `polls_choice_question_id_c5b4b260_fk_polls_question_id` >> FOREIGN KEY (`question_id`) REFERENCES `polls_question` (`id`) >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci | >> >> +--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ >> 1 row in set (0.00 sec) >> </quote> >> >> Can someone tell me what I'm doing wrong? >> >> >> -- >> >> / per ardua ad astra / >> >> -- > 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/362bb406-8d44-4285-8ac5-7ae3af832d7a%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/362bb406-8d44-4285-8ac5-7ae3af832d7a%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CA%2BLmcYssrmxNYhK%3D7pcP36XSR23T4y4XosvdBv-3WFbRxYufMA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
