pull_requests: 718734191

This data as json

id node_id number state locked title user body created_at updated_at closed_at merged_at merge_commit_sha assignee milestone draft head base author_association repo url merged_by auto_merge
718734191 MDExOlB1bGxSZXF1ZXN0NzE4NzM0MTkx 22 open 0 Make sure that case-insensitive column names are unique 32016596 This closes #21. When there are metadata entries with the same case insensitive string, then there is an error when trying to create a new column for that metadata entry in the database table, because a column with that case insensitive name already exists. ```xml <Record type="HKQuantityTypeIdentifierDietaryCholesterol" sourceName="MyFitnessPal" sourceVersion="35120" unit="mg" creationDate="2021-07-04 20:55:27 +0200" startDate="2021-07-04 20:55:00 +0200" endDate="2021-07-04 20:55:00 +0200" value="124"> <MetadataEntry key="meal" value="Dinner"/> <MetadataEntry key="Meal" value="Dinner"/> </Record> ``` The code added in this PR checks if a key already exists in a record and if so adds a number at its end. The resulting column names look like the example below then. Interestingly, the column names viewed with Datasette are not case insensitive. ```text startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, metadata_meal, metadata_Meal_2, metadata_Mahlzeit ``` 2021-08-24T13:13:38Z 2021-08-24T13:26:20Z     c757d372c10284cd6fa58d144549bc89691341c3     0 b16fb556f84a0eed262a518ca7ec82a467155d23 9fe3cb17e03d6c73222b63e643638cf951567c4c FIRST_TIME_CONTRIBUTOR 197882382 https://github.com/dogsheep/healthkit-to-sqlite/pull/22    

Links from other tables