remove clientSQL, get user sites, add checks if the user has access t…

[peterdudfield]

Pull Request

Description

• upgrade datamodel
• let user only get sites asscioated with them
• email from user auth is used to get the user and the asscioated sites

How Has This Been Tested?

• CI tests

• ran locally

• hard to fully test without doing migration first on db

• [ ] Yes

Checklist:

• [ ] My code follows OCF's coding style guidelines
• [ ] I have performed a self-review of my own code
• [ ] I have made corresponding changes to the documentation
• [ ] I have added tests that prove my fix is effective or that my feature works
• [ ] I have checked my code and corrected any misspellings

[codecov[bot]]

Codecov Report

Merging #99 (8d56f6c) into main (a260dcd) will increase coverage by 0.25%. Report is 1 commits behind head on main. The diff coverage is 100.00%.

@@            Coverage Diff             @@
##             main      #99      +/-   ##
==========================================
+ Coverage   93.22%   93.48%   +0.25%     
==========================================
  Files          10       10              
  Lines         428      445      +17     
==========================================
+ Hits          399      416      +17     
  Misses         29       29              

Files Changed	Coverage Δ
pv_site_api/__init__.py	100.00% <100.00%> (ø)
pv_site_api/_db_helpers.py	100.00% <100.00%> (ø)
pv_site_api/main.py	93.43% <100.00%> (+0.27%)	:arrow_up:
pv_site_api/pydantic_models.py	100.00% <100.00%> (ø)

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more

[peterdudfield]

@braddf @devsjc @rachel-labri-tipton I',m gona merge this, but I welcome any comments that I can add afterwards