{"action":"created","issue":{"url":"https://api.github.com/repos/cansik/pg4nosql/issues/14","labels_url":"https://api.github.com/repos/cansik/pg4nosql/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/cansik/pg4nosql/issues/14/comments","events_url":"https://api.github.com/repos/cansik/pg4nosql/issues/14/events","html_url":"https://github.com/cansik/pg4nosql/issues/14","id":97620336,"number":14,"title":"SQL String generation for put and save can fail","user":{"login":"cansik","id":5220162,"avatar_url":"https://avatars.githubusercontent.com/u/5220162?v=3","gravatar_id":"","url":"https://api.github.com/users/cansik","html_url":"https://github.com/cansik","followers_url":"https://api.github.com/users/cansik/followers","following_url":"https://api.github.com/users/cansik/following{/other_user}","gists_url":"https://api.github.com/users/cansik/gists{/gist_id}","starred_url":"https://api.github.com/users/cansik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cansik/subscriptions","organizations_url":"https://api.github.com/users/cansik/orgs","repos_url":"https://api.github.com/users/cansik/repos","events_url":"https://api.github.com/users/cansik/events{/privacy}","received_events_url":"https://api.github.com/users/cansik/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cansik/pg4nosql/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-28T05:36:52Z","updated_at":"2015-07-28T07:52:10Z","closed_at":null,"body":"This is because of the bad conversion from object to string. None object will not be recognised."},"comment":{"url":"https://api.github.com/repos/cansik/pg4nosql/issues/comments/125488592","html_url":"https://github.com/cansik/pg4nosql/issues/14#issuecomment-125488592","issue_url":"https://api.github.com/repos/cansik/pg4nosql/issues/14","id":125488592,"user":{"login":"cansik","id":5220162,"avatar_url":"https://avatars.githubusercontent.com/u/5220162?v=3","gravatar_id":"","url":"https://api.github.com/users/cansik","html_url":"https://github.com/cansik","followers_url":"https://api.github.com/users/cansik/followers","following_url":"https://api.github.com/users/cansik/following{/other_user}","gists_url":"https://api.github.com/users/cansik/gists{/gist_id}","starred_url":"https://api.github.com/users/cansik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cansik/subscriptions","organizations_url":"https://api.github.com/users/cansik/orgs","repos_url":"https://api.github.com/users/cansik/repos","events_url":"https://api.github.com/users/cansik/events{/privacy}","received_events_url":"https://api.github.com/users/cansik/received_events","type":"User","site_admin":false},"created_at":"2015-07-28T07:52:10Z","updated_at":"2015-07-28T07:52:10Z","body":"With this code:\r\n```python\r\nrecord = self.relational_table.get(self.first_relational)\r\nrecord['height'] = None\r\nself.relational_table.save(record)\r\nrecord = self.relational_table.get(self.first_relational)\r\nself.assertEqual(None, record['height'])\r\n```\r\n\r\nThis can happen:\r\n```\r\nError\r\nTraceback (most recent call last):\r\n  File \"/Users/cansik/Projects/pg2nosql/test/PostgresNoSQLTableTest.py\", line 89, in test_save_relational_with_none\r\n    self.relational_table.save(record)\r\n  File \"/Users/cansik/Projects/pg2nosql/pg4nosql/PostgresNoSQLTable.py\", line 55, in save\r\n    json.dumps(data), AsIs(relational_data_sql), object_id))\r\n  File \"/Library/Python/2.7/site-packages/psycopg2/extras.py\", line 223, in execute\r\n    return super(RealDictCursor, self).execute(query, vars)\r\nDataError: invalid input syntax for type real: \"None\"\r\nLINE 1: ...{\"color\": \"blue\", \"items\": 3}' , age='24', height='None', na...\r\n```"}}