########################################################################################## JILS-50: Load project avatars ########################################################################################## Issue Type: Task ----------------------------------------------------------------------------------------- Issue Information ==================== Priority: Major Status: Closed Resolution: Done (2021-06-03 12:18:08) Project: Jira Issue Listing Script (JILS) Reported By: btasker Assigned To: btasker Affected Versions: - 0.01b Time Estimate: 0 minutes Time Logged: 0 minutes ----------------------------------------------------------------------------------------- Issue Description ================== This project has sat idle for quite some time, but this is something that's periodically bugged me, so I want to put it in quickly. Within JIRA itself, projects have been assigned various avatars - really we should have the ability to display those ----------------------------------------------------------------------------------------- Activity ========== ----------------------------------------------------------------------------------------- 2021-06-03 10:08:18 btasker ----------------------------------------------------------------------------------------- So, if we look at the schema in the DB as well as on disk: -- BEGIN SNIPPET -- mysql> select PROJECT_ID from project_key where PROJECT_KEY="LAN"; +------------+ | PROJECT_ID | +------------+ | 10502 | +------------+ 1 row in set (0.00 sec) -- The query select AVATAR from project where pname="Home LAN"; would also work, but we want to lookup by key mysql> select AVATAR from project where ID=10502; +--------+ | AVATAR | +--------+ | 10602 | +--------+ 1 row in set (0.00 sec) mysql> describe avatar; +--------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------+------+-----+---------+-------+ | ID | decimal(18,0) | NO | PRI | NULL | | | filename | varchar(255) | YES | | NULL | | | contenttype | varchar(255) | YES | | NULL | | | avatartype | varchar(60) | YES | MUL | NULL | | | owner | varchar(255) | YES | | NULL | | | systemavatar | decimal(9,0) | YES | | NULL | | +--------------+---------------+------+-----+---------+-------+ 6 rows in set (0.01 sec) mysql> select * from avatar where ID=10602; +-------+------------+-------------+------------+-------+--------------+ | ID | filename | contenttype | avatartype | owner | systemavatar | +-------+------------+-------------+------------+-------+--------------+ | 10602 | 644062.png | image/png | project | 10502 | 0 | +-------+------------+-------------+------------+-------+--------------+ [root@Rimmer ben]# ls /var/atlassian/application-data/jira/data/avatars/10602* /var/atlassian/application-data/jira/data/avatars/10602_644062.png /var/atlassian/application-data/jira/data/avatars/10602_small_644062.png /var/atlassian/application-data/jira/data/avatars/10602_xsmall_644062.png /var/atlassian/application-data/jira/data/avatars/10602_xxlarge_644062.png /var/atlassian/application-data/jira/data/avatars/10602_xxxlarge_644062.png /var/atlassian/application-data/jira/data/avatars/10602_medium_644062.png /var/atlassian/application-data/jira/data/avatars/10602_xlarge_644062.png /var/atlassian/application-data/jira/data/avatars/10602_xxlarge@