{"action":"created","issue":{"url":"https://api.github.com/repos/eclarke/swga/issues/30","labels_url":"https://api.github.com/repos/eclarke/swga/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/eclarke/swga/issues/30/comments","events_url":"https://api.github.com/repos/eclarke/swga/issues/30/events","html_url":"https://github.com/eclarke/swga/issues/30","id":112402371,"number":30,"title":"Backwards compatible, Python error with new version of swga and old version files","user":{"login":"stsmall","id":2847551,"avatar_url":"https://avatars.githubusercontent.com/u/2847551?v=3","gravatar_id":"","url":"https://api.github.com/users/stsmall","html_url":"https://github.com/stsmall","followers_url":"https://api.github.com/users/stsmall/followers","following_url":"https://api.github.com/users/stsmall/following{/other_user}","gists_url":"https://api.github.com/users/stsmall/gists{/gist_id}","starred_url":"https://api.github.com/users/stsmall/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stsmall/subscriptions","organizations_url":"https://api.github.com/users/stsmall/orgs","repos_url":"https://api.github.com/users/stsmall/repos","events_url":"https://api.github.com/users/stsmall/events{/privacy}","received_events_url":"https://api.github.com/users/stsmall/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-20T15:59:38Z","updated_at":"2015-10-20T17:26:37Z","closed_at":null,"body":"Hi,\r\nI created primer sets using an older version of swga. When I updated swga to the new version (for bug fixes) commands no longer seem to work on the old files. Py.test produces no errors and it works properly on files created under the same version. The python error is:\r\nTraceback (most recent call last):\r\n  File \"/home/smalls/anaconda/bin/swga\", line 9, in <module>\r\n    load_entry_point('swga==0.3.6', 'console_scripts', 'swga')()\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/swga/commands/swga_entry.py\", line 61, in main\r\n    command_opts[args.command](remaining, args.config)\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/swga/commands/summary.py\", line 13, in main\r\n    summary(**cmd.args)\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/swga/commands/summary.py\", line 48, in summary\r\n    bs = Set.select().order_by(Set.score).limit(1).get()\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2595, in get\r\n    return clone.execute().next()\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2636, in execute\r\n    self._qr = ResultWrapper(model_class, self._execute(), query_meta)\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2325, in _execute\r\n    return self.database.execute_sql(sql, params, self.require_commit)\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 3015, in execute_sql\r\n    self.commit()\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2864, in __exit__\r\n    reraise(new_type, new_type(*exc_value.args), traceback)\r\n  File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 3007, in execute_sql\r\n    cursor.execute(sql, params or ())\r\npeewee.OperationalError: no such column: t1.bg_dist_mean\r\n\r\nany thoughts?"},"comment":{"url":"https://api.github.com/repos/eclarke/swga/issues/comments/149639732","html_url":"https://github.com/eclarke/swga/issues/30#issuecomment-149639732","issue_url":"https://api.github.com/repos/eclarke/swga/issues/30","id":149639732,"user":{"login":"eclarke","id":372767,"avatar_url":"https://avatars.githubusercontent.com/u/372767?v=3","gravatar_id":"","url":"https://api.github.com/users/eclarke","html_url":"https://github.com/eclarke","followers_url":"https://api.github.com/users/eclarke/followers","following_url":"https://api.github.com/users/eclarke/following{/other_user}","gists_url":"https://api.github.com/users/eclarke/gists{/gist_id}","starred_url":"https://api.github.com/users/eclarke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eclarke/subscriptions","organizations_url":"https://api.github.com/users/eclarke/orgs","repos_url":"https://api.github.com/users/eclarke/repos","events_url":"https://api.github.com/users/eclarke/events{/privacy}","received_events_url":"https://api.github.com/users/eclarke/received_events","type":"User","site_admin":false},"created_at":"2015-10-20T17:26:37Z","updated_at":"2015-10-20T17:26:37Z","body":"Hey there, \nThe most recent version of SWGA uses a different database format than the previous versions to address certain issues. As a consequence, it looks like it broke compatibility with old workspaces (which wasn't my intention).\n\nThe easiest way to get around this is to add your existing primer sets to swga by following the instructions here: \nhttps://github.com/eclarke/swga/wiki/Using-a-custom-list-of-primers-for-finding-or-scoring-specific-sets.\n\nThis will add specific sets of primers to your workspace and score them correctly so that you can use them as before. \n\nPlease let me know if this helps, and sorry for the inconvenience!\n\n> On Oct 20, 2015, at 11:59 AM, stsmall <notifications@github.com> wrote:\n> \n> Hi,\n> I created primer sets using an older version of swga. When I updated swga to the new version (for bug fixes) commands no longer seem to work on the old files. Py.test produces no errors and it works properly on files created under the same version. The python error is:\n> Traceback (most recent call last):\n> File \"/home/smalls/anaconda/bin/swga\", line 9, in \n> load_entry_point('swga==0.3.6', 'console_scripts', 'swga')()\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/swga/commands/swga_entry.py\", line 61, in main\n> command_optsargs.command\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/swga/commands/summary.py\", line 13, in main\n> summary(*cmd.args)\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/swga/commands/summary.py\", line 48, in summary\n> bs = Set.select().order_by(Set.score).limit(1).get()\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2595, in get\n> return clone.execute().next()\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2636, in execute\n> self.qr = ResultWrapper(model_class, self.execute(), query_meta)\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2325, in _execute\n> return self.database.execute_sql(sql, params, self.require_commit)\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 3015, in execute_sql\n> self.commit()\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 2864, in __exit\n> reraise(new_type, new_type(exc_value.args), traceback)\n> File \"/home/smalls/anaconda/lib/python2.7/site-packages/peewee.py\", line 3007, in execute_sql\n> cursor.execute(sql, params or ())\n> peewee.OperationalError: no such column: t1.bg_dist_mean\n> \n> any thoughts?\n> \n> —\n> Reply to this email directly or view it on GitHub.\n> \n\n"}}