-
Notifications
You must be signed in to change notification settings - Fork 12
Open
Description
I'm getting an error on my initial attempt to import data:
$ healthkit-to-sqlite 20201119\ healthkit\ export.zip healthkit.db
Importing from HealthKit [###################################-] 98% 00:00:01
Traceback (most recent call last):
File "venv/bin/healthkit-to-sqlite", line 8, in <module>
sys.exit(cli())
File "venv/lib/python3.9/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "venv/lib/python3.9/site-packages/click/core.py", line 782, in main
rv = self.invoke(ctx)
File "venv/lib/python3.9/site-packages/click/core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "venv/lib/python3.9/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "venv/lib/python3.9/site-packages/healthkit_to_sqlite/cli.py", line 57, in cli
convert_xml_to_sqlite(fp, db, progress_callback=bar.update, zipfile=zf)
File "venv/lib/python3.9/site-packages/healthkit_to_sqlite/utils.py", line 34, in convert_xml_to_sqlite
workout_to_db(el, db, zipfile)
File "venv/lib/python3.9/site-packages/healthkit_to_sqlite/utils.py", line 57, in workout_to_db
pk = db["workouts"].insert(record, alter=True, hash_id="id").last_pk
File "venv/lib/python3.9/site-packages/sqlite_utils/db.py", line 1660, in insert
return self.insert_all(
File "venv/lib/python3.9/site-packages/sqlite_utils/db.py", line 1778, in insert_all
self.insert_chunk(
File "venv/lib/python3.9/site-packages/sqlite_utils/db.py", line 1588, in insert_chunk
result = self.db.execute(query, params)
File "venv/lib/python3.9/site-packages/sqlite_utils/db.py", line 213, in execute
return self.conn.execute(sql, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: workouts.id
Metadata
Metadata
Assignees
Labels
No labels