Commit Graph

60 Commits

Author SHA1 Message Date
nobohan 9c90e5ac07 Add single python script for translating third party information into SQL 2024-02-16 09:48:07 +01:00
Mathieu Jaumotte 543a4569fd update script with resinam troubles 2023-05-05 17:16:30 +02:00
Mathieu Jaumotte 36e3bf3b4b modifs mineures du canevas sur les headers (v0.6.1) 2023-03-15 17:02:35 +01:00
Mathieu Jaumotte ddfe9b53b3 Merge branch 'dev' 2023-03-15 13:25:29 +01:00
Mathieu Jaumotte cea5190174 update readme 2023-03-15 13:24:52 +01:00
Mathieu Jaumotte ca3ce608c0 Merge branch 'dev' 2023-03-15 10:25:12 +01:00
Mathieu Jaumotte f3bda2a22e add readme 2023-03-15 10:24:39 +01:00
Mathieu Jaumotte 4e866c2d8e Merge branch 'dev' 2023-03-14 12:21:17 +01:00
Mathieu Jaumotte 6b11efd18e add v0.6.0 of excel canvas 2023-03-14 12:20:28 +01:00
Mathieu Jaumotte 290a9b917f Things to think when running script 2023-03-14 12:05:52 +01:00
Mathieu Jaumotte b68e0399cc 62-63. Add and link comments to periods, pin last comment 2023-03-11 16:53:26 +01:00
Mathieu Jaumotte 07df6c4292 default value for socialissue_id, user_id, scope_id 2023-03-11 16:50:11 +01:00
Mathieu Jaumotte d9152fc090 60. Link jobs to periods 2023-03-11 15:30:28 +01:00
Mathieu Jaumotte 12f0ec0ae4 59. Link origin to periods 2023-03-11 15:30:24 +01:00
Mathieu Jaumotte 264fdb5888 58. Link scopes to periods 2023-03-11 15:29:53 +01:00
Mathieu Jaumotte 7893eb3c81 57. Link referrer to periods 2023-03-11 13:43:44 +01:00
Mathieu Jaumotte 1adf47e63e 56. Link socialissues to periods 2023-03-11 13:42:38 +01:00
Mathieu Jaumotte 314e625c91 55. Copy period in period_location_history 2023-03-10 19:58:25 +01:00
Mathieu Jaumotte 59daee4790 53-54. Link period to person or temporary address location 2023-03-10 19:27:31 +01:00
Mathieu Jaumotte 6900d66206 52. Link participations to periods 2023-03-10 18:32:09 +01:00
Mathieu Jaumotte f513dd1b36 Add a setval() query after INSERT INTO when id is not nextval() 2023-03-10 17:53:05 +01:00
Mathieu Jaumotte 67d020d322 50-51. Insert in accompanyingPeriods table 2023-03-10 17:51:58 +01:00
Mathieu Jaumotte 477565f6e1 Improve undo delete clause to avoid removing still referenced rows
(foreign key constraint violation)
2023-03-10 16:51:23 +01:00
Mathieu Jaumotte e569d77bd2 Fix WHERE jsonb comparison 2023-03-10 16:20:58 +01:00
Mathieu Jaumotte 0ab77b77ed improve setval id if remove all rows 2023-03-10 16:18:51 +01:00
Mathieu Jaumotte 307cfcbe74 46. Add household composition 2023-03-10 16:17:27 +01:00
Mathieu Jaumotte 081ce76085 renaming alias 2023-03-10 16:16:27 +01:00
Mathieu Jaumotte cadcddddb5 Improve date management for not specified dates
- use real import date for person createdat field
- use year first day for not specified startdate, comment date, etc.
2023-03-10 13:21:31 +01:00
Mathieu Jaumotte dd3769e2a0 use validfrom in address insertion 2023-03-10 12:55:53 +01:00
Mathieu Jaumotte 1cc1b83435 add gendercomment in person insertion 2023-03-10 12:45:23 +01:00
Mathieu Jaumotte 9ac2553eb0 Fix phone numbers format 2023-03-10 12:16:51 +01:00
Mathieu Jaumotte 0c7ea76178 42. Insert query bloc for center history insertion 2023-03-08 23:44:39 +01:00
Mathieu Jaumotte 5f78276762 Rename aliases in undo queries 2023-03-08 23:43:47 +01:00
Mathieu Jaumotte 5a6daae5a4 43-44. Insert household and link to person, address, position 2023-03-08 21:20:52 +01:00
Mathieu Jaumotte 3978ee8b1a Fix WHERE jsonb comparison 2023-03-08 21:20:47 +01:00
Mathieu Jaumotte 838bcb78ff 33-34 Fix phone format 2023-03-08 21:08:02 +01:00
Mathieu Jaumotte f3170d0c87 cleaning 2023-03-08 18:16:55 +01:00
Mathieu Jaumotte 1a6f3953ca 42. Add address, and link it to person 2023-03-01 21:20:49 +01:00
Mathieu Jaumotte 139dd6209a 33-34. Format phone numbers 2023-03-01 20:57:25 +01:00
Mathieu Jaumotte 25510c1efe fix query for person insertion 2023-03-01 20:56:53 +01:00
Mathieu Jaumotte a36ee22be6 fix numberofchildren cast 2023-03-01 17:34:47 +01:00
Mathieu Jaumotte b6f26900a7 20-32. Prepare import personnes and periodes tables 2023-03-01 17:18:00 +01:00
Mathieu Jaumotte dd89aa6ff1 improve title comment block 2023-02-17 19:43:57 +01:00
Mathieu Jaumotte 4dc09c559a fix setval with coalesce (reset id too if no rows) 2023-02-17 19:28:00 +01:00
Mathieu Jaumotte cb12f3000b 13. Complete chill_person_social_issue table 2023-02-17 19:23:38 +01:00
Mathieu Jaumotte e14f6896e3 12. complete users table (referrer) 2023-02-17 19:23:38 +01:00
Mathieu Jaumotte 7b4f04ef40 11. complete scopes table 2023-02-17 19:22:45 +01:00
Mathieu Jaumotte 6d64060965 10. complete chill_main_user_job table 2023-02-17 19:22:38 +01:00
Mathieu Jaumotte 396444790f 9. complete chill_person_accompanying_period_origin table 2023-02-17 10:02:49 +01:00
Mathieu Jaumotte 44d24155a1 8. complete chill_person_accompanying_period_closingmotive table 2023-02-17 10:02:49 +01:00