[x] (N/A) New code has inline comments where necessary
[x] (N/A) Any new modules, functions or classes have docstrings consistent with dbprocessing style
[x] (N/A) Major new functionality has appropriate Sphinx documentation
[x] (N/A) Added an entry to release notes if fixing a major bug or providing a major new feature
[x] (See below) New features and bug fixes should have unit tests
[x] Relevant issues are linked in the description (use Closes # if this PR closes the issue, or some other reference, such as See # if it is related in some other way)
*We don't yet have unit tests to make sure warnings aren't raised, the tests now pass without warnings on Python 3.10, sqlalchemy 1.4, and 2.0.
This would close #135, so should edit the PR description to say that. (Last item in the PR checklist, see #120 for an example, also some information here.)
Updated a series of errors so that dbprocessing code works for both sqlalchemy 2.0 and sqlalchemy 1.4. Closes #135.
Adding/Removing bind=self.engine
Join syntax needs to be reorganized so that the order of the second argument aligns with the first argument, as well as deleting extra parenthesis
Replaced Query.get() with Session.get()
PR Checklist
Closes #
if this PR closes the issue, or some other reference, such as See # if it is related in some other way)*We don't yet have unit tests to make sure warnings aren't raised, the tests now pass without warnings on Python 3.10, sqlalchemy 1.4, and 2.0.