Flask login with PostgreSQL
============================

DEPENDENCY LISTS HERE DO HAVE UNNECESSARY PACKAGES AND PACKAGES WHICH DO NOT EXIST.
It should be good enough to get this working (irnore warnings about missing packages),
but the dependencies in this text should be corrected.

::

   https://itnext.io/sqlalchemy-orm-connecting-to-postgresql-from-scratch-create-fetch-update-and-delete-a86bc81333dc

Install PostgreSQL
*******************

::

   sudo apt-get install libllvm10 libpq-dev libpq5 libwxbase3.0-0v5 libwxgtk3.0-gtk3-0v5
   sudo apt-get install postgresql postgresql-12 postgresql-client
   sudo apt-get install postgresql-client-12 postgresql-client-common postgresql-common
   sudo apt-get install postgresql-doc postgresql-doc-12 sysstat
   sudo apt-get install postgresql-contrib
   
   Note: pgadmin 3 has been obsoleted, use pgdmin 4. Run script "sudo apt.postgresql.org.sh"
   to add repository, then "sudo apt-get install pgadmin4".

Postgre daemon can be started and stopped. Enabling daemon means that it is started
automatically at boot. 
   
::   

   sudo systemctl start postgresql
   sudo systemctl stop postgresql
   sudo systemctl enable postgresql
   sudo systemctl disable postgresql


Set postgreSQL password
*******************************************
When postgre has been installed fron ubuntu distro log:

::

   sudo -u postgres psql 

Set default "postgres" user password to "smith333"
   
::   

   postgres=# ALTER USER postgres PASSWORD 'smith333';
   postgres=# create database iocafecloud;

Starting with flask login tutorial
***********************************
Running flask login tutorial

::

   https://hackersandslackers.com/flask-login-user-authentication/
   https://flask-sqlalchemy.palletsprojects.com/en/2.x/config/

Here we assume that we have anaconda virtual environment set up, see "flask setup 
for production".

::

   cd /coderoot
   git clone https://github.com/toddbirchard/flasklogin-tutorial.git
   conda activate flask
   python -m pip install -r requirements.txt
   python -m pip install flask flask-login flask-sqlalchemy flask-wtf
   sudo python -m pip install psycopg2-binary
   sudo python -m pip install psycopg2

requirements.txt file opened (I do not think these all are needed, inherited from example)

::

   python -m pip install click dnspython email-validator 
   python -m pip install Flask Flask-Assets Flask-SQLAlchemy Flask-WTF
   python -m pip install idna, itsdangerous, Jinja2
   python -m pip install PyMySQL python-dotenv SQLAlchemy
   python -m pip install webassets, Werkzeug, WTForms



Starting it up
***************
Modify start.sh test script to use our postgres database.

::

   # start.sh
   export FLASK_APP=wsgi.py
   export FLASK_DEBUG=1
   export APP_CONFIG_FILE=config.py
   export SQLALCHEMY_DATABASE_URI=postgresql://postgres:smith333@127.0.0.1/iocafecloud
   export SECRET_KEY=typeanythingsecrethere
   flask run
   
   
::

   cd /coderoot/flasklogin-tutorial
   conda activate flask
   ./start.sh
   
Open web browser at http://127.0.0.1:5000