View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000238 | My infrastructure | General | public | 2024-07-01 18:06 | 2024-07-01 18:37 |
| Reporter | dvl | Assigned To | dvl | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Summary | 0000238: What is the wlc table? | ||||
| Description | I've seen it on a few FreshPorts databases. | ||||
| Tags | No tags attached. | ||||
|
|
Nothing in here:[18:07 pg03 dvl ~] % cd src/freshports/database-schema [18:07 pg03 dvl ~/src/freshports/database-schema] % grep wlc * [18:07 pg03 dvl ~/src/freshports/database-schema] % |
|
|
Nothing in web:[18:07 dvl-nginx01 dvl ~/www] % grep -r wlc * grep: configuration/freshports.net.conf: No such file or directory grep: configuration/status-config.php: No such file or directory [18:07 dvl-nginx01 dvl ~/www] % |
|
|
Nothing in ingress:[18:07 dvl-ingress01 dvl ~] % grep -r wcl ~/scripts ~/modules grep: /usr/home/dvl/modules/config.pm: Permission denied [18:08 dvl-ingress01 dvl ~] % |
|
|
Nothing at https://news.freshports.org/ either.... |
|
|
I suspect wlc = watch list count : How many people are watching this port.
name | category | wlc
--------------------------------------------------------+---------------+-----
0ad | games | 3
0d1n | security | 0
0verkill | games | 6
1password-client | security | 1
2048 | games | 0
...
|
|
|
The value on the port page is calculated by this function:
CREATE OR REPLACE FUNCTION watch_list_count(integer) RETURNS bigint
AS $$
SELECT count(*)
FROM watch_list_element
WHERE element_id = $1;
$$
LANGUAGE sql STABLE;
This is invoked by classes/ports.php by the function WatchListCount() Which is invoked by classes/port-display.php within Display() |
|
|
I'm concluding this table can be deleted.... Let's wait a few days after I've change the permissions. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-07-01 18:06 | dvl | New Issue | |
| 2024-07-01 18:07 | dvl | Note Added: 0000284 | |
| 2024-07-01 18:07 | dvl | Note Added: 0000285 | |
| 2024-07-01 18:08 | dvl | Note Added: 0000286 | |
| 2024-07-01 18:08 | dvl | Note Added: 0000287 | |
| 2024-07-01 18:10 | dvl | Note Added: 0000288 | |
| 2024-07-01 18:25 | dvl | Note Added: 0000289 | |
| 2024-07-01 18:25 | dvl | Note Added: 0000290 | |
| 2024-07-01 18:37 | dvl | Assigned To | => dvl |
| 2024-07-01 18:37 | dvl | Status | new => assigned |
