{"action":"created","issue":{"url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python/issues/47","repository_url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python","labels_url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python/issues/47/labels{/name}","comments_url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python/issues/47/comments","events_url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python/issues/47/events","html_url":"https://github.com/GoogleCloudPlatform/getting-started-python/issues/47","id":146536433,"number":47,"title":"Local mysql server database initialization","user":{"login":"beyondns","id":16799459,"avatar_url":"https://avatars.githubusercontent.com/u/16799459?v=3","gravatar_id":"","url":"https://api.github.com/users/beyondns","html_url":"https://github.com/beyondns","followers_url":"https://api.github.com/users/beyondns/followers","following_url":"https://api.github.com/users/beyondns/following{/other_user}","gists_url":"https://api.github.com/users/beyondns/gists{/gist_id}","starred_url":"https://api.github.com/users/beyondns/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beyondns/subscriptions","organizations_url":"https://api.github.com/users/beyondns/orgs","repos_url":"https://api.github.com/users/beyondns/repos","events_url":"https://api.github.com/users/beyondns/events{/privacy}","received_events_url":"https://api.github.com/users/beyondns/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-04-07T07:45:54Z","updated_at":"2016-04-07T08:06:00Z","closed_at":"2016-04-07T08:06:00Z","body":"DATA_BACKEND = 'cloudsql'\r\nSQLALCHEMY_DATABASE_URI = \\\r\n    'mysql+pymysql://root:xxxxxx@127.0.0.1/mydata'\r\n\r\nrun local python main.py\r\nhttp request gives this:\r\n\r\n\r\nsqlalchemy.exc.ProgrammingError\r\nProgrammingError: (pymysql.err.ProgrammingError) (1146, u\"Table 'mydata.books' doesn't exist\") [SQL: u'SELECT books.id AS books_id, books.title AS books_title, books.author AS books_author, books.`publishedDate` AS `books_publishedDate`, books.`imageUrl` AS `books_imageUrl`, books.description AS books_description, books.`createdBy` AS `books_createdBy`, books.`createdById` AS `books_createdById` \\nFROM books ORDER BY books.title \\n LIMIT %(param_1)s, %(param_2)s'] [parameters: {u'param_1': 0, u'param_2': 10}]\r\n\r\nHow to init database?"},"comment":{"url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python/issues/comments/206749677","html_url":"https://github.com/GoogleCloudPlatform/getting-started-python/issues/47#issuecomment-206749677","issue_url":"https://api.github.com/repos/GoogleCloudPlatform/getting-started-python/issues/47","id":206749677,"user":{"login":"beyondns","id":16799459,"avatar_url":"https://avatars.githubusercontent.com/u/16799459?v=3","gravatar_id":"","url":"https://api.github.com/users/beyondns","html_url":"https://github.com/beyondns","followers_url":"https://api.github.com/users/beyondns/followers","following_url":"https://api.github.com/users/beyondns/following{/other_user}","gists_url":"https://api.github.com/users/beyondns/gists{/gist_id}","starred_url":"https://api.github.com/users/beyondns/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beyondns/subscriptions","organizations_url":"https://api.github.com/users/beyondns/orgs","repos_url":"https://api.github.com/users/beyondns/repos","events_url":"https://api.github.com/users/beyondns/events{/privacy}","received_events_url":"https://api.github.com/users/beyondns/received_events","type":"User","site_admin":false},"created_at":"2016-04-07T08:06:00Z","updated_at":"2016-04-07T08:06:00Z","body":"python bookshelf/model_cloudsql.py"}}