HEX

File: //usr/lib/python3/dist-packages/trac/__pycache__/db_default.cpython-310.pyc
o

�k�`:�!@sddlmZmZmZdZdd�Zeddd�ed�ed�fed	d
d�ed�ed�fed
dd�ed�ed�ed�eddd�feddd�ed�eddd�eddd�edg�edg�feddd�ed�eddd�ed�ed�feddd�eddd�eddd�ed�fedd d�ed!�ed�ed"�ed#dd�edd$d�ed%�ed&�fed'd(d�ed�ed)dd�edd$d�ed&�ed*�ed+�ed,dd�edg�fed-d.d�eddd�ed�ed�fed/d0d�ed1dd�ed2d3d4�edd$d�ed&�ed5�ed1dg�fed6dd�edd7d8�ed1dd�ed2d3d4�ed9d:d4�ed;d<d=�ed>d<d=�ed?�ed@�egdA��egdB��f
edCdd�edd7d8�ed!�edd$d�edDd$d�edE�edF�edG�edH�edI�edJ�ed)�edK�edL�edM�edN�ed%�edO�edg�edLg�fedPdQd�edCdd�edd$d�ed&�edR�edS�edT�edCg�edg�fedUdVd�edCdd�ed�ed�fedWdXd�ed!�ed�ed�ed%�fedEdd�ed�edH�ed%�fedKdd�ed�edYd$d�edZd$d�ed%�fed)dd�ed�edd$d�ed%�fed[dd�edd7d8�ed&�ed\�ed]�ed%�fed^dd�edd7d8�edd$d�edDd$d�ed_�ed�eddd�ed`�eda�edGdd�edb�eddg�ed_g�fedcdd�edd7d8�ed�eddd�ed_�edd�ede�egdf��egdg��fgZdhdi�Zdjdk�ZdlS)m�)�Table�Column�Index�-cCs0g}|D]}|�d|d|d|df�q|S)z�Utility function used to create report data in same syntax as the
    default data. This extra step is done to simplify editing the default
    reports.Nr��)�append)�reports�result�report�r�1/usr/lib/python3/dist-packages/trac/db_default.py�__mkreportss r�system�name)�key�value�
permission��username�actionrr�auth_cookie)�cookie�ipnrrrr�time�int)�type�session)�sid�
authenticatedrr�
last_visit�session_attribute)rrr�cache�id�
generationr�
attachment)rr#�filenamerr&�size�int64�description�author�wiki)r�versionr,�text�comment�readonly�
repository)r#r�revision)�repos�revr2r3�()�key_size�message�node_changeT)�auto_increment�path��	node_typer)r'�change_type�	base_path�base_rev)r2r3r9)r2r9r3�ticket�
changetime�	component�severity�priority�owner�reporter�cc�	milestone�status�
resolution�summary�keywords�
ticket_change)r?r�fieldrM�oldvalue�newvalue�
ticket_custom)r?r�enum)rr�due�	completedr�title�query�notify_subscription�class�distributor�format�adverb�notify_watch�realm�target)rrrW)rWr\r]cCs�ddd|�dd�dfddd	|�dd�d
fddd
|�dd�|�dd�ffddd|�dd�d
fddd|�dd�d
fddd|�dd�fddd|�dd�dfddd|�dd�dffS)NzActive TicketszM * List all active tickets by priority.
 * Color each row based on priority.
amSELECT p.value AS __color__,
   t.id AS ticket, t.summary, t.component, t.version, t.milestone,
   t.type AS type, t.owner, t.status, t.time AS created,
   t.changetime AS _changetime, t.description AS _description,
   t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed'
  ORDER BY zp.valuerz, t.milestone, t.type, t.time
zActive Tickets by Versionz�This report shows how to color results by priority,
while grouping results by version.

Last modification time, description and reporter are included as hidden fields
for useful RSS export.
a�SELECT p.value AS __color__,
   t.version AS __group__,
   t.id AS ticket, t.summary, t.component, t.version, t.type AS type,
   t.owner, t.status, t.time AS created,
   t.changetime AS _changetime, t.description AS _description,
   t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed'
  ORDER BY (t.version IS NULL), t.version, z, t.type, t.time
zActive Tickets by Milestonez�This report shows how to color results by priority,
while grouping results by milestone.

Last modification time, description and reporter are included as hidden fields
for useful RSS export.
a�SELECT p.value AS __color__,
   %s AS __group__,
   t.id AS ticket, t.summary, t.component, t.version, t.type AS type,
   t.owner, t.status, t.time AS created, t.changetime AS _changetime,
   t.description AS _description, t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed'
  ORDER BY (t.milestone IS NULL), t.milestone, %s, t.type, t.time
