Service-Project

its teh service project...

Contributing

Python 3.10+

python -m venv .venv
. .venv/bin/activate
pip install pip -U
pip install -r requirements.txt -r dev-requirements.txt -U

alembic upgrade head

uvicorn api.main:app --reload --port 8080

Create a Migration

alembic revision --autogenerate -m "add/update ..."

# make sure the migration was generated properly
nvim ./alembic/versions/<revision>.py

alembic upgrade head

Reset database

sql# DROP TABLE "user" CASCADE;
DROP TABLE opp CASCADE;
DROP TABLE user_opp_association CASCADE;
DROP TABLE alembic_version;

rm -rf alembic/versions/*

alembic revision --autogenerate -m "init"
alembic upgrade head

SQLAlchemy Docs

https://docs.sqlalchemy.org/en/14/orm/queryguide.html https://docs.sqlalchemy.org/en/14/tutorial/orm_data_manipulation.html

Docker

docker build -t fastapi .
docker run -d --name ai-service-project-api -p 8080:80 fastapi

If the docker file is changed

docker ps -a
docker stop <id>
docker rm <id>

docker build -t fastapi .
docker run -d --name ai-service-project-api -p 8080:80 fastapi

TODO

URGENT

• sync types with FE
• switch db provider

Current

• add real opportunity models

• switch PUT routes to PATCH

• switch unix timestamps to postgres's TIMESTAMPZ

• handle database errors better https://fastapi.tiangolo.com/tutorial/handling-errors/

• add a _deleted flag to db

Done

• Fix schema recursion error ./api/routers/user.py:78

• get, create, update, delete users

• get, create, update, delete tags

• refactor file if it gets too large

  • main.py
  • schemas.py
  • models.py
  • routers
  • db.py

• add routes to routes.http (automatically)

• fix sqlite complaining about thread safety => move to postgres https://github.com/tiangolo/full-stack-fastapi-postgresql/tree/master/%7B%7Bcookiecutter.project_slug%7D%7D/backend/app

• fix absolute imports not working (if there is more than 1 file)

• add auto migrations https://alembic.sqlalchemy.org/en/latest/autogenerate.html

• edit and delete routes

• status codes

• add user table and create relations (many to many)