Commits · main · IT Repositories / IT Shared Libraries and Components / MST Python Libraries / mst-sql · GitLab

Snippets Groups Projects

May 23, 2025
- add documentation · f900a13c
  bpsxv3@umsystem.edu authored 1 month ago
  
  f900a13c
May 22, 2025
- bump version · c4814578
  bpsxv3@umsystem.edu authored 1 month ago
  
  c4814578
May 21, 2025
- change execute_all to tx_execute_all · dcb87bc5
  bpsxv3@umsystem.edu authored 1 month ago
  
  dcb87bc5
- fix bug and separate params to per query · fa829206
  bpsxv3@umsystem.edu authored 1 month ago
  
  fa829206
- last bugfix · 78503804
  bpsxv3@umsystem.edu authored 1 month ago
  
  78503804
- bugfix again · 1c334328
  bpsxv3@umsystem.edu authored 1 month ago
  
  1c334328
- bugfix · b6373f7f
  bpsxv3@umsystem.edu authored 1 month ago
  
  b6373f7f
- add execute_all for running many queries within a transaction · c2d07c87
  bpsxv3@umsystem.edu authored 1 month ago
  
  c2d07c87
Apr 25, 2025
- add ssl key · c860f736
  Kim, Sophia Younjoo authored 2 months ago
  
  c860f736
Mar 27, 2025
- remove ssl params when it is not needed · ac8baab4
  Kim, Sophia Younjoo authored 3 months ago
  
  ac8baab4
Feb 17, 2025
- recycles connections every 30 min to avoid timeouts and prevents using a dead... · 5b8ccbc0
  Kim, Sophia Younjoo authored 4 months ago
  5b8ccbc0
Nov 14, 2024
- Ran black again · 85e0cb09
  Nicholas Farrell authored 7 months ago
  
  85e0cb09
- passing force_return=True to execute() method for insert/update/delete queries... · 32823cc1
  Nicholas Farrell authored 7 months ago
  32823cc1
- Revert "execute method now optionally returns rows (defaults as cursorresult)" · ebe4c371
  Nicholas Farrell authored 7 months ago
  ebe4c371
- Revert "Ran black" · 600482eb
  Nicholas Farrell authored 7 months ago
  600482eb
- Ran black · 10f0dc25
  Nicholas Farrell authored 7 months ago
  
  10f0dc25
- execute method now optionally returns rows (defaults as cursorresult) · 903bbbdd
  Nicholas Farrell authored 7 months ago
  
  903bbbdd
Oct 17, 2024
- Updated version. · e34cb3d1
  Joe Skeeters authored 8 months ago
  
  e34cb3d1
- Ran Black. · 4d3ae6a6
  Joe Skeeters authored 8 months ago
  
  4d3ae6a6
- Added SSL connection options. · 2f80d442
  Joe Skeeters authored 8 months ago
  
  2f80d442
Aug 28, 2024
- Incremented version number · 73f6f39f
  Nicholas Farrell authored 10 months ago
  
  73f6f39f
- replaced writeheader() method, which only works for dictwriter objects, with writerow() method · d217f7d4
  Nicholas Farrell authored 10 months ago
  
  d217f7d4
- select_csv() method uses the csv module rather than writing csvs by itself · 2687eff8
  Nicholas Farrell authored 10 months ago
  
  2687eff8
Aug 12, 2024
- Incremented version · 8756b759
  Nicholas Farrell authored 10 months ago
  
  8756b759
- select_csv no longer leaves floats/bools/datetime/etc datatypes blank · 3925f0b7
  Nicholas Farrell authored 10 months ago
  
  3925f0b7
Jun 06, 2024
- Ran black · 29429697
  Nicholas Farrell authored 1 year ago
  
  29429697
- Limit argument no longer defaults to 1000. A different default value can be... · e8a093e1
  Nicholas Farrell authored 1 year ago
  e8a093e1
May 10, 2024
- updated version number · fb51c904
  Nicholas Farrell authored 1 year ago
  
  fb51c904
May 09, 2024
- Ran black · e4da8b6c
  Nicholas Farrell authored 1 year ago
  
  e4da8b6c
Apr 30, 2024
- Removed defaulting to self.last_qry and self.last_params, added select_csv method · b45c7dab
  Nicholas Farrell authored 1 year ago
  
  b45c7dab
Nov 17, 2023
- Last version didn't merge correctly and so was missing recent changes, this one should be correct · d0b186ce
  Nicholas Farrell authored 1 year ago
  
  d0b186ce
Nov 13, 2023
- Incremented version · 358e8266
  Nicholas Farrell authored 1 year ago
  
  358e8266
Oct 02, 2023
- Ran black · d0b4bfd3
  Nicholas Farrell authored 1 year ago
  
  d0b4bfd3
- Added sequence parameters · 1052a3ca
  Nicholas Farrell authored 1 year ago
  
  1052a3ca
Aug 22, 2023
- DBHandler initialization now allows custom user/database/password arguments,... · ac2040ad
  Nicholas Farrell authored 1 year ago
  ac2040ad
Aug 11, 2023
- Added default row limit to select method as well as prefetch option that... · c91fd323
  Nicholas Farrell authored 1 year ago
  c91fd323
Aug 02, 2023
- select_first methods no longer raise an error when used with queries that... · 41d0fcf0
  Nicholas Farrell authored 1 year ago
  41d0fcf0
- Ran black · 14da8ea4
  Nicholas Farrell authored 1 year ago
  
  14da8ea4
- Added '_first' to names of methods returning single rows to make them more... · 8fbd9806
  Nicholas Farrell authored 1 year ago
  8fbd9806
Jul 31, 2023
- add pymysql · ca2f925d
  Kim, Sophia Younjoo authored 1 year ago
  
  ca2f925d