Compatibility with devlake 1.0

[guilhem]

Description

opendora-api return a lot of bad value or trigger error with devlake 1.0 beta

Expected behavior

return values

Actual Behavior

https://domain/dora/api/metric?type=mttr&aggregation=weekly

Error 1054 (42S22): Unknown column 'repos.name' in 'where clause'

https://domain/dora/api/metric?type=cfr&aggregation=monthly

Error 1054 (42S22): Unknown column 'repos.name' in 'where clause'

https://domain/dora/api/metric?type=mltc&aggregation=monthly

{"aggregation":"monthly","dataPoints":[{"key":"24/01","value":0},{"key":"24/02","value":0},{"key":"24/03","value":0},{"key":"24/04","value":0},{"key":"24/05","value":0},{"key":"24/06","value":0}]}

Reproduction steps

use devlake 1.0 beta10

Your Environment

No response

Context of the bug

No response

Have you spent some time to check if this bug has been raised before?

• [X] I checked and didn't find similar issue

Are you willing to submit PR?

None