pingcap/ossinsight-lite

I finished the settle follow document but it seem no data.

weykon opened this issue · 8 comments

weykon commented

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:
I read many time and follow each part carefully.
but no valid data appear.

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
image

Desktop (please complete the following information):

  • OS: MacOS Sonoma
  • Browser chrome

Additional context
what problem would cause this ?

weykon commented

image
I add this secret like this, and this is using the github new feature UI.

did I set correct ?

634750802 commented

Hi, @weykon

I have visited your GitHub home page, I found you are not open your activity data to public.
image

I think the reason is the default GITHUB_ACCESS_TOKEN used by pipeline cannot collect your private activity data. Checkout this document and use an authorized GITHUB_ACCESS_TOKEN to allow pipeline to collect your private activity data.

And I suggest you to enable the Repo sync workflow to auto sync upstream changes (this workflow uses force push on main branch).

634750802 commented

image I add this secret like this, and this is using the github new feature UI.

did I set correct ?

Your Data pipeline workflow passed, that means you have configured the DATABASE_URL correctly

weykon commented

Oh, Thank you for your reply, but I still have a small problem that it does not collect data correctly at most used languages and the other.
image

Some wrong at running Personal Pipeline.

image

the secret I set: read:discussion, read:repo_hook, read:user, repo, user:follow

hooopo commented

Oh, Thank you for your reply, but I still have a small problem that it does not collect data correctly at most used languages and the other. image

Some wrong at running Personal Pipeline.

image

the secret I set: read:discussion, read:repo_hook, read:user, repo, user:follow

This is the first time I've encountered this error（invalid cursor） as well. I think it might be caused by you not setting the correct token initially, and then setting the correct token later, leading to the previous cursor becoming invalid. I suggest you change to a different dbname or drop the db set in the action, so the pipeline will create a new, clean db.

634750802 commented

@weykon

The most used language SQL is here
https://github.com/pingcap/ossinsight-lite/blob/main/collections/contribution-most-used-languages/template.sql

WITH languages AS (
    SELECT language, COUNT(*) as count
    FROM pull_requests pr
    JOIN repos r on pr.repo_id = r.id
    WHERE pr.user_id = (SELECT id FROM curr_user LIMIT 1) AND r.language IS NOT NULL
    GROUP BY language
    ORDER BY count DESC
), total AS (
    SELECT SUM(count) as total FROM languages
)
SELECT language, count, ROUND(count * 100.0 / total, 2) as precentage
FROM languages, total
ORDER BY count DESC

This uses the repo's main language. The chart title is misleading. @Mini256

weykon commented

Oh really thanks guys ! :)
I'll try again later tonight, I'm enjoying the holidays.

weykon commented

Oh really thanks guys ! :) I'll try again later tonight, I'm enjoying the holidays.

I reset the TiDB, and its view seems to be working fine.

  • 🎉2