connect MySQL with Django code example
Example 1: django mysql settings
#add this settings in settings file
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'DB_NAME',
'USER': 'DB_USER',
'PASSWORD': 'DB_PASSWORD',
'HOST': 'localhost', # Or an IP Address that your DB is hosted on
'PORT': '3306',
}
}
Example 2: 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 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