home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1229119171

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/471#issuecomment-1229119171 https://api.github.com/repos/simonw/sqlite-utils/issues/471 1229119171 IC_kwDOCGYnMM5JQt7D 9599 2022-08-27T04:18:28Z 2022-08-27T04:18:28Z OWNER

I tried this: ``` sqlite-utils :memory: 'select extract_domain("https://www.google.com/blah")' --functions ' from urllib.parse import urlparse

def extract_domain(url): from urllib.parse import urlparse return urlparse(url).netloc ' And got: NameError: name 'urlparse' is not defined Error: user-defined function raised exception But this worked OK: % sqlite-utils :memory: 'select extract_domain("https://www.google.com/blah")' --functions ' def extract_domain(url): from urllib.parse import urlparse return urlparse(url).netloc ' [{"extract_domain(\"https://www.google.com/blah\")": "www.google.com"}] ```

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
1352932716  
Powered by Datasette · Queries took 1.031ms · About: github-to-sqlite