add a method to save to a pv site database

[peterdudfield]

Pull Request

Description

• add method to save to pv_sites database
• add tests

I have a general feeling this is a bit complicated for what it is. Might be worth in the future thinking about making this a lot simpler.

(slight reason this is complicated is, the consumer checks what the last data is, and then only pull and saves new data. Essentially this could be done with a different sql upload function)

46

How Has This Been Tested?

• normal tests

• add test to save to new database

• [x] Yes

Checklist:

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

[codecov-commenter]

Codecov Report

Merging #47 (bbde4da) into main (a3b476b) will decrease coverage by 4.07%. The diff coverage is 76.59%.

@@            Coverage Diff             @@
##             main      #47      +/-   ##
==========================================
- Coverage   97.26%   93.19%   -4.07%     
==========================================
  Files           5        6       +1     
  Lines         256      294      +38     
==========================================
+ Hits          249      274      +25     
- Misses          7       20      +13     

Impacted Files	Coverage Δ
pvconsumer/utils.py	76.08% <30.76%> (-17.86%)	:arrow_down:
pvconsumer/app.py	92.85% <91.66%> (-3.40%)	:arrow_down:
pvconsumer/save.py	95.23% <95.23%> (ø)
pvconsumer/__init__.py	100.00% <100.00%> (ø)

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