{"action":"created","comment":{"url":"https://api.github.com/repos/ContinuumIO/into/pulls/comments/24303270","id":24303270,"diff_hunk":"@@ -152,7 +154,9 @@ def append_csv_to_sql_table(tbl, csv, **kwargs):\n     # move things to a temporary S3 bucket if we're using redshift and we\n     # aren't already in S3\n     if dialect == 'redshift' and not isinstance(csv, (S3(CSV), Temp(S3(CSV)))):","path":"into/backends/sql_csv.py","position":16,"original_position":16,"commit_id":"89670197d9ccb37f8bdb7ab66f63dfc588383bb4","original_commit_id":"89670197d9ccb37f8bdb7ab66f63dfc588383bb4","user":{"login":"mrocklin","id":306380,"avatar_url":"https://avatars.githubusercontent.com/u/306380?v=3","gravatar_id":"","url":"https://api.github.com/users/mrocklin","html_url":"https://github.com/mrocklin","followers_url":"https://api.github.com/users/mrocklin/followers","following_url":"https://api.github.com/users/mrocklin/following{/other_user}","gists_url":"https://api.github.com/users/mrocklin/gists{/gist_id}","starred_url":"https://api.github.com/users/mrocklin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrocklin/subscriptions","organizations_url":"https://api.github.com/users/mrocklin/orgs","repos_url":"https://api.github.com/users/mrocklin/repos","events_url":"https://api.github.com/users/mrocklin/events{/privacy}","received_events_url":"https://api.github.com/users/mrocklin/received_events","type":"User","site_admin":false},"body":"`isinstance(...,  S3(CSV))` should be sufficient.  `isinstance` honors inheritance.","created_at":"2015-02-08T22:27:02Z","updated_at":"2015-02-08T22:27:02Z","html_url":"https://github.com/ContinuumIO/into/pull/77#discussion_r24303270","pull_request_url":"https://api.github.com/repos/ContinuumIO/into/pulls/77","_links":{"self":{"href":"https://api.github.com/repos/ContinuumIO/into/pulls/comments/24303270"},"html":{"href":"https://github.com/ContinuumIO/into/pull/77#discussion_r24303270"},"pull_request":{"href":"https://api.github.com/repos/ContinuumIO/into/pulls/77"}}},"pull_request":{"url":"https://api.github.com/repos/ContinuumIO/into/pulls/77","id":28887972,"html_url":"https://github.com/ContinuumIO/into/pull/77","diff_url":"https://github.com/ContinuumIO/into/pull/77.diff","patch_url":"https://github.com/ContinuumIO/into/pull/77.patch","issue_url":"https://api.github.com/repos/ContinuumIO/into/issues/77","number":77,"state":"open","locked":false,"title":"Fix appending to a sqlite table from a CSV with a header","user":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"body":null,"created_at":"2015-02-08T22:23:25Z","updated_at":"2015-02-08T22:27:02Z","closed_at":null,"merged_at":null,"merge_commit_sha":"20436efd7c2814dc2ac622db04474965d0fce691","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/ContinuumIO/into/pulls/77/commits","review_comments_url":"https://api.github.com/repos/ContinuumIO/into/pulls/77/comments","review_comment_url":"https://api.github.com/repos/ContinuumIO/into/pulls/comments/{number}","comments_url":"https://api.github.com/repos/ContinuumIO/into/issues/77/comments","statuses_url":"https://api.github.com/repos/ContinuumIO/into/statuses/89670197d9ccb37f8bdb7ab66f63dfc588383bb4","head":{"label":"cpcloud:fix-sqlite-csv-with-header","ref":"fix-sqlite-csv-with-header","sha":"89670197d9ccb37f8bdb7ab66f63dfc588383bb4","user":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"repo":{"id":28089885,"name":"into","full_name":"cpcloud/into","owner":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cpcloud/into","description":"Data Migration for Blaze Project","fork":true,"url":"https://api.github.com/repos/cpcloud/into","forks_url":"https://api.github.com/repos/cpcloud/into/forks","keys_url":"https://api.github.com/repos/cpcloud/into/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cpcloud/into/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cpcloud/into/teams","hooks_url":"https://api.github.com/repos/cpcloud/into/hooks","issue_events_url":"https://api.github.com/repos/cpcloud/into/issues/events{/number}","events_url":"https://api.github.com/repos/cpcloud/into/events","assignees_url":"https://api.github.com/repos/cpcloud/into/assignees{/user}","branches_url":"https://api.github.com/repos/cpcloud/into/branches{/branch}","tags_url":"https://api.github.com/repos/cpcloud/into/tags","blobs_url":"https://api.github.com/repos/cpcloud/into/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cpcloud/into/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cpcloud/into/git/refs{/sha}","trees_url":"https://api.github.com/repos/cpcloud/into/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cpcloud/into/statuses/{sha}","languages_url":"https://api.github.com/repos/cpcloud/into/languages","stargazers_url":"https://api.github.com/repos/cpcloud/into/stargazers","contributors_url":"https://api.github.com/repos/cpcloud/into/contributors","subscribers_url":"https://api.github.com/repos/cpcloud/into/subscribers","subscription_url":"https://api.github.com/repos/cpcloud/into/subscription","commits_url":"https://api.github.com/repos/cpcloud/into/commits{/sha}","git_commits_url":"https://api.github.com/repos/cpcloud/into/git/commits{/sha}","comments_url":"https://api.github.com/repos/cpcloud/into/comments{/number}","issue_comment_url":"https://api.github.com/repos/cpcloud/into/issues/comments/{number}","contents_url":"https://api.github.com/repos/cpcloud/into/contents/{+path}","compare_url":"https://api.github.com/repos/cpcloud/into/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cpcloud/into/merges","archive_url":"https://api.github.com/repos/cpcloud/into/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cpcloud/into/downloads","issues_url":"https://api.github.com/repos/cpcloud/into/issues{/number}","pulls_url":"https://api.github.com/repos/cpcloud/into/pulls{/number}","milestones_url":"https://api.github.com/repos/cpcloud/into/milestones{/number}","notifications_url":"https://api.github.com/repos/cpcloud/into/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cpcloud/into/labels{/name}","releases_url":"https://api.github.com/repos/cpcloud/into/releases{/id}","created_at":"2014-12-16T14:12:39Z","updated_at":"2015-02-07T02:56:15Z","pushed_at":"2015-02-08T22:23:04Z","git_url":"git://github.com/cpcloud/into.git","ssh_url":"git@github.com:cpcloud/into.git","clone_url":"https://github.com/cpcloud/into.git","svn_url":"https://github.com/cpcloud/into","homepage":null,"size":2698,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"ContinuumIO:master","ref":"master","sha":"a1ff3b78ee4af227b4714202a967be39fb794353","user":{"login":"ContinuumIO","id":1158637,"avatar_url":"https://avatars.githubusercontent.com/u/1158637?v=3","gravatar_id":"","url":"https://api.github.com/users/ContinuumIO","html_url":"https://github.com/ContinuumIO","followers_url":"https://api.github.com/users/ContinuumIO/followers","following_url":"https://api.github.com/users/ContinuumIO/following{/other_user}","gists_url":"https://api.github.com/users/ContinuumIO/gists{/gist_id}","starred_url":"https://api.github.com/users/ContinuumIO/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ContinuumIO/subscriptions","organizations_url":"https://api.github.com/users/ContinuumIO/orgs","repos_url":"https://api.github.com/users/ContinuumIO/repos","events_url":"https://api.github.com/users/ContinuumIO/events{/privacy}","received_events_url":"https://api.github.com/users/ContinuumIO/received_events","type":"Organization","site_admin":false},"repo":{"id":27790033,"name":"into","full_name":"ContinuumIO/into","owner":{"login":"ContinuumIO","id":1158637,"avatar_url":"https://avatars.githubusercontent.com/u/1158637?v=3","gravatar_id":"","url":"https://api.github.com/users/ContinuumIO","html_url":"https://github.com/ContinuumIO","followers_url":"https://api.github.com/users/ContinuumIO/followers","following_url":"https://api.github.com/users/ContinuumIO/following{/other_user}","gists_url":"https://api.github.com/users/ContinuumIO/gists{/gist_id}","starred_url":"https://api.github.com/users/ContinuumIO/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ContinuumIO/subscriptions","organizations_url":"https://api.github.com/users/ContinuumIO/orgs","repos_url":"https://api.github.com/users/ContinuumIO/repos","events_url":"https://api.github.com/users/ContinuumIO/events{/privacy}","received_events_url":"https://api.github.com/users/ContinuumIO/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ContinuumIO/into","description":"Data Migration for Blaze Project","fork":false,"url":"https://api.github.com/repos/ContinuumIO/into","forks_url":"https://api.github.com/repos/ContinuumIO/into/forks","keys_url":"https://api.github.com/repos/ContinuumIO/into/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ContinuumIO/into/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ContinuumIO/into/teams","hooks_url":"https://api.github.com/repos/ContinuumIO/into/hooks","issue_events_url":"https://api.github.com/repos/ContinuumIO/into/issues/events{/number}","events_url":"https://api.github.com/repos/ContinuumIO/into/events","assignees_url":"https://api.github.com/repos/ContinuumIO/into/assignees{/user}","branches_url":"https://api.github.com/repos/ContinuumIO/into/branches{/branch}","tags_url":"https://api.github.com/repos/ContinuumIO/into/tags","blobs_url":"https://api.github.com/repos/ContinuumIO/into/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ContinuumIO/into/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ContinuumIO/into/git/refs{/sha}","trees_url":"https://api.github.com/repos/ContinuumIO/into/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ContinuumIO/into/statuses/{sha}","languages_url":"https://api.github.com/repos/ContinuumIO/into/languages","stargazers_url":"https://api.github.com/repos/ContinuumIO/into/stargazers","contributors_url":"https://api.github.com/repos/ContinuumIO/into/contributors","subscribers_url":"https://api.github.com/repos/ContinuumIO/into/subscribers","subscription_url":"https://api.github.com/repos/ContinuumIO/into/subscription","commits_url":"https://api.github.com/repos/ContinuumIO/into/commits{/sha}","git_commits_url":"https://api.github.com/repos/ContinuumIO/into/git/commits{/sha}","comments_url":"https://api.github.com/repos/ContinuumIO/into/comments{/number}","issue_comment_url":"https://api.github.com/repos/ContinuumIO/into/issues/comments/{number}","contents_url":"https://api.github.com/repos/ContinuumIO/into/contents/{+path}","compare_url":"https://api.github.com/repos/ContinuumIO/into/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ContinuumIO/into/merges","archive_url":"https://api.github.com/repos/ContinuumIO/into/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ContinuumIO/into/downloads","issues_url":"https://api.github.com/repos/ContinuumIO/into/issues{/number}","pulls_url":"https://api.github.com/repos/ContinuumIO/into/pulls{/number}","milestones_url":"https://api.github.com/repos/ContinuumIO/into/milestones{/number}","notifications_url":"https://api.github.com/repos/ContinuumIO/into/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ContinuumIO/into/labels{/name}","releases_url":"https://api.github.com/repos/ContinuumIO/into/releases{/id}","created_at":"2014-12-09T22:17:14Z","updated_at":"2015-02-08T17:00:30Z","pushed_at":"2015-02-08T03:42:01Z","git_url":"git://github.com/ContinuumIO/into.git","ssh_url":"git@github.com:ContinuumIO/into.git","clone_url":"https://github.com/ContinuumIO/into.git","svn_url":"https://github.com/ContinuumIO/into","homepage":null,"size":3846,"stargazers_count":87,"watchers_count":87,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":8,"mirror_url":null,"open_issues_count":18,"forks":8,"open_issues":18,"watchers":87,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ContinuumIO/into/pulls/77"},"html":{"href":"https://github.com/ContinuumIO/into/pull/77"},"issue":{"href":"https://api.github.com/repos/ContinuumIO/into/issues/77"},"comments":{"href":"https://api.github.com/repos/ContinuumIO/into/issues/77/comments"},"review_comments":{"href":"https://api.github.com/repos/ContinuumIO/into/pulls/77/comments"},"review_comment":{"href":"https://api.github.com/repos/ContinuumIO/into/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/ContinuumIO/into/pulls/77/commits"},"statuses":{"href":"https://api.github.com/repos/ContinuumIO/into/statuses/89670197d9ccb37f8bdb7ab66f63dfc588383bb4"}}}}