Commit Graph

73 Commits

Author SHA1 Message Date
Kenneth Kehl
dd42b9636c fix 2025-07-25 08:00:43 -07:00
Kenneth Kehl
839f2009f2 clear up sqlalchemy warning 2025-07-25 07:35:39 -07:00
Kenneth Kehl
3c0621f472 more code review feedback 2024-12-20 08:09:19 -08:00
Kenneth Kehl
3388371428 fix filter_bys 2024-12-19 11:10:03 -08:00
Kenneth Kehl
1a1de39949 change querie to stmt 2024-11-21 09:38:43 -08:00
Kenneth Kehl
38e7672866 fix 2024-11-18 14:54:49 -08:00
Kenneth Kehl
552d4644da try fixing pagination 2024-11-18 12:19:23 -08:00
Kenneth Kehl
71e4794f02 try fixing pagination 2024-11-18 12:08:32 -08:00
Kenneth Kehl
4539e5cbfc try fixing pagination 2024-11-18 11:53:11 -08:00
Kenneth Kehl
25d2901b86 try fixing pagination 2024-11-18 11:36:20 -08:00
Kenneth Kehl
9b965ae6bf fix first paginate method 2024-10-18 12:40:14 -07:00
Kenneth Kehl
567a16fb53 fix first paginate method 2024-10-18 12:23:51 -07:00
Kenneth Kehl
2b1e83cef6 fix first paginate method 2024-10-18 12:12:20 -07:00
Kenneth Kehl
a3b2b19406 fix first paginate method 2024-10-18 11:55:30 -07:00
Kenneth Kehl
5e8efacdb8 fix first paginate method 2024-10-18 11:33:59 -07:00
Kenneth Kehl
73dbca16e1 fix first paginate method 2024-10-18 11:18:29 -07:00
Kenneth Kehl
c859c5c53a fix first paginate method 2024-10-18 11:03:21 -07:00
Kenneth Kehl
697ea84d32 fix first paginate method 2024-10-18 10:44:56 -07:00
Kenneth Kehl
f12f6b9b63 fix first paginate method 2024-10-18 10:27:29 -07:00
Kenneth Kehl
fed5a842e0 fix first paginate method 2024-10-18 10:16:09 -07:00
Kenneth Kehl
5716c86e8a fix first paginate method 2024-10-18 10:03:46 -07:00
Kenneth Kehl
cf3e99c801 fix first paginate method 2024-10-18 09:50:06 -07:00
Kenneth Kehl
001c16bdce fix first paginate method 2024-10-18 09:40:37 -07:00
Kenneth Kehl
f207b65c9a fix first paginate method 2024-10-18 09:31:12 -07:00
Kenneth Kehl
c36a1ba221 fix first paginate method 2024-10-18 09:21:04 -07:00
Kenneth Kehl
3b651a2716 fix first paginate method 2024-10-18 09:05:03 -07:00
Kenneth Kehl
78aab59d15 fix first paginate method 2024-10-18 08:45:31 -07:00
Kenneth Kehl
fdc494e561 fix delete 2024-10-18 08:12:22 -07:00
Kenneth Kehl
ea32db8df3 revert pagination fix 2024-10-17 14:28:22 -07:00
Kenneth Kehl
be56461587 fix delete_inbound_sms_older_than_retention and dao_get_inbound_sms_by_id 2024-10-17 14:17:00 -07:00
Kenneth Kehl
6f29a0e5a4 fix delete_inbound_sms_older_than_retention and dao_get_inbound_sms_by_id 2024-10-17 14:05:03 -07:00
Kenneth Kehl
3c3fb8eb3a fix delete_inbound_sms_older_than_retention and dao_get_inbound_sms_by_id 2024-10-17 13:52:25 -07:00
Kenneth Kehl
cfce20fb46 fix delete_inbound_sms_older_than_retention and dao_get_inbound_sms_by_id 2024-10-17 13:39:05 -07:00
Kenneth Kehl
80d05532e7 fix delete_inbound_sms_older_than_retention and dao_get_inbound_sms_by_id 2024-10-17 13:22:41 -07:00
Kenneth Kehl
dd4bf2abd3 fix delete_inbound_sms_older_than_retention and dao_get_inbound_sms_by_id 2024-10-17 13:10:02 -07:00
Kenneth Kehl
af22cbcab9 start InboundSmsDao 2024-10-17 12:58:35 -07:00
Kenneth Kehl
0f1d70f593 start InboundSmsDao 2024-10-17 12:44:28 -07:00
Kenneth Kehl
672fb364ec start InboundSmsDao 2024-10-17 12:36:26 -07:00
Kenneth Kehl
608f1ec3a3 start InboundSmsDao 2024-10-17 12:27:17 -07:00
Kenneth Kehl
c818bac288 start InboundSmsDao 2024-10-17 12:24:23 -07:00
Aditi Anand
ad55eef5e9 Changes for sqlalchemy 2.0 2024-04-24 16:27:20 -04:00
Cliff Hill
3982f061b6 Made enums.py for all the enums to avoid cyclic imports.
Signed-off-by: Cliff Hill <Clifford.hill@gsa.gov>
2024-02-28 12:43:31 -05:00
Cliff Hill
43f18eed6a More changes for enums.
Signed-off-by: Cliff Hill <Clifford.hill@gsa.gov>
2024-02-28 12:41:57 -05:00
Cliff Hill
820ee5a942 Cleaning up a lot of things, getting Enums used everywhere.
Signed-off-by: Cliff Hill <Clifford.hill@gsa.gov>
2024-02-28 12:40:52 -05:00
Kenneth Kehl
1ecb747c6d reformat 2023-08-29 14:54:30 -07:00
Rebecca Law
68d28aa83b The update of SQLAlchemy 1.4.10 has caused some conflicts in our code. This PR fixes most of those conflicts.
- sqlalchemy.sql.expression.case must include an else statement.
- clearly define list of columns for inbound_sms_history insert, getting the list from InboundSmsHistory.__table__.c was causing data type errors.
- remove relationships when not needed, the foreign key relationship is established in the creation of the column. This will get rid of the warnings referenced here: http://sqlalche.me/e/14/qzyx.
- update queries now that he user relationship in ServiceUser db model has been removed.
- move the check that a template is archived to the view instead of the dao method. The check was clearing the session before the version history could be done.

Deleting notifications in the night tasks still needs to be
investigated. The raw sql is causing an error.
2021-04-29 13:32:36 +01:00
Rebecca Law
85895a9e8b Revert "Scheduled weekly dependency update for week 16" 2021-04-28 10:17:16 +01:00
Rebecca Law
1b070d69a1 The update of SQLAlchemy 1.4.10 has caused some conflicts in our code. This PR fixes most of those conflicts.
- sqlalchemy.sql.expression.case must include an else statement.
- clearly define list of columns for inbound_sms_history insert, getting the list from InboundSmsHistory.__table__.c was causing data type errors.
- remove relationships when not needed, the foreign key relationship is established in the creation of the column. This will get rid of the warnings referenced here: http://sqlalche.me/e/14/qzyx.
- update queries now that he user relationship in ServiceUser db model has been removed.
- move the check that a template is archived to the view instead of the dao method. The check was clearing the session before the version history could be done.

Deleting notifications in the night tasks still needs to be
investigated. The raw sql is causing an error.
2021-04-26 11:50:30 +01:00
Rebecca Law
d4009ffc52 Rename database management functions.
Rename @transactional to @autocommit.
Rename nested_transaction to tranaction.
2021-04-19 10:56:00 +01:00
Ben Thorner
a91fde2fda Run auto-correct on app/ and tests/ 2021-03-12 11:45:45 +00:00