{"action":"created","comment":{"url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/comments/42481431","id":42481431,"diff_hunk":"@@ -70,6 +70,39 @@ def ssp_query(self,\n         else:\n             grouping = False\n \n+        # Build join parameters\n+        if join_types:\n+            counter = 0\n+            for join_type in join_types:\n+                if join_type.upper() == 'LEFT OUTER JOIN':\n+                    join_item = 'LEFT OUTER JOIN %s ON %s = %s ' % \\\n+                                (join_tables[counter], join_evals[counter][0], join_evals[counter][1])\n+                elif join_type.upper() == 'JOIN' or join_type.upper() == 'INNER JOIN':\n+                    join_item = 'JOIN %s ON %s = %s ' % \\\n+                                (join_tables[counter], join_evals[counter][0], join_evals[counter][1])\n+                else:\n+                    join_item = ''\n+\n+                counter += 1\n+                join += join_item\n+\n+        # Build custom where parameters\n+        if custom_where:\n+            for w in custom_where:\n+                c_where += w[0] + ' = ? AND '\n+\n+                # The order of our args changes if we are grouping\n+                #if grouping:\n+                #    args.insert(0, w[1])\n+                #else:\n+                #    args.append(w[1])\n+\n+                # My testing shows that order of args doesn't change\n+                args.append(w[1])","path":"plexpy/datatables.py","position":38,"original_position":38,"commit_id":"db7225fbad34aafcff29809c54ccd098442f0e14","original_commit_id":"2c354ad78349b1b01f4245c1a192fb86c76106cb","user":{"login":"drzoidberg33","id":1313205,"avatar_url":"https://avatars.githubusercontent.com/u/1313205?v=3","gravatar_id":"","url":"https://api.github.com/users/drzoidberg33","html_url":"https://github.com/drzoidberg33","followers_url":"https://api.github.com/users/drzoidberg33/followers","following_url":"https://api.github.com/users/drzoidberg33/following{/other_user}","gists_url":"https://api.github.com/users/drzoidberg33/gists{/gist_id}","starred_url":"https://api.github.com/users/drzoidberg33/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drzoidberg33/subscriptions","organizations_url":"https://api.github.com/users/drzoidberg33/orgs","repos_url":"https://api.github.com/users/drzoidberg33/repos","events_url":"https://api.github.com/users/drzoidberg33/events{/privacy}","received_events_url":"https://api.github.com/users/drzoidberg33/received_events","type":"User","site_admin":false},"body":"I honestly can't even remember why I needed to do this. I believe it had to do with custom searches and grouping.","created_at":"2015-10-20T11:02:01Z","updated_at":"2015-10-20T11:02:01Z","html_url":"https://github.com/drzoidberg33/plexpy/pull/256#discussion_r42481431","pull_request_url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256","_links":{"self":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/comments/42481431"},"html":{"href":"https://github.com/drzoidberg33/plexpy/pull/256#discussion_r42481431"},"pull_request":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256"}}},"pull_request":{"url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256","id":48024235,"html_url":"https://github.com/drzoidberg33/plexpy/pull/256","diff_url":"https://github.com/drzoidberg33/plexpy/pull/256.diff","patch_url":"https://github.com/drzoidberg33/plexpy/pull/256.patch","issue_url":"https://api.github.com/repos/drzoidberg33/plexpy/issues/256","number":256,"state":"open","locked":false,"title":"Miscellaneous fixes","user":{"login":"JonnyWong16","id":9099342,"avatar_url":"https://avatars.githubusercontent.com/u/9099342?v=3","gravatar_id":"","url":"https://api.github.com/users/JonnyWong16","html_url":"https://github.com/JonnyWong16","followers_url":"https://api.github.com/users/JonnyWong16/followers","following_url":"https://api.github.com/users/JonnyWong16/following{/other_user}","gists_url":"https://api.github.com/users/JonnyWong16/gists{/gist_id}","starred_url":"https://api.github.com/users/JonnyWong16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonnyWong16/subscriptions","organizations_url":"https://api.github.com/users/JonnyWong16/orgs","repos_url":"https://api.github.com/users/JonnyWong16/repos","events_url":"https://api.github.com/users/JonnyWong16/events{/privacy}","received_events_url":"https://api.github.com/users/JonnyWong16/received_events","type":"User","site_admin":false},"body":"Resubmit PR to dev branch.\r\n\r\nReference #219.","created_at":"2015-10-19T01:32:34Z","updated_at":"2015-10-20T11:02:01Z","closed_at":null,"merged_at":null,"merge_commit_sha":"fc4d483e0c85ac091ea61e32f082b65fd9c5165b","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256/commits","review_comments_url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256/comments","review_comment_url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/comments{/number}","comments_url":"https://api.github.com/repos/drzoidberg33/plexpy/issues/256/comments","statuses_url":"https://api.github.com/repos/drzoidberg33/plexpy/statuses/db7225fbad34aafcff29809c54ccd098442f0e14","head":{"label":"JonnyWong16:miscellaneous-fixes","ref":"miscellaneous-fixes","sha":"db7225fbad34aafcff29809c54ccd098442f0e14","user":{"login":"JonnyWong16","id":9099342,"avatar_url":"https://avatars.githubusercontent.com/u/9099342?v=3","gravatar_id":"","url":"https://api.github.com/users/JonnyWong16","html_url":"https://github.com/JonnyWong16","followers_url":"https://api.github.com/users/JonnyWong16/followers","following_url":"https://api.github.com/users/JonnyWong16/following{/other_user}","gists_url":"https://api.github.com/users/JonnyWong16/gists{/gist_id}","starred_url":"https://api.github.com/users/JonnyWong16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonnyWong16/subscriptions","organizations_url":"https://api.github.com/users/JonnyWong16/orgs","repos_url":"https://api.github.com/users/JonnyWong16/repos","events_url":"https://api.github.com/users/JonnyWong16/events{/privacy}","received_events_url":"https://api.github.com/users/JonnyWong16/received_events","type":"User","site_admin":false},"repo":{"id":40862882,"name":"plexpy","full_name":"JonnyWong16/plexpy","owner":{"login":"JonnyWong16","id":9099342,"avatar_url":"https://avatars.githubusercontent.com/u/9099342?v=3","gravatar_id":"","url":"https://api.github.com/users/JonnyWong16","html_url":"https://github.com/JonnyWong16","followers_url":"https://api.github.com/users/JonnyWong16/followers","following_url":"https://api.github.com/users/JonnyWong16/following{/other_user}","gists_url":"https://api.github.com/users/JonnyWong16/gists{/gist_id}","starred_url":"https://api.github.com/users/JonnyWong16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonnyWong16/subscriptions","organizations_url":"https://api.github.com/users/JonnyWong16/orgs","repos_url":"https://api.github.com/users/JonnyWong16/repos","events_url":"https://api.github.com/users/JonnyWong16/events{/privacy}","received_events_url":"https://api.github.com/users/JonnyWong16/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/JonnyWong16/plexpy","description":"A Python based monitoring and tracking tool for Plex Media Server.","fork":true,"url":"https://api.github.com/repos/JonnyWong16/plexpy","forks_url":"https://api.github.com/repos/JonnyWong16/plexpy/forks","keys_url":"https://api.github.com/repos/JonnyWong16/plexpy/keys{/key_id}","collaborators_url":"https://api.github.com/repos/JonnyWong16/plexpy/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/JonnyWong16/plexpy/teams","hooks_url":"https://api.github.com/repos/JonnyWong16/plexpy/hooks","issue_events_url":"https://api.github.com/repos/JonnyWong16/plexpy/issues/events{/number}","events_url":"https://api.github.com/repos/JonnyWong16/plexpy/events","assignees_url":"https://api.github.com/repos/JonnyWong16/plexpy/assignees{/user}","branches_url":"https://api.github.com/repos/JonnyWong16/plexpy/branches{/branch}","tags_url":"https://api.github.com/repos/JonnyWong16/plexpy/tags","blobs_url":"https://api.github.com/repos/JonnyWong16/plexpy/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/JonnyWong16/plexpy/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/JonnyWong16/plexpy/git/refs{/sha}","trees_url":"https://api.github.com/repos/JonnyWong16/plexpy/git/trees{/sha}","statuses_url":"https://api.github.com/repos/JonnyWong16/plexpy/statuses/{sha}","languages_url":"https://api.github.com/repos/JonnyWong16/plexpy/languages","stargazers_url":"https://api.github.com/repos/JonnyWong16/plexpy/stargazers","contributors_url":"https://api.github.com/repos/JonnyWong16/plexpy/contributors","subscribers_url":"https://api.github.com/repos/JonnyWong16/plexpy/subscribers","subscription_url":"https://api.github.com/repos/JonnyWong16/plexpy/subscription","commits_url":"https://api.github.com/repos/JonnyWong16/plexpy/commits{/sha}","git_commits_url":"https://api.github.com/repos/JonnyWong16/plexpy/git/commits{/sha}","comments_url":"https://api.github.com/repos/JonnyWong16/plexpy/comments{/number}","issue_comment_url":"https://api.github.com/repos/JonnyWong16/plexpy/issues/comments{/number}","contents_url":"https://api.github.com/repos/JonnyWong16/plexpy/contents/{+path}","compare_url":"https://api.github.com/repos/JonnyWong16/plexpy/compare/{base}...{head}","merges_url":"https://api.github.com/repos/JonnyWong16/plexpy/merges","archive_url":"https://api.github.com/repos/JonnyWong16/plexpy/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/JonnyWong16/plexpy/downloads","issues_url":"https://api.github.com/repos/JonnyWong16/plexpy/issues{/number}","pulls_url":"https://api.github.com/repos/JonnyWong16/plexpy/pulls{/number}","milestones_url":"https://api.github.com/repos/JonnyWong16/plexpy/milestones{/number}","notifications_url":"https://api.github.com/repos/JonnyWong16/plexpy/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/JonnyWong16/plexpy/labels{/name}","releases_url":"https://api.github.com/repos/JonnyWong16/plexpy/releases{/id}","created_at":"2015-08-17T04:15:28Z","updated_at":"2015-08-17T04:15:30Z","pushed_at":"2015-10-20T07:50:34Z","git_url":"git://github.com/JonnyWong16/plexpy.git","ssh_url":"git@github.com:JonnyWong16/plexpy.git","clone_url":"https://github.com/JonnyWong16/plexpy.git","svn_url":"https://github.com/JonnyWong16/plexpy","homepage":"","size":7840,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":0,"forks":1,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"drzoidberg33:dev","ref":"dev","sha":"5967636ef97f92cc487772232db1f8b4f4fc9582","user":{"login":"drzoidberg33","id":1313205,"avatar_url":"https://avatars.githubusercontent.com/u/1313205?v=3","gravatar_id":"","url":"https://api.github.com/users/drzoidberg33","html_url":"https://github.com/drzoidberg33","followers_url":"https://api.github.com/users/drzoidberg33/followers","following_url":"https://api.github.com/users/drzoidberg33/following{/other_user}","gists_url":"https://api.github.com/users/drzoidberg33/gists{/gist_id}","starred_url":"https://api.github.com/users/drzoidberg33/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drzoidberg33/subscriptions","organizations_url":"https://api.github.com/users/drzoidberg33/orgs","repos_url":"https://api.github.com/users/drzoidberg33/repos","events_url":"https://api.github.com/users/drzoidberg33/events{/privacy}","received_events_url":"https://api.github.com/users/drzoidberg33/received_events","type":"User","site_admin":false},"repo":{"id":31169720,"name":"plexpy","full_name":"drzoidberg33/plexpy","owner":{"login":"drzoidberg33","id":1313205,"avatar_url":"https://avatars.githubusercontent.com/u/1313205?v=3","gravatar_id":"","url":"https://api.github.com/users/drzoidberg33","html_url":"https://github.com/drzoidberg33","followers_url":"https://api.github.com/users/drzoidberg33/followers","following_url":"https://api.github.com/users/drzoidberg33/following{/other_user}","gists_url":"https://api.github.com/users/drzoidberg33/gists{/gist_id}","starred_url":"https://api.github.com/users/drzoidberg33/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drzoidberg33/subscriptions","organizations_url":"https://api.github.com/users/drzoidberg33/orgs","repos_url":"https://api.github.com/users/drzoidberg33/repos","events_url":"https://api.github.com/users/drzoidberg33/events{/privacy}","received_events_url":"https://api.github.com/users/drzoidberg33/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/drzoidberg33/plexpy","description":"A Python based monitoring and tracking tool for Plex Media Server.","fork":false,"url":"https://api.github.com/repos/drzoidberg33/plexpy","forks_url":"https://api.github.com/repos/drzoidberg33/plexpy/forks","keys_url":"https://api.github.com/repos/drzoidberg33/plexpy/keys{/key_id}","collaborators_url":"https://api.github.com/repos/drzoidberg33/plexpy/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/drzoidberg33/plexpy/teams","hooks_url":"https://api.github.com/repos/drzoidberg33/plexpy/hooks","issue_events_url":"https://api.github.com/repos/drzoidberg33/plexpy/issues/events{/number}","events_url":"https://api.github.com/repos/drzoidberg33/plexpy/events","assignees_url":"https://api.github.com/repos/drzoidberg33/plexpy/assignees{/user}","branches_url":"https://api.github.com/repos/drzoidberg33/plexpy/branches{/branch}","tags_url":"https://api.github.com/repos/drzoidberg33/plexpy/tags","blobs_url":"https://api.github.com/repos/drzoidberg33/plexpy/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/drzoidberg33/plexpy/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/drzoidberg33/plexpy/git/refs{/sha}","trees_url":"https://api.github.com/repos/drzoidberg33/plexpy/git/trees{/sha}","statuses_url":"https://api.github.com/repos/drzoidberg33/plexpy/statuses/{sha}","languages_url":"https://api.github.com/repos/drzoidberg33/plexpy/languages","stargazers_url":"https://api.github.com/repos/drzoidberg33/plexpy/stargazers","contributors_url":"https://api.github.com/repos/drzoidberg33/plexpy/contributors","subscribers_url":"https://api.github.com/repos/drzoidberg33/plexpy/subscribers","subscription_url":"https://api.github.com/repos/drzoidberg33/plexpy/subscription","commits_url":"https://api.github.com/repos/drzoidberg33/plexpy/commits{/sha}","git_commits_url":"https://api.github.com/repos/drzoidberg33/plexpy/git/commits{/sha}","comments_url":"https://api.github.com/repos/drzoidberg33/plexpy/comments{/number}","issue_comment_url":"https://api.github.com/repos/drzoidberg33/plexpy/issues/comments{/number}","contents_url":"https://api.github.com/repos/drzoidberg33/plexpy/contents/{+path}","compare_url":"https://api.github.com/repos/drzoidberg33/plexpy/compare/{base}...{head}","merges_url":"https://api.github.com/repos/drzoidberg33/plexpy/merges","archive_url":"https://api.github.com/repos/drzoidberg33/plexpy/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/drzoidberg33/plexpy/downloads","issues_url":"https://api.github.com/repos/drzoidberg33/plexpy/issues{/number}","pulls_url":"https://api.github.com/repos/drzoidberg33/plexpy/pulls{/number}","milestones_url":"https://api.github.com/repos/drzoidberg33/plexpy/milestones{/number}","notifications_url":"https://api.github.com/repos/drzoidberg33/plexpy/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/drzoidberg33/plexpy/labels{/name}","releases_url":"https://api.github.com/repos/drzoidberg33/plexpy/releases{/id}","created_at":"2015-02-22T16:36:06Z","updated_at":"2015-10-19T19:37:28Z","pushed_at":"2015-10-20T07:50:35Z","git_url":"git://github.com/drzoidberg33/plexpy.git","ssh_url":"git@github.com:drzoidberg33/plexpy.git","clone_url":"https://github.com/drzoidberg33/plexpy.git","svn_url":"https://github.com/drzoidberg33/plexpy","homepage":"","size":9535,"stargazers_count":129,"watchers_count":129,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":29,"mirror_url":null,"open_issues_count":48,"forks":29,"open_issues":48,"watchers":129,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256"},"html":{"href":"https://github.com/drzoidberg33/plexpy/pull/256"},"issue":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/issues/256"},"comments":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/issues/256/comments"},"review_comments":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256/comments"},"review_comment":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/pulls/256/commits"},"statuses":{"href":"https://api.github.com/repos/drzoidberg33/plexpy/statuses/db7225fbad34aafcff29809c54ccd098442f0e14"}}}}