{"action":"created","issue":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223","repository_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map","labels_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223/labels{/name}","comments_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223/comments","events_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223/events","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223","id":167047144,"number":1223,"title":"Enable MySQL as an database alternative","user":{"login":"vaurdan","id":5804923,"avatar_url":"https://avatars.githubusercontent.com/u/5804923?v=3","gravatar_id":"","url":"https://api.github.com/users/vaurdan","html_url":"https://github.com/vaurdan","followers_url":"https://api.github.com/users/vaurdan/followers","following_url":"https://api.github.com/users/vaurdan/following{/other_user}","gists_url":"https://api.github.com/users/vaurdan/gists{/gist_id}","starred_url":"https://api.github.com/users/vaurdan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vaurdan/subscriptions","organizations_url":"https://api.github.com/users/vaurdan/orgs","repos_url":"https://api.github.com/users/vaurdan/repos","events_url":"https://api.github.com/users/vaurdan/events{/privacy}","received_events_url":"https://api.github.com/users/vaurdan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-07-22T13:38:21Z","updated_at":"2016-07-23T01:45:02Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/pulls/1223","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223","diff_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223.diff","patch_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223.patch"},"body":"Since there are people having a bunch of Database locked issues because of SQLite - see #1028 and #744 - I've decided to implement an alternative MySQL connection. \r\n\r\nI'm storing the database settings on the `database.json` file. If the `db_type` value is `sqlite` or empty, it will simply use the normal SQLite database, so by default and for the basic users it's still simply plug-and-play to use. If you use `mysql` as `db_type` it will use a MySQL database.\r\n\r\nHowever, when you have several instances of PokemonGo-Map running, SQLite doesn't work that well, and with this PR you can move all your database logic to MySQL.\r\n\r\nThis pull request includes a\r\n\r\n- [X] Bug fix\r\n- [x] New feature\r\n- [ ] Translation\r\n\r\nThe following changes were made\r\n\r\n- Added an alternative MySQL backend\r\n- Changed `credentials.json` to store mysql settings\r\n\r\nRelated issues: #1028 and #744"},"comment":{"url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/comments/234692129","html_url":"https://github.com/AHAAAAAAA/PokemonGo-Map/pull/1223#issuecomment-234692129","issue_url":"https://api.github.com/repos/AHAAAAAAA/PokemonGo-Map/issues/1223","id":234692129,"user":{"login":"vinsilsim","id":20602754,"avatar_url":"https://avatars.githubusercontent.com/u/20602754?v=3","gravatar_id":"","url":"https://api.github.com/users/vinsilsim","html_url":"https://github.com/vinsilsim","followers_url":"https://api.github.com/users/vinsilsim/followers","following_url":"https://api.github.com/users/vinsilsim/following{/other_user}","gists_url":"https://api.github.com/users/vinsilsim/gists{/gist_id}","starred_url":"https://api.github.com/users/vinsilsim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vinsilsim/subscriptions","organizations_url":"https://api.github.com/users/vinsilsim/orgs","repos_url":"https://api.github.com/users/vinsilsim/repos","events_url":"https://api.github.com/users/vinsilsim/events{/privacy}","received_events_url":"https://api.github.com/users/vinsilsim/received_events","type":"User","site_admin":false},"created_at":"2016-07-23T01:45:02Z","updated_at":"2016-07-23T01:45:02Z","body":"@vaurdan \r\nDont work\r\n\r\n2016-07-23 01:40:10,528 [     models] [   INFO] Connecting to MySQL database on\r\nlocalhost.\r\n2016-07-23 01:40:11,980 [  runserver] [   INFO] Parsed location is: 34.0092/-118\r\n.4976/0.0000 (lat/lng/alt)\r\n2016-07-23 01:40:11,980 [     search] [   INFO] Map iteration: 0\r\n2016-07-23 01:40:11,980 [     search] [   INFO] Attempting login to Pokemon Go.\r\n2016-07-23 01:40:11,980 [   auth_ptc] [   INFO] PTC login for: vinsilsim\r\n2016-07-23 01:40:12,013 [  _internal] [   INFO]  * Running on http://172.31.1.10\r\n0:2222/ (Press CTRL+C to quit)\r\n2016-07-23 01:40:12,684 [   auth_ptc] [   INFO] PTC Login successful\r\n2016-07-23 01:40:13,010 [     search] [   INFO] Login to Pokemon Go successful.\r\n2016-07-23 01:40:13,010 [     search] [   INFO] Scanning step 1 of 100.\r\nException in thread search_thread:\r\nTraceback (most recent call last):\r\n  File \"C:\\Python27\\lib\\threading.py\", line 801, in __bootstrap_inner\r\n    self.run()\r\n  File \"C:\\Python27\\lib\\threading.py\", line 754, in run\r\n    self.__target(*self.__args, **self.__kwargs)\r\n  File \"C:\\Users\\Administrator\\Desktop\\PokemonMap_Mysql\\pogom\\search.py\", line 1\r\n06, in search_loop\r\n    search(args, i)\r\n  File \"C:\\Users\\Administrator\\Desktop\\PokemonMap_Mysql\\pogom\\search.py\", line 8\r\n7, in search\r\n    parse_map(response_dict, i, step)\r\nTypeError: parse_map() takes exactly 1 argument (3 given)"}}
{"actor":{"display_login":"vinsilsim"}}