Following-Django-Proj-CRM-App-Tutorial

Following a Django Tutorial to Build a CRM App Tutorial

Steps

• conda deactivate base

• 3:17 install virtual environment

• 3:31 activate virtual environment

• 3:43 pip install django

• python.exe -m pip install --upgrade pip

• 3:50 pip install mysql

• 3:54 Download mysql

• 4:01 connector from Django to mysql app

  • 4:05 There are 2 connectors

    • 4:06 pip install mysql-connector
    • 4:13 pip install mysql-connector-python

• 4:34 download and install mysql

• dev.mysql.com

  • dev.mysql.com/downloads/installer/
  • MySQL Installer 8.0.34

• 4:48 Community installer

• 4:50 link 2 of 2 with the ~300M file size

• 4:53 click download

Installation Note

• 5:04 Important: setup Username and Password

Turn on MySQL Server

• 5:30 Turn on MySQL Server

  • 5:37 MySQL needs to be running in the background

• 5:43 head back over to terminal

• 5:52 django-admin startproject dcrm

• 13:38 setup git

• 16:37 See code pushed to GitHub remote repository

• 21:29 First webpage working

• 21:46 In base.html is the code that will go on every page

• 21:49 Bootstrap

• 21:54 getbootstrap.com

• 21:59 Docs

• 25:47 change light to dark navbar

• 28:08 navbar has been tidied up

---

• 28:48 Django login users

• 29:50 views.py import authenticate log in out and messages

• 30:47 how request works

• 31:11 url

• 35:55 Form added with baasic modification

• 36:14 Cut log me out tick box

• 37:31 Username and Password formatted

• 37:41 Login button clicking should do nothing (Fixed earlier error, see README/Bugs/Issue:Login...)

• 37:46 Username and Password need to be requireed

• 47:16 There was an error login Bootstrap message with x working

• 50:37 Login and Logout working

• 51:46 Register Users

• 54:42 Register Page exists

• 1:04:28 Registration updated, tutorial commit

  GitHub for Tutorial:

  • tutorial 'registration' commit

  • relevant code: form.py

• 1:13:53 Add registration detail - Done

• 1:14:43 end setting up site | start crm

• 1:15:03 Django DataBase Model

• 1:15:30 Python/Django creates a class that abstracts away and creates code for us on the backend.

  • 1:15:37 It will create the MySQL code if you're using MySQL

  • 1:15:40 It will create the PostgreSQL code

  • 1:15:42 Whatever DataBase you're using, it will do it for you behind the scenes.

• 1:15:48 define class

• 1:19:18 In models.py Add class Record and Define subelements

• 1:23:11 Record model migration applied

• 1:24:21 Records model added to admin.py

• 1:25:50 Start of 'Django View Records on Website' timestamp on tutorial

• 1:31:02 Return record at front end | View but still not formatted correctly

• 1:31:02 Start of Django Bootstrap Table for formatting | Same timestamp twice for different topics | (Purpose of 2 timestamps is to delineate different topics)

• 1:35:26 Table added to site

• 1:35:26 Prepare for adding extra formatting from Bootstrap Table Docs

• 1:36:10 table-hover class added to table in home.html

• 1:36:41 Border added to table

• 1:36:57 table-sm | table small class

• 1:37:14 Cut table-sm | table small class

• 1:37:34 Add table-dark class (to <thead> element) | Purpose: To make table header row dark

• 1:37:55 Identify TODO items and Plan next steps

• 1:38:25 Next Step: Django Individual Records

• 1:43:57 Added customer records page accessible only when logged in | Access page by primary key by passing (/<int:pk>) | setup url in urls.py, view in views.py and record.html in templates folder

• 1:45:10 Hovering over record ID links on page causes bottom left corner of site to display (hosted site home page)/record/(id#)

• 1:45:38 TODO Add content to record/int:pk

• 1:46:14 Added customer record to record page

• 1:48:43 Added content to records page | TODO: Add Bootstrap Card (formatting)

• 1:56:52 Added Bootstrap Card and Buttons (unconnected) to records page | TODO: Delete Record

• 2:01:07 Wired up Delete Record Button on record page | TODO: Add "Add Records" Functionality

• 2:03:09 Add "Add Record" button to navbar

• 2:12:12 Added 'Add Record' Form to 'Add Record' Page | TODO: Update Records

• 2:20:08 Add Update Record Page (with Back Button) | Push Code to GitHub

Bugs

Bug Number: 1

Issue: Login button goes to a 403 page with CSRF missing

Cause: form element missing closing triangular bracket in templates/home.html

Fix: add closing triangular bracket to form element

______________________________________________________________________________________________;

Bug Number: 2

Context:

File: forms.py

Line Number: 40

Line Content: first_name = Forms.CharField(required=True, widget=forms.widgets.TextInput(attrs={"placeholder":"First Name", "class":"form-control"}), label="")

Issue: First letter capitalization of Forms

Fix: Change Forms to forms

References

• Tutorial
• GitHub Repository for Tutorial
• ChatGPT3.5
• [VisualStudioCode]
• [Sublime]

VSCode Extensions

• [Live Server | Go Live]
• [Copilot]
• [Tabnine AI Autocomplete for Javascript, Python, Typescript, PHP, Go, Java, Ruby & more]
• [GitLens]
• [IntelliCode]
• [IntelliCode API Usage Examples]
• [Pylance]
• [Python]
• [Python Environment Manager]
• [Python Extension Pack]
• [WSL]
• [Path Intellisense]
• [Live Preview]
• [isort]

Packages

• [Django]
• [Bootstrap]

DataBase

• [MySQL]
• [mysql-connector]
• [mysql-connector-python]
• [mysqlclient]