{"action":"created","issue":{"url":"https://api.github.com/repos/kizniche/Mycodo/issues/62","labels_url":"https://api.github.com/repos/kizniche/Mycodo/issues/62/labels{/name}","comments_url":"https://api.github.com/repos/kizniche/Mycodo/issues/62/comments","events_url":"https://api.github.com/repos/kizniche/Mycodo/issues/62/events","html_url":"https://github.com/kizniche/Mycodo/issues/62","id":118966800,"number":62,"title":"Conversion to SQLAlchemy","user":{"login":"Cabalist","id":828557,"avatar_url":"https://avatars.githubusercontent.com/u/828557?v=3","gravatar_id":"","url":"https://api.github.com/users/Cabalist","html_url":"https://github.com/Cabalist","followers_url":"https://api.github.com/users/Cabalist/followers","following_url":"https://api.github.com/users/Cabalist/following{/other_user}","gists_url":"https://api.github.com/users/Cabalist/gists{/gist_id}","starred_url":"https://api.github.com/users/Cabalist/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Cabalist/subscriptions","organizations_url":"https://api.github.com/users/Cabalist/orgs","repos_url":"https://api.github.com/users/Cabalist/repos","events_url":"https://api.github.com/users/Cabalist/events{/privacy}","received_events_url":"https://api.github.com/users/Cabalist/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":18,"created_at":"2015-11-26T03:50:22Z","updated_at":"2015-11-30T04:10:39Z","closed_at":null,"body":"Hello again! \r\n\r\nI just made a branch on my fork that converts the initial database setup to SQLAlchemy and replaces optparse with argparse.\r\n\r\nI am not submitting it as a pull request yet because it mildly changes some behaviour.   Can you take a look at it and tell me what you think.  \r\n\r\nEvery piece of SQL was replaced with Python objects.  It is now Backend independent, meaning that it would work just as well on Postgres, MySql and SQLite and more.  \r\n\r\nThis is my first step to eliminating globals and simplifying the code immensely.  :)  \r\n\r\n\r\nCheck it out here:  https://github.com/Cabalist/Mycodo/tree/Sqlalchemy_conversion"},"comment":{"url":"https://api.github.com/repos/kizniche/Mycodo/issues/comments/160511907","html_url":"https://github.com/kizniche/Mycodo/issues/62#issuecomment-160511907","issue_url":"https://api.github.com/repos/kizniche/Mycodo/issues/62","id":160511907,"user":{"login":"kizniche","id":838427,"avatar_url":"https://avatars.githubusercontent.com/u/838427?v=3","gravatar_id":"","url":"https://api.github.com/users/kizniche","html_url":"https://github.com/kizniche","followers_url":"https://api.github.com/users/kizniche/followers","following_url":"https://api.github.com/users/kizniche/following{/other_user}","gists_url":"https://api.github.com/users/kizniche/gists{/gist_id}","starred_url":"https://api.github.com/users/kizniche/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kizniche/subscriptions","organizations_url":"https://api.github.com/users/kizniche/orgs","repos_url":"https://api.github.com/users/kizniche/repos","events_url":"https://api.github.com/users/kizniche/events{/privacy}","received_events_url":"https://api.github.com/users/kizniche/received_events","type":"User","site_admin":false},"created_at":"2015-11-30T04:10:38Z","updated_at":"2015-11-30T04:10:38Z","body":"It probably doesn't help that I rearranged some things, but I pushed the changes to https://github.com/Cabalist/Mycodo/tree/Sqlalchemy_conversion_kizniche\r\n\r\nOne thing that irked me about SQLite is its inability to delete a column without having to rewrite the entire table, which I sometimes wanted to do in a database update. Can SQLAlchemy do this somehow or would you recommend a different backend?"}}