Mysql/Models

[alkha...@mymail.vcu.edu]

Hello everyone,

Again, I'm super new to django so please bare with me. 

I have just connected my mysql database to my django project in settings.py. I then manually made models for the tables in my database. I originally used inspectdb to do this, but I was getting a bunch of errors. I decided to just do it manually from there, although I'm not necessarily sure if it is correct yet. Do my models have to perfectly match my sql relations? My tables already have unique ids as a field. I now that django automatically does this, that is, make unique ids? Will this be a problem. 

Anyway, I then ran makemigrations and migrate (which worked wonderfully), and now I am trying to simply view some data from my database in the manage.py shell. I am not exactly sure how to do this, so any help would be great. Further, am I missing any steps as far connecting the mysql database to my django project? Lastly, a rather huge disconnect I am having with all of this is simply understanding how exactly the models.py in my apps are actually connected to my database?

Here are a few snapshots of my files:

Models.py 

   

manage.py shell

[m712 - Developer]

On Apr 17, 2017 12:57 AM, alkha...@mymail.vcu.edu wrote:
>
> I am not exactly sure how to do this, so any help would be great.

The shell is just a Python REPL, you can run any Python code in it. Consider:
>>> from yourapp import models
>>> models.YourModel.objects.first()
<YourModel: YourModel object>

>Further, am I missing any steps as far connecting the mysql database to my django project?

If you can do the above successfully I don't think so.

>Lastly, a rather huge disconnect I am having with all of this is simply understanding how exactly the models.py in my apps are actually connected to my database?

Short answer: they're not really.
Long answer: When you try to access a field of a model in Django, Django will query the table related to that model, get the row with the ID of your model, then give you the correct column.

[Camilo Torres]

Hi,

You can use a Meta class for your models and add a db_table property to control the table name related to the model, that way, you can name your model as you like (and differently from the DB table name).
You can also use the db_column parameter to Fields to control the name of the column in the table you are associating the model fields. That allows you to use lowercase field names as customary for Python, for example:

class Organism(models.Model):
    author = models.CharField(max_length=200, db_column='Author')
    ...

Please, read this documentation:
https://docs.djangoproject.com/en/1.11/ref/models/options/
https://docs.djangoproject.com/en/1.11/ref/models/fields/#db-column