Skip to content
This repository has been archived by the owner on Apr 18, 2023. It is now read-only.

Latest commit

 

History

History
147 lines (75 loc) · 4.02 KB

README.md

File metadata and controls

147 lines (75 loc) · 4.02 KB

UCI CubeSat Backend Quart Server

Contributor:

Katherine Hsu: kaishih@uci.edu,

Hailey Lin: weixil4@uci.edu,

Jiaen Zhang: jiaenz@uci.edu,

Yi-Ju Tsai,

Gabrielle Palar

Installing prerequisite

Double check Python3 and Pip3 are installed

Homebrew installation for macOS

`/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"`

`brew install git`

`brew install postgresql`

`brew install python@3.10`

Chocolatey installation for Windows

`Run Powershell as Admin`

`Set-ExecutionPolicy AllSigned`

`Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))`

verify `chocolatey` is installed: `choco -?`

`choco install git`

`choco install postgresql`

`choco install python --version=3.10.7`

Setting up the Python/Quart Backend Server locally

  1. Setup virtual environment

    cd UCI-CubeSat-Server

    python3 -m venv venv

  2. Activate venv:

    macOS/Linux: . venv/bin/activate

    Windows: . venv/Scripts/activate

  3. Install postgreSQL:

    macOS/Linux: brew install postgresql

    Windows: choco install postgresql

  4. Install requirements.txt: pip3 install -r 'requirements.txt'

  5. Create .env file

    Create a new file under the UCI-CubeSat-Server root folder, named .env

    Ask in the #gs-server-secret discord channel for a copy of the .env file.

  6. Run Quart: quart run

    Reopen your IDE and retry if quart run does not work initially

Connecting to SQL Database

  1. Double check you have PostgreSQL installed: pg_config --version

    More information about our database information can be found on: heroku-postgresql

  2. Access Database:

    Method a. Command Line Interface(CLI)

    heroku pg:psql postgresql-solid-33882 --app uci-cubesat-server-dev
    
    SELECT * FROM "two_line_element"; 
    

    Method b. DataGrip

    ElephantSQL INFO Dashboard

    Elephant SQL is a software-as-a-service company that host PostgreSQL databases and handles the server configuration, backups and data connections on top of AWS.

    1. Visit ElephantSQL Dashboard to access connection credential information

    2. Open DataGrip

    3. Open manage data sources using command+;

    4. Click on the add button on the top left corner, find PostgreSql, fill in the config based on ElephantSQL

      1. DG[Host] = ElephantSQL[Server]
      2. DG[User] = ElephantSQL[User & Default Database]
      3. DG[Password] = ElephantSQL[password]
      4. DG[Database] = ElephantSQL[User & Default Database]
      5. DG[URL] = jdbc:postgresql://castor.db.elephantsql.com/omoglffn
      6. Click on "Test Connection"
      7. If Succeed, click on apply and OK
    5. Now, you can write SQL query inside console. To open the console, use shift + command + L

Run FullStack Web App

  1. cd to UCI-CubeSat-Server:

    create venv environment

    quart run

  2. cd to UCI-CubeSat-Dashboard:

    npm start

Deployment to Heroku

Deploying to Heroku require significant configuration

The client and server must be deploy to different dyno/app

Example: Front End, Back End

For Python Quart server, Heroku require you to have:

app.py at project's root directory

web: hypercorn app:app inside Procfile at project's root directory

pip requirements.txt at project's root directory

Adding Python build pack