PACA-003: Select Statements

Jay-Shu / pythonautoclaimsapp

Python Auto Claims app - Simple. Intended for interactions with an MS SQL DB.

Other

1 stars 0 forks source link

PACA-003: Select Statements #2

Open Jay-Shu opened 3 months ago

Jay-Shu commented 3 months ago

Create Select Statements for the application. This will need to include BEGIN TRANSACTIONS, COMMIT TRANSACTIONS, and ROLLBACK TRANSACTIONS within their final form.

Jay-Shu commented 3 months ago

Added the first Select statement getAccounts_v1.

Jay-Shu commented 3 months ago

Added getAccounts_v2, getAccounts_v3, and getAccounts_v4.

Jay-Shu commented 1 month ago

This is getAccounts_v1 successfully running via test_dbsp.py in order to validate that the stored procedure is actually being ran.

Jay-Shu commented 1 month ago

Further investigation shows that the culprit was logic within the python side missing and not in the data being returned by the MS SQL Server. Additionally, planning for error catching is necessary to prevent system thrown errors. Because an error will be thrown in command prompt if one is thrown by MS SQL Server.