Hi,<div><br></div><div>I would like to create a tool or a template that could list and (re)generate key for the user you want if you are login as an admin.</div><div>I found the api_keys function in the user controller but I don&#39;t know how to use it. It seems that the decorators before the function checked if you are login as the good user...</div>
<div>I also found the mako template that used this api_keys function but it is still unclear for me.</div><div><br></div><div>Here is my sql function (FULL OUTER JOIN compatibility for MySQL) that list every keys even if they are empty :</div>
<div><br></div><div><div>SELECT `galaxy_user`.`id`, `api_keys`.`user_id`, `api_keys`.`key`, `galaxy_user`.`email`, `galaxy_user`.`username`</div><div>FROM `galaxy_user`</div><div>LEFT JOIN `api_keys` on `api_keys`.`user_id` = `galaxy_user`.`id`</div>
<div>UNION</div><div>SELECT `galaxy_user`.`id`, `api_keys`.`user_id`, `api_keys`.`key`, `galaxy_user`.`email`, `galaxy_user`.`username`</div><div>FROM `galaxy_user`</div><div>RIGHT JOIN `api_keys` on `api_keys`.`user_id` = `galaxy_user`.`id`</div>
</div><div><br></div><div><br></div><div>I know how to do that in PHP but it won&#39;t use python framework sqlalchemy (= only for mysql or pgsql...) !</div><div><br></div><div>Morevoer I don&#39;t know how do you generate your api_keys. Is it a md5 sum based on username / password ? Or is it just a random key with fix length ?</div>
<div><br></div><div><br></div><div>Any help would be gracefull,</div><div><br></div><div>Regards,</div><div><br>Remy</div>