django with mysql code example
Example 1: link django to mysql
$ brew reinstall openssl
#run two commands under "For compilers to find [email protected] you may need to set:"
$ pip install mysqlclient
Example 2: database setup in django
sudo apt install python3-dev libmysqlclient-dev default-libmysqlclient-dev
Example 3: django creating database
# --------------- Start with databases in Django ------------------ #
In your virtual environment, where your Django project lives,
use the following commands:
# Migrations are Django’s way of propagating changes you make to
# your models (adding a field, deleting a model, etc.) into your
# database schema.
>> python3 manage.py makemigrations
# If used for the first time, it creates a standard user model
# (a table for saving information about users). Otherwise, it updates
# the database with the new information in the folder "migrations"
# (responsible for applying and unapplying migrations):
>> python3 manage.py migrate
# For printing the SQL code that is going to run:
>> python3 manage.py sqlmigrate "name_app" "code_of_specific_object"
# for example: python3 manage.py sqlmigrate app 0001
# Run a Django + python shell for working/testing with models:
>> python3 manage.py shell