z'Milestone 'zt.milestonez!Accepted, Active Tickets by OwnerzBList accepted tickets, group by ticket owner, sorted by priority.
aoSELECT p.value AS __color__,
   t.owner AS __group__,
   t.id AS ticket, t.summary, t.component, t.milestone, t.type AS type,
   t.time AS created, t.changetime AS _changetime,
   t.description AS _description, t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status = 'accepted'
  ORDER BY t.owner, z4Accepted, Active Tickets by Owner (Full Description)zdList tickets accepted, group by ticket owner.
This report demonstrates the use of full-row display.
apSELECT p.value AS __color__,
   t.owner AS __group__,
   t.id AS ticket, t.summary, t.component, t.milestone, t.type AS type,
   t.time AS created, t.description AS _description_,
   t.changetime AS _changetime, t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status = 'accepted'
  ORDER BY t.owner, z,All Tickets By Milestone  (Including closed)z=A more complex example to show how to make advanced reports.
a�SELECT p.value AS __color__,
   t.milestone AS __group__,
   (CASE t.status
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE
        (CASE t.owner WHEN $USER THEN 'font-weight: bold' END)
    END) AS __style__,
   t.id AS ticket, t.summary, t.component, t.status, t.resolution, t.version,
   t.type AS type, t.priority, t.owner, t.changetime AS modified,
   t.time AS _time, t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  ORDER BY (t.milestone IS NULL), t.milestone DESC, (t.status = 'closed'),
        (CASE t.status WHEN 'closed' THEN t.changetime ELSE (-1) * %s END) DESC
z
My Ticketsz�This report demonstrates the use of the automatically set
USER dynamic variable, replaced with the username of the
logged in user when executed.
a�SELECT p.value AS __color__,
       (CASE
         WHEN t.owner = $USER AND t.status = 'accepted' THEN 'Accepted'
         WHEN t.owner = $USER THEN 'Owned'
         WHEN t.reporter = $USER THEN 'Reported'
         ELSE 'Commented' END) AS __group__,
       t.id AS ticket, t.summary, t.component, t.version, t.milestone,
       t.type AS type, t.priority, t.time AS created,
       t.changetime AS _changetime, t.description AS _description,
       t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed' AND
        (t.owner = $USER OR t.reporter = $USER OR
         EXISTS (SELECT * FROM ticket_change tc
                 WHERE tc.ticket = t.id AND tc.author = $USER AND
                       tc.field = 'comment'))
  ORDER BY (COALESCE(t.owner, '') = $USER AND t.status = 'accepted') DESC,
           COALESCE(t.owner, '') = $USER DESC,
           COALESCE(t.reporter, '') = $USER DESC,
           zActive Tickets, Mine firstzj * List all active tickets by priority.
 * Show all tickets owned by the logged in user in a group first.
a�SELECT p.value AS __color__,
   (CASE t.owner
     WHEN $USER THEN 'My Tickets'
     ELSE 'Active Tickets'
    END) AS __group__,
   t.id AS ticket, t.summary, t.component, t.version, t.milestone,
   t.type AS type, t.owner, t.status, t.time AS created,
   t.changetime AS _changetime, t.description AS _description,
   t.reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE t.status <> 'closed'
  ORDER BY (COALESCE(t.owner, '') = $USER) DESC, )�cast�concat��dbrrr
�get_reports�s|
	�	��

���
��
	�	��
	�	��
��
���
�����rbc
Csdddddddtt|��ffS)N)rA)rrD))�
component1�somebody)�
component2rd)rG)rrRrS))�
milestone1rr)�
milestone2rr)�
milestone3rr)�
milestone4rr)r,)rr))z1.0r)z2.0r)rQ)rrr)
)rI�fixed�1)rI�invalid�2)rI�wontfix�3)rI�	duplicate�4)rI�
worksforme�5)rC�blockerrk)rC�criticalrm)rC�majorro)rC�minorrq)rC�trivialrs)�ticket_type�defectrk)ry�enhancementrm)ry�taskro)rr))�	anonymous�LOG_VIEW)r}�	FILE_VIEW)r}�	WIKI_VIEW)r�WIKI_CREATE)r�WIKI_MODIFY)r}�SEARCH_VIEW)r}�REPORT_VIEW)r}�REPORT_SQL_VIEW)r}�TICKET_VIEW)r�
TICKET_CREATE)r�
TICKET_MODIFY)r}�BROWSER_VIEW)r}�
TIMELINE_VIEW)r}�CHANGESET_VIEW)r}�ROADMAP_VIEW)r}�MILESTONE_VIEWr)r*rTrUr))rrbr`rrr
�get_datavs
��r�N)	�trac.db.schemarrr�
db_versionr�schemarbr�rrrr
�<module>s�
��
��

��


��

��


��


��




��

��




��








��



��


��
	
��
��
��


��

��

��






��




����&.