Add trac-admin session promote command

[Ryan J Ollos]

When [ticket] restrict_owner = true, users aren't displayed in the ticket assign-to field (TracTickets#Assign-toasDrop-DownList) until they have authenticated with the project. As a workround, some admins choose to run a SQL query on the database to insert "known users". To help with this recurring issue we could extend the session set command or add a session promote command, either of which would effectively or directly execute Session.promote_session​.

The issue was recently raised again in ​gmessage:trac-users:vKI_MDGL-Fs/EkAu9fiNCQAJ.

[aikidoguy@…]

Thank you for considering this. I would very much like to see a command that could be run to add a user.

[Jun Omae]

We can use session add to add session data without SQL query and a new command.

Trac [/var/trac/1.0-sqlite]> help session add
session add <sid[:0|1]> [name] [email]

    Create a session for the given sid

    Populates the name and email attributes for the given session. Adding a
    suffix ':0' to the sid makes the session unauthenticated, and a suffix ':1'
    makes it authenticated (the default if no suffix is specified).

Trac [/var/trac/1.0-sqlite]> session add zzz:1
Trac [/var/trac/1.0-sqlite]>

$ sqlite3 /var/trac/1.0-sqlite/db/trac.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from session where sid='zzz';
zzz|1|1444405511
sqlite> select * from session_attribute where sid='zzz';
sqlite>

[Ryan J Ollos]

Documentation added in TracTickets@75. I considered that a session set command would be useful for modifying the authenticated parameter of sessions that already exist in the database, however I'll wait to see if the functionality is really needed. The ability to set the session authenticated parameter might be more useful in the ​AccountManagerPlugin user management page, and for that matter I haven't looked closely to see if the capability already exists in AccountManager.