Skip to content

Gradient personnel view should use the new wiki #2

@jorgenschaefer

Description

@jorgenschaefer

emtools/grdpersonnel/views.py:get_roster currently uses the old wiki via web access. It should use the new Wiki's Roster page via local database access.

This is a bit more complex than it should be, as utils.connect() currently can't deal with different passwords per database, which needs to be added first.

Once that is done, the roster page text is a simple SQL query away:

SELECT t.old_text
FROM page p 
     INNER JOIN revision r ON p.page_latest = r.rev_id
     INNER JOIN text t ON r.rev_text_id = t.old_id
WHERE p.page_title = 'Roster'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions