fix: pypy problem cannot commit transaction

[yihong0618]

Pull Request Checklist

• A news fragment is added in news/ describing what is new.
• Test cases added for changed code.

Describe what you have changed in this PR.

close: #3706

this patch do two things

1. add pypy test in ci
2. fix pypy sqlite problem

there will be 4 commits

1. add pypy in ci let it failed see: http://github.com/yihong0618/pdm/actions/runs/20609668356/job/59191873410
2. fix the problem by make sqlite thread safe(with closing) see: https://github.com/yihong0618/pdm/actions/runs/20609693665/job/59191935467
3. drop the test ci branch name
4. add news for it

[codecov]

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 85.93%. Comparing base (324f00e) to head (58626e9).
⚠️ Report is 1 commits behind head on main.

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #3708      +/-   ##
==========================================
+ Coverage   85.92%   85.93%   +0.01%     
==========================================
  Files         118      118              
  Lines       12367    12369       +2     
  Branches     2060     2060              
==========================================
+ Hits        10626    10629       +3     
  Misses       1168     1168              
+ Partials      573      572       -1     

Flag	Coverage Δ
unittests	85.78% <100.00%> (+0.01%)	⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.