You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
I really like the command for querying author contributions:
SELECT author_name, COUNT(author_name) AS commit_num FROM commits WHERE datetime > "2024-01-01 00:00:00" GROUP BY author_name ORDER BY commit_num DESC
I especially like that this can be run across many repos at once. That is an excellent and unique feature.
However, from this I cannot view information about insertions, deletions, and files changed.
I see that there is a diffs table, but it cannot be filtered by datetime or branch. It is also very expensive to query. I also don't see a way to join commits to diffs.
Describe the solution you'd like
Include insertions, deletions, and file count in commits table.
Describe alternatives you've considered
Include a way to filter diffs by date and branch.
Include a way to join commits and diffs
Additional context
Add any other context or screenshots about the feature request here.
The text was updated successfully, but these errors were encountered:
Thanks you suggestion, Now i added datetime to the diffs table and also you will be able to join commits with diffs using commits id, author name...etc, but still working on ON expression for join
Is your feature request related to a problem? Please describe.
I really like the command for querying author contributions:
SELECT author_name, COUNT(author_name) AS commit_num FROM commits WHERE datetime > "2024-01-01 00:00:00" GROUP BY author_name ORDER BY commit_num DESC
I especially like that this can be run across many repos at once. That is an excellent and unique feature.
However, from this I cannot view information about insertions, deletions, and files changed.
I see that there is a diffs table, but it cannot be filtered by datetime or branch. It is also very expensive to query. I also don't see a way to join commits to diffs.
Describe the solution you'd like
Include insertions, deletions, and file count in commits table.
Describe alternatives you've considered
Additional context
Add any other context or screenshots about the feature request here.
The text was updated successfully, but these errors were encountered: