{"url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/13","repository_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite","labels_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/13/comments","events_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/13/events","html_url":"https://github.com/dogsheep/swarm-to-sqlite/issues/13","id":1373210675,"node_id":"I_kwDODD6af85R2Ygz","number":13,"title":"fails before generating views. ERR:  table sqlite_master may not be modified","user":{"login":"pax","id":116795,"node_id":"MDQ6VXNlcjExNjc5NQ==","avatar_url":"https://avatars.githubusercontent.com/u/116795?v=4","gravatar_id":"","url":"https://api.github.com/users/pax","html_url":"https://github.com/pax","followers_url":"https://api.github.com/users/pax/followers","following_url":"https://api.github.com/users/pax/following{/other_user}","gists_url":"https://api.github.com/users/pax/gists{/gist_id}","starred_url":"https://api.github.com/users/pax/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pax/subscriptions","organizations_url":"https://api.github.com/users/pax/orgs","repos_url":"https://api.github.com/users/pax/repos","events_url":"https://api.github.com/users/pax/events{/privacy}","received_events_url":"https://api.github.com/users/pax/received_events","type":"User","user_view_type":"public","site_admin":false},"labels":[{"id":1528446243,"node_id":"MDU6TGFiZWwxNTI4NDQ2MjQz","url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/labels/bug","name":"bug","color":"d73a4a","default":true,"description":"Something isn't working"}],"state":"open","locked":false,"assignees":[],"milestone":null,"comments":4,"created_at":"2022-09-14T15:41:50Z","updated_at":"2023-04-11T03:46:17Z","closed_at":null,"assignee":null,"author_association":"NONE","type":null,"active_lock_reason":null,"sub_issues_summary":{"total":0,"completed":0,"percent_completed":0},"issue_dependencies_summary":{"blocked_by":0,"total_blocked_by":0,"blocking":0,"total_blocking":0},"body":"generates checkins.db but seems to fail before generating views \r\n\r\nnote: it worked on an Ubuntu WSL but fails on macOS 12.5.1\r\n\r\nlater edit: I suspect this is a problem with my local set-up, `dogsheep-beta index` also throws the same error\r\n\r\nfull error:\r\n\r\n    Importing 2591 checkins  [###################################-]   98%  00:00:00\r\n    Traceback (most recent call last):\r\n      File \"/Users/pax/devbox/envAll/bin/swarm-to-sqlite\", line 8, in <module>\r\n        sys.exit(cli())\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/click/core.py\", line 829, in __call__\r\n        return self.main(*args, **kwargs)\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/click/core.py\", line 782, in main\r\n        rv = self.invoke(ctx)\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/click/core.py\", line 1066, in invoke\r\n        return ctx.invoke(self.callback, **ctx.params)\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/click/core.py\", line 610, in invoke\r\n        return callback(*args, **kwargs)\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/swarm_to_sqlite/cli.py\", line 77, in cli\r\n        ensure_foreign_keys(db)\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/swarm_to_sqlite/utils.py\", line 145, in ensure_foreign_keys\r\n        db[fk.table].add_foreign_key(fk.column, fk.other_table, fk.other_column)\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/sqlite_utils/db.py\", line 2123, in add_foreign_key\r\n        self.db.add_foreign_keys([(self.name, column, other_table, other_column)])\r\n      File \"/Users/pax/devbox/envAll/lib/python3.8/site-packages/sqlite_utils/db.py\", line 1086, in add_foreign_keys\r\n        cursor.execute(\r\n    sqlite3.OperationalError: table sqlite_master may not be modified","closed_by":null,"reactions":{"url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/13/reactions","total_count":0,"+1":0,"-1":0,"laugh":0,"hooray":0,"confused":0,"heart":0,"rocket":0,"eyes":0},"timeline_url":"https://api.github.com/repos/dogsheep/swarm-to-sqlite/issues/13/timeline","performed_via_github_app":null,"state_reason":null,"pinned_comment":null}