{"action":"created","issue":{"url":"https://api.github.com/repos/sdispater/orator/issues/109","repository_url":"https://api.github.com/repos/sdispater/orator","labels_url":"https://api.github.com/repos/sdispater/orator/issues/109/labels{/name}","comments_url":"https://api.github.com/repos/sdispater/orator/issues/109/comments","events_url":"https://api.github.com/repos/sdispater/orator/issues/109/events","html_url":"https://github.com/sdispater/orator/issues/109","id":182930305,"number":109,"title":"Incorrect datetime value: '2016-10-13 18:59:57.892599+00:00' for column 'created_at' at row 1\")","user":{"login":"12789","id":244297,"avatar_url":"https://avatars.githubusercontent.com/u/244297?v=3","gravatar_id":"","url":"https://api.github.com/users/12789","html_url":"https://github.com/12789","followers_url":"https://api.github.com/users/12789/followers","following_url":"https://api.github.com/users/12789/following{/other_user}","gists_url":"https://api.github.com/users/12789/gists{/gist_id}","starred_url":"https://api.github.com/users/12789/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/12789/subscriptions","organizations_url":"https://api.github.com/users/12789/orgs","repos_url":"https://api.github.com/users/12789/repos","events_url":"https://api.github.com/users/12789/events{/privacy}","received_events_url":"https://api.github.com/users/12789/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-10-13T23:35:47Z","updated_at":"2016-10-14T16:35:30Z","closed_at":null,"body":"Orator-ORM: 0.9.1\r\nPython: 2.7.10\r\nMySQL: 5.7.15\r\n\r\nIt happened when I save a model.\r\n\r\n`orator.exceptions.query.QueryException: (1292, \"Incorrect datetime value: '2016-10-13 18:59:57.892599+00:00' for column 'created_at' at row 1\") (SQL: INSERT INTO `admins` (`created_at`, `email`, `updated_at`) VALUES (%s, %s, %s) ([<Pendulum [2016-10-13T18:59:57.892599+00:00]>, 'abc@gmail.com', <Pendulum [2016-10-13T18:59:57.892599+00:00]>]))`\r\n\r\n\r\nThe migration script:\r\n\r\n```\r\nfrom orator.migrations import Migration\r\n\r\n\r\nclass CreateAdminsTable(Migration):\r\n\r\n    def up(self):\r\n        \"\"\"\r\n        Run the migrations.\r\n        \"\"\"\r\n        with self.schema.create('admins') as table:\r\n            table.increments('id')\r\n            table.string('email', 64).unique()\r\n            table.json('profile').nullable()\r\n            table.json('token').nullable()\r\n            table.small_integer('status').default(0)\r\n            table.timestamps()\r\n\r\n    def down(self):\r\n        \"\"\"\r\n        Revert the migrations.\r\n        \"\"\"\r\n        self.schema.drop('admins')\r\n\r\n```\r\n\r\nI guess the question is timezone info (+00:00).\r\n"},"comment":{"url":"https://api.github.com/repos/sdispater/orator/issues/comments/253853230","html_url":"https://github.com/sdispater/orator/issues/109#issuecomment-253853230","issue_url":"https://api.github.com/repos/sdispater/orator/issues/109","id":253853230,"user":{"login":"12789","id":244297,"avatar_url":"https://avatars.githubusercontent.com/u/244297?v=3","gravatar_id":"","url":"https://api.github.com/users/12789","html_url":"https://github.com/12789","followers_url":"https://api.github.com/users/12789/followers","following_url":"https://api.github.com/users/12789/following{/other_user}","gists_url":"https://api.github.com/users/12789/gists{/gist_id}","starred_url":"https://api.github.com/users/12789/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/12789/subscriptions","organizations_url":"https://api.github.com/users/12789/orgs","repos_url":"https://api.github.com/users/12789/repos","events_url":"https://api.github.com/users/12789/events{/privacy}","received_events_url":"https://api.github.com/users/12789/received_events","type":"User","site_admin":false},"created_at":"2016-10-14T16:35:30Z","updated_at":"2016-10-14T16:35:30Z","body":"@sdispater \r\n\r\n```\r\nclass Admin(db.Model):\r\n\r\n    def __repr__(self):\r\n        return '<Admin %r>' % self.id\r\n```\r\n```\r\nadmin = Admin()\r\nadmin.email = email\r\nadmin.save()\r\n```"}}
{"actor":{"display_login":"12789"}}