Skip to content

Add view for better display of dependent repos #36

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
simonw opened this issue May 1, 2020 · 2 comments
Closed

Add view for better display of dependent repos #36

simonw opened this issue May 1, 2020 · 2 comments
Labels
enhancement New feature or request

Comments

@simonw
Copy link
Collaborator

simonw commented May 1, 2020 •
edited
Loading 

select
  repos.full_name as repo,
  'https://github.com/' || repos2.full_name as dependent,
  repos2.created_at as dependent_repo_created,
  repos2.updated_at as dependent_repo_updated,
  repos2.stargazers_count as dependent_repo_stars,
  repos2.watchers_count as dependent_repo_watchers
from
  dependents
  join repos as repos2 on dependents.dependent = repos2.id
  join repos on dependents.repo = repos.id
order by
  repos2.created_at desc

https://dogsheep.simonwillison.net/github?sql=select%0D%0A++repos.full_name+as+repo%2C%0D%0A++%27https%3A%2F%2Fgithub.com%2F%27+%7C%7C+repos2.full_name+as+dependent%2C%0D%0A++repos2.created_at+as+dependent_repo_created%2C%0D%0A++repos2.updated_at+as+dependent_repo_updated%2C%0D%0A++repos2.stargazers_count+as+dependent_repo_stars%2C%0D%0A++repos2.watchers_count+as+dependent_repo_watchers%0D%0Afrom%0D%0A++dependents%0D%0A++join+repos+as+repos2+on+dependents.dependent+%3D+repos2.id%0D%0A++join+repos+on+dependents.repo+%3D+repos.id%0D%0Aorder+by%0D%0A++repos2.created_at+desc
@simonw simonw added the enhancement New feature or request label May 1, 2020
@simonw simonw mentioned this issue May 1, 2020
Closed
@simonw
Copy link
Collaborator Author

simonw commented May 1, 2020

Blocked on #37

@simonw simonw closed this as completed in 143c3c5 May 2, 2020
@simonw
Copy link
Collaborator Author

simonw commented May 2, 2020

Demo: https://github-to-sqlite.dogsheep.net/github/dependent_repos

simonw added a commit that referenced this issue May 2, 2020
@simonw
Release 2.2
4fe6978 
Refs #36, #10, #12, #35, #33, #4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@simonw