EngrTrackline

A project aimed at chronicling my journey of learning and advancement in electronics, mathematics, and robotics.

Development Environment Commands

Install pip and venv

sudo apt install python3-pip python3-venv

Create Python Virtual Environment

python3 -m venv DarkVenv

Start Virtual Python Environment

source ./DarkVenv/bin/activate

Install Django

pip3 install django

Update Django

pip3 install --upgrade django

Stop Virtual Python Environment

deactivate

Django Project Commands

Create Django Project Folder

mkdir EngrTrackline
cd EngrTrackline
django-admin startproject engrtrackline .

Initialize SQLite Database

python manage.py migrate

Run Local Server

python manage.py runserver

Create App Inside Project Folder

python manage.py startapp tracklineapp

Open Django Shell Session

python manage.py shell

Make App Migrations

python manage.py makemigrations tracklineapp

Create Database Super User

python manage.py createsuperuser

SQLite3 Commands

Install SQLite3

sudo apt install sqlite3

Open Default Django Project Database

sqlite3 db.sqlite3

Show All Tables

.tables 

Turn on Headers

.headers on

Change to Column View

.mode column

View Current Mode

.mode

Exit SQLite3

.exit

Export SQL Query Output to CSV

sqlite3 db.sqlite3 ".mode csv" ".headers on" ".output ./activitylog/reading_log.csv" "SELECT strftime('%Y-%m-%d %H:%M:%S',datetime(logged, 'localtime')) AS logged,leg,pages,title,author FROM tracklineapp_reading_leg INNER JOIN tracklineapp_book ON tracklineapp_reading_leg.book_id = tracklineapp_book.id;"

Export SQL Query Output to Text File

sqlite3 db.sqlite3 ".mode column" ".headers on" ".output ./activitylog/reading_log.txt" "SELECT strftime('%Y-%m-%d %H:%M:%S',datetime(logged, 'localtime')) AS logged,leg,pages,title,author FROM tracklineapp_reading_leg INNER JOIN tracklineapp_book ON tracklineapp_reading_leg.book_id = tracklineapp_book.id;"