LinuxSuRen / LinuxSuRen/api-testing
Support to show the status of a database
- Dominant language
- Go
- Stars
- 369
- Forks
- 67
- PR merge metrics
- No merged PRs in 30d
Description
*Description*:
>Describe the desired behavior, what scenario it enables and how it
would be used.
[optional *Relevant Links*:]
>Any extra documentation required to understand the issue.
## MySQL
Get status via the following SQL:
```sql
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
```
## PostgresDB
```sql
SELECT
pid, -- Process ID
usename AS username, -- Connection user
datname AS database,
client_addr AS host,
state, -- e.g., 'active', 'idle', 'idle in transaction'
query -- Current/last executed query
FROM pg_stat_activity;
```
Contributor guide
Research direction
No files, entry points, or tests are named. Start by locating the database integration and status-display entry points, then clarify the intended behavior and supported status fields for the MySQL INFORMATION_SCHEMA.PROCESSLIST and Postgres pg_stat_activity queries. Done should mean the agreed database status is shown and covered by tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, postgresql, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100