models foreign key
jeffreyequizuvero
This is about the models foreign key,
I have two tables and i used foreign key to connect these tables however after i did migration it's not working. Is there any wrong with my code?
please help, Thanks.
class Author(models.Model):
Author_code = models.CharField(max_length=50,unique=True)
Author_Fname = models.CharField(max_length=30, blank=True, null=True)
Author_Mname = models.CharField(max_length=30, blank=True, null=True)
Author_Lname = models.CharField(max_length=30, blank=True, null=True)
class Meta:
# managed = False
db_table = 'Author'
class Book(models.Model):
Book_code = models.CharField(max_length=50, blank=True, default=user_code_key,unique=True)
Author_code = models.ForeignKey(Author, to_field=Author_code', on_delete=models.CASCADE)
Book_title = models.CharField(max_length=50, blank=True, null=True)
class Meta:
# managed = False
db_table = 'Book'
jorr...@gmail.com
I can see a few potential problems:
- You're missing a quotation mark around Author_code in the to_field parameter;
- The fields on both models have the same name, this might cause problems.
Jeffrey Uvero
Author_code = models.ForeignKey(Author, to_field='Author_code', on_delete=models.CASCADE)
--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django...@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/fb32e401-f1a6-4180-a49a-12c86b09bed5%40googlegroups.com.
--
Jeffrey E. Uvero
Amellar Solution
3rd Floor, LGI Building, Ortigas Avenue
Greenhills, San Juan City,
Philippines 1500
Tel: (+63) 9776824461
SkypeID: jeffrey.uvero
Email: jeffreyeq...@gmail.com / jeffe...@gmail.com
Melvyn Sopacua
On Friday 13 January 2017 07:42:17 Jeffrey Uvero wrote:
> *there's no problem appeared but when I go to my database, there's no
> connection with these two table.. there should be a connection between
> two same name column.(foreign key)*
> Correction with my code above.
How did you determine there's no connection? What database are using? If using MySQL do you have InnoDB storage engine enabled?
--
Melvyn Sopacua
Jeffrey Uvero
--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django...@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/3929969.KToH5YS5at%40devstation.
Melvyn Sopacua
On Monday 16 January 2017 07:55:28 Jeffrey Uvero wrote:
> *I am using oracle. *
>
> *actually I used the procedure before and it was successful, but now i
> used same procedure but it didn't work. *
Make sure that the tool you use to "see the connection between these tables" is not the problem.
Use:
python manage.py sqlmigrate <app_label> <migration_name>
to show the SQL created for that migration. If you see no foreign key being created in the SQL, then follow-up with the code of the migration file and the SQL shown by above command.
> On Sun, Jan 15, 2017 at 12:16 AM, Melvyn Sopacua
> wrote:
> > On Friday 13 January 2017 07:42:17 Jeffrey Uvero wrote:
> > > *there's no problem appeared but when I go to my database, there's
> > > no
> > >
> > > connection with these two table.. there should be a connection
> > > between
> > >
> > > two same name column.(foreign key)*
> > >
> > > Correction with my code above.
> >
> > How did you determine there's no connection? What database are
> > using? If using MySQL do you have InnoDB storage engine enabled?
> >
> > --
> >
> > Melvyn Sopacua
> >
> > --
> > 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...@googlegroups.com.
> > To post to this group, send email to django...@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/3929969.KToH5YS5at%40devstation
> > <https://groups.google.com/d/msgid/django-users/3929969.KToH5YS5at%4
> > 0devstation?utm_medium=email&utm_source=footer> .
Melvyn Sopacua
Michal Petrucha
>
>
> *This is about the models foreign key, I have two tables and i used foreign
I can see that you have a commented-out “managed = False” in the
definition of your models. Did you create and apply migrations before,
or after you commented the attribute out? If you ran your migrations
with managed = False, then it's expected that those tables are ignored
for migrations.
If that's not it, then I'm afraid you'll have to provide more details
than “it's not working” – what steps did you take exactly, what was
the output, what output did you expect, etc.
Good luck,
Michal
> *please help, Thanks. *
>
>
> class *Author*(models.Model):
> * Author_code = models.CharField(max_length=50,unique=True)*
> Author_Mname = models.CharField(max_length=30, blank=True, null=True)
> Author_Lname = models.CharField(max_length=30, blank=True, null=True)
>
> class Meta:
> # managed = False
> db_table = 'Author'
>
>
> Book_code = models.CharField(max_length=50, blank=True,
> default=user_code_key,unique=True)
> on_delete=models.CASCADE)*
>
> class Meta:
> # managed = False
> db_table = 'Book'
>
>
>
>
> 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...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.