Gsheets POC

This deals with poc on google sheets access and manipulation in a web application ( client-server architechture ) .

It also demonstrates the Google Oauth2 authentication in such a setup .

| Djnago | python | sqlite |

Running server :

# using Makefile
make runserver

# manually
python3 manage.py runserver localhost:5000

On Browser :

• / points to base path points to gsheets app .
  • /sheet/api points to api specific enpoints .
• /auth points to gauth app .
• /admin points to django admin .

  • admin panel credentials :

    • username : admin
    • password : admin

    If credential not set , generate them by running command ( on terminal/shell/cmd ):

    python3 manage.py createsuperuser

---

TODO :

• when we add google sheet's sharable url , gid is not included in it , hence , if we select GID option , it'll give error , hence we can add an enhencement ( already part of office project )
  • replace extract_id_gid function with a validate_sheet_url function and when gid is not available , hence, operate accordingly

---

Notes on GIT

Globally

git config --global credential.helper 'cache --timeout=3600'

Locally

git config credential.helper 'cache --timeout=3600'

NOTE :

Git credentials.helper `cache` option stores credentials in running process's memory .
For e.g:
    If you are operating GIT commands on Terminal/cmd , then these
    command stores the credentials in the memory of that terminal/cmd
    process .
    Once you exit that process , the `cache` is lost